Miva 5 / MYSQL Optimization Tips Needed

[3djoe]

Does anyone have any MYSQL - Miva 5 optimization tips for us? Doing a new Miva 5 install and having some issues with sluggishness, performance.

Thanks!
Brian

[ILoveHostasaurus]

What kind of server is it running on and is mysql running on the same server as the website? In the Merchant 5 connection string is it using localhost as the server address? Where does the sluggishness occur? While shopping, importing products, etc.?

[dotCOM_host]

Does anyone have any MYSQL - Miva 5 optimization tips for us? Doing a new Miva 5 install and having some issues with sluggishness, performance.
Brian,

What's your site URL? Who's your host, and what type of server is your site hosted on?

mySQL is not the fastest beast out of the box and you can tweak the performance quite a bit, but even stock Linux/mySQL install should not feel sluggish on a decent server. Unless your host is overloading the server you are on, or has seriously misconfigured mySQL setup, inadequate memory resources, etc, it's hard to say why the site would feel "sluggish." Perhaps if you give us your URL we can have a look at it and see what's causing this.

[3djoe]

greetings remik, we host on our own box and the install was out of the box. this is a new server and the miva 5 store is under development. since it isn't public yet, will send you the url to your info@ e-mail. i know you are your own host but do you do any consulting on the site? we are looking for someone to tune the machine and make sure mysql is set-up ok. if anyone on this list knows of any freelance sysadmin contractors, please let me know. best, brian

[adam2003w]

Yes, I have a miva / mysql tip for you:

TURN LOGGING OFF!

Excuse me. I might have said that loud, but Miva 5 has an extensive sql logging system that creates a log file the size of a twelve elephant circus in a phone booth.

You can find the solution here:
http://extranet.miva.com/forums/showthread.php?t=179

Maybe that's not why your Miva 5 was sluggish, but it sure was the reason my miva sites were. We kept getting calls from our host that were were exceeding our space limit daily! Once we turned logging off, no more space issue and site ran much faster.

Hope this helps. Good luck.

[ILoveHostasaurus]

Yes, I have a miva / mysql tip for you:

TURN LOGGING OFF!

Excuse me. I might have said that loud, but Miva 5 has an extensive sql logging system that creates a log file the size of a twelve elephant circus in a phone booth.


Logging is not turned on by default though, someone has to manually edit the merchdb.dat to enable it.