…the other nodes, a GTID will also (by design) be established. We’ll never end up with…to several hundred. This really will open a large window where rows won’t be able to…the database periodically? if( $last_count % 100 == 0 ) { $db->do( “UPDATE achievements SET count = $last_count where achievement…
Comment: About This Blog
September 22, 2010 By 48 Comments
…. I’m a DB novice (ie. I can use them and design alright, but not tune for high traffic, large db stuff) but have recently inherited a poorly designed, very poorly optimized/tuned MySQL DB…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…performs well. The issue is even this simple design can start to have issues as the data…accept storing data ( at least temporarily ) outside the DB. Think memcached. Almost everyone loves memcached, it’s… # of writes in MySQL coupled with the still large # of reads takes its toll. Another place where…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…see what can be done to remedy it. We designed the benchmark the following way – there is a …@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb… gives about 330 req/sec and mysqldump for large table completes in about 95 seconds. If we …
Comment: Blob Storage in Innodb
February 17, 2010 By 13 Comments
… blob table. What you achieve: 1) A single large file in the filesystem for that 1 InnoDB …row compression and pay the CPU price on your DB server, or have your application compress/decompress upon …that price on your app. server. 2) A well-designed meta-data table will contain everything you need …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… INNODB STATUS output will not grow too large. Transaction id is current transaction identifier – it … Free buffers 0 Database pages 258053 Modified db pages 37491 Pending reads 0 Pending writes: LRU…see a bit conflicting information. This is by design as requiring global lock to provide consitent …
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…can be quite large because of the…processlist; +——-+——+———–+———-+———+——+————————-+—————————–+———–+—————+———–+ | Id | User | Host | db | Command | Time | State | Info | Rows… (other than code design) for read lock…
Comment: 128GB or RAM finally got cheap
August 6, 2008 By 14 Comments
… a RAID 5+0 configuration. I have it configured with large_pages and about 80GB in the innodb_buffer_pool. The… is reserved for temp tables (20GB tmpfs partition) and connections (large buffer sizes are setup). The only thing we’ve found… designed to scale out. However, in this case, being able to quickly insert many thousands of records per second into one DB…
