Thanks to some work started by Ville Skyttä , MySQLTuner is now included in Fedora 9 repositories:
# cat /etc/fedora-release
Fedora release 9 (Sulphur)
# yum info mysqltuner
Loaded plugins: fastestmirror, priorities, refresh-packagekit
Loading mirror speeds from cached hostfile
* updates: mirrors.usc.edu
* fedora: mirror.unl.edu
* livna: mirrors.tummy.com
Available Packages
Name : mysqltuner
Arch : noarch
Version : 0.9.1
Release : 4
Size : 11 k
Repo : updates
Summary : MySQL high performance tuning script
URL : http://mysqltuner.com/
License : GPLv3+
Description: MySQLTuner is a MySQL high performance tuning script written in perl that will provide you with a snapshot of a MySQL server’s health. Based
: on the statistics gathered, specific recommendations will be provided that will increase a MySQL server’s efficiency and performance. The
: script gives you automated MySQL ...
Content suppressed by ://URLFAN, for full article visit source
Plesk Professional Website Editor hangs at loginFrom: rackerhacker.com
Post Date: 2008-03-13 11:11:57
One of my biggest Plesk gripes is dealing with the Plesk Professional Website Editor. One of the most common occurrences with PPWSE is that it hangs when you attempt to log into the server. Normally, this happens when a server is behind a firewall, and it is using private IP’s.
Plesk will actually query the DNS for the domain (rather than simply connecting to the localhost), try to reach the public IP, and the traffic will be blocked by the firewall. This creates a login sess...
more Hunting down elusive sources of iowaitFrom: rackerhacker.com
Post Date: 2008-03-11 11:00:18
A question I’m asked daily is “How can I find out what is generating iowait on my server?” Sure, you can dig through pages of lsof output, restart services, or run strace, but it can be a frustrating process. I saw a process on this blog post , and I changed the regexes to fit Red Hat and CentOS systems a bit better:
# /etc/init.d/syslog stop
# echo 1 > /proc/sys/vm/block_dump
# dmesg | egrep "READ|WRITE|dirtied" | egrep -o ’([a-zA-Z]*)’ | sort | un...
more