Naturally, I ran into this problem in the middle of the night when the client was asleep and I had no access to the Magento administrative interface. The short story is that after running a re-index of the site, the home page began returning a 404 erro...
During the last couple of months I have been involved in an unusually high amount of performance audits for e-commerce applications running with Magento. And although the systems were quite different, they also had one thing in common: the MySQL query cache was very useful. That was counter-intuitive for me as I’ve always expected the query cache to be such a bottleneck that response time is better when the query cache is turned off no matter what. That lead me to run a few experiments to better understand when the query cache can be helpful.
The query cache is well known for its contentions: a global mutex has to be acquired for any read or write operation, which means that any access is serialized. This was not an issue 15 years ago, but with today’s multi-core servers, such serialization is the best way to kill performance.
However from a performance …[Read more]
February 4, 2015 By Severalnines Check Out Our Latest Technical Resources for MySQL, MariaDB & MongoDB Clusters
Like every month, we have created new content and tools for you; here is a summary of what we’ve published. Please do check it out and let us know if you have any comments or feedback.
New Live Technical Webinars
Tuesday, February 17th
Infrastructure automation isn’t easy, but it’s not rocket science either, says Riaan Nolan. Automation is a worthwhile investment for retailers serious about eCommerce, but deciding on which …[Read more]
CPTN Holdings unmasked. Oracle updates MySQL. And more.
# Florian Mueller reported that the Novell patent acquiring CPTN Holdings is Microsoft, Apple, EMC and Oracle.
# The VAR Guy told the (previously) untold story of Novell’s sale to Attachmate.
# Attachmate committed to support the existing roadmaps and release schedules for Novell and SUSE products.
# Oracle …[Read more]
Red Hat invests in EnterpriseDB. The White House goes open source. And more.
For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask
In other news…
# EnterpriseDB confirmed Red Hat investment, partnership.
# Whitehouse.gov migrated to Drupal, as well as …[Read more]