mysql update

2010-01-21 Thread madunix
I have the following update procedure that update mySQL DB over the internet between source Linux Centos (local machine on my net behind a DMZ with real IP A.B.C.D) and target Linux fedora (web server www.myweb.com) every day on a specific time 18:00 through a crontab on my source linux server ser

Re: optimize mysql

2010-01-14 Thread madunix
its a linux server fedora with 2GB ram, insert mostly used through the update, no load or on cpu during that time mysql> show status; +++ | Variable_name | Value | +++ | Aborted_clients

optimize mysql

2010-01-12 Thread madunix
I need your recommendation, I have the following config file need to be optimized, can any one recommend any modification on this file, lately mysql went slow with update procedure # Example MySQL config file for medium systems. # # This is for a system with little memory (32M - 64M) where MySQL