…file sql/sql_cache.cc patching file sql/sql_class.cc patching file sql/sql_class.h patching file sql/sql_parse.cc patching file sql/sql_select.cc patching file sql/sql_show.cc patching file sql… it in my.cnf file, the remaining part of the configuration will not matter, because the log file won’…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… 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 options. # # In this file, you can… the next comment character if you are not familiar with SQL #safe-updates [isamchk] key_buffer = 256M sort_buffer_size = 256M…
Post: MySQL Configuration Wizard Updated
January 26, 2012 By 5 Comments
…: this is a tool to help you generate my.cnf files based on your server’s hardware and other …Drizzle fixes — and should be fixed by default in MySQL — but never will be because they might…tools that people have requested or suggested: a SQL formatter, a visual EXPLAIN tool, a configuration advisor,…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… start on a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT… more more semicolon terminated SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries.sql. I have also provided….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… as in this benchmark. Could you post the my.cnf file used and the computer hardware specs that produced this benchmark. I am interested in…:/Program Files/MySQL/MySQL Server 5.0/Data/” default-character-set=latin1 default-storage-engine=INNODB #default-storage-engine=MyISAM sql-mode… data to be inserted faster than it is coming in. Please post the my.cnf file that you were able to get 9000 inserts…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = READ-COMMITTED max… with implicit memory tables. innodb_file_per_table – so I assume storing each table in its own file worked better for this benchmark… worth a bit of performance overhead. My best wishes to the Tom Daly and his team in further benchmark results improvements. I…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…53:28 [Note] Slave SQL thread initialized, starting replication in log ‘bin.000025′ …In a MySQL replication slave the last master binlog file InnoDB: position 0 12501110, file name bin.000025 InnoDB: Last MySQL binlog file…/Linux Also currently: these config (my.cnf) were all disabled from 20 servers:…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 139 Comments
… SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a …_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low…to realize, is as good as a file system on steroids and nothing more…. have to do this check in the application. Just my experience. I know some…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… to sync the metadata of the file also (size, name, access time, etc.),…in restart performance and has the advantage of persisting across machine restarts. The configuration variables for my.cnf…SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in…
