June 19, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

… also use the slave_compressed_protocol option in /etc/my.cnf if bandwidth is a concern. … Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going …/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ …

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)

April 17, 2013 By 2 Comments

… Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running… ‘fix in config file‘ part. What happens if we specify the master-user, master-password, master-host and master-port in the my.cnf file? # cat my.cnf… binary log file on the master, which is probably not what you want. So never set master-xxx variables in my.cnf! From MySQL…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Updated msl (microslow) patch, installation walk-through!

April 20, 2008 By 17 Comments

…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’…

Filed Under: Percona Software Tagged With:

Comment: Database problems in MySQL/PHP Applications

November 6, 2006 By 13 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…

Filed Under: Insight for Developers Tagged With: , ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text search, in the sense that the SQL…there are a lot of “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql …that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

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,…

Filed Under: Insight for DBAs, MySQL

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…

Filed Under: MySQL

Post: Profiling MySQL Memory Usage With Valgrind Massif

January 9, 2013 By 3 Comments

…-out-file=/tmp/massif.out /path/to/mysqld {mysqld options…} Note that ‘{mysqld options}’ could for instance include –default-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld to your settings file etc. After…/sbin/mysqld) | |   | ->10.10% (7,135,744B) 0x5316EC: handle_slave_sql (in /usr/local/percona/mysql-5.5.28/usr/sbin/mysqld…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

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…

Filed Under: Benchmarks Tagged With: ,

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…

Filed Under: Benchmarks
« Older Posts