… with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ…MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult to work with. MyISAM…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…-H run, and it can’t be because we used MyISAM tables which are not ACID complaint. Plus we only measured… box had 8 cores it is little use for MySQL as only one query is ran concurrently, same can be told about 8 hard…. Parallel query will be growing issue for MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… mostly CPU bound. Next I went on testing MySQL. My goal was to simulate as much IO …scale well with increased concurrency even though we had 8 cores available for disposal. Unfortunately oprofile did not work … it back to the client. I tested MyISAM with myisam_use_mmap option which did not seems to …
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… Last time I worked with similar system it used MyISAM and the system was built using multiple tables. …we went through and just share final numbers. On 8 core Opteron Box we were able to achieve 275K … which went down to about 15% in MySQL 5.5.8 with 8 concurrent threads. This both shows there is …
Post: Modeling InnoDB Scalability on Multi-Core Servers
January 26, 2011 By 11 Comments
…MyISAM benchmarks that Oracle recently published prompted me to do some mathematical modeling of InnoDB’s scalability as the number of cores…core counts and with sysbench on another machine, instead of taking 12 cores away from MySQL… could “upgrade” from 4 to 8 cores and see a reduction in throughput…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… see here is that this is an 8-core machine, two quad-core processors at 2GHz. I also know…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…an indication that it’s time to convert MyISAM tables to InnoDB. (But then again, it …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5… is now 8 instead of 1 optimizing for higher concurrency workloads. Makes sense as servers have a lot more cores available these… getting MyISAM because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL 5…
Post: Talking MySQL to Sphinx
April 19, 2009 By 4 Comments
…_links` smallint(5) unsigned NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 This table contained … | 2735703 | +————+——–+———-+———–+———+ 10 rows in set (32.47 sec) MySQL mysql> select max(forum_id) as m,…through 100M+ rows on the single modern 8 core server which is quite…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… not escalate MyISAM scalability question. This time working on the customer system we figured out that box with 1 CPU Core is… results for MyISAM using MySQL 5.0.45 run on 4 Core System: Threads queries/sec 1 161 2 107 4 110 8 121… with 4 Cores. Here is comparison of MyISAM Innodb and Falcon results in the graphical form: I’ve created bug, for MyISAM key…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…# Processor ################################################## Processors | physical = 2, cores = 12, virtual = 24, …MySQL configurations, I didn’t try out different MySQL…myisam_recover skip-grant-tables Amount of rows used was 20M, transactions were not used (autocommit), number of threads – 1, 4, 8…
