I'm experiencing pages loading very slowly, it's happening intermittently on a low traffic EE site. Most of the traffic is just me.
When they load slow, they take a good 30 seconds or so.
But when the load fast they are very quick. Less than a second.
The template debugger and output profiler numbers look good as far as I can tell.
Could this be due to mysql table locking?
For future reference, I upgraded MySQL to MariaDB (a drop-in MySQL replacement) on the host and also changed DB tables from the default MyISAM to InnoDB (actually XtraDB) and have continued to watch it. These changes have had a positive impact on performance so far.