68,668 reputation
1070160
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 9 months
seen 2 hours ago

One of JEHOVAH's Witnesses (TV)

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


May
2
revised Database user specified as a definer
edited tags
May
2
answered Database user specified as a definer
May
2
revised How to create a mysql stored procedure through linux terminal
added 802 characters in body
May
2
revised How to create a mysql stored procedure through linux terminal
Remove tags since they are too narrow in scope. mysql-console could easily be tagged in other specific ways but is not really a significant statistic. Removed linux because this problem can occur in Windows or MacOS as well, thus it is not linux specific.
May
2
answered How to create a mysql stored procedure through linux terminal
May
2
revised Varchar index - will hashing value make it faster?
edited tags
May
2
answered Varchar index - will hashing value make it faster?
May
2
revised Varchar index - will hashing value make it faster?
deleted 2 characters in body; edited tags
May
2
comment For absolute performance, is SUM faster or COUNT?
+1 for answering your own question with proper due diligence.
May
2
comment Trigger not firing when deleting a record from stored procedure MySql
+1 for suggesting that the foreign keys do the heavy lifting !!!
May
2
comment How to tune mysql to be inmemory-like
What Storage Engine are the tables using ? InnoDB, MyISAM, or Both ?
May
2
reviewed Reject suggested edit on Breaking Semisynchronous Replication in MySQL 5.5
May
2
reviewed Reject suggested edit on Breaking Semisynchronous Replication in MySQL 5.5
May
2
reviewed Reject suggested edit on MariaDB and XtraDB/InnoDB plugins
May
2
reviewed Edit suggested edit on INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so' not working
May
2
revised INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so' not working
added semi-sync-replication tag
May
2
reviewed Reject suggested edit on “freeing items” taking forever on inserts, updates and deletes
May
2
reviewed Approve suggested edit on Does pt-table-checksum point out rows that are different between Master and Slave?
May
2
reviewed Reject suggested edit on How to create a mysql stored procedure through linux terminal
May
1
revised Can I find out what version of MySQL from the data files?
added 86 characters in body