Hi,
I'm having trouble in configuring the my.cnf for "optimal" condition on my server.
My MySQL server (3.23.52max) is running on Solaris 8 - Sun Sparc 4 processors and 4 GB
memory.
and my.cnf is :
- keybuffer : 768M
- sortbuffer : 8M
- recordbuffer : 8M
previously is :
- keybuffer : 1024M
- sortbuffer : 12M
- recordbuffer : 12M
and with this configuration my server can't handle more than 1200 concurrent threads.
The error message said "Can't create more threads ... error 11 ... memory limit"
And my database condition is :
- average number of records : 2 million per table (1GB size per table)
- a lot of query with order by (I'm aware it's related to sortbuffer)
- index "almost" created properly :D
I know if I set my configuration to lower value than I had slow query performance. And
I found with sortbuffer : 12M and recordbuffer : 12M ... my query performance is good.
but I can't have more than 1200 concurrent threads :((
Please help me on this. What should I do ? Which value should I set bigger or lower ?
And what is the calculation for the memory also ....
Thank you ... thank you very much if you would like to help me .... :D
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 2 days, Queries : 340.607 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
