63,623 reputation
1064148
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 6 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
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
2d
revised Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
added 102 characters in body
2d
revised Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
added 102 characters in body
2d
revised Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
added 23 characters in body
2d
answered Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
2d
comment Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
Never mind, I see the counts in the question.
2d
comment Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
Please run SELECT COUNT(1) TotalRows FROM newbb_innopost; and SELECT COUNT(1) SearchRows FROM newbb_innopost WHERE threadid = 51506; and tell me the results.
2d
revised MySQL Replication: Seconds Behind Master super high
added 257 characters in body
2d
revised MySQL Replication: Seconds Behind Master super high
edited tags