3,950 reputation
616
bio website openark.org
location
age
visits member for 2 years, 3 months
seen 8 hours ago

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


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).
Mar
22
comment Linux command to kill all MySQL sessions from a specific User?
When piping back to mysql, use --force, since a KILL command will fail if by change the connection has already terminated. Without --force this will abort all following KILL commands.
Mar
22
answered Linux command to kill all MySQL sessions from a specific User?
Mar
1
comment How can I repair a TokuDB table?
@RolandoMySQLDBA I haven't encountered any. But maybe the filesystem has a corrupt block? It would be interesting to understand which queries run just fine and which crash.