HELP :) Optimizing data file axs through adding indexes

Hi, I've a table which is read very often.. Simplified table structure: create table comments ( id int unsigned not null auto_increment primary key, datedate not null, comment varchar(255) not null

HELP :) Optimizing data file axs through adding indexes

Hi, I've a table which is read very often.. Simplified table structure: create table comments ( id int unsigned not null auto_increment primary key, datedate not null, comment varchar(255) not null

Calculation of memory usage by indexes

Hi, I've got a question about the use of indexes. I've a site running quite good. I've such features like polls and all that usual stuff. I take the poll tables as example. POLLS: idpoll bigint unsigned not null auto_increment primary key,

!!! Mysql hangs after some days on FreeBSD 4.0I

Hi, I've mysql 3.23.32 running on FreeBSD 4.0. It runs a site with heavy traffic and heavy database interaction. After starting mysql it hangs after some days. Mysql server is still in the processlist, but it is not possible to connect to the sql