…_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… the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After creating… = 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_heap…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… = 4000 innodb_use_native_aio=0 #not innodb options (fixed) port = 3306 back_log = 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_heap…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…, faster inter-process/node communication). Results: First of all, we used a smaller dataset for this benchmarks round, since reportedly Dimitri… = 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: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… ids(after load of data size of datadir ~10GB). We used this dataset to check server behavior when data fully fits…_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query… # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive_hash_index_partitions=8 innodb…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
….2 — New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for… report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III… the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for… report that it received a packet larger than the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III… the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_seeks_for_keyblogpercona.commanual max_sort_lengthblogpercona.commanual max_sp_recursion_depthblogpercona.commanual max_tmp_tablesblogpercona.commanual Max_used_connectionsblogpercona.commanual max_user_connectionsblogpercona.commanual max…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’, ’28987′ ‘Key_blocks_used‘, ’1332′ ‘Key_read_requests’, ’1552507′ ‘Key_reads’, ’1654′ ‘Key_write_requests’, ’114303′ ‘Key_writes’, ’1346′ ‘Max_used_connections‘, ’651′ ‘Not…_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key_buffer_size=32M # Only for MyISAM which isnt used. sort…
Comment: 10+ Ways to Crash or Overload MySQL
November 14, 2007 By 20 Comments
… for user ‘sdf’@'localhost’ (using password: YES) [pz@mail pz]$ mysqladmin extended | grep conn | Aborted_connects | 2 | | Max_used_connections | 0 | | Threads_connected | 1 | So entered password is counted as aborted connect. If those do not count towards max_connect_errors this…
