NYCPHP Meetup

[David Roth]

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 <nhart at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20121017/3e427cd4/attachment.html>