…row queries (SELECT, INSERT, DELETE, UPDATE) are similar in speed…row writes are likely to be slower in PARTITIONed tables unless you include something to facilitate pruning. A billion rows…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…MySQL has installations with many billions of rows…1 row in set (4 min 58.63 sec) mysql> select count(pad) from large where val between 1 and 100; +————+ | count(pad) | +————+ | 314008 | +————+ 1 row…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
…mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select count(i) from sample for update; +———-+ | count(i) | +———-+ | 1638400 | +———-+ 1 row…row level locks should not be the problem even for rather large databases – even billion of locked rows…
