Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Mysql my.cnf limits

Discussion in 'General Discussion' started by bsasninja, Jun 1, 2007.

  1. bsasninja

    bsasninja Well-Known Member

    Joined:
    Sep 2, 2004
    Messages:
    528
    Likes Received:
    0
    Trophy Points:
    166
    I´m running mysql 4.1.21 and have this in my /etc/my.conf

    set-variable = max_connections=300
    set-variable = max_user_connections=100
    set-variable = connect_timeout=10
    set-variable = wait_timeout=10

    I want to add more limits to avoid excesive usage of mysql, I read that there are two commands

    max_connections_per_user
    max_connections_per_ip

    which value should i set to them ?

    Thanks
     
    #1 bsasninja, Jun 1, 2007
  2. s3bhost.net

    s3bhost.net Member

    Joined:
    May 29, 2007
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    151
    Hello,

    open ssh and type :

    Code:
    pico /etc/my.cnf
    remove all and add
    Code:
    [mysqld]
max_connections = 400
key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M
skip-innodb
[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 32M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout
safe-show-database
set-variable=local-infile=0
    restart mysql :

    Code:
    /etc/init.d/mysql restart
     
    #2 s3bhost.net, Jun 1, 2007
  3. Un Area

    Un Area Well-Known Member

    Joined:
    Nov 16, 2006
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    156
    yeah but no values for

    max_connections_per_user
    max_connections_per_ip
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 Un Area, Jun 2, 2007
  4. bsasninja

    bsasninja Well-Known Member

    Joined:
    Sep 2, 2004
    Messages:
    528
    Likes Received:
    0
    Trophy Points:
    166
    Anyone is using this settings at /etc/my.cnf ?

    max_connections_per_user =
    max_connections_per_ip =

    which values should I insert there? This settings works with mysql 4.1.21 ?

    Thanks
     
    #4 bsasninja, Jun 4, 2007
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mysql limits
  1. navhost

    reinstalling mysql

    navhost, Aug 16, 2018 at 3:32 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    91
    cPanelMichael
    Aug 17, 2018 at 12:14 PM
  2. planetjoin

    From mysql 5.7 to MariaDB 10.0.34 manually

    planetjoin, Aug 11, 2018, in forum: Database Discussion
    Replies:
    5
    Views:
    107
    cPanelMichael
    Aug 16, 2018 at 10:26 AM
  3. martin MHC

    Updating MySQL/MariaDB but unsure what needs to be recompiled

    martin MHC, Aug 10, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    88
    cPanelLauren
    Aug 15, 2018 at 7:47 AM
  4. Guilherme Nastrini

    xmlapi.php não cria BD Mysql

    Guilherme Nastrini, Aug 10, 2018, in forum: Discussões em Português
    Replies:
    7
    Views:
    152
    Guilherme Nastrini
    Aug 14, 2018 at 12:02 PM
  5. conductexam

    Connection refusedFailed to connect to MySQL

    conductexam, Aug 9, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    92
    cPanelLauren
    Aug 13, 2018 at 9:06 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice