…lower_case_file_systemblogpercona.commanual lower_case_table_namesblogpercona.commanual master_bindblogpercona.commanual master_connect…
Post: MySQL Limitations Part 4: One thread per connection
October 27, 2010 By 14 Comments
… is about the way MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple threads. Not all databases… whenever possible, because of things like the lower startup cost for the query). But MySQL isn’t a data warehouse DBMS first…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…thread and in MySQL 5.6.2 one can have multiple dedicated purge threads. Percona Server 5.1 supports multiple purge threads…format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona Server … of lower TPS. There is one possible area for improvement: once the purge threads …
Post: What to tune in MySQL Server after installation
September 29, 2006 By 116 Comments
… for people to work as MySQL DBAs or be involved with MySQL Performance in some way …100.000 used. thread_cache Thread creation/destructions can be expensive, which happen at each connect/disconnect. I …. For certain workloads cache hit ratio is lower than would justify having it enabled. Note: …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…_locks_immediate’, ’895966639′ ‘Table_locks_waited’, ’20096′ ‘Threads_cached’, ’0′ ‘Threads_connected‘, ’260′ ‘Threads_created’, ’124272′ ‘Threads_running’, ’3′ ‘Uptime’, ’4433556′ # top …=8M # Lowered from 32M according to MySQL innodb_additional_mem_pool_size=20M innodb_file_io_threads=4 innodb_…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…alignment, not different MySQL configurations, I didn’t try out different MySQL versions or …threads = 8 innodb_write_io_threads = 8 innodb_io_capacity = 200 port = 3306 back_log = 50 max_connections = 2500 max_connect…benchmarks, the reason was in fact lower number of IO operations and higher …
Comment: MySQL Limitations Part 4: One thread per connection
October 29, 2010 By 14 Comments
… many connections is unused memory buffers like sort/join and additional locks on one_thread_per_connection_scheduler checks increments/decrements. Maybe per-connection… locks on thread count after all thread init completes successfully. If the priority of connection threads lower then a priority of system mysql threads, the thread storm it…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… is not really constant, sometime he is lower to 5% and sometime it’s upper…mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_…log_at_trx_commit=2 [mysql.server] user=mysql basedir=/var/lib thread_concurrency = 8 max_allowed_packet…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…upgrading from 5.0 / 5.1.23 or lower: any indexes on columns in that …connection to the remote server was closed leading to an unappropriated network error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized…
Post: Percona Server 5.5.14-20.5
August 17, 2011 By 4 Comments
…upgrading from 5.0 / 5.1.23 or lower: any indexes on columns in that …connection to the remote server was closed leading to an unappropriated network error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and#61790 in MySQL (Alexey Kopytov). Querying…
