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


5h
revised Proposal: MySQL blob handling revision
added 20 characters in body
8h
reviewed No Action Needed Optimistic concurrency check failure when updating linked server table with timestamp column
8h
reviewed Reviewed poor and/or unreliable InnoDB performance
13h
revised Proposal: MySQL blob handling revision
added 18 characters in body
13h
revised Proposal: MySQL blob handling revision
added 291 characters in body
13h
answered Proposal: MySQL blob handling revision
13h
comment Proposal: MySQL blob handling revision
Please don't close this. I have an answer I am writing up. Please stand by ...
13h
reviewed Leave Open Proposal: MySQL blob handling revision
13h
comment Multi-Column Full Text Search Going Very Slow
I am sorry I took so long to get to it.
14h
revised Multi-Column Full Text Search Going Very Slow
deleted 4 characters in body
14h
answered Multi-Column Full Text Search Going Very Slow
15h
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 ?
15h
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 ?
15h
comment MySQL master/slave replication - replicate all tables
Question #1) Are you using Magento ???
16h
comment Unresponsive MySQL database
When that heavy query condition happened, were you out of disk space in the root partition ?
16h
comment Unresponsive MySQL database
Please tell use how much RAM the DB Server has and what is the output of df -h.
17h
comment Unresponsive MySQL database
Please run select * from information_schema.global_variables where variable_name like 'max%' and variable_name like '%conn%' union select * from information_schema.global_status where variable_name in ('aborted_connects','Max_used_connections'); and post the output
18h
reviewed Close Useful guide & FAQ for Application+SQL
19h
revised How to enforce the structural constraints of rectangularly arrayed data?
added 8 characters in body
20h
reviewed Close Which database is suitable for Restaurant Menus