… get the logging in place and possibly another restart to disable it when no longer necessary (though actually slow log can be disabled by simply setting long_query_time MySQL variable vale… MySQL host, this will not work since all traffic goes through a unix socket file. It’s most definitely not a MySQL log…
Post: MySQL Error control changes
February 19, 2007 By 4 Comments
… storage engine disabled. This can cause numerous problems especially if you got use to old behavior and do not check MySQL logs but… are accessible not catching such errors. If MySQL is started with Innodb tables disabled accesses to Innodb tables will simply result in… people is performing Innodb conversion…. By default MySQL substitutes storage engines so if Innodb is disabled MyISAM is used, so I’ve…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… sec) Log sequence number 380170274979 1 row in set (0.00 sec) When you are done and you want to disable paging, you can simply run: mysql> pager Default pager wasn’t set, using…, pretty much like the Unix tee command: mysql> tee queries.log Logging to file ‘queries.log‘ mysql> use sakila Reading table information for completion of…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… which would mean limit disabled. Very few users actually need DOS prevention this variable strives to provide as MySQL is typically protected… just be left alone. Same applies to sync_relay_log and sync_relay_log_info settings. James also promises updated sample my…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… portion of the load in the application by aggregating query log with mk-query-digest. When I filtered out only queries…,sub_select,do_select,JOIN::exec,mysql_sel ect,handle_select,execute_sqlcom_select,mysql_execute_command,mysql_parse,dispatch_command,do_command…,mysql_execute_command,mysql_parse,dispatch_command,do_command,do_handle_one_connection,handle_one_conne ction,start_thread,clone P.S Disabling…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…/xinetd.d/ disable = no flags = REUSE socket_type = stream port = 9200 wait = no user = nobody server = /usr/bin/clustercheck log_on_failure…–db-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… innodb_read_ahead=none For MySQL 5.5.8, I used: innodb_log_file_size=2000M (innodb_log_files_in_group=2), as… results for MySQL 5.5.8. For both servers I used: innodb_flush_log_at_trx_commit=2 ibdata1 and innodb_log_files… improvement in Percona Server are: Big log files. Total size of logs are: innodb_log_file_size=8G Disabling flushing of neighborhood pages: innodb…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…, so I have microsecond logging in the slow query log, and extended statistics in the same log. I logged a couple gigabytes of queries… and fetch data from them (with functions like NOW() that disable the query cache) are executing in no more than 12… improvements to the MySQL source code are necessary. But in many cases something can be done, such as disabling or reconfiguring some…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… of choice was XFS. Barriers and physical disk cache was disabled. The tool I used was sysbench 0.4.10 that…/mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log… what exactly happened with setting #3 when WB cache was disabled, what I do know though is that, based on IO…
Post: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
… need to restrict MySQL users based on hostnames? If you don’t, you should probably disable this feature of MySQL‘s authentication system… go into the toilet. And when that happens, MySQL mysteriously stops letting users log in, and all kinds of chaos ensues. Worse…’t be able to log in after you disable DNS resolution. For more information on how and why MySQL does both a forward…
