… Cores… this is number of hardware threads which is not exactly the same thing. Each T2 Plus CPU has 8 cores, which with 8… setup 32! MySQL instances on this box (approximately one per core). Comparing single instance performance (4350 statements/sec) to the total… over 50.000 queries on 8 cores (and close to 40.000 queries/sec on 4 slow AMD cores). Do not get me…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… had 8 cores it is little use for MySQL as only one query is ran concurrently, same can be told about 8 hard… issue for MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half… processing was not too bad, however with 16,32,64 cores it is just too bad.
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… seem to cap out something in the innodb kernel around 8 parallel inserting threads. Any more than that and I actually… vmstat shows 6-7 cores spinning and about 1 core worth of IO wait I have 8 idle CPU cores. IOStat shows I’m… think), that older versions of innodb have concurrency issues around 8 cores and up, but frankly I’ve not seen that issue…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… seem to cap out something in the innodb kernel around 8 parallel inserting threads. Any more than that and I actually… vmstat shows 6-7 cores spinning and about 1 core worth of IO wait I have 8 idle CPU cores. IOStat shows I’m… think), that older versions of innodb have concurrency issues around 8 cores and up, but frankly I’ve not seen that issue…
Comment: Big Iron for tests anyone ?
March 21, 2008 By 10 Comments
… x86, up to 8 core, 64 thread) http://www.sun.com/servers/coolthreads/t2000/specs.xml (non x86, up to 8 core, 64 thread) http://www.sun.com/servers/x64/x4450/specs.xml (up to 4 quad core Intel) http…://www.sun.com/servers/x64/x4600/features.xml (up to 8 dual core AMD, upgradable to quad)
Comment: MySQL and PostgreSQL SpecJAppServer benchmark results
January 7, 2009 By 13 Comments
…! The PostgreSQL was run on an 8 core HW while the MySQL was run on 4 core system. They were totally different. And… wrong information… MySQL 5 720.56 12 cores, 6 chips (2 core/chip) Postgres 8.2 778.14 12 cores, 6 chips (2 cores/chip)
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 17 Comments
… experiments we went through and just share final numbers. On 8 core Opteron Box we were able to achieve 275K inserts/sec… start. Using multiple buffer pools with innodb_buffer_pool_instances=8 was very important. Second thing – Partitioning. Unfortunately MySQL 5.5… would expect gains can be higher with more cores. PARTITION BY HASH(col) PARTITIONS 8 is what we used. This looks like…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… can see for J2EE the system with 8 cores was used while for database 4 cores was enough. Does it mean the J2EE… ? Or does it mean MySQL did not scale well to 8 cores on this benchmark ? Now lets look at Java Settings: JDBC… = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… way too little for what you would expect from 24 core system. For comparison you can checkSysbench Results which Vadim published… 1 thread to peak performance on system with 12 physical cores and 24 threads, which is almost perfect scalability. So there… where you still can’t get use of more than 8 cores effectively (which would correspond to single CPU socket these days…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 2, 2007 By 51 Comments
Peter. Regarding #22… you’re right. Multi-core scalability is a BIG problem that I’d like to … assume machines will have 8 cores from here on out. They’re REALLY cheap. You can get quad cores from AMD + Intel now and put two chips per box. An 8 core machine with 16G of memory…
