… post. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but…”,”host”:”localhost”,”cmd”:”Connect“,”query”:”Connect“} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… to connect and talk more about MySQL buffer pools or anything else that’s on your mind! There are numerous solutions for MySQL… – http://master_server:3307/slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest…: Are these MySQL tools able to be run against Amazon RDS instances? A: It depends. Most MySQL tools can connect to remote hosts… the sakila database 1 master and 2 slaves installed with MySQL Sandbox, with the sakila database Thanks to everyone who attended…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… a try. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t have a… (https) connection over the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options… me”. pt-stalk 2.2 and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools…
Post: MySQL Connection Timeouts
April 19, 2011 By 4 Comments
… busy MySQL server you will see sporadic connection timeouts, such as Can’t connect to MySQL server on ‘mydb’ (110). If you have connects timed in your application you will see some successful connections taking well over the second. The problem may start very slow…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
…/libc.so.6(__poll+0×53)[0x7fbb86066f93] /usr/sbin/mysqld(_Z26handle_connections_socketsv+0×124)[0x51ba64] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0xcfc)[0x521b0c… in many cases could be to connect as “gdb -p `pidof mysqld`” select “continue” and let MySQL run. If it crashes you… if you expect to do any MySQL profiling or dealing with crashes. It does not slow MySQL performance yet it is very helpful…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option …commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona….Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…,btr_search_build_page_hash_index,btr_search_info_update_slow,btr_search_info_update,btr_cur_search_to_nth_level…,mysql_select,handle_select,execute_sqlcom_select,mysql_execute_command,my sql_parse,dispatch_command,do_command,do_handle_one_connection,handle_one_connection…,JOIN::exec,mysql_select,handle_select,execu te_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection,handle…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… only works when persistent connections or connection pools aren’t used and is only accurate when single mysql connection is used during execution of…, you are usually interested in queries that are consuming most MySQL time and that’s how mk-query-digest groups and…_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew some particular pages were taking…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…, key_buffer_size etc, you have reasonable amount of connections but yet MySQL takes much more memory than you would expect, causing… max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections (or stopping related… good tools to detect memory leaks like valgrind are too slow to run in production. So the best thing to do…
