Percona's MySQL & InnoDB performance and scalability blog
…_test_myisam ORDER BY 3 DESC LIMIT 1; +——-+—————-+——-+ | id | full_name | score | +——-+—————-+——-+ | 62633 | Thomas B Smith | 1 | +——-+—————-+——-+ Looks … this hypothesis, I reset innodb_ft_min_token_size to 1, dropped/rebuilt the InnoDB index,…
…update_time ’0000-00-00 00:00:00′ GROUP BY 1) t; The answer which came back was also completely … +———————+ | min(update_date) | +———————+ | 2024-06-21 10:35:55 | +———————+ (root@localhost) [test]> select update_date FROM foo order by update_date LIMIT 5…
… AND Year BETWEEN 2000 AND 2008 GROUP BY Origin ORDER BY c DESC LIMIT 10; 4.96 sec Query Q4: mysql> SELECT… WHERE YearD BETWEEN 2008 and 2008 GROUP BY DestCityName ORDER BY 2 DESC LIMIT 10; And times for InfiniDB: 1y: 8.13… sec 3y: 24.46 sec 4y: 32.49 sec 10y: 1 min 10.35 sec Query Q9: Q9: select Year ,count(*) as…
…order by author_id desc limit 10; +————+——–+———-+ | id | weight | forum_id | +————+——–+———-+ | 6739362135 | 1 | 2736983 | | 6739362391 | 1 | 2736983 | | 6739338327 | 1 | 1024599 | | 6739357527 | 1 | 1023063 | | 6739359063 | 1 | 1024599 | | 6739305559 | 1… (1 min…
… serious limitations in the fast index creation feature introduced in…ALTER TABLE t ADD COLUMN v VARCHAR(1); Query OK, 4194304 rows affected (1 min 1.97 sec) Records: 4194304 Duplicates:…indexes because records are inserted in the correct order into sequentially allocated pages after merge-sorting. So…
…LIMIT is used. Take a look at this simple example: mysql> explain select * from rnd order by r desc limit 1 \G *************************** 1. row *************************** id: 1… which may flood it quite badly. Too bad –min-examined-row-limit is not yet implemented 
EXPLAIN would also return …
…,89% set option 1,189 1,84 0,03% I have a gallery with select query with ORDER BY, LIMIT and with paging — Handler…, 1 CPU 4core with 4 Gb RAM, 3Tb SATA disk space Load avg: 0.81 (1 min) 0.68 (5 mins) 0.73 (15 mins) Real memory 3.86 GB total, 1.38 GB used Virtual…
… against (“internet”) order by score desc limit 10; +—————————————+—————–+ | title | score | +—————————————+—————–+ | ….8775291442871 | +—————————————+—————–+ 10 rows in set (1 min 46.73 sec…
… | 720100 | 3572 | | 6019 | 718031 | 3475 | +————-+————-+————-+ 10 rows in set (43 min 10.11 sec) As an added benefit, if you build… I delete some line items from orders: mysql> delete -> from order_lines -> where order_id -> between 1 and 100 -> limit 500; Query OK, 484 rows…
…UPDATE: 78153671549 COUNT_DELETE: 4292 SUM_TIMER_DELETE: 1302645570629 MIN_TIMER_DELETE: 18127219 AVG_TIMER_DELETE: 303505097 MAX_…mysql> select * from file_summary_by_instance order by COUNT_READ desc limit 6G *************************** 1. row *************************** FILE_NAME: /data/tachion/sb…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.