…have instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the …or 5 hours ALTER TABLE command. Let me also comment on the memory fit diagram – understanding your working … also fully support Matt in his views of black boxes. If you want to be able to resolve …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
… PowerEdge R900 box, using RAID10 over 8 disks and a FusionIO 320GB MLC card. First, the results for tpcc-mysql, 500w… way. UPDATE By request from commenter I put also results with different innodb_io_capacity for MySQL 5.5.8. It is…: [client] socket=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
….00GHz CPU. This number is per core. In theory this box which has 4 cores should be able to do up… rows and wrote little stored procedure to make timing easier: mysql> DELIMITER // mysql> CREATE PROCEDURE test_read(pl INT) -> BEGIN -> DECLARE t…_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) mysql> select count(*) from m4 where c>”a…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… several memory allocators on the performance/scalability of MySQL server in the read-only workloads. For my …:/lib64:/usr/lib64 Testing details: Cisco USC_C250 box Percona Server 5.5.24 2 read only …. UPDATE: To cover some questions raised in the comments I rerun OLTP_RO/POINT_SELECT tests with …
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. Jeremy Speaks about MyISAM… flush their cache. Watch out for MySQL 5.0 – if you enabled Binary log with MySQL 5.0 you loose group commit… to go with scale out and keep single server a box with few CPUs and few hard drives while running MySQL.
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… their stats and post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. The… displaying samples; * displaying table status and CREATE statements; * reviewing and commenting on queries. Despite its lack of ability to save predefined…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified… it at default value (8M). So if you have dedicated MySQL Box and you’re only using Innodb tables you will want… big boxes, though it can be even less than that. Besides Operating System needs you also have MySQL needs – these include MySQL buffers…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…size : 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM /… interesting results I want to show graphics with comments READ_PK_POINT Query: SELECT name FROM $tableName…better. Unfortunately InnoDB shows bad scalability for 8CPU box, in many cases the transition from 16 …
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
…get really good performance we have to setup 32! MySQL instances on this box (approximately one per core). Comparing single instance …Perfrormance with MySQL The Matt Ingenthron commented “Sun†is not, to my knowledge, “aggressively pushing T2000 as Scalable MySQL Platformsâ€. – Well…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…up questions out of this. I had added my comments to some of the questions. HT will stand …? HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_…Q24: INNODB has typically had problems scaling on multicore boxes. The new quad core CPUs from AMD and …
