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


1d
reviewed Close Backup DB -> Zip & Encrypt script , how?
1d
reviewed No Action Needed Inserting data into a table with one value as clob and blob
1d
reviewed No Action Needed Error Code: 1133. Can't find any matching row in the user table
2d
reviewed Close Is Transparent Data Encryption (TDE) only available in Enterprise edition?
2d
reviewed Close sql server date issue
2d
revised Is it normal that I have to FLUSH QUERY CACHE once every 6 hours to maintain fast queries?
added 235 characters in body
2d
revised Is it normal that I have to FLUSH QUERY CACHE once every 6 hours to maintain fast queries?
added 235 characters in body
2d
answered Is it normal that I have to FLUSH QUERY CACHE once every 6 hours to maintain fast queries?
2d
comment Why pages not made young is zero?
How much RAM does the DB Server have ?
Sep
15
comment Why MySQL taking 150% CPU?
What version of MySQL (Please run SELECT VERSION();)
Sep
15
revised Renaming the system generated partitions during interval partitioning
added 13 characters in body
Sep
15
revised plsql script continue excution even there ar promt statement
deleted 10 characters in body
Sep
15
revised What's the difference between functions and stored procedures?
added 1 character in body
Sep
15
revised Optimizing SSIS Packages
added 7 characters in body
Sep
15
revised How to generate auto increment values for my duplicate column in my sql?
added 5 characters in body
Sep
15
reviewed Close Is database record access sequential after retrieving the indexed page from disk?
Sep
15
reviewed Close How to resolve: Specified key was too long; max key length is 767 bytes
Sep
15
reviewed Close MySQL - Foreign Key Problem
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