61,358 reputation
960143
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 5 months
seen 1 min 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


14h
comment How to safely add column to replicated mysql database
Please run SHOW CREATE TABLE mytable\G and run SELECT COUNT(1) FROM mytable; and display it in the question please
18h
reviewed Reviewed XtraBackup fails with my.cnf Percona Configuration
20h
revised InnoDB: “Only one log file found” after binary import
added 19 characters in body; edited title
20h
comment InnoDB: “Only one log file found” after binary import
Nice Final Answer. +1 !!!
20h
comment Is my MySQL instance irretrievably dead?
@BillKarwin I was thinking the same thing (stackoverflow.com/questions/23276198/…). You should write your comment as an answer.
20h
comment How to stop ROLLBACK in progress?
It will not overwrite table1 because I used the -t option (which means --no-create-info). It prevents the dropping and recreating of the table. You should test this on DEV or STAGING servers to make sure of this action.
23h
reviewed Approve suggested edit on How to recover my database in DBF?
23h
reviewed Approve suggested edit on Can SQL Server stop me from running an UPDATE statement without a WHERE clause?
23h
reviewed Approve suggested edit on View with left joins are very slow
23h
reviewed Close Extract mdf & ldf files from backup file?
23h
reviewed Leave Open What are some good resources for learning about document oriented databases?
23h
reviewed Leave Open How do I place leading zeros for numbers less than 10 without affecting those 10+?
23h
reviewed Close Automatically Transfer Files From server to Database
23h
reviewed Close Setting up a new database
23h
reviewed Close Whether Logfile Shrinking is good or bad one for Performance in SQL?
23h
reviewed Close Can I automate data pulling from VistA databases using MUMPS?
23h
reviewed Close Postgres vs Mongodb, Suggestions to improve mongodb performance
23h
reviewed Close PHP MySQL: Taking Long time to Insert Record in Table when using Mozilla Browser
23h
reviewed Close MySQL/PHP Returning Blank Error Message
23h
reviewed Leave Open mysql server is not starting