…: The system was 2* Quad Core Xeon E5310, CentOS 5, Data stored on ramfs. We controlled number of cores used with /sys/devices/system… increases with number of cores. If you would not only run MySQL plugin but also use new “Barracuda” Innodb format you see just 1% slow down with 2 cores and about half percent with 8 cores which is what…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…. Q24: INNODB has typically had problems scaling on multicore boxes. The new quad core CPUs from AMD and Intel means that 8-core boxes are… any specific thoughts here? INNODB was originally written on single core CPUs. HT: Users have reported lots of InnoDB scalability problems from multicore CPU…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… team working on it. Q29: Would doubling the amount of RAM from 8Gig to 16Gig help the write performance of Innodb on Solaris… two-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-). At the moment the server… on this this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… 2*Dual Core CPUs seems to do very well, while with even just two Quad Core CPUs scalability issues can be observed on many workloads. Though this depends on the application a lot… more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on your recovery speed needs but 256M…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… benchmarks on my own. 2*Quad Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes (matches Innodb… on the box in question so I could not investigate where exactly CPU is wasted. My first obvious quess was Innodb checksumming (innodb… be one of the Items besides CPU scaling which Innodb team will put on their roadmap. With SSD coming this will be…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… I see here is that this is an 8-core machine, two quad-core processors at 2GHz. I also know some things about…. In addition, at the tail it has information on core dumps and so on. It’s possible that it has filled up with… I’ll look at SHOW INNODB STATUS\G and see if there’s anything worth commenting on there. Depending on the workload, there might…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
… Enterprise Linux AS release 4 (Nahant Update 4) 2 Ñ… Quad Core Intel XEON cpu family : 15 model : 6 model name : Intel…/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records (about 350Mb of data on disk) 2. Run…. Interesting InnoDB scalability is pretty bad for this query. The result with 4 thread is worse then with 1 thread on both…
Comment: Heikki Tuuri to answer your in depth Innodb questions
September 28, 2007 By 51 Comments
INNODB has typically had problems scaling on multicore boxes. The new quad core CPUs from AMD and Intel means that 8-core boxes are going… buying 40 8-core boxes with 32G of memory. Have any specific thoughts here? INNODB was originally written on single core CPUs. The other…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… really need your help on finding the solution for my problems. Fyi, i’m using 2 X quad core processor with 8gb of…_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries.log innodb_data_home_dir = /var/lib/mysql/ #innodb_data_file…-variable = innodb_buffer_pool_size=100M set-variable = innodb_additional_mem_pool_size=10M innodb_flush_log_at_trx_commit=1 #skip-innodb skip…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 2, 2007 By 51 Comments
…… you’re right. Multi-core scalability is a BIG problem that I’d like to see addressed with INNODB. BTW……. I think MySQL should 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…
