…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…high…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…high…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE_SCHEMA_MAX…MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql… with high number of connections/sec…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…the server by simulating number of failed connections. This can be avoided by having high max_connect_errors variables but this will obviously … having few connections which use appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…High Performance MySQL…+———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_…mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…
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…max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_… is very similar, due to high concurrency response time in the …
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 5.0.87-percona-highperf-log MySQL Percona High Performance…mysql [localhost] {msandbox} ((none)) > select @@global.max_connections; +————————–+ | @@global.max_connections | …
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 10 Comments
…Max processes” appears to have plenty of headroom. If max_connections is set to 1200, we should have no problem accepting 1200 simultaneous connections… in). If we have a high-traffic MySQL server with a very large… minutes or hours of unacceptable performance degradation while the buffer pool warms…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…could easily hurt performance instead of …max_connections. You’re right that higher values are desirable at high connection rates. max_connections was the best proxy we had for expected high connection…mysql_server_5_6_default . thread_cache_size is quite low, and dynamic based on max_connections…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… so we did it on MySQL side instead. “SET GLOBAL max_connections=20″ to limit number of connections to MySQL and so let application to err when it tries to put too much load on MySQL as MySQL load… dies with the high traffic ? How high is the response time penalty and how long it takes to reach normal performance ? Have a…
