June 20, 2013

Post: Dynamic row format for MEMORY tables

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

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

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

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

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

Post: SHOW INNODB STATUS walk through

… 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

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

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

Post: Debugging problems with row based replication

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 MySQLSHOW SLAVE STATUS\G Relay_Log_File: mysql_sandbox25162-relay-bin.000002 Relay_Log_Pos: 340718 Slave_SQL_Running: No Last_Errno: 1032 Last

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

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

Post: Recovery deleted ibdata1

…time, there are modified pages in the buffer…sequence number and last checkpoint inSHOW 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

Post: Shard-Query EC2 images available

… 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