Optimal configuration

2001-02-16 Thread Jesús Gómez Pastor 

Hi.
I have a server running mysql.From it reads data two web server
wich has about 30.000 daily visits and 250.000 pages so the 
trafic to the mysql server is big.

Can anybody tell me a optimal mysql configuration for this
server?.
Actually in the /etc/my.cnf i have:

set-variable = max_connections=500
set-variable = wait_timeout=1000
set-variable = key_buffer=64M
set-variable = table_cache=256

The server has 650M of ram and two HD of 17 GB.

Thanks.

PD:Excuse me for my poor english. 
;)
Jess Gmez Pastor
[EMAIL PROTECTED]
Equipo de Desarrollo
Autocity Networks
www.autocity.com
wap.autocity.com

Query problem in mysql.3.23.32

2001-01-24 Thread Jesús Gómez Pastor 

I have a problem in 3.23.32,

The query

  select * from table
  repalce table values('','nextval+1)

returns me always nextval=1.

table has 1 row and the query runs fine in mysql 3.22.x

Any idea?

Thanks.