Hi,
I am running a site that has multiple gallery2 installs, using MySQL. I have experienced a great loss in MySQL performance since I started using the gallery2 application. This performance loss happens gradualy, not immediately. I have reformated my server 2 times, and the same problem occurs. I heard that MySQL on OS X has performance problems because of threading. When I view my server stats in phpMyAdmin, I see:
Query statistics: Since its startup, 49,723 queries have been sent to the server.
Total ø per hour ø per minute ø per second
49,723 18,509.23 308.49 5.14
This is over a 2.75 hour period.
Should I move my databases over to Linux or FreeBSD?