Percona's MySQL & InnoDB performance and scalability blog
…Records: 0 Duplicates: 0 Warnings: 1 mysql> show warnings; …mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY | VALUE | +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1032677 | | last…
…see into it. If there’s no record later that someone else can follow, …ways to get this information, too. The last three commands are for giving me …disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | …
… MySQL configuration, we quite often want to know how various …b.col2 You can see these un-indexed queries in SHOW STATUS as Select_full_join, and you want zero… join cache with packed records 14178 Records are stored in tab->cache.buffer and last record in 14179 last record is stored with pointers…
…event staff, and especially the attendees for making last week’s conference a resounding success. With … of credit for putting on a great show, with fun activities for everyone. Akiban, for example…. Sheeri Cabral also recorded some of the breakout sessions, so watch Planet MySQL for an announcement …
… MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as …DESC LIMIT 100) l ORDER BY start_time which shows last queries in the end similar to tail command. …consuming. This is actually where being able to sort records by physical position quickly without need to have …
…SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL…*** WE ROLL BACK TRANSACTION (2) For last deadlock Innodb shows transactions which caused deadlocks, …”undo n:o” will show the undo log record number which purge is currently…
…, 4194304 rows affected (1 min 1.97 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW PROFILE; +——————————+———–+ | Status | Duration | +——————————+———–+ | starting | 0.000054 | | checking…) mysql> ALTER TABLE t MODIFY v VARCHAR(2); Query OK, 4194304 rows affected (36.07 sec) Records: 4194304 Duplicates: 0 Warnings: 0 mysql> SHOW… let’s repeat the last test with innodb_buffer_pool_sizeset to approximately 1/10th of the dataset: mysql> SET expand_fast…
…Can you quickly show the my.cnf settings again? A: Sure, see this post or webinar recording. Q: Fault… on asynchronous replication, galera and built-in mysql replication are independent from each other. Q: … to different groups of clients. So, the last gcomm:// option should be avoided. Although it …
…mysql> alter table am auto_increment=1000; Query OK, 0 rows affected (0.00 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> show… CHARSET=utf8 INSERT_METHOD=LAST UNION=(`a1`,`a2`) | …
…you may not be affected as bad as we show here. Benchmarks were done using this script: … $i 10000000; mysql -e’drop database test1′; mysql -e’create database test1′; done; tables: 1; total records: 10000000; …update is a lot of overhead. During this last test box felt really sluggish responding 10+ …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.