Re: MySQL on large server
This is what I have in /etc/my.cnf on my current MySQL server (dual AthlonMP,2GB RAM) [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking log-slow-queries = slowqueries.log set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=1024 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=24 set-variable= max_connections=510 set-variable = thread_concurrency=16 set-variable = myisam_sort_buffer_size=64M set-variable= tmp_table_size=128M set-variable = wait_timeout=90 Whilst monitoring the server using 'mytop' is can see the server using between 250 400 threads, never dropping below 210 threads ('top' reports about 15-20MB RAM free) 'extended-status' reports: Max_used_connections = 480 And these numbers are going to grow as the server gets busier, hence the Dual Xeon server with 6GB RAM. Instead of added more h/w in the future though, I'd like to be able to squeeze more out of Linux/MySQL I used a C program (thread-limit.c) which tests the amount the threads Linux can create (am I correct in assuming these are the same thing?) (I can send the 4k file if required) On my server, the program reports 255 threads max which I believe is down to glibc... The MySQL binaries are reported to handle 1000-1500 connections. I was wondering if anybody has achieved this building with source? If so, what was involved? (version of libs, etc were used?) Possibly of relevance are the results of running 'thread-limit' against various platforms (glibc versions were taken from 'rpm -q'; 'qpkg' in the case of Gentoo) Distro | kernel | glibc | threads created before failure Mandrake 8 | 2.4.19-16mdk | 2.2.5-16mdk| 255 Gentoo | 2.4.19-gentoo-r9 | 2.2.5-r7 | 1021 RedHat 7.2 | 2.4.19-2 (custom)| 2.2.5-42 | 255 Unfortunately, I'm not ready to deploy Gentoo on a production server, but they're doing something differently... Many thanks From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: MySQL on large server Date: Thu, 9 Jan 2003 14:36:38 -0800 On Thu, Jan 09, 2003 at 08:55:36AM +, mysql list wrote: Hi, I was wondering if anybody has built MySQL 3.23 from source that can handle a high number of connections threads. I've have tried MySQL binaries in the past (not RPMs), but these have had stability/load problems. When building from source I don't have those issues, but I am limited by the inbuilt limits (of glibc,etc...) How many connections do you need? If memory serves, the master db behind Slashdot was handling around 700 connections on a 4 processor P3 Xeon with 4GB RAM. But it's been a while since I've talked with Brian about it. I need to build MySQL 3.23 on a production server running RedHat 7.2, patched glibc (2.2.5-42) and a custom kernel (2.4.19-2 SMP). Hardware contains Dual Xeon 2.4GHz (hyperthreading disabled) and 6GB RAM. With that kind of RAM and horespower you should be able to go well above 500 connections. I'd say more on this topic, but I've not really needed to push MySQL in that direction. We tend to use more boxes that cost less and replicate data. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 863,460,485 queries (388/sec. avg) - 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 _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - 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
Re: MySQL on large server
How many connections do you need? 1000? As many as possible I guess. I'd like to maximise usage of the new server.. This is what I have in /etc/my.cnf on my current MySQL 3.23 server (dual AthlonMP,2GB RAM) [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking log-slow-queries = slowqueries.log set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = table_cache=1024 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = thread_cache=24 set-variable= max_connections=510 set-variable = thread_concurrency=16 set-variable = myisam_sort_buffer_size=64M set-variable= tmp_table_size=128M set-variable = wait_timeout=90 Whilst monitoring the server using 'mytop' is can see the server using between 250 400 threads, never dropping below 210 threads 'extended-status' reports: Max_used_connections=480 And these numbers are going to grow as the server gets busier, hence the Dual Xeon server with 6GB RAM. Instead of added more h/w in the future though, I'd like to be able to squeeze more out of Linux/MySQL I used a C program (thread-limit.c) which tests the amount the threads Linux can create (am I correct in assuming these are the same thing?) (I can send the 4k file if required) On my server, the program reports 255 threads max which I believe is down to glibc... With that kind of RAM and horespower you should be able to go well above 500 connections. The MySQL binaries are reported to handle 1000-1500 connections. I was wondering if anybody has achieved this building with source? If so, what version of libs, etc were used? We tend to use more boxes that cost less and replicate data I'd like to pursue that route in the future, but our d/b's all need writes and I haven't looked into replication hard enough to see how it would fit into our scheme. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - 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
Re: MySQL on large server
I rade some where that in the lateste MySQL versopn you can use 1000 to 1400 concurrent connection.Pls cross check in mysql site. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 5:36 PM Subject: Re: MySQL on large server On Thu, Jan 09, 2003 at 08:55:36AM +, mysql list wrote: Hi, I was wondering if anybody has built MySQL 3.23 from source that can handle a high number of connections threads. I've have tried MySQL binaries in the past (not RPMs), but these have had stability/load problems. When building from source I don't have those issues, but I am limited by the inbuilt limits (of glibc,etc...) How many connections do you need? If memory serves, the master db behind Slashdot was handling around 700 connections on a 4 processor P3 Xeon with 4GB RAM. But it's been a while since I've talked with Brian about it. I need to build MySQL 3.23 on a production server running RedHat 7.2, patched glibc (2.2.5-42) and a custom kernel (2.4.19-2 SMP). Hardware contains Dual Xeon 2.4GHz (hyperthreading disabled) and 6GB RAM. With that kind of RAM and horespower you should be able to go well above 500 connections. I'd say more on this topic, but I've not really needed to push MySQL in that direction. We tend to use more boxes that cost less and replicate data. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 863,460,485 queries (388/sec. avg) - 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 - 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
MySQL on large server
Hi, I was wondering if anybody has built MySQL 3.23 from source that can handle a high number of connections threads. I've have tried MySQL binaries in the past (not RPMs), but these have had stability/load problems. When building from source I don't have those issues, but I am limited by the inbuilt limits (of glibc,etc...) I read that glibc needs to be modified and file descriptor limits need to be increased, but I have been unsuccessful in finding some definitive documentation to achieve this. I need to build MySQL 3.23 on a production server running RedHat 7.2, patched glibc (2.2.5-42) and a custom kernel (2.4.19-2 SMP). Hardware contains Dual Xeon 2.4GHz (hyperthreading disabled) and 6GB RAM. My understanding is that MySQL can handle is 500 connections (recommended setting) by default. This is something I would need to increase as well as the ability to handle more threads. I would appreciate any help whatsoever. Many thanks _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus - 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
Re: MySQL on large server
On Thu, Jan 09, 2003 at 08:55:36AM +, mysql list wrote: Hi, I was wondering if anybody has built MySQL 3.23 from source that can handle a high number of connections threads. I've have tried MySQL binaries in the past (not RPMs), but these have had stability/load problems. When building from source I don't have those issues, but I am limited by the inbuilt limits (of glibc,etc...) How many connections do you need? If memory serves, the master db behind Slashdot was handling around 700 connections on a 4 processor P3 Xeon with 4GB RAM. But it's been a while since I've talked with Brian about it. I need to build MySQL 3.23 on a production server running RedHat 7.2, patched glibc (2.2.5-42) and a custom kernel (2.4.19-2 SMP). Hardware contains Dual Xeon 2.4GHz (hyperthreading disabled) and 6GB RAM. With that kind of RAM and horespower you should be able to go well above 500 connections. I'd say more on this topic, but I've not really needed to push MySQL in that direction. We tend to use more boxes that cost less and replicate data. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 25 days, processed 863,460,485 queries (388/sec. avg) - 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