… can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /usr/local/mysql/data) or # ~/.my.cnf to set user-specific…_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… per transaction. here is data from my tests: computer 1: My.ini [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 basedir…=”C:/Program Files/MySQL/MySQL Server 5.0/Data/” default-character-set=latin1 default-storage-engine=INNODB #default-storage-engine=MyISAM sql… inserted faster than it is coming in. Please post the my.cnf file that you were able to get 9000 inserts per…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…-id in my.cnf. You change the server-id interactively, this is an action you should never perform on a slave. “SET GLOBAL… on the slaves. And recently I saw a weird problem, my.cnf was correct on all the machines, but the value was… 1 !! There was a hidden character in my.cnf that was unvalidating the value and then it was set to 1. How to identify…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT…. Note dates may not be in date_id order’; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` ( `UniqueCarrier` char….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
… the database latency. To give you more information, this is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql… max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M…_concurrency=2 innodb_file_per_table=1 innodb_doublewrite=0 # Set buffer pool size to 50-80% of your computer’s…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… this is a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red…_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow… will have to do this check in the application. Just my experience. I know some big websites are using MySQL, but…
Comment: MySQL versions shootout
October 12, 2011 By 6 Comments
… and there might be a lot of reasons (like complex character set supports) for slowdown for 4.0->4.1 Other question… settings, such as multiple buffer pools on MySQL 5.5 and above ? Also I’m not sure the config file posted (my.cnf…
