61,308 reputation
960143
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 5 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


Dec
12
comment mysql freeze/crash on JOIN
I usually recommend wordpress clients to go with InnoDB. Here is my post in the WordPress StackExchange : wordpress.stackexchange.com/a/15377/4699
Dec
12
answered MySQL query slow even with indexes
Dec
12
comment mysql freeze/crash on JOIN
That's 7.5MB. You should be fine. RKBS stands for Recommended Key Buffer Size. you already have 32M which is fine.
Dec
12
comment mysql freeze/crash on JOIN
Please run this query : SELECT SUM(index_length) RKBS FROM information_schema.tables WHERE engine='MyISAM' AND table_schema NOT IN ('information_schema','mysql'); and tell me what RKBS is
Dec
12
answered mysql freeze/crash on JOIN
Dec
12
revised mysql freeze/crash on JOIN
edited tags
Dec
12
comment mysql freeze/crash on JOIN
What version of mysql are you using? Please run SELECT VERSION(); and tell me
Dec
12
comment Why is this table structure so slow to CRUD?
Please run SHOW VARIABLES LIKE 'innodb%'; and SELECT VERSION(); and post them in the question.
Dec
12
comment mysql freeze/crash on JOIN
What version of mysql are you using? Please run SELECT VERSION(); and tell me
Dec
12
comment mysql freeze/crash on JOIN
How many tables did you convert from MyISAM to InnoDB ???
Dec
12
comment mysql freeze/crash on JOIN
Is that the entire my.cnf ???
Dec
12
awarded  Custodian
Dec
12
reviewed Reopen How can I use “select distinct” and have a range for my rows?
Dec
12
reviewed Approve suggested edit on offset-fetch tag wiki
Dec
12
reviewed Approve suggested edit on offset-fetch tag wiki excerpt
Dec
11
comment MySQL on RDS, data transfer from one instance to another as a production job
+1 for such heroism in the face for MySQL RDS
Dec
11
comment MySQL on RDS, data transfer from one instance to another as a production job
Would going with option 2 work ? You could 1) spin up a snapshot 2) put the incremental data in it, 3) run reports, 4) drop that instance.
Dec
11
revised MySQL on RDS, data transfer from one instance to another as a production job
edited tags
Dec
11
revised Should fields that aren't needed often be kept in separate tables?
edited title
Dec
11
revised MySQL on RDS, data transfer from one instance to another as a production job
added 128 characters in body