63,363 reputation
1062148
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 1 hour ago

One of JEHOVAH's Witnesses

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

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


Aug
22
comment How to break table into two without losing performance?
Please run SELECT MAX(id) FROM part1; and tells us the value.
Aug
22
revised How to break table into two without losing performance?
added 136 characters in body
Aug
22
revised Huge differences of performance of MySQL in two servers
Removed windows 2008 tag since the OS is not the real issue. Added windows tag since both servers use Windows
Aug
22
answered Huge differences of performance of MySQL in two servers
Aug
22
comment Revoke write privileges vs setting database to readonly
@jynus You are right for the all-InnoDB database. For the brave souls still using MyISAM, FLUSH TABLES; is still a must.
Aug
22
comment Huge differences of performance of MySQL in two servers
Can we have a look at the my.ini for both machines, please ?
Aug
22
comment Huge differences of performance of MySQL in two servers
Can you post an example of a query that runs great in TEST but is horrible in PROD ? In addition, please run the EXPLAIN plan on the query in both systems and post the results.
Aug
22
reviewed No Action Needed Slow SQL Server authentication, but fast SAN, fast querying?
Aug
22
comment Debugging error report percona 5.6
Temp tables get on my nerves. There is no .frm files and you have to going fishing in the OS. In the question, the .MYI files are from Nov 2013. I doubt they are in use. +1 !!!
Aug
22
reviewed Edit In DB2 LUW 9.5, is there any way to change the collating sequence without recreating the db?
Aug
22
revised In DB2 LUW 9.5, is there any way to change the collating sequence without recreating the db?
added 2 characters in body; edited tags
Aug
22
revised Difference between On Delete Cascade & On Update Cascade in mysql
deleted 2 characters in body; edited tags
Aug
22
reviewed Close What is better? Delete and insert or update?
Aug
22
reviewed Close Tuple relational calculus for all
Aug
22
comment Tuple relational calculus for all
This question appears to be off-topic because it is about Computer Science Theory ( cstheory.stackexchange.com )
Aug
22
comment Tuple relational calculus for all
This question looks like it could be in cstheory.stackexchange.com
Aug
22
reviewed Close ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist
Aug
22
reviewed Close PL/SQL group orders by date and sum the total
Aug
22
reviewed Close What's a good workbench tool for sqlite similar to MySQLWorkbench for MySQL?
Aug
22
reviewed Close ORA-02049 and ORA-02063 Errors