Reputation
12,050
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 13 35
Newest
 Revival
Impact
~764k people reached

Aug
11
comment GRANT EXECUTE ON PROCEDURE unable to USE database
Without debating the merits of this solution, for a moment, does GRANT USAGE ON dataDB.* TO 'otherUser'@'%'; coupled with granting execute on that singular procedure not do what you want? The "usage" permission typically means "grant nothing in particular, but create a placeholder here for more specific permissions to cascade under." It seems unlikely that a procedure could have access effectively granted, if you don't have permission to see the existence of the database the procedure is in.
Aug
11
comment MYSQL- concurrency issue
If you have a transaction running in workbench, not seeing the updated value would be the correct behavior, depending on your isolation level. You would see the value as it existed when you started the transaction. Issuing a ROLLBACK or COMMIT should roll your session forward in time and you'd see the expected value.
Aug
11
comment Avoid foreign keys on an 800-GB database?
You can't be serious. I'm withholding my downvote on this, in the hopes that you are actually using reverse psychology to convince OP that not using foreign key constraints for alleged performance reasons is preposterous.
Aug
11
answered Mysql privileges and replication
Aug
5
awarded  Nice Answer
Jul
28
comment Mysql backup bug
Please post the exact error you get, omitting no details or punctuation. Errors can be cryptic to the untrained eye and obvious to experienced DBAs, and there are easy ways to examine large files using sed or perl or other tools, but we need more info. Also the output of mysqldump -V and the query SELECT @@VERSION;.
Jul
28
answered Data and index file compatibility between patch/revision releases of MySQL
Jul
28
awarded  Caucus
Jul
19
comment Active-active Cluster In MySQL
@tesla747 you are correct.
Jul
19
comment Active-active Cluster In MySQL
NDB Cluster is synchronous, but it's its own different product, it's not "Standard MySQL behavior + Synchronous Replication" which is what PXC and MariaDB essentially provide, with Galera. There are arguments on both sides of the MariaDB/Percona preference debate, which are not on topic here, but I suggest that of those two is more likely to fit what you want than NDB, because unlike them, NDB is not a drop-in replacement for MySQL Server, and has a smaller set of applications and environments to which it is suited.
Jul
19
answered Active-active Cluster In MySQL
Jul
12
comment restoring a EC2 snapshot on RDS
The phrase "restore our database snapshot on ec2 directly on RDS" does not really explain what you are trying to do. Please edit the question to clarify exactly what you are trying to do, and why.
Jul
10
awarded  Enlightened
Jul
10
awarded  Nice Answer
Jul
10
comment Best way to backup mysql database?
Rsync? Of the actual MySQL data files from a running server? That's not an acceptable method of backup.
Jul
9
comment Cannot Start mySQL Daemon with Error “mysqld from pid file … ended”
$ ps auwwx | grep mysqld | grep -v grep ... does that return anything?
Jul
2
comment RDS Replication Error (Apply Error 1406 / Truncation)
You made schema changes on the replica, directly?
Jun
29
comment mysql query choosing an incorrect execution plan
You may not have noticed, based on the boxes you drew, but the optimizer has actually swapped the order of the last 2 tables in the query plan.
Jun
29
comment MySQL is inserting “” as 0 in decimal fields. How to stop that?
Empty string is no more like NULL than it is like 0 and arguably even less so. If you want null, why exactly would you not insert null?
Jun
29
answered update query field order guaranteed