63,613 reputation
1064148
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 months
seen 29 mins 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


4h
comment Mysql syntax error when i add on completion preserve
I fixed it back in the other post : dba.stackexchange.com/a/75237/877
4h
revised Adding time to an event that runs on a weekly basis
edited body
4h
answered How to convert time to minutes in Mysql
17h
awarded  performance
22h
revised How to search whole MySQL database for a particular string
added 166 characters in body
23h
revised How to search whole MySQL database for a particular string
added 5 characters in body
23h
revised How to search whole MySQL database for a particular string
deleted 45 characters in body
1d
comment queries for hierarchical data
You should lookover my stored procedures for preorder tree traversal ( dba.stackexchange.com/a/7161/877 ) and see if it gives you any ideas. I use a queue. If you change the paradigm to a stack, it could work.
1d
revised Adding time to an event that runs on a weekly basis
added 199 characters in body
1d
answered Table is dropped but ibd file still exists
1d
reviewed Reviewed Environment Varible PATH exceeding recommended length solution?
1d
reviewed Reviewed Unable to install 64-bit Oracle 10g Release 2 ODAC 10.2.0.3 for Windows x64 on 64 bit Windows Server 2008 R2
1d
revised Unable to install 64-bit Oracle 10g Release 2 ODAC 10.2.0.3 for Windows x64 on 64 bit Windows Server 2008 R2
added 4 characters in body
1d
answered Adding time to an event that runs on a weekly basis
1d
revised MySQL RDS Instance eating up memory and swapping
edited body; edited tags; edited title
1d
revised Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
added 838 characters in body
1d
comment Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
@watery Here is the Full Size Picture : scribd.com/doc/31337494/XtraDB-InnoDB-internals-in-drawing
1d
awarded  Guru
1d
revised Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
added 102 characters in body
1d
revised Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
added 102 characters in body