3,775 reputation
514
bio website openark.org
location
age
visits member for 1 year, 11 months
seen 5 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


2d
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.
Feb
22
comment Multiple “root” users in MySQL
correct on your "localhost" assumption on unix-like systems
Feb
21
comment mysql transaction vs lock
With InnoDB - yes; no UPDATE, DELETE, INSERT, SELECT can operate outside a transaction. If not declared otherwise, they operate within their own singular transactions.
Feb
11
comment Is the MySQL replica's data consistent if the Master was switched to binlog_format = MIXED but the Slave's relay logs were rotated sometime later?
It you don't have "log_slave_updates" then you shouldn’t care about anything, really.
Feb
10
answered Is the MySQL replica's data consistent if the Master was switched to binlog_format = MIXED but the Slave's relay logs were rotated sometime later?
Feb
1
answered security tools for mysql
Jan
29
answered Please tell me my data isn't gone… lie to me even