70,731 reputation
1170161
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 10 months
seen 53 mins 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


2d
reviewed Close “Arithmetic overflow” when initializing SQL Server 2012 replication from backup
2d
revised MySQL dump - how to order tables?
added 2103 characters in body
Dec
22
reviewed Close How to create a temporary table using VALUES in PostgreSQL
Dec
22
reviewed Close Cannot grant execute to stored procedure
Dec
22
revised tables relationships in database
Since nothing mysql specfic is mentioned in the question, mysql tag was removed
Dec
21
comment When is it safe to disable InnoDB doublewrite buffering?
Also keep in mind that turning off the double write buffer did not mean double writing does not take place. From the blog, that responsibility is being passed on to ext4 journaling. The result is faster double writing. You would need to do the PULL THE PLUG TEST yourself for your environment and see.
Dec
21
comment When is it safe to disable InnoDB doublewrite buffering?
I have seen that post months ago. I enjoyed reading it and I don't disagree with it. You will need make sure you use specific hardware, OS settings, and MySQL configs. The post did say: As always, test thoroughfully, I only tested on Ubuntu 14.04. You should test it too.
Dec
21
reviewed Close 32bit connected 64bit sqldeveloper
Dec
21
reviewed Close Mysql Database Migration failed
Dec
21
revised MySQL column type to boost performance
added 38 characters in body
Dec
21
comment MySQL column type to boost performance
Are you using InnoDB or MyISAM ? What version of MySQL ?
Dec
21
comment MySQL dump - how to order tables?
I just updated my answer with the way to make certain tables last in dumping
Dec
21
revised MySQL dump - how to order tables?
added 1088 characters in body
Dec
20
reviewed Leave Closed What is more important for Oracle DB performance, number of cores or memory size?
Dec
20
reviewed Close BLOB storage relocation
Dec
20
revised MySQL dump - how to order tables?
added 397 characters in body
Dec
20
answered MySQL dump - how to order tables?
Dec
20
comment MySQL dump - how to order tables?
Table Ordering can be done with the INFORMATION_SCHEMA. I am posting an answer on how to do it by table name and table size.
Dec
20
comment MySQL 5.6 Datetime Range
You originally asked if the documentation is wrong. I just showed you that it is wrong because MySQL left the fact about storing bad dates in the table back in the 5.0 docs. MySQL also said you should check date validity before saving it. As I also showed, any date dt where UNIX_TIMESTAMP(dt) is 0 is obviously invalid. Evidently, the storage engines are not checking the date field and neither is mysqld. You need to ask oracle why by means of a bug report. Setting the SQL mode won't address this either.
Dec
19
revised When is it safe to disable InnoDB doublewrite buffering?
added 254 characters in body