Hi Dani!

Your presentation was fantastic.
Thank you for your tips!

z.

Can I put this in my account if I’m not the host, but just a cpanel user? for example, can I put this in ~/etc/my.cnf? I am digging this tutorial, but I don’t have time to finish it now, and just was thinking about this…

Hello. Very goog video. I would help to see an example of a well tuned mysql server.

For some reason, I’m not seeing the prior comments any longer, but I wanted to reply to one by O that was previously posted.

In regards to individual my.cnf files on /home/username accounts for cPanel users, this is not possible under the MySQL setup, since my.cnf variables are globally defined. The only setting that can be defined in a user-level file would be the user’s MySQL password in /home/username/.my.cnf file (similar to the root password being defined in /root/.my.cnf file).

I do appreciate the kind words noted by the 3 prior comments that were here previously.

Thanks!
Dani (aka Tristan) Wallace

where can i download Optimized my.cnf file by dani wallace ??

This video describes how to generate an optimized my.cnf yourself.  Be mindful that optimizations depend on the SQL queries being run on your server and other factors, as described in the video. So using someone else’s my.cnf file for the purposes of optimization may not be the most productive route to pursue.

How did you measure the load and log it at the same intervals that you ran the cron?

I simply ran a cron that would gauge uptime every minute that wrote the output to a text file (such as “uptime >> /root/uptime” would do), since uptime shows the load levels. Getting the load every minute was more frequent than the cron being run for the query, so I was able to see the minute by minute results from mysqlslap on the machine.