…connection: Connection refused (111) Connection to cluster failed: Transport endpoint is not connected… …but MySQL is still running: [root@percona2 percona]# mysqladmin ping mysqld…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default…
Comment: Configuring MySQL For High Number of Connections per Second
August 17, 2012 By 23 Comments
…about this: is the server (mysqld or os) aware in anyway of the client connection attempt? The error is … question, why the error code changes if I set a timeout on the client >=63 seconds? I tested …~]$ mysql -h 172.0.0.1 –connect-timeout=62 ERROR 2003 (HY000): Can’t connect to MySQL server on ’172….
Comment: Why MySQL could be slow with large tables ?
December 17, 2012 By 141 Comments
…wait_timeout=120 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql init_connect=’SET collation_connection = utf8_general_ci; SET NAMES… default-character-set=utf8 set-variable = max_allowed_packet=32M [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid …
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
…Enterprise with dual SCSI RAID: [mysqld] long_query_time=5 …type=1 max_connections=1500 interactive_timeout=25 wait_timeout=10 connect_timeout=5 …connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections…
Comment: What to tune in MySQL Server after installation
October 6, 2006 By 118 Comments
… ratio only between 40-50%). My current settings: [mysqld] max_connections = 300 max_user_connections = 300 key_buffer = 16M myisam_sort_buffer_… 1000 thread_cache_size = 200 interactive_timeout = 25 wait_timeout = 30 connect_timeout = 10 max_allowed_packet = 2M max_connect_errors = 1000 query_cache_…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
…21 and the sorftware has the following settings: [mysqld] log-error=/var/log/mysqld.log init_connect=SET CHARACTER SET utf8 datadir=/data/mysql socket=/data…resolve #skip-bdb default-time-zone=America/Caracas max_connections = 1000 wait_timeout = 60 thread_concurrency = 2 max_allowed_packet = 1M […
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
… can do some settings Here is mysql configuration (We are having only 1 mysql server, no replication setup) [mysqld] datadir=/var/lib… = 16K wait_timeout = 120 connect_timeout = 60 tmp_table_size = 192M max_heap_table_size = 192M max_allowed_packet = 64M #max_connect_errors = 10000…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_cache_size =…need to connect to mysqld run on the same host. # All interaction with mysqld must be … MASTER_USER=’joe’, MASTER_PASSWORD=’secret’; # # OR # # 2) Set the variables below. However, in case …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets [mysqld] port=3323 server-id=1 socket=/tmp/mysqld…log_size=100M #read-only # limits max_connections=1000 #old-passwords #lower_case_table_…buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M …
