mysql processes

[Fraser]

more linux server questions if anyone can help me out with some advice it would be great. I feel like I'm back in school trying to learn french again and having no idea what anyone is talking about!

on a server that I'm using for some sites the host says that "the mysql processes are out of control" they seem to use up all the memory and then crash the server.

is this a case of just being too much for the server? my badly written queries? or the way mysql is configured?

[Aquanuke]

Most likely cause is just poor configuration. Most servers need to be tuned for how your using it.

Try disabling persistant mysql connections in your php.ini

edit the file /etc/my.cnf to suit your needs.

Your best bet would be to have alook at the vb forums as theres alot of good thread about tunning mysql.. and no doubt this thread would bore most members here to death

Would be a good idea to try this script..
http://www.vbulletin.com/forum/showt...?threadid=3477

Also you do need to tune apache and if your doing alot of php then something like php-accelerator would help keep it all together.

I usualy have around 200 mysql processes running and my.cnf looks like this..

PHP Code:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=500
interactive_timeout=100
wait_timeout=100
connect_timeout=10
thread_cache_size=96
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=768k
max_connect_errors=10
thread_concurrency=4
myisam_sort_buffer_size=64M
log-bin
server-id=1

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

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout 


[Fraser]

Thanks again aquanuke for the tips - ideal just to point me in the right direction.

my.cnf file has only one line in it - so it looks like it's not badly configured just not configured at all!