… problem. 1. You have to add one row to your my.ini file. # =0 is traditional lock mode == > funcionality of auto_increment…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… insert throughput as in this benchmark. Could you post the my.cnf file used and the computer hardware specs that produced… doing multiple inserts per transaction. here is data from my tests: computer 1: My.ini [client] port=3306 [mysql] default-character-set=latin1… inserted faster than it is coming in. Please post the my.cnf file that you were able to get 9000 inserts…
Comment: Working with large data sets in MySQL
January 28, 2010 By 12 Comments
… am trying just to fill first the database with data. My data will fit in around 10 tables of 90Gb each… statistics. But no transaction, no updates, no inserts anymore. So, my problem is simply, how can I fill this information fast… a different engine? I already played some how with the my.ini but still not improvement in the uploading performance. I take…
Comment: What to tune in MySQL Server after installation
July 1, 2009 By 116 Comments
These are mysql configuration and it is found in my.ini or my.cnf which is the base of mysql configuration. in linux you can view this file in this location /etc/my.cnf
Comment: MySQL Query Cache
October 11, 2009 By 69 Comments
… need to to is to activate it in the my.cnf (or my.ini) MySQL configuration file with setting the query-cache-type…
Comment: What to tune in MySQL Server after installation
May 5, 2009 By 116 Comments
[...] Hier findet sich eine etwas älterere Beschreibung über die verschiedenen Einstellungemöglichkeiten im MySQL my.ini (oder my.cfg): http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ [...]
Comment: MySQL Query Cache
November 22, 2008 By 69 Comments
… need to to is to activate it in the my.cnf (or my.ini) MySQL configuration file with setting the query-cache-type…
Comment: MySQL Query Cache
December 30, 2007 By 69 Comments
… need to to is to activate it in the my.cnf (or my.ini) MySQL configuration file with setting the query-cache-type…
Comment: MySQL Query Cache
August 26, 2007 By 69 Comments
… need to to is to activate it in the my.cnf (or my.ini) MySQL configuration file with setting the query-cache-type…
Comment: MySQL Query Cache
February 16, 2007 By 69 Comments
… need to to is to activate it in the my.cnf (or my.ini) MySQL configuration file with setting the query_cache_type…
