Some quick info I have pulled off of the web on MySQL performance tuning. I am currently working on some mysql performance tuning and this is some of the information I have gathered.
Threads_created details the number of threads that have been created since the MySQL server started, and Connections is the total number of client connections to the MySQL server since startup. To work out the thread cache hit ratio, we use this calculation:
I needed to find the peak utilization for over 100 Linux servers, so rather than interpreting sar output manually, I spent my time doing something that I could reuse.
I had a few systems crash over the weekend, and one in particular had some filesystem corruption. It also happened that the file corruption was on the root filesystem, and it was a SAN boot machine. Anyhow, after booting up into a rescue disk (using pxe boot), I was able to fsck the root filesystem.
This will query your phpBB database and display the last SHOW_HOWMANY post subjects. I couldn’t find anything that did this already, so I wrote this.
Use at your own risk. Continue reading
EasyApache is a pre configured script that allows you to easily update Apache Web server through WHM or SSH on a server running cPanel. In this tutorial we will show you how to update apache using SSH /scripts/easyapache.