… given configuration. What is the formula they could use. The reasons to worry about memory usage are quite understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however configure it so… increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections increases peak memory consumption just 30MB not 3000MB as you…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… seen a situation where mysql reports max connections reached and freezes, with a bunch of processes waiting to finish. Also, mysql will not shut… # Replication Slave (comment out master section to use this) # # To configure this host as a replication slave, you can choose between…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have …back_log = 50 max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = …
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… many customers having large number of connections opened in MySQL and although I told them this … I installed Percona-Server-11.2 which I configured with the following Innodb settings: innodb_buffer_…DIRECT innodb_flush_log_at_trx_commit=0 max_connections = 10000 open_files_limit = 32768 The desktop …
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…clear the current input statement. mysql [localhost] {msandbox} ((none)) > select @@global.max_connections; +————————–+ | @@global.max_connections | +————————–+ | 5000 | +————————–+ 1 row in … assumes you had less than 5000 max_connections configured…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… MySQL server connections. Some people simply do not realize you can increase max_connections variable and get over 100 concurrent connections with MySQL… MySQL connection open, others will serve static content such as images which also does not need MySQL connection open. In optimal configuration…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable amount of connections…up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
… new connections to MySQL per second during peak times. This is a high number by any account. When a new connection to MySQL is… as a queue for new connections on operating system size to allow MySQL to handle spikes. Although MySQL connections are quite fast compared to… call. The maximum value on Linux is directed by tcp_max_syn_backlog sysctl parameter unless syncookies are enabled. The simple…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…dips, but an adaptive flushing still requires big log files. MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file…= 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…MySQL configuration… +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_…mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…
