Percona's MySQL & InnoDB performance and scalability blog
… 1 | | 1 | Harold Wesley Abbott Iii | 0 | | 3 | William Doyle Abbott Jr | 0 | | 5 | Robert Jack Abraham | 0 | | 7 | Mark Allen Abrell | 0 | +——-+————————–+——-+ And with 5… will take a look at performance. How does the speed of InnoDB FTS compare to its MyISAM counterpart, and…
… from MySQL 4.0 and 4.1 to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often… and we have to live with it, most likely MySQL 5.0 and 5.1 would not get any fixes for this problem, so… required anyway and it would allow to get some extra speed. It is often left at default value without a good…
… operations, but it is know to have good decompression speed even with 1 thread. UPDATE 17-Mar-2009: I added lzma results… stops to work. threadslevelcompressed sizecompress ratiocomression time, seccompr speed, MB/sdecomp time, secdecomp speed, MB/s qpress116,058.930.5210955.599265.86… the speed of processing is too slow. What is interesting on Level 5 the compression is worse than in pigz Level 5 pigz…
…# Processor ################################################## Processors | physical = 2, cores = 12, virtual = 24, hyperthreading = yes Speeds | 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ …in_prg {925} dm-0 462.1 34.1 7.7 0% 3.8 8.2 12.1 87.0 0.5 0% 0.0 0.7 93% 0 While number of operations…
… lock, heap no 5 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 80000002; asc ;; 1: len 6; hex… lock, heap no 5 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 80000002; asc ;; 1: len 6; hex… index is hash index Innodb builds for some pages to speed up row lookup replacing btree search with hash search. This…
…,c2); Using where; Using filesort 1 row in set (0.00 sec) As you can see MySQL 5.1.21 uses sort_merge to… data) takes 1sec. Let’s see how classic pre MySQL 5.0 solution – using UNION instead of single query works in this… finding rows or sorting as well) but query speed goes to less than 0.01 sec. So it is great optimization which…
… advanced techniques used in these allocators that should help to speed up allocation,purging of the dirty pages, minimize impact of… 1 – 5.5.30pre-jemalloc-3.0.0 # Set 2 – 5.5.30pre-jemalloc-3.1.0 # Set 3 – 5.5.30pre-jemalloc-3.2.0 # Set 4 – 5.5.30pre-jemalloc-3.3.0 # # Threads Set 1…
… install Percona-Server-shared-compat Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * addons: mirror.vcu.edu * base: centos.mirror….0.0 from install of Percona-Server-shared-compat-5.1.43-3.x86_64 conflicts with file from package Percona-Server-shared-51-5.1….0.0 from install of Percona-Server-shared-compat-5.1.43-3.x86_64 conflicts with file from package Percona-Server-shared-51-5.1…
… MySQL Performance 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected and… development there is no free lunch and your decisions to speed something up often will mean something else becomes slower. There…
…only one index actually used. To some extent, MySQL 5.0 and later changed this situation with the introduction … here that the (parent_id, status, user_type) = (0, 1, 2) tuple chosen by pt-query-digest as … not see right away. Disabling this setting might speed up this query (it did), but it might …
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.