64,578 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


8h
comment Why MySQL taking 150% CPU?
What version of MySQL (Please run SELECT VERSION();)
11h
answered Select statement to output to console
11h
revised Renaming the system generated partitions during interval partitioning
added 13 characters in body
11h
revised plsql script continue excution even there ar promt statement
deleted 10 characters in body
11h
revised What's the difference between functions and stored procedures?
added 1 character in body
11h
revised Optimizing SSIS Packages
added 7 characters in body
11h
revised How to generate auto increment values for my duplicate column in my sql?
added 5 characters in body
11h
reviewed Close Is database record access sequential after retrieving the indexed page from disk?
11h
reviewed Close How to resolve: Specified key was too long; max key length is 767 bytes
11h
reviewed Close MySQL - Foreign Key Problem
11h
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 ???
12h
revised Too much IO to MySQL InnoDB log files
added 15 characters in body; edited title
13h
revised Too much IO to MySQL InnoDB log files
edited body
13h
revised Too much IO to MySQL InnoDB log files
added 109 characters in body
13h
answered Too much IO to MySQL InnoDB log files
14h
reviewed Reviewed Suitable database to store GPS track data
15h
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.
15h
revised MySqlDump's DISABLE KEYS have no effect on import
added 598 characters in body
15h
answered MySqlDump's DISABLE KEYS have no effect on import
1d
revised Fastest engine for Mass Updates (only updates done on table)
added 1314 characters in body