…the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is the configuration that I used: ## InnoDB options … 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
…  Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New Features Added…system variable have_response_time_distribution and compile option –without-response_time_distribution in Response Time Distribution…._gettime() is present in librt at the configure stage. If yes, -lrt is added to LIBS….
Page: Presentations
May 3, 2006 By
…MySQL Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1…MySQL Users Conference 2004, Orlando, FL Presentation shows how much you can improve performance by OS setting and Hardware configuration…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…). When I have mounted the partition with inode64 option however, the effect disappeared and performance without LVM … different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I … {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… for the disk here so the RAID has 4 bearing disks (spindles) and if there’s … 145648 cylinders, total 2339840000 sectors Units = sectors of 1 * 512 = 512 bytes Disk identifier: 0×00091218 Device Boot… also one of the options you usually have to decide on very early when configuring RAID. Disk sectors…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…BH_RSI_Repository 4.0K brighthouse.ini 4.0K brighthouse.log 4.0K brighthouse.seq 964K mysql 123M ontime1 …: NULL Create_options: Comment: Contains all avaialble data from 1988 to 2010 1 row in set (…configuration There is a script provided to generate the shards.ini file for testing an cluster of 1…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…4 cores was enough. Does it mean the J2EE system got saturated before the database ? Or does it mean MySQL…what you can try for JDBC configuration. Some caching options are must (otherwise JDBC will have…slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data_home_dir = /data/mysql/var innodb…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…I usually look for MySQL is performance in …4.8: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 1 Extra file open flags: 16384 1…configuration: We get 4735.27 Requests/sec from 1 thread and single file; 4740.19 Requests/sec from 64 threads and 1…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…/3/4 file system is sticking to defaults when it comes to behavior on errors. By default these filesystems are configured to… are reported back to MySQL/Innodb it will assert and restart. Now lets look at couple of other options you might want… every so often check MySQL tables for corruption. To change those options you can run tune2fs -m0 -i0 -c -1 /dev/sda1 changing…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
…cache in the controller in RAID1+0 configuration. First the raw numbers – 100 threads, 20%…4.1 331.4 1207.4 81.3 | 60.7 10.0 335.7 1201.1 83.5 312.7 | 250.8 4.1… in xfs – I use a mount option allocsize=1g). The second problem is … of what MySQL is doing so we are currently testing xfs with MySQL. But …
