SQL command for MySQL ?

2010-03-17 Thread Stephane MAGAND
Hi i am debutant in SQL and i am search to know if it's possible: My SQL requets: UPDATE Table_Logs_Summary SET mails_recus=(mails_recus+1),mail_rbl=(mail_rbl+1) WHERE dom_id=4 AND Date_Start="2010-03-16 06:00:00" AND Date_End="2010-03-16 06:59:59"; I wan't know if they have a optimised sql

Mysql Performence config ?

2010-03-16 Thread Stephane MAGAND
Hi i use MySQL Server 5.1.42 on a IBM Xseries x3950 (32Go,4xDual Core,Mandriva 64 Bits, 250 GoRAID SAS). I search the best my.cnf configuration for performence, actually i use : [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket