query string make mysqld crash (mysqld 4.0.20)

nnections = 1506815 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > -e > Number of processes running now: 0 > 040614 13:33:33 mysqld restarted > Thans for any help Regards -- Bernard CHAMBON IN2P3 / CNR

MySql 4.0.20 : Parenthesis number problem ?

nnections = 1506815 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > -e > Number of processes running now: 0 > 040614 13:33:33 mysqld restarted > Thans for any help Regards -- Bernard CHAMBON IN2P3 / CNR

key_buffer or key_buffer_size

_size, thread_cache and thread_cache_size, innodb_buffer_pool and innodb_buffer_pool_size etc. -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Questions on index and 'order by'

enforce the optimizer by setting max-seeks-for-key but no result ! What is wrong with my indexes ? Regards -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Questions on index and 'order by'

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

log-bin file rotation questions

uot;; "unlock master") But doing a "lock master" seem to me dangerous for many reasons Do I misunderstood something ? Regards -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 --

Re: Does replication works with innodb ?

notice that 'slave_net_timeout' wasn't recognized (unrecognized option `--slave_net_timeout=300') Now I concentrate on 'bin-log rotation problem' Regards. Jeremy Zawodny wrote: On Tue, Jan 07, 2003 at 12:29:31PM +0100, Chambon wrote: The problem is that NOTHI

Does replication works with innodb ?

) ? Best regards. -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Question about replication

d on the master, that the slave thread is running. Show slave status is ok. Any idea ? Best regards. -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 - Before postin

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

27;out of sync' erro messages ! He will change this in the next days. After that I think everything will work fine (insert / update / query) Thanks you for your help Regards -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTE

Re: Lost connection, C API

eral client threads, > and get the error above. > > Best regards, > > Heikki Tuuri > Innobase Oy > -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email: mailto:[EMAIL PROTECTED] Tel : 04 72 69 42 18 -

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 :

Re: Mysql, innodb, linux problems

Hello, As recommended I upgrade from 3.23.39 to 3.23.47 and now everything works very well Intensive insert with simultaneous update and several simultaneous select on the same table works perfectly on InnoDB tables Regards -- Bernard CHAMBON IN2P3 / CNRS (Centre de Calcul de LYON) email

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 -