56,260 reputation
852131
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 2 months
seen 2 hours 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


Oct
22
revised Do MySQL sub-queries essentially use as much overhead as separate queries?
added 8 characters in body
Oct
22
revised unenforced constraints/possible duplication in my database design?
Removing mysql tag because this question is not specific to mysql in anyway
Oct
22
revised How large should be mysql innodb_buffer_pool_size?
added 1569 characters in body
Oct
22
revised How large should be mysql innodb_buffer_pool_size?
added 1569 characters in body
Oct
22
answered How large should be mysql innodb_buffer_pool_size?
Oct
21
reviewed Close SQL relationships, one-to-one, many-to-many etc
Oct
21
reviewed Close how to connect values of a new record in a form to a table?
Oct
20
revised Problem with MySQL subquery
added 6 characters in body
Oct
20
revised What permissions are required to view the contents of a catalog on a remote server?
edited tags
Oct
19
comment Blocking drop database command
Sadly, the answer to that is no. That is what I meant by privilege scope. Databases, tables, and views in mysql.db have the same privilege scope on the drop_priv column.
Oct
19
reviewed Approve suggested edit on Is there a more concise way to convert a UTC datetime into a local date only?
Oct
19
answered Blocking drop database command
Oct
19
comment Blocking drop database command
Please login as that user and run SHOW GRANTS; (hide the password)
Oct
19
reviewed Reviewed What are the pros and cons of using CLIENT_RESULT_CACHE_SIZE and RESULT_CACHE_MODE
Oct
19
comment Disable console output when executing a SQL file using MySQL source command
Yes, output to NUL writes absolutely nothing. You could do 2>stderr.txt if you want.
Oct
19
revised Disable console output when executing a SQL file using MySQL source command
added 4 characters in body
Oct
19
reviewed Approve suggested edit on “Connection to host lost” using telnet to MySQL
Oct
19
reviewed Approve suggested edit on mariadb tag wiki excerpt
Oct
19
reviewed Approve suggested edit on mariadb tag wiki
Oct
19
revised InnoDB - High disk write I/O on ibdata1 file and ib_logfile0
added 344 characters in body