… considering changing web-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
I have innodb tables in my production database and i have set files_per_table variable. … TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ‘MB’) DATA, CONCAT(ROUND(data_free / ( 1024 * 1024… table abc engine=innodb and re-executed SELECT TABLE_SCHEMA, TABLE_NAME, CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), ‘MB’) DATA, CONCAT…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…memory (and would have fit even with only a few GB of main memory). The cost of querying this database …fit. But with all 4 indexes the data itself is 2 or 3 times bigger, and the B-tree nodes …hits the memory wall at about 100M rows, which matches my prediction that at 400M rows and 55GB RAM, Inno …
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2 Compute Units (8 virtual cores with… innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my results are as follow: Transaction1: root@localhost:test 14… of [21,30],but it came out my insert still be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0… inserting mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 1216, 1 row lock(s…
Comment: MySQL on Amazon RDS part 1: insert performance
April 25, 2012 By 37 Comments
I see no improvement from RDS with innodb_flush_log_at_trx_commit set to 2 or 0. My benchmarks have the same results, regardless of the setting. Does RDS fools the flush in some way or has the setting disabled somehow?
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Justin, I would be doing another benchmark and use ‘innodb_ibuf_accel_rate’ together with tuning other IO related parameters that I can tune to good affect, and I will post my results.
Post: Testing Fusion-io ioDrive2 Duo
May 10, 2012 By 12 Comments
I was lucky enough to get my hands on new Fusion-io ioDrive2 Duo card. So I … I did for other Flash devices. This is ioDrive2 Duo 2.4TB card and it is visible to OS as two…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… special, and I feel that both do not fully reflect my needs when I run benchmarks. Uniform is stupidly simple: for…, is following: say row 1 accessed N, then row 2 is accessed 2^θ less times, row 3 is accessed 3^θ….1)=466,516 times, row 3: 1,000,000/(2^1.1)=298,652 times, …, row id=10000 : 1,000,…
