… on the performance/scalability of MySQL server in the read-only workloads… Testing details: Cisco USC_C250 box Percona Server 5.5.24 2… taken into account – memory footprint. table { width: 80%; margin: 0; background: #FFFFFF; …To cover some questions raised in the comments I rerun OLTP_RO/POINT_…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
…very nice post about MySQL Replication Performance. There are however few points I should comment on. Jeremy Speaks…such effect just by enabling log_bin. Innodb tables also have to flush logs on transaction commit… out and keep single server a box with few CPUs and few hard drives while running MySQL…
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… value (8M). So if you have dedicated MySQL Box and you’re only using Innodb tables you will want to give all memory… System needs you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…of this. I had added my comments to some of the questions. HT…ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_…has typically had problems scaling on multicore boxes. The new quad core CPUs from…if ORDER and ORDERLINE tables are joined to form a single table), it might make…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 … results I want to show graphics with comments READ_PK_POINT Query: SELECT name FROM … Unfortunately InnoDB shows bad scalability for 8CPU box, in many cases the transition from 16…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…to change, and actually out-of-box things running pretty well. There …can take there https://launchpad.net/mysql-patch/mytools What makes fractal …and in this case – read previous comment. – The version we tested did …transparent backup, as it applied TABLE LOCK on copying table. When recovery logs are…
Comment: MySQL VIEW as performance troublemaker
August 24, 2009 By 57 Comments
…Simple select: mysql> select count(*) from (select * from comments where user_id in (select user_id from comments where … lists based on three tables (account, client, client-address) tables: client’s names list, …lists client-side-software maps grids, combo-boxes and other. In author’s example, …
Post: Scaling to 256-way the Sun way
November 11, 2008 By 13 Comments
… we have to setup 32! MySQL instances on this box (approximately one per core)….MySQL The Matt Ingenthron commented “Sun†is not, to my knowledge, “aggressively pushing T2000 as Scalable MySQL… single thread performance (REPLICATION, ALTER TABLE etc) and willing to run insane number of MySQL …
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
…DataWarehouse oriented engines I used single table without joins, and with small (as …( I run benchmark on 8 cores box), and it allowed to load … and graph is below. There couple comments from me. InfoBright was fully 1…blog http://infinidb.org/infinidb-blog/mysql-parallel-query-processing-of-ssb-…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…Same as during last time I will provide my comments for some of the answers under PZ and … of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been …% already) So, is the general recomendation also for boxes with larger amounts of RAM, to give INNODB ~…
