Re: MySQL on large server

[my5ql _]

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