Visual Foxpro
parameter ts1, ts2, ts3 this.m_sClsNam = if TYPE_C == type( 'ts1' ) and TYPE_C == type( 'ts2' ) and TYPE_C == type( 'ts3' ) COdbcSynchBatchNotrans::Init( ts1, ts2, ts3 ) else COdbcSynchBatchNotrans::Init( 'theOdbcReference', 'theUser', 'thePAssword' ) endif this.m_sTableName = '' COdbcSynchBatchNotrans::Connect() endproc ** * En VFP mi date format siempre es dd/mm/, mysql necesita '-mm-dd' para manejar fechas (FECHA1 y FECHA1 son DATE) FUNCTION FIXDATE PARAMETER ts1 LOCAL m.sRet IF TYPE_D == TYPE( ts1 ) ts1 = DTOC( ts1 ) ENDIF m.sRet = IF NOT EMPTY( ts1 ) m.sRet = RIGHT( ts1, 4 ) + - + SUBSTR( ts1, 4, 2 ) + - + LEFT( ts1, 2 ) ENDIF RETURN m.sRet enddefine * Jose de Jesus Ruiz Gonzalez Depto. de Sistemas 5480-3886 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RV: Assertion failure with MySQL 4.0.3/InnoDB
Hello, Recently I have installed MySQL-Max 4.0.3 in my production server, and in the error log I found the following message (or very similar) several times: InnoDB: Assertion failure in thread xxx in file btr0pcur.c line 203 Why takes place this crash? NOTE: Querys associated to crash dump are very trivial SELECT's that work OK in 3.23.52. The only similarity among them is the use of ORDER BY DESC. Best regards, José Ceferino Ortega - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
slow querys
Threads: 12 Questions: 107446 Slow queries: 485 Opens: 88 Flush tables: 1 Open tables: 82 Queries per second avg: 42.722 -- Why have I so many slow querys??? I can't understand, but the performance get down. I have Mysql/apache/php it's a web aplication what can i do? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php