Home osCommerce Courses CRE Loaded Book Store osC Max The Dean's Blog Zen Cart File Library eCommerce FAQ Education Forums Community Wiki Wiki Contact

Author Topic: Tweaking Mysql Servers  (Read 545 times)

Offline inetbiz

  • eCommerce Strategy Consultant
  • Administrator
  • Full Member
  • *****
  • Posts: 125
  • Karma: 22
  • SKYNET; T3; Apple Inc. Coincidence?
    • View Profile
    • Hosting for Creloaded Cart
Tweaking Mysql Servers
« on: July 14, 2009, 01:02:50 AM »
Hosting Providers,

Please share your tips and tricks to optimizing mysql servers for CRE Loaded, osCommerce, Magento

This is related to a forum topic about cart speed mysql optimizations

Offline zach

  • Newbie
  • *
  • Posts: 1
  • Karma: 0
    • View Profile
Re: Tweaking Mysql Servers
« Reply #1 on: August 17, 2010, 05:08:55 PM »
I would start with running:

cd /root && wget mysqltuner.pl/mysqltuner.pl && perl mysqltuner.pl

Offline inetbiz

  • eCommerce Strategy Consultant
  • Administrator
  • Full Member
  • *****
  • Posts: 125
  • Karma: 22
  • SKYNET; T3; Apple Inc. Coincidence?
    • View Profile
    • Hosting for Creloaded Cart
Re: Tweaking Mysql Servers
« Reply #2 on: August 17, 2010, 05:45:25 PM »
And you also mentioned once about testing memory with a mysql tool. What did you use?