On one of the Free phpBB hosting server, MySQL take about 18 minutes to start.
That is if i restart MySQL for any reason (including server reboot), it take too much time to just start the MySQL server.
The server have a second hard disk, so i moved the MySQL data folder to that HD to [...]

• 0 Comments

Today a client wanted to move his MySQL database to second hard disk. Moving MySQL database to its own hard disk improve IO performance as the hard disk only need to serve MySQL data, nothing OS related. This was a cpanel server, so start with stoping chkservd, so mysql or httpd will not start while [...]

• 0 Comments

Today i found a blog on MySQL performance.
 http://www.mysqlperformanceblog.com/mysql-performance-presentations/
I manage many big MySQL databases, some are over 20 GB in size. But i have not yet done much MySQL optimizations.  For me, it is good CPU and enough RAM will handle with out much problem.
Most MySQL optimizations are finding slow MySQL query and optimize the SQL [...]

• 0 Comments