… | 24×1600.000 Models | 24xIntel(R) Xeon(R) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory …MySQL versions or settings. Moreover, I have been running these benchmarks for a customer so I just used…io_capacity = 200 port = 3306 back_log = 50 max_connections = 2500 max_connect_errors = …
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
MySQL server intensively uses dynamic memory allocation so a good choice of memory allocator is quite important for the proper utilization of CPU… not always efficiently with MySQL so i decided to include old one to comparison as well. I used glibc-2.13 for…/scalability runs with tcmalloc also demonstrate best response time (30-50 ms at the high threads). Besides throughput and latency there…
Post: The Optimization That (Often) Isn't: Index Merge Intersection
December 14, 2012 By 6 Comments
…Using intersect(user_type,status,parent_id); Using where; Using index; Using filesort At first glance, this might not look too bad. MySQL is using… ==== ===== == # 1 0xCF90A421D9FB8717 1022239.0748 66.9% 311599 3.2806 0.50 0.02 SELECT user…several orders of magnitude and CPU utilization on the machine…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…asked if it could scale to 50, but testing 20 was all …limitation in resources in a cluster (cpu, memory, disk, power,etc) then … can automatically partition sets into subsets using basic relational algebra substitution rules …speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’…
Comment: MySQL Partitioning - can save you or kill you
June 29, 2012 By 45 Comments
… plan for the query, but it _may_ not. > This base mysql version (5.1.56) supports partitions, but does not support… stupidity and guide I pegged you as being relatively knowledgeable. USE/FORCE INDEX — Do these only as a last resort. As… disk-intensive and the app is CPU-intensive. Do not allow swapping; that will kill MySQL performance. “50 users” — a useless metric without…
Post: How network can impact MySQL Operations ?
September 1, 2008 By 5 Comments
… lot of data copying around between MySQL boxes. We had prepared well and …mentioned you can get even better with using fast parallel compression like LZO or … projected 80MB/sec. The IO and CPU usage both on source and target … now would like to restore all 50 servers from backup… in parallel. Will …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
….net/svnroot/sysbench The used LUA script for sysbench http://www.mysqlperformanceblog.com/files/benchpbxt/phptest.lua The mysql.start script with…) Processor 2210 stepping : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta… between %d and %d Interesting PBXT is better here by 50-80% READ_KEY_RANGE_LIMIT Query: SELECT name FROM $tableName…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
… sleeping, 2 running, 0 zombie, 0 stopped CPU states: cpu user nice system irq softirq iowait idle total…96 3304016194 1360995328 cciss/c1d1 66.15 227.50 255.83 3441930690 3870514728 cciss/c1d1p1 66…/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb_buffer_pool_size=1800M # USE…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…(R) CPU 5130 @ 2.00GHz stepping : 6 cpu MHz : 1995.004 cache size : 4096 KB 16GB of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…_id = %d and state_id between %d and %d LIMIT 50 READ_FTS Query: SELECT min(dob) FROM $tableName The hardest…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
… of logical IO is happening CPU bound. The beauty of this terminlogy (and so why I use it) – it is very easy to see if system is IO bound or CPU bound, while to understand if MySQL goes…. Typically you will not be able to get over 30-50% from the second hard drive (and diminishing returns if you…
