68,928 reputation
1070160
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 9 months
seen 4 mins ago

One of JEHOVAH's Witnesses (TV)

Seasoned MySQL DBA (SCMDBA) since 2007-08-11

Profile for RolandoMySQLDBA on Stack Exchange, a network of free, community-driven Q&A sites


May
10
answered Select records that do not have associations outside a certain list
May
10
reviewed Approve suggested edit on Table design when one data is dependant of another and the second one has repeated values
May
10
revised Configuring MySQL (my.cnf) for MyISAM and InnoDB
added 1027 characters in body
May
10
reviewed Leave Open Queries getting stuck on very simple COUNT queries
May
10
comment Configuring MySQL (my.cnf) for MyISAM and InnoDB
Yes, you are right. Again, sorry about the typo.
May
10
comment Configuring MySQL (my.cnf) for MyISAM and InnoDB
I missed an asterisk on ib_logfile. It should be ib_logfile*
May
10
revised Configuring MySQL (my.cnf) for MyISAM and InnoDB
added 1 characters in body
May
9
comment Configuring MySQL (my.cnf) for MyISAM and InnoDB
I have to leave the office, I'll be back online in 5 hours. I'll add some explanation for those setting later.
May
9
answered Configuring MySQL (my.cnf) for MyISAM and InnoDB
May
9
comment Configuring MySQL (my.cnf) for MyISAM and InnoDB
How many CPUs/Cores in the DB Server?
May
9
comment Configuring MySQL (my.cnf) for MyISAM and InnoDB
Is there a reason why you do not want to convert every table to InnoDB ?
May
9
comment Configuring MySQL (my.cnf) for MyISAM and InnoDB
Please post output of SHOW ENGINES; in your question.
May
9
comment MySQL high CPU usage (MyISAM table indexes)
In that question, please post the output of SHOW ENGINES;
May
9
comment MySQL high CPU usage (MyISAM table indexes)
Please post this as a separate question
May
9
comment MySQL high CPU usage (MyISAM table indexes)
I put a link the script in the question already. Look at the link When to switch from MyISAM to InnoDB? under the heading NEED #2
May
9
revised How can I make a select statement get blocked?
added 736 characters in body
May
9
revised How can I make a select statement get blocked?
added 2 characters in body
May
9
revised How can I make a select statement get blocked?
edited tags
May
9
revised How can I make a select statement get blocked?
added 83 characters in body
May
9
answered How can I make a select statement get blocked?