Performance indexes with a lot of Null values on MyISAM big tables

2002-03-25 Thread Benoît Grangé
is change ? The server is a dual P3, 1 gig RAM, with hardware raid, only doing this. Regards, -- Benoît Grangé Directeur réseau, Tiscali Télécom 37 rue Greneta, 75002 Paris (plan) tel: +33 1 45 08 24 68 fax: +33 1 45 08 20 01 ---

RE: Insert delayed & locks

2001-01-21 Thread Benoît Grangé
below and failed, specifically when doing FLUSH TABLES and FLUSH TABLES WITH READ LOCK which simply prevents the DELAYED INSERT handler to restart correctly and immediatly makes mysql reach its maximum thread limit. Benoît Grangé LibertySurf Télécom 10, rue Fructidor, 75834 Paris CEDEX 17 Tel: +33 (0

RE: examples of large mysql databases

2001-01-21 Thread Benoît Grangé
Brett, I am using mysql to log RADIUS accounting for a big ISP. The accounting table has 10 fields of different types with one index on an aggregate of 3 fields. The record is fixed length. Mysql is reasonably fast and handles tables until you reach the 2 GB file size limit where it fails (this