Вариант А
В случае медленных запросов, оптимизируем их, добавляем индексы и т.д.
Вариант Б
Одновременные соединения. В этом случае распределяем их на разное время запуска, чтобы они были выполнены не в одинаковое время. Т.е. убрать вот такие варианты:
|
1
2
3
4
|
$otime = date('i');while ( true ) {if ( $otime != date('i') ) { mysql_query('SELECT 1'); $otime = date('i'); }} |
А может быть оптимизация кода Вам не подойдет, тогда можно увеличить кол-во одновременных подключений. Это делается в файле конфигурации mysql, а именно /etc/my.cnf, вот в этой строчке:
|
1
|
max_connections = 250 |
Стандартное значение после установки 100. После внесения изменений, нужно рестартануть демона mysqld, делается это командой:
|
1
|
/etc/init.d/mysqld restart |
и теперь можно проверить, все ли ок, sql запросом:
|
1
|
SHOW VARIABLES LIKE 'max_connections' |
Вот и всё. Не забывайте делать резервные копии перед внесением изменений в конфигурационные файлы!
Mysql too many connections
Wow, incredible blog structure! How long have you ever been blogging for?
you made running a blog glance easy. The full glance of your
web site is fantastic, as well as the content material!
You can see similar here ecommerce
Today, I went to the beach with my children. I found a sea shell and gave
it to my 4 year old daughter and said «You can hear the ocean if you put this to your ear.» She put the shell to her ear and screamed.
There was a hermit crab inside and it pinched her ear. She never
wants to go back! LoL I know this is entirely off topic but I had to tell
someone! I saw similar here: Dobry sklep
If you wish for to obtain a good deal from this article
then you have to apply these strategies to your won web site.
I saw similar here: Najlepszy sklep
Good day! Do you know if they make any plugins to help with Search Engine Optimization?
I’m trying to get my website to rank for some targeted
keywords but I’m not seeing very good results. If you know
of any please share. Appreciate it! I saw similar article here:
Hitman.agency
Good day! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my website to rank for some targeted keywords
but I’m not seeing very good results. If you know of any please
share. Cheers! I saw similar art here: GSA Verified List
Wonderful perspective! The points you made are very enlightening. For further information, visit: DISCOVER MORE. Excited to hear your views!