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
3297
July 28, 2005 01:24PM
2085
July 28, 2005 03:27PM
2022
July 28, 2005 04:02PM
2414
July 28, 2005 05:50PM
1947
July 28, 2005 06:50PM
1982
July 28, 2005 07:37PM
2498
July 30, 2005 11:36AM
1849
August 01, 2005 01:54PM
2784
August 12, 2005 02:54PM
1946
August 18, 2005 11:21AM
Re: MySQL Server crashes - spawning too many threads.
1825
August 18, 2005 06:50PM
2111
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.