Questions on index and 'order by'

---+-- +-+ | Test | ref | K0| K0 | 17 | const |1 | Using where; Using filesort | +---+--+---+--+-+---+-- +---------+ Thanks for any help - Bernard Cha

auto_increment and range or highest value

Sequence+1) ; select * from Generator ; +--+ | Sequence | +--+ | 0065535 | +--+ Here something doesn't work, or I probably not undestood ! Thank you for any help -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://

mysql_use_result, out of sync, Mysql

esult() in a dummy function. (by dummy, i mean nusefull) but I still got 'out of sync' Perhaps, the solution is to close and open a new connection in such a case ?. But before that, I want to understand. Thank you for your help Regards. -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul

Re: Lost connection, C API

tes: 0 r_requests: 0 reads: 0 handler status: read_key: 5704 read_next:1706 read_rnd47 read_first:394 write:1447 delete 0 update:465 Table status: Opened tables: 26 Open tables:

Lost connection, C API

The query concerned is a small select (only 1 field) on a small table (6 fields) (the max_allowed_packet is set to 16M ) Has anybody encountred a similar problem ? Is there a relation with the net_read_timeout (set to 30) Thank you -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél :

Mysql, innodb, linux problems

admin processlist', I see about 10 threads of insert/update/select worst, if I do a 'mysqladmin kill ...' to kill some thread, nothing happens The only way to recover, is to kill the mysqld processes and restart mysql Thank you for your help -- Bernard CHAMBON IN2

INNOBASE, autocommit = 0, and C API ( mysql_real_query )

The problem is still there ! The autocommit option seems to be an session command. Is there any way to set it for the whole server ? Thank you for your help Sincerely. -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) Tél : 04 72 69 42 18 http://www.in2p3.fr/CC -