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


Aug
27
answered Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
Aug
27
comment Why are simple SELECTs on InnoDB 100x slower than on MyISAM?
Never mind, I see the counts in the question.
Aug
27
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.
Aug
27
revised MySQL Replication: Seconds Behind Master super high
added 257 characters in body
Aug
27
revised MySQL Replication: Seconds Behind Master super high
edited tags
Aug
27
answered MySQL Replication: Seconds Behind Master super high
Aug
27
revised Proposal: MySQL blob handling revision
added 20 characters in body
Aug
27
reviewed No Action Needed Optimistic concurrency check failure when updating linked server table with timestamp column
Aug
27
reviewed Reviewed poor and/or unreliable InnoDB performance
Aug
26
revised Proposal: MySQL blob handling revision
added 18 characters in body
Aug
26
revised Proposal: MySQL blob handling revision
added 291 characters in body
Aug
26
answered Proposal: MySQL blob handling revision
Aug
26
comment Proposal: MySQL blob handling revision
Please don't close this. I have an answer I am writing up. Please stand by ...
Aug
26
reviewed Leave Open Proposal: MySQL blob handling revision
Aug
26
comment Multi-Column Full Text Search Going Very Slow
I am sorry I took so long to get to it.
Aug
26
revised Multi-Column Full Text Search Going Very Slow
deleted 4 characters in body
Aug
26
answered Multi-Column Full Text Search Going Very Slow
Aug
26
comment MySQL master/slave replication - replicate all tables
Question #3) When you run SELECT COUNT(1) TableCount FROM information_schema.tables WHERE table_schema NOT IN ('information_schema','mysql','performance_schema'); on the Master and on the Slave, how many tables do they have ?
Aug
26
comment MySQL master/slave replication - replicate all tables
Question #2) When you run SHOW SLAVE STATUS\G, what do Replicate_Do_DB:,Replicate_Ignore_DB:,Replicate_Do_Table:,Replicate_Ignor‌​e_Table:,Replicate_Wild_Do_Table: and Replicate_Wild_Ignore_Table: say ?
Aug
26
comment MySQL master/slave replication - replicate all tables
Question #1) Are you using Magento ???