Gossamer Forum
Home : General : Databases and SQL :

Mysql Max Users Connect?

Quote Reply
Mysql Max Users Connect?
On my installation (on a dual cpu 2gig ram dedicated server) the my.cnf file has only following:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

max User Connect is 100 by default. Where exactly is this variable changed? What values could be set?

Thnx

Anup
Quote Reply
Re: [anup123] Mysql Max Users Connect? In reply to
100 is fine, there's no reason to change it unless you have a *seriously* busy site. Most sites probably use well under 100 connections.
Quote Reply
Re: [Paul] Mysql Max Users Connect? In reply to
Hi,

| Aborted_clients | 22 |
| Aborted_connects | 6 |
| Bytes_received | 2321907 |
| Bytes_sent | 7338318 |
| Connections | 714 |
| Created_tmp_disk_tables | 3 |
| Created_tmp_tables | 89 |

Does this imply some hardware error. The first two records... could it be related to filedescriptors available on my version of linux. Where doe one get the same (which file in /proc exactly and can that be changed if yes how?). Linux details:

Linux version 2.4.7-10custom (root@rekor1.rekor.net) (gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) #16 SMP Wed Apr 24 00:06:47 EEST 2002

Anup

Last edited by:

anup123: May 16, 2003, 6:26 AM