Percona's MySQL & InnoDB performance and scalability blog
…in MySQL…rows in set (53.78 sec) session10 > show status like ‘Open%tables’; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 1 | +—————+——-+ 2 rows in…
…rows affected, 1 warning (39.73 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> show…10 rows in set (0.00 sec) mysql> delete from dir_test_innodb LIMIT 200000; Query OK, 200000 rows affected (8.65 sec) mysql…
…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…
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…
…in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In…MySQL 5.5.30 and MySQL 5.6.10…: mysql: SHOW CREATE TABLE innodb_myisam_stopword\G *************************** 1. row …in replacement for your current MyISAM FTS, the results may surprise you. That last…
… 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…
… 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…
…in mind when using this new feature (and these points are probably the reason why it was not included in MySQL in…show-stopping, in the future we will work to remove them. The full usage notes, including discussion when the dynamic row…
…row-level locking, and foreign keys | YES | YES | YES | [...] mysql> SELECT “Hello World!” AS “Success!” \G *************************** 1. row *************************** Success!: Hello World! 1 row in…
…. 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…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.