June 19, 2013

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

rows affected, 1 warning (39.73 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> show10 rows in set (0.00 sec) mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql

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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in… new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…

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. InMySQL 5.5.30 and MySQL 5.6.10…: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. rowin replacement for your current MyISAM FTS, the results may surprise you. That last

Post: Finding out largest tables on MySQL Server

MySQL instance is no brainier in MySQL 5.0+ thanks to Information Schema but … 10 rows in set (2 min 29.19 sec) I do some converting and rounding to see number of rows in millions and data and index size in GB so I can save on counting zeros. The last column shows

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

… explained in my previous post) to lookup the rows in table2….in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here and BKA in… desc, o_orderdate LIMIT 10; In-memory workload Now …are sized appropriately, which shows that the IO … MySQL 5.6. Next interesting thing are the last

Post: Dynamic row format for MEMORY tables

in mind when using this new feature (and these points are probably the reason why it was not included in MySQL inshow-stopping, in the future we will work to remove them. The full usage notes, including discussion when the dynamic row

Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

row-level locking, and foreign keys | YES | YES | YES | [...] mysql> SELECT “Hello World!” AS “Success!” \G *************************** 1. row *************************** Success!: Hello World! 1 row in

Post: SHOW INNODB STATUS walk through

…. In MySQL 5 number of Innodb performance counters were exported and now available in SHOW… len 7; hex 00000040150110; asc @ ;; 3: len 10; hex 61202020202020202020; asc a ;; *** (2) TRANSACTION:…last section – row operations which shows activity on the row basics and some system information. It shows