Tiger, MySQL, Gallery2

[Anonymous]

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?

[heavyboots]

You might want to check out the AnandTech article on optimizing for G5. It looks like the answer may be “yes” from their article. Or you could reformat with YDL on the XServe, at a very minimum (if you’re not doing anything with AFP or other Apple technologies anyway).

Also, have you tried msyqladmin refresh? Perhaps (if it works) an hourly refresh cronjob would be enough to keep it from bogging?

[zombor]

Seems the problem was with flock()…I did a ktrace on the httpd process and there were a ton of flock() calls taking half a second each. I swithced G2 from file locking to database locking and the load time cut in half, however still slower than it should be.

I did some more ktraces, and now i get a bunch of lseek()’s taking .1-.3 seconds each, kdump output is:

7962 httpd 0.125575 CALL lseek(0xa,0,0)
7962 httpd 0.126855 CALL close(0xa)
7962 httpd 0.127335 RET close 0
7962 httpd 0.128935 RET getdirentries 664/0x298
7962 httpd 0.132929 CALL lseek(0xa,0,0)
7962 httpd 0.135916 CALL lseek(0xa,0,0)
7962 httpd 0.138924 RET flock 0
7962 httpd 0.155503 CALL access(0x2875400,0)
7962 httpd 0.160541 CALL lseek(0xa,0,0)
7962 httpd 0.165998 CALL lseek(0xa,0,0)
7962 httpd 0.182390 CALL lseek(0xa,0,0)
7962 httpd 0.186547 CALL lseek(0xa,0,0)
7962 httpd 0.443527 GIO fd 9 read 4 bytes

Anyone have any other info I could try out?

[Anonymous]

I ran it thru Shark and a php profiling software and it gets stuck up in getdirentries(). I am going to file a bug report with apple since this work perfectly fine on Panther with the same setup.

[Author]

Posts