The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Since Update to 11.44 i have Mysql Problems.

Discussion in 'Database Discussions' started by Bidi, Jul 11, 2014.

  1. Bidi

    Bidi Well-Known Member

    Joined:
    Oct 3, 2012
    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    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
     
    #1 Bidi, Jul 11, 2014
    Last edited: Jul 11, 2014
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Please post that ticket ID here if you would.
     
  3. Bidi

    Bidi Well-Known Member

    Joined:
    Oct 3, 2012
    Messages:
    51
    Likes Received:
    1
    Trophy Points:
    8
    Location:
    Romania, Transilvania
    cPanel Access Level:
    DataCenter Provider
    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.
     
  4. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,482
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Sounds like issues with the wordpress setup, or the addons/plugins you're using that's pounding the server to me.

    Please post that ticket ID here. Thanks.
     
Loading...

Share This Page