56,285 reputation
852132
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 2 months
seen 3 mins ago

One of JEHOVAH's Witnesses

  • Exodus 6:2,3; Exodus 9:13-16
  • Isaiah 12:2,4,5

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

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


3h
awarded  Revival
13h
reviewed No Action Needed DISTINCT not using an index
17h
reviewed Reviewed Avoiding entitized characters when using FOR XML PATH for string concatenation
18h
reviewed No Action Needed Failover Mirror
18h
reviewed No Action Needed SQl comand works in Workbench but not from Java Program
20h
revised Problem with mysqldump and view
added 825 characters in body
21h
answered How to grant super privilege to the user?
22h
answered How to decide whether to enable MySQL query cache using InnoDB
23h
reviewed Close what values to set for the folowing PostgreSQL Variable
23h
reviewed Close Who and when were changed Database default location settings?
23h
reviewed No Action Needed Avoid transaction rollback when Deadlock is encountered (mysql)
1d
reviewed Close How can I find which records of `Data Warehouse` must be updated according to CDC captured changes?
1d
reviewed Close Latitude and Longtitude Distance Calculation
1d
comment Problem with mysqldump and view
Ouch, you ran mysql_upgrade. Please run this query SELECT COUNT(1) MySQLGrantsCount,VERSION() MySQLVersion FROM information_schema.columns WHERE table_schema='mysql' AND table_name='user'; What number and version does it output ???
1d
reviewed No Action Needed Any idea why this seemingly-simple query is really slow?
1d
reviewed No Action Needed How to make MYSQL smart enough to understand when it should take into account stop word and when it shouldn't?
1d
revised Problem with mysqldump and view
added 560 characters in body
1d
comment Problem with mysqldump and view
Added wild suggestions to help you look closer.
1d
revised Problem with mysqldump and view
added 560 characters in body
1d
revised Problem with mysqldump and view
added 469 characters in body