Re: MySQL Server crashes - spawning too many threads.
Hey steve -
I haven't looked into tweaking Mac X but it's all UNIX. I'm more familar with Solaris and it only took a bit of digging to find the translation into linux. You want to tweak both the nprocs and open files. I got the number from a combo of places. My sys admins and online docs (I may have gotten the number on an Oracle doc -- installing Oracle on Linux). I HIGHLY suggest you search for an Oracle doc for installing on Mac X (not sure if they have a product for Mac X but I can't see why not??). They go into details on how to tweak the OS for a database.
From looking at my stats I see that the most at any one time I have ppl connected is something like 200. (I'm away from work & my stats). Most of our connections to the database are quick.
Don't forget your formula for setting up your buffers (System Buffers + (thread buffers * max_connections)). 4 GBs of RAM may not be enough for your application.
Why not post your variables (show variables) and your stats (show status). I also HIGHLY recommend you get a copy of mysqlreport and run that....
I've got to run but I'll check back tomorrow.
erin
Subject
Views
Written By
Posted
3029
July 28, 2005 01:24PM
1946
July 28, 2005 03:27PM
1895
July 28, 2005 04:02PM
2230
July 28, 2005 05:50PM
1777
July 28, 2005 06:50PM
1833
July 28, 2005 07:37PM
2325
July 30, 2005 11:36AM
1712
August 01, 2005 01:54PM
2631
August 12, 2005 02:54PM
1791
August 18, 2005 11:21AM
Re: MySQL Server crashes - spawning too many threads.
1682
August 18, 2005 06:50PM
1933
August 19, 2005 02:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.