MySQL on FreeBSD with libthr support
All the time i have use MySQL on FreeBSD compiled with linuxthreads. Last two years this was a very stable solution, but experience of other people, who already migrate from linuxthreads to libthr, force me to do some research. Tests show what libthr do about double better performance. I have made tests under FreeBSD 6.2/amd64. Before test maximum queries per second around 580, after test 1200. At this moment server uptime is 3 weeks, so i think libthr are stable, and i highly recommend to try it.
To run MySQL with libthr, just compile mysql from ports without BUILD_STATIC, and add this strings to /etc/libmap.conf
[mysqld]
libc_r.so.5 libthr.so.2
libc_r.so.6 libthr.so.2
libpthread.so.1 libthr.so.2
libpthread.so.2 libthr.so.2
February 8th, 2007 at 12:05 am
Troubleshooting slow queries and queries without indexes in MySQL
After spending the last few days tuning and troubleshooting a MySQL/Apache/PHP/FreeBSD setup for a client, I found a lot of excellent writings about the subject. I might touch some of the subjects in later posts, but what I found to be the single most…