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


Sep
30
awarded  Explainer
Aug
26
revised One WordPress and database but multiple subdomains
Improved Formatting of URLs, Corrected Spelling
Aug
26
revised One WordPress and database but multiple subdomains
Corrected format, diction, and spelling
Aug
26
comment Is MySQL query cache useful for WordPress?
@Otto please keep in mind that they are instances where a decently-sized InnoDB Buffer Pool with every data and index needed for queries can be just a convenient to access as a query cache. Both a query cache and the InnoDB Buffer Pool are subject to results and memory blocks being cleansed. My money would be on InnoDB because query cache results can sometimes be boxed in by the option query_cache_min_res_unit. When you divide query_cache_size by query_cache_min_res_unit, it gives you an idea how many entries can fit. Guessing can waste space. With InnoDB, results can be rebuild all in RAM.
Aug
26
suggested suggested edit on One WordPress and database but multiple subdomains
Aug
26
suggested suggested edit on One WordPress and database but multiple subdomains
Aug
26
comment Is MySQL query cache useful for WordPress?
@Otto not if InnoDB "STOPS AND FRISKS" the Query Cache for every INSERT, UPDATE, and DELETE. MySQL 4.1 and 5.6 have it disabled to spare InnoDB databases that are heavily written. When one is truly aware of the write activity a website will face, you will set up query cache accordingly. For some, it may be a size you can predict. For others, it may be too much if InnoDB has its way, leaving you with no alternative but to disable the query cache. It all depends on the write load and the InnoDB Storage Engine.
Aug
25
revised Is MySQL query cache useful for WordPress?
Improved formatting and added InnoDB tag since the question involved InnoDB
Aug
25
revised Is MySQL query cache useful for WordPress?
deleted 1 character in body
Aug
25
answered Is MySQL query cache useful for WordPress?
Aug
25
suggested suggested edit on Is MySQL query cache useful for WordPress?
Jun
7
reviewed Reviewed Rename wp-admin
May
9
reviewed No Action Needed Change url of posts with keywords
Apr
15
awarded  Yearling
Jul
8
revised innodb wiki description
added 1703 characters in body
Jul
8
suggested suggested edit on innodb tag wiki
Jul
8
revised mysql wiki description
Removed Section on XEROUND because it recently folded
Jul
8
suggested suggested edit on mysql tag wiki
Jun
10
answered Concurrent / simultaneous MySQL connections
May
3
reviewed No Action Needed Convert WP Menu to a Drop Down for Mobile browser