3,970 reputation
616
bio website openark.org
location
age
visits member for 2 years, 4 months
seen Nov 20 at 6:07

Software engineer, DBA & instructor. I develop mostly sever-side and backend, but also web apps and client side.

I'm a MySQL community member. I've won Oracle ACE, Oracle Technologist of the Year 2011 & MySQL Community Member of the Year 2009 awards.

Author of common_schema , openark-kit and mycheckpoint open source tools.

I blog at openark.org


Nov
19
comment MySQL relay log rotates too soon and too often
Also kill -HUP makes for an implicit FLUSH LOGS. Check if you have a crontab entry that does that
Nov
5
answered Truncating and inserting in a safe transaction on MySQL
Nov
5
comment Truncating and inserting in a safe transaction on MySQL
This leaves the database in a state where mytable does not exist. Use a RENAME table statement instead, which allows for two atomic renames
Oct
3
awarded  Nice Answer
Sep
28
revised Can I time out my scripted “FLUSH TABLES WITH READ LOCK;”?
fixed markdown
Sep
24
awarded  Autobiographer
Aug
6
answered SHOW SLAVE HOSTS shows incorrect output
Aug
2
answered Mysql dump with View dependent on user
Jul
12
awarded  Yearling
Jul
7
awarded  Revival
Jun
9
awarded  Enlightened
Jun
9
awarded  Nice Answer
Jun
4
comment How To Prevent Replication Failure
To skip a single, known query, issue: SET GLOBAL SQL_SLAVE_SKIP_COUNTER:=1; START SLAVE;
May
27
comment MySQL - Shift procedure execution context
Before "shifting" execution context, why not check why would 8000 rows take so much time? Let's begin with examining the indexes. Can you paste the table definitions for all tables involved?
Apr
26
answered Are relay logs necessary for replication?
Apr
19
comment Will redirecting queries to dev/null warm up indexes?
@RolandoMySQLDBA are you using 5.6 yourself in production?
Apr
19
comment Will redirecting queries to dev/null warm up indexes?
That doesn't make sense, either.
Apr
18
answered Will redirecting queries to dev/null warm up indexes?
Mar
27
reviewed Approve suggested edit on mysqldump dump file size
Mar
24
comment How do I access a result set from a StoredProcedure… in another StoredProcedure
@a_horse_with_no_name is right; tables are the only way to pass non-primitive results, unless you're into ugly string concatenation & parsing (as in aggregating the entire result set into one long string).