Skip to main content

Database issue

Comments

6 comments

  • cPanelMichael
    Hello :) Are those the only entries you could find in the MySQL error log? Do the time stamps match when the issue occurred? Thank you.
    0
  • lfait
    [quote="cPanelMichael, post: 1668412">Hello :) Are those the only entries you could find in the MySQL error log? Do the time stamps match when the issue occurred? Thank you.
    Yes, from error_log inside the script that is the only error i'm facing now . the remote server is dealing about 100+ connections each 1Second, 90% are passing okay about 5% randomly are giving such errors like not allowed to connect etc.. Is there anything i didn't change to enable more connections per second ? Even with back_log it's set to accept 2048 connections per 1 sec . Regards
    0
  • lfait
    Still struggling with this issue I have increase OS limitations root@replication [~]# cat /proc/sys/fs/file-max 1000000
    root@replication [~]# ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 773762 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 65503 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 773762 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited root@replication [~]#
    cat /etc/security/limits.conf httpd soft nofile 45503 httpd hard nofile 55503 mysql soft nofile 50000 mysql hard nofile 65000 mysql soft nproc 50000 mysql hard nproc 65000
    Still can't find any clue why MySQL is loosing about 3000 connections randomly from 17,000 . Any suggestions would be great, also if a paid solution is there I'm ready for it . Regards
    0
  • InterServed
    Hi, What is your MySQL version ? Personally i would try to test if you face the same problem by using MariaDB or Percona feature "Thread Pool", do some research about it: thread_handling = pool-of-threads
    0
  • lfait
    [quote="InterServed, post: 1670751">Hi, What is your MySQL version ? Personally i would try to test if you face the same problem by using MariaDB or Percona feature "Thread Pool", do some research about it: thread_handling = pool-of-threads

    Server version: 5.5.37-cll - MySQL Community Server (GPL) I guess i found some clues regarding to my issue . [QUOTE]root@power [/home/runner/www]# netstat -an | grep :* | wc -l 15389 root@power [/home/runner/www]# netstat -an | grep :80 | wc -l 1105 root@power [/home/runner/www]# netstat -an | grep :443 | wc -l 7649 root@power [/home/runner/www]# netstat -an | grep :3306 | wc -l 7334 root@power [/home/runner/www]#
    Now it seems i'm getting the max cPanel connections as each script need to have 1 SSL + 1 SQL ports for it Is there a way to maximize my dedicated server to handle 65500 connection and not the default cpanel which is 16xxx on my server . My server is 256GB ram + 40 Cores Xeons I'm only using about 120 GB ram and less than 15% of CPU I need to use all possible connections on that server . Regards
    0
  • cPanelMichael
    I moved this thread to the "Optimization" forum where you will likely receive more user-feedback for this type of question. Thank you.
    0

Please sign in to leave a comment.