…changes…type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql…query_cache_size = 0 query_cache_type…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, …Com_alter_db_upgradeblogpercona.commanual… Com_change_dbblogpercona.commanual Com_change…type_conversionsblogpercona.commanual Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…type/refresh method are interchangeable since a refresh method is selected at the time of view creation and may not be changed…”CREATE TABLE db.schema … AS SELECT” and/or “INSERT INTO db.schema …querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query …
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…changes in MySQL…type of queries…mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are serviced from the Query…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
…MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f”, ulonglong2double(query…DB,Query,Field List,Create DB,Drop DB,Refresh,Shutdown,Statistics,Processlist,Connect,Kill,Debug,Ping,Time,Delayed insert,Change…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
…queries from MySQL query-log and tcpdump files and run them on other MySQL…queries with a response time longer than the ones run on the original. Additional statistics, like the query types…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… –datadir=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult 28852… is off the table. Queries can be rewritten. Indexes and data types and table structures can be changed. Queries can be broken into pieces…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…type: Query Server_id: 1 End_log_pos: 271 Info: BEGIN *************************** 4. row *************************** Log_name: mysql-bin.000007 Pos: 271 Event_type: Query…MySQL, because the logging of stored procedures has changed…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…change_db‘, ’155′ ‘Com_change_master’, ’0′ ‘Com_check’, ’0′ ‘Com_checksum’, ’0′ ‘Com_commit’, ’9558970′ ‘Com_create_db…_types‘, ’0′ ‘Com_show_create_db‘,…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
… executes one particular type of statement) and…mysql_execute_command frame: (gdb) frame 21 #21 0x00000000005a30af in mysql… the query cache if something changed 3141 after unlocking when changes become … = 72}, cs = 0x101e980}, db = 0x7f3e84004b70 “test”, db_length = 4},
