-
Hi!
Hello, i had "too many connections" error so i did these that bplex advised:
Mysql config:
Code:
[mysqld]
datadir=/var/lib/mysql
skip-locking
safe-show-database
query_cache_limit=3M
query_cache_size=256M
query_cache_type=1
query_prealloc_size = 163840
query_alloc_block_size = 32768
max_user_connections=300
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=10
thread_cache_size=384
key_buffer=256M
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=8M
read_buffer_size=8M
read_rnd_buffer_size=8M
thread_concurrency=16
myisam_sort_buffer_size=64M
server-id=1
[mysql.server]
user=mysql
[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
And this in httpd.conf:
Code:
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 10
MaxSpareServers 20
StartServers 15
MaxClients 180
MaxRequestsPerChild 1000
But than i couldn't convert videos! Cause i had this error:
"mysql server has gone away"
What to do? Please help!
-
Re: Hi!
too many connections
I had this error when i was running my torrent tracker site.
The connections amount can be altered through putty is you has root access
-
Re: Hi!
too many connections
I had this error when i was running my torrent tracker site.
The connections amount can be altered through putty is you has root access.
mysql server has gone away
This is do to your mysql server not responding
-
Re: Hi!
The settings that I posted are not for everyone to use. They were for the person who was having problems. Each person's system has to be tuned to their site.
The "too many connections" issue means that you need to increase your connection limit in mySQL. Your settings are too low for your site's traffic.
The "mySQL server has gone away" issue means that your timeouts are too short for the time that it is taking to convert your videos. You will need to increase your mySQL timeout.
-
Re: Hi!
okay, and how can i know what is the best settings? how to find out? And what is my server limits?
-
Re: Hi!
ask you web host they will know more about your server than anyone
-
Re: Hi!
my webhost is me, myself.. So that's not an option.
Any other possibility, a table showin what system can handle how much...
-
Re: Hi!
Unfortunately, that type of information does not exist. Most DBAs who do this sort of stuff for a living based their settings off of what they are seeing. For example, if you are seeing your site get 2000 connections, obviously you'll need to increase your connection limit to be more than that. I have not found any table that could give you suggestions.
-
Re: Hi!
Thanks anyway then i 'll be watching... :D