10 Apr 2015, 21:53
MySQL writes too much. I noticed that long tine ago, found some wrongly written plugins, but still MySQL writes way too much. One performance metric got on my nerves for years - high percentage of temporary tables created on disk. Increasing the buffer did not help, so I ignored this. However, 3 days ago I stumbled upon this issue again and decided to finally look into it. It turned out that tables with TEXT columns cannot be created in memory. All these three days I've been analysing table structures, calculating the longest entries, removing garbage, replacing text columns with varchar ones when possible and ... suddenly I noticed that almost no temporary tables are being created on disk anymore! And the CPU/memory load is dropped! I would call it a success 😉
I always knew that WordPress (and WP plugins) was not created with performance in mind, but how could I know that it would take me years and years of tweaking and performance tuning... And it's still very resource hungry. MyBB developers have done a better job.
And I still have to rewrite the WordPress theme to conform the latest internal design ideas.
I always knew that WordPress (and WP plugins) was not created with performance in mind, but how could I know that it would take me years and years of tweaking and performance tuning... And it's still very resource hungry. MyBB developers have done a better job.
And I still have to rewrite the WordPress theme to conform the latest internal design ideas.