… two Intel Westmere CPUs (X5670 @ 2.93GHz). Each CPU has 6 cores and 12 threads. The most amazing part is the amount… get from “threads”, as there are only 12 “real” cores, with each core having two “threads”. So, I took Percona Server 5… the fact that half of them are not real CPU cores. For up to 10 threads, the scale factor is quite…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…caption id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So… on repeat runs) Test Server: Intel core i970-3.20GHz. 12 logical cores (six physical cores). 12GB memory 4 disk 7200RPM RAID 10… | 3 | 18223 | 0.3784 | | `ssb`.`dim_date` | PRIMARY | 17 | 11 | 6 | 2414 | 0.2075 | | `ssb`.`lineorder` | LO_OrderKey | 17 | 17 | 0…
Post: Getting MySQL Core file on Linux
August 26, 2011 By 1 Comment
… “/tmp/corefiles/core” > /proc/sys/kernel/core_pattern echo “1″ > /proc/sys/kernel/core_uses_pid First we enable dumping cores of suid applications…)[0x518414] /lib/libpthread.so.0(+0xf8f0)[0x7fbb86de98f0] /lib/libc.so.6(__poll+0×53)[0x7fbb86066f93] /usr/sbin/mysqld(_Z26handle_connections_socketsv+0×124… this message – you should see Segmentation fault(core dumped) after Writing a core file. If core file was not written you will just…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… which we used for testing. Even though box had 8 cores it is little use for MySQL as only one query… to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737.540.99 Query2NANANA Query3NANANA Query4NANANA Query5NANANA… issue for MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
….011 cache size : 12288 KB physical id : 3 siblings : 6 core id : 5 cpu cores : 6 fpu : yes fpu_exception : yes cpuid level : 11… TPS as with 1 connection (and it is on 24-cores box!). XtraDB is slightly better there than InnoDB, but nothing… cases is something to worry about in 16+ cores boxes. Intel Based 24 Core Servers are not mainstream these days but as…
Comment: Air traffic queries in InfiniDB: early alpha
November 5, 2009 By 19 Comments
… take cores offline to mimic a 2, 4, and 8 core server. In spite of this hack, with 6 out of 8 cores offline the measurements were remarkably similar (a total of 178.6 seconds on the dual Xeon, and a total of 174.56 seconds with 6 cores offline). Because this…
Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
…) 6 cores (12 threads) @ 2.93 GHz 6 x 4 = 24 (so 4 sockets) And the Opterons of course have slower clocked cores but more per socket, so 12 cores… is interesting to see that the chips with more physical cores cannot end up scaling past the chips with the faster…
Comment: Intel Nehalem vs AMD Opteron shootout in sysbench workload
April 25, 2011 By 41 Comments
…) 6 cores (12 threads) @ 2.93 GHz 6 x 4 = 24 (so 4 sockets) And the Opterons of course have slower clocked cores but more per socket, so 12 cores… is interesting to see that the chips with more physical cores cannot end up scaling past the chips with the faster…
Comment: Percona Server scalability on multi-cores server
October 1, 2010 By 14 Comments
… series(8 cores), the latest Cisco equipment does not use the memory extender technology that they have on the 4/6-core systems…’m a fan of the HP BL685c G7 blade 48 cores, 32 DIMMs, and of course HP has Fusion IO expansion boards for their blades. Fully loaded chassis with 384 cores and 4TB of memory comes in at about 6,700W in 10U.
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/tmp | | SECURE_AUTH | OFF | ON | | VERSION | 5.5.30 | 5.6.10 | | INNODB_CONCURRENCY_TICKETS | 500 | 5000 | | INNODB_PURGE_THREADS | 0…_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file… concurrency workloads. Makes sense as servers have a lot more cores available these days. query_cache_type and query_cache_size…
