Percona's MySQL & InnoDB performance and scalability blog
…to check which sessions have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables…
…to find out how to make InnoDB FTS blazingly-fast, but simply to get a sense of how it works compared to…to DROP multiple FT indexes with InnoDB in the same ALTER TABLE statement, but it’s not possible to CREATE…select…
… table we created earlier. This step is known as probe step. This join algorithm works best for highly selective …10; In-memory workload Now let’s see how effective are the join optimizations when the workload…set to 6M. MariaDB 5.5 is close, yet slower by ~10s. Another thing that is important to know…
…select * from test_innodb; ERROR 2013 (HY000): Lost connection to MySQL server during query Recovering CREATE TABLE from .frm file for MyISAM Table…table MySQL comes with another creative error message if .frm is the only file which exists: mysql> show create table…
…TABLE for MyISAM vs Innodb. I used the following simple table for tests: CREATE TABLE…select count(distinct i,c) from antest; +———————+ | count(distinct i,c) | +———————+ | 10201 | +———————+ 1 row in set (0.43 sec) Lets see how…Another…
…an overview of how to install and …to process SBR changes from a MySQL master. I’ll talk more about that in another…metadata table: $ mysql -e ‘select * from flexviews.binlog_consumer_…create a table, insert some rows, add a change log, delete rows and then insert some more of them: mysql> create table…
… of how fast this can be restored to another server, is how fast you…to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How to…to be investigated The number one cause of backup alerts are due to problems with “FLUSH TABLE WITH READ LOCK”. Namely when a select…
… to look at yet another similar variable – innodb_open_files which defines how… and creating 100.000 tables with single integer column. The process of creating tables…to be flushed before recycling. First ran however was done with clean buffer pool (after reading all tables once) Same as with select…
…how much time MySQL spends in…database to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT *…6 | 0.0001336667 | | Creating tmp table | 0.000548 | 0.32 | 1 | 0.0005480000 | | Opening tables | 0.000196 | 0.11…, I could add in a UNION to inject another row for “lost time” …
… the wp_options table. Another thing to note is the last line in the output the # MISC part, it tells you how much of…+ # Tables # SHOW TABLE STATUS FROM `wp_blog_one ` LIKE ‘wp_options’\G # SHOW CREATE TABLE `wp_blog_one `.`wp_options`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.