…-maint”,”host”:”localhost”,”cmd”:”Connect“,”query“:”Connect“} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…, as one had to rely on too much info (general log) or external help (snort or similar IDS).
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
…is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; …and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may…56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… queries doing PRIMARY KEY lookups (aka QPS sysbench mode); same MySQL queries executed…pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group …capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=… we use following queries: select avg(id) from sbtest$i force key…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…log…query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix for bug #1070856 introduced a regression in Percona Server for MySQL…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… default linkbench dataset has 10M ids(after load of data size of…outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5…innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at…connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…= 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 …query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id…threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb…log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect…query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size = 64M serverid…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…amazing MySQL manual, especially the option and ….commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual …Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log_fileblogpercona.commanual …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are serviced from the Query…MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…connections. Now let’s get started. Before We Start! But before we start, make sure you have enabled slow query logging…the vanilla MySQL server, you would see an entry like this in the slow query log: # Time:…of the output produced by pt-query-digest. # Profile # Rank Query ID Response time Calls R/…
