Hi Nick. Is there enough memory available on the 64-bit server compared to the 32-bit one? I ask because I had a similar situation recently which happen to be on a 64-bit CentOS server. I had a PHP program parse data and populate a MySQL table. It ran very slowly, and I found out the PHP program to make a long story short had a memory leak. There was hardly any free RAM available and the server was using swap which it almost never does. After I resolved the memory leak situation MySQL was still crawling so I stopped and started MySQL, and it was back to normal.
I don't know if this is related to the problem you are experiencing, but I never had a slow down like this before and the root cause was the memory issue. I used MySQL out-of-the-box I didn't look into any sort of performance tuning on this server. It's my server I use for development so I'm the only one on it. David Roth On Wed, Oct 17, 2012 at 11:47 AM, Nicholas Hart <nh...@partsauthority.com>wrote: > MySQL - PHP: > > Anyone have experience with a 64bit mysql server? > Recently tried to move a PHP application to a not as busy > 64 bit Dell Server and it and it was vy slow for some unknown reason. > Checked all indexes in applicable tables which matched 32 bit server. > I have optimzed data and checked/repaired indexes with myisamck. > I have run MYSQL PERFORMANCE TUNING PRIMER Version 5.1.31 > and made suggested changes but no change in speed of this app. > Moved it back to 32 bit Dell Server and it is fine again now. > > I guess what I am ultimately looking for is a decent site or book to > explain > mysql db admin. Any suggestions or theories much appreciated. > Note: I moved it b/c I thought it would run faster on a 64bit server:-( > > Thanks, > Nick > >
_______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show-participation
