64,533 reputation
1065150
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 7 months
seen 24 secs 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


2h
answered mysql stored procedure create date plus one day but time set to 00:00:00
2h
answered Fastest engine for Mass Updates (only updates done on table)
3h
revised Why does mysql give different result for this summations?
added 3768 characters in body
1d
comment MySQL - varchar length and performance
dba.stackexchange.com/questions/424/…
2d
comment Amazon: How to change database name in Amazon RDS MySQL?
+1 for you because you came up with the principle idea first.
2d
comment Slow Performance with Multi-threaded app - MySQL InnoDB
Please post the following: 1) 1) The SHOW CREATE TABLE mytable\G of the table into which you are mass inserting. 2) All your innodb settings in my.cnf. 3) Amount of RAM, 3) # of CPUs
2d
comment Amazon: How to change database name in Amazon RDS MySQL?
@BillKarwin I corrected a few mistakes (Left out database parameters). This should work because I just wrote something 10 timex more complicated to merge two schemas and their data where schema1 has more columns than schema2, and schema2 has more data the schema1.
2d
revised Amazon: How to change database name in Amazon RDS MySQL?
added 18 characters in body
2d
answered Amazon: How to change database name in Amazon RDS MySQL?
2d
revised Why does mysql give different result for this summations?
added 208 characters in body
2d
comment Why does mysql give different result for this summations?
Please don't close this. I have an answer.
2d
answered Why does mysql give different result for this summations?
2d
reviewed Close Export sql Table to sql file on server with php
2d
reviewed Close how I Backing Up SQL Server database?
2d
reviewed Close Best practice for testing database disaster recovery
2d
reviewed Leave Open Why does mysql give different result for this summations?
2d
reviewed Close Have you ever used MySQLBackupFTP?
2d
reviewed Close What is wrong with this statement? 'Unknown column'?
2d
comment Amazon: How to change database name in Amazon RDS MySQL?
I have four(4) critical questions: 1) Does the database have stored procedures ? 2) Does the database have triggers ? 3) Does the database have events ? 4) Do any tables have foreign key constraints ?
2d
comment Amazon: How to change database name in Amazon RDS MySQL?
If this were EC2, then your answer would be quick-and-dirty.