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


Sep
15
comment Adding two rows in a database together based on columns
That would be SELECT A,B,SUM(Num1) Num1,SUM(Num2) Num2 FROM mytable GROUP BY A,B;. Any particular reason you asked this ???
Sep
15
revised Too much IO to MySQL InnoDB log files
added 15 characters in body; edited title
Sep
15
reviewed Reviewed Suitable database to store GPS track data
Sep
15
comment MySqlDump's DISABLE KEYS have no effect on import
@jynus HA HA :-). You should post your mysqldump comment for InnoDB (dba.stackexchange.com/questions/76565/…) as an answer.
Sep
15
revised MySqlDump's DISABLE KEYS have no effect on import
added 598 characters in body
Sep
15
answered MySqlDump's DISABLE KEYS have no effect on import
Sep
15
revised Fastest engine for Mass Updates (only updates done on table)
added 1314 characters in body
Sep
15
answered mysql stored procedure create date plus one day but time set to 00:00:00
Sep
15
answered Fastest engine for Mass Updates (only updates done on table)
Sep
15
revised Why does mysql give different result for this summations?
added 3768 characters in body
Sep
13
comment MySQL - varchar length and performance
dba.stackexchange.com/questions/424/…
Sep
13
comment Amazon: How to change database name in Amazon RDS MySQL?
+1 for you because you came up with the principle idea first.
Sep
13
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
Sep
13
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.
Sep
13
revised Amazon: How to change database name in Amazon RDS MySQL?
added 18 characters in body
Sep
12
answered Amazon: How to change database name in Amazon RDS MySQL?
Sep
12
revised Why does mysql give different result for this summations?
added 208 characters in body
Sep
12
comment Why does mysql give different result for this summations?
Please don't close this. I have an answer.
Sep
12
answered Why does mysql give different result for this summations?
Sep
12
reviewed Close Export sql Table to sql file on server with php