Percona's MySQL & InnoDB performance and scalability blog
…in set (0.00 sec) After running the query, see how many pages were read from disk versus how many page requests their were: mysql…table_name, index_name, count(*) pages, sum(is_old=’YES’) old, count(*) – sum(is_old=’YES’) hot, sum(number_records) records…
…count in the table) It is worth to note if you do ALTER TABLE Innodb, same as MyISAM will internally run analyze as soon as table…TABLE for Innodb couple of more times to see how values change: mysql> analyze table antest_innodb; +——————–+———+———-+———-+ | Table…
…table creation time. Once I’ve got a table with an explicit FTS_DOC_ID column, however, MySQL…
…same benchmarks in Tokyo tyrant. All to often people force themselves into using a database like MySQL…in the database. Rinse and repeat. Sure these setups vary sometimes, throwing in a “lookup†via username, or even the rare count…how many…
…in the table: mysql> select count(*), count(distinct UniqueCarrier) from dim_flightG *************************** 1. row *************************** count(*): 58625 count(distinct UniqueCarrier): 29 1 row in…a list of the queries, followed by a response time table recording the actual response times…
…in this table and see how long does it take: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select count…in set (8.60 sec) Interestingly enough this statement already takes 1.5 seconds longer (I repeated runs many time…
…times faster which is interesting as it shows how much overhead you have by using mysql…table of 7 million records: mysql> select count(*) from paintings where title != ltrim_junk(title); +———-+ | count(*) | +———-+ | 101533 | +———-+ 1 row in set (6.82 sec) mysql> select count…
…mysql> show tables; +——————–+ | Tables_in_dumptest | +——————–+ | A | | B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | +———-+ 1 row in set (1.73 sec) mysql…
…a lot of memory Prepared statements and Cursors. Single connection may have many…MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer which is large enough to contain largest record in the given table…time…counted…
…same data to LucidDB, but I was not successful in this. I tried to analyze a…time: 0.5s for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL…many records, there is query select year,count(*) as c1 from ontime group by YEAR which shows how many records…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.