June 20, 2013

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

…rows in set (53.78 sec) session10 > show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 1 | +—————+——-+ 2 rows in…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , ,

Post: Dynamic row format for MEMORY tables

September 6, 2011 By 5 Comments

…last week. There have been efforts in the community to remove this limitation. In…in mind when using this new feature (and these points are probably the reason why it was not included in MySQL in…row format delivers the memory savings for VARCHAR fields agains the fixed row format. For that we modify…

Filed Under: MySQL, Percona Software

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In…: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row … “WITH PARSER” modifier to …in replacement for your current MyISAM FTS, the results may surprise you. That last…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Edge-case behavior of INSERT...ODKU

October 27, 2012 By 6 Comments

…last_modified | +—-+———-+———+———————+ | 1 | foo | 3 | 2012-10-05 22:58:28 | +—-+———-+———+———————+ 1 row in…in which they were defined, and the PRIMARY KEY is always going to be considered as being defined first. So, MySQL…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… things. In MySQL 5 number of Innodb performance counters were exported and now available in SHOW STATUS…is typically done by calling fsync() for modified files. Constant high values for any … last section – row operations which shows activity on the row basics and some system information. It shows …

Filed Under: Insight for DBAs Tagged With:

Post: Flexviews - part 3 - improving query performance using materialized views

April 4, 2011 By 20 Comments

…row *************************** cnt: 155187034 1 row in set (32.03 sec) mysql> select sum(total_lines) cnt from dashboard_top_customers\G *************************** 1. row *************************** cnt: 155187034 1 row in…

Filed Under: Insight for DBAs, MySQL

Post: Debugging problems with row based replication

May 6, 2010 By 12 Comments

…modify any rows.  No binary logging will be performed by this statement in row… |    65536 | +———-+ 1 row in set (0.02 sec) My test setup includes a MySQL…SHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL_Running: No Last_Errno: 1032 Last…

Filed Under: Insight for DBAs, MySQL Tagged With: , , , ,

Post: Statement based replication with Stored Functions, Triggers and Events

December 16, 2011 By 4 Comments

…in Master and Slave servers. Example: mysql> create trigger Copy_data AFTER INSERT on t FOR EACH ROW… a SHOW SLAVE STATUS you will see a message like the following one: Last_Error…In this case neither the trigger, the CALL or the queries inside the procedure that modifies data are logged. So in…

Filed Under: MySQL

Post: Recovery deleted ibdata1

August 10, 2012 By 9 Comments

…time, there are modified pages in the buffer…sequence number and last checkpoint in “SHOW ENGINE INNODB …mysql# /etc/init.d/mysql restart After the restart all InnoDB tables are reachable: mysql> select count(*) from sbtest; +———-+ | count(*) | +———-+ | 1000000 | +———-+ 1 row in…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… can fix this by modifying shard-query/run_worker to… was discussed in the comments of the last post. ICE …mysql> show table status like ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row…

Filed Under: MySQL
« Older Posts