…. Note dates may not be in date_id order’; /*!40101 SET character_set_client = @saved_cs_client */; CREATE TABLE `dim_flight` ( `UniqueCarrier` char… hosts.internal [host list omitted] Now you need to set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools… the shards.ini file for testing an cluster of 1 to 20 nodes. cd shard-query #generate a config for 20 shards…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…_log_at_trx_commit=2″ into the config file. The “innodb_buffer_pool_size” is set to 4Go but the whole database size… max_allowed_packet=64M default-collation=utf8_unicode_ci default-character-set=utf8 default-storage-engine=InnoDB bulk_insert_buffer_size=8M…_pool_size=4G innodb_additional_mem_pool_size=20M # Set the log file size to about 25% of the buffer pool size…
Comment: MySQL versions shootout
October 12, 2011 By 6 Comments
… (like complex character set supports) for slowdown for 4.0->4.1 Other question is configuration – I see configuration file is large with… any special settings, such as multiple buffer pools on MySQL 5.5 and above ? Also I’m not sure the config file posted (my.cnf) is correct at all. It contains: innodb_log_file_size = 4000M #innodb_log_file_size = 1024M #innodb_log_file…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…ram. Here is our my.cnf # sammple MySQL config file for very large systems. # # # This is for a…pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb…16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-…
