… 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-mode=”STRICT_TRANS_TABLES… inserted faster than it is coming in. Please post the my.cnf file that you were able to get 9000 inserts per…
Comment: Why MySQL could be slow with large tables ?
December 17, 2012 By 141 Comments
…so please guide me where to set parameters to overcome this issue. my.cnf file contains the following information….SET collation_connection = utf8_general_ci; SET NAMES utf8;’ default-character-set=utf8 character-set-server=utf8 collation-server=utf8_general_ci [client] default-character-set=utf8 set…
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…=30 wait_timeout=15 max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this … # (and different from the master) # defaults to 2 if master-host is set # but will not function… [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` ( `UniqueCarrier` char(7) DEFAULT NULL, `AirlineID` int(11) DEFAULT NULL, `Carrier` char(2) DEFAULT ….573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 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_queries… will have to do this check in the application. Just my experience. I know some big websites are using MySQL, but…
