June 18, 2013

Comment: Innodb Performance Optimization Basics

March 4, 2008 By 75 Comments

… this out given the recent posting on the about checking MySQL Config files. Keep up the fantastic work. Kirby

Filed Under: Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09 FTS_00000000000000ad_CONFIG.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 16:09….ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15:55 FTS_0000000000000114_CONFIG.ibd -rw-rw—-. 1 mysql mysql 98304 Feb 20 15:54…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark

March 11, 2013 By 7 Comments

… tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings except innodb_old_blocks_time=0 Config 3: MySQL… Rationale: Since O_DIRECT is not used by default, the file system cache will give better read performance after first run…

Filed Under: MySQL Tagged With: , , , , ,

Post: How to replace a NDB node on EC2

June 9, 2011 By 10 Comments

… a new IP? Just change the IP in the cluster config and perform an rolling restart! no? In fact this will… solved by using host names instead of IPs in the config.ini file. What needs to be done is to define, in… the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname…

Filed Under: MySQL

Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script

August 19, 2010 By 6 Comments

…/ha.d/ha.cf and ask heartbeat to reload its config MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE…/ha.d/ha.cf and ask heartbeat to reload its config MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE… of the monitor host in the heartbeat ha.cf configuration file and then, finishes up some missing configuration settings of the…

Filed Under: Insight for DBAs, MySQL Tagged With:

Comment: New Forum Categories: Help Wanted, For Hire

March 5, 2013 By 1 Comment

Hi, My Current MYSQL Config as below. Could you please provide us suggestions to improve … innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor boonton…

Filed Under: Events and Announcements Tagged With:

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… the shards.ini file for testing an cluster of 1 to 20 nodes. cd shard-query #generate a config for 20 shards…/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file…

Filed Under: MySQL

Comment: How to estimate time it takes Innodb to Recover ?

June 25, 2008 By 7 Comments

… a MySQL replication slave the last master binlog file InnoDB: position 0 12501110, file name bin.000025 InnoDB: Last MySQL binlog file position 0 90914, file name /var/log/mysql/bin.000027…_64 x86_64 x86_64 GNU/Linux Also currently: these config (my.cnf) were all disabled from 20 servers: # Uncomment the…

Filed Under: Insight for DBAs Tagged With:

Comment: Can we improve MySQL variable handling ?

February 19, 2012 By 8 Comments

… problems here is MySQL concept of treating all options as command line parameters which may not come from config file at all. I think software which has main config file which is being read (which may…

Filed Under: MySQL

Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)

December 21, 2010 By 11 Comments

…_log_files_in_group=2) innodb_flush_neighbor_pages=0 innodb_adaptive_checkpoint=keep_average innodb_read_ahead=none For MySQL 5.5.8, I used: innodb_log_file_size=2000M (innodb_log_files_in_group=2), as… innodb_log_files located on separate RAID10 partitions, InnoDB datafiles on the Virident tachIOn 400G card The raw results, config, and script…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , ,
« Older Posts
Newer Posts »