…. We tested 10G and 100G data sets which was CPU bound and IO bound box on the Dell 2950 box w 16G of… to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737… MySQL because CPUs just continue to add more cores. Having 2 CPUs and being able to use only half of system CPU…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
Backing up MySQL Database most people compress them – which can make a good … takes extra CPU resources on the source server in additional to IO resources which may not be available, especially for CPU bound MySQL Load… in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events…
Post: Scaling IO Bound Workloads Webinar
June 19, 2009 By 2 Comments
… for IO Bound Workloads in MySQL. My part of the presentation will be speaking about why switching from CPU bound workload to IO bound is… you’re interested in Schooner appliance offerings, flash or scaling MySQL in General. You can follow this url to register.
Post: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
…+————————–+ | 0 | +————————–+ 1 row in set (1.50 sec) # T2000 mysql> select benchmark(100000000,1+2); +————————–+ | benchmark(100000000,1+2) | …if you’re running time sensitive long running CPU bound queries or if queries contribute significant time …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 2
October 16, 2009 By 8 Comments
… and looked at boosting performance of the application by buffer MySQL with memcached. Our test application is simple and requires… Fast api, MySQL gets hammered. This type of thing happens a lot. For example an application is CPU bound, so you add more processing power, but then you hit disks harder and now your disk bound. A couple…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… see as response to these requirements ? From MySQL side we have further development of MySQL Cluster to be more usable for web… can be used with MySQL to get very fast IO and so consolidate system suffering from IO bound workloads. There is KickFire appliance around the corner which more focuses on CPU bound complex queries and there…
Post: Interesting MySQL and PostgreSQL Benchmarks
November 30, 2006 By 20 Comments
… share too much information about how MySQL or PostgreSQL was configured or about queries. Furthermore MySQL and PostgreSQL has a bit different… used in the benchmark. This is CPU bound benchmark with working set fitting in memory. MySQL and PostrgreSQL Scalability on Xeon Woodcrest, Opteron… interesting to see CPU comparison in this test. Woodcrest has best performance in this test (and in many other MySQL tests), Opteron…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… impact of several memory allocators on the performance/scalability of MySQL server in the read-only workloads. For my testing i… my experince this new malloc behaved not always efficiently with MySQL so i decided to include old one to comparison as… consists of 4 sysbench tables(50M rows each) ~50G data / CPU bound case innodb_buffer_pool_size=52G For every malloc allocator…
Post: MySQL Partitioning - can save you or kill you
December 11, 2010 By 45 Comments
I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant … fit in buffer pool completely so replication became CPU bound (single thread) instead of IO bound. You could celebrate but hey…. you need…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… spike in MySQL usage Personally I would see a few more things implemented. A few examples to mention: per-user CPU time usage, some queries may be CPU bound rather than reading lots of rows support for prepared statements which all currently fall under Other_commands a few MySQL…
