… you use for running MySQL in Production ? I guess most of the game here is between Intel and AMD x86-64 variants…
Post: What CPU Architecture do you prefer for running MySQL In production
November 24, 2012 By 13 Comments
Post: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
…, one based Intel Nehalem (Cisco UCS C250) and second on AMD Opteron (Dell PowerEdge R815), I decided to run some simple… took sysbench oltp ( both read-only and read-write) and MySQL 5.6.2 as it seems most scalable system at… threads throughput drops significantly. I actually suspect this is rather MySQL problem, and 32 cores may be limit of scaling for…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… for MySQL as well. From these numbers performance looks great and it looks like finally Intel has something to respond to AMD… presentation – neither of them was match to Opteron performance in MySQL workloads. As benchmark used in this article is very different… article also has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on Linux with…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… use Sun Fire X4200 M2 available in September 2006, using AMD Opteron 2220 SE. We can see some 5% difference in… databases) is not where most of MySQL sweet spots come from. MySQL performance gains usually come from MySQL unique features – non transactional MyISAM… at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL 5.2
Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 26, 2011 By 41 Comments
… have a leg up on the scalability side under MySQL workloads. The AMD chips are far better suited for true multi-threaded… can execute that process faster and release the lock. On AMD, the individual cores can only execute instructions so fast, so… where resource locking isn’t an issue, i think the AMD chips would have a better leg up because they could…
Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
… have a leg up on the scalability side under MySQL workloads. The AMD chips are far better suited for true multi-threaded… can execute that process faster and release the lock. On AMD, the individual cores can only execute instructions so fast, so… where resource locking isn’t an issue, i think the AMD chips would have a better leg up because they could…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… sysbench http://www.mysqlperformanceblog.com/files/benchpbxt/phptest.lua The mysql.start script with startup parameters for InnoDB and PBXT http… AMD Opteron(tm) Processor 2210 stepping : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version We used MySQL… Compilation parameters: For MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… was done on my home test box (2Ghz AMD Sempron CPU) using MySQL 4.1 and PHP 5.0. For memcached access… File Cache 27000 Memcached Cache (TCP/IP) 12200 MySQL Query Cache (TCP/IP) 9900 MySQL Query Cache (Unix Socket) 13500 Selecting from… used, but if Unix Socket is used to connect to MySQL MySQL Query Cache will be faster. The explanation for this is…
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
… really make it work, considering how many bottlenecks remain in MySQL. What article really tells us ? First the number 256 – this… not, to my knowledge, “aggressively pushing T2000 as Scalable MySQL Platformsâ€. – Well what this one would be ? Of course it… single MySQL instance showing over 50.000 queries on 8 cores (and close to 40.000 queries/sec on 4 slow AMD…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from 16GB… AMD Opterons. Yes it helped:-). At the moment the server has around 21 GB of memory used for applications (of which Mysql… – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent…
