…_buffer_size=52428800 read_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max… will help you identify the cause of the crash. 130528 09:53:56 mysqld_safe Number of processes running now: 0 130528 09…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results in both posts look… = 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance… –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov… (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey… a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov… (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance bugs. (Alexey… a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…: As we can see, all of the configuration options produce numbers that, in the absence of outliers, are roughly identical, but …= 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max_…
Post: Configuring MySQL For High Number of Connections per Second
January 6, 2012 By 23 Comments
…/tcp_max_syn_backlog) and the only limitation would be that you could potentially have a large number of connections waiting on connection instead of failing quickly and potentially connecting to different server, but that can be fixed by setting the client connect…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
…. I recently had to work with many customers having large number of connections opened in MySQL and although I told them this was… connections, basically to match the number of available computing threads the Core i5 allows. I know by experience that this is about the max DBT2 NOTPM for small number of…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… (spikes) of connections which is rather unrelated to number of connections. You can get 1000s of connections a second even from as little as 100 connections, hence max_connections would… max_connections + 1 for every 20 max_connections over 500, capped at 2000 Same thing. What number of max connections has to do with number of hosts which can potentially connect…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…with persistent connections is using too many MySQL server connections. Some people simply do not realize you can increase max_connections …of “overload”. In case your number of connections is limited you start getting connection errors which are easy to handle, in case of large number of connections…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… was run with default settings except following: [mysqld] user=root max_connections=3000 innodb_log_file_size=128M innodb_flush_log_at… decreases MySQL’s performance on 6-20% depending on a number of connections to a database. It should be noted during the test… observed. IO-bound case – 100 warehouses Database size 10GiB # of connections No logging, NOTPM Logging queries > 1 sec, NOTPM Ratio no…
