Since Update to 11.44 i have Mysql Problems.

Bidi

Well-Known Member
Oct 3, 2012
119
15
68
Romania, Transilvania
cPanel Access Level
DataCenter Provider
Hy guys i had opened an cpanel ticket and it says its oka but is not at all.

Oka so i made upgrade to cpanel 11.44 and since i made this update even to mysql, apache...etc if on the website is more then 30 50 people online the websites ar not working any more it says: Cannot connect to mysql database before i made the update i was having 1000 online people and i never had any problems and im so tired on this because i`m losing money me and my customers.

You have here screens /http://api.browsershots.org/png/original/99/99dfd5c25b0d0e1fd405e0a2f03d8656.png with the display error and im so despret because its allmowst a week with this problem.

I opened a tichet to cpanel and it says not is just fine but is not at all mysql with the new updates is nor working ok at all and i didnt made any changes to mysql just upgrade.

Please guys give me a hand.

This ar my : my.cnf

Code:
[mysqld]
max_connections=150
max_user_connections=30

key_buffer_size=325M
myisam_sort_buffer_size=64M

join_buffer_size=10M
sort_buffer_size=2M

table_open_cache=500
thread_cache_size=16
table_open_cache=1800

interactive_timeout=16
wait_timeout=600
connect_timeout=8

max_allowed_packet=268435456
max_connect_errors=10

query_cache_limit=1M
query_cache_size=128M
query_cache_type=1

max_heap_table_size = 128M
tmp_table_size = 128M

innodb_buffer_pool_size = 156M

tmpdir = /home/mysqltmp

slow_query_log=1
slow_query_log_file="/var/lib/mysql/slow.log"
open_files_limit=50000


local-infile=0
innodb_file_per_table=1
default-storage-engine=MyISAM
 
Last edited:

Bidi

Well-Known Member
Oct 3, 2012
119
15
68
Romania, Transilvania
cPanel Access Level
DataCenter Provider
Please post that ticket ID here if you would.
The cpanel team they still checking for the problem.

So in the final i fiind the problem the problem is with Wordpress i got some custommers who use Wordpress on with we have the same problem all of us if we have more then 70 100 online wordpress it says Cannot connect to database. If you whait a bit till someone quits the website and you hit refresh it starts to work.

And before making the updates i was having all the time 1000 Online imagine how much money i`m losing every day because of the problem. ( Ex: 150 Euros / Day . Now 5 10 )

In the other CSM or Custom CSM ones there is not problem they have 500 online on the website and it works perfect.

We still didnt fix the problem because we dont know why it makes like this.