Re[4]: mysql 4.0.8- crash on TCP connection

2003-01-09 Thread Andrew Sitnikov
t this is "build" problem in binary distribution. P.S sql,query,queries,smallint :) Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, plea

Re[4]: mysql 4.0.8- crash on TCP connection

2003-01-09 Thread Andrew Sitnikov
ed from mysql mirror, and 4.0.7 work for me about 1 month with out problems (load avg 10-60 Query/sec), and 4.0.8 crash (in some hardware/software) after 2 seconds work :( Best regards, Andrew Sitnikov e

Re[2]: mysql monitoring?

2003-01-09 Thread Andrew Sitnikov
Temporary and disk tables usage http://www.mysqlstat.org/en/ http://www.mysqlstat.org/en/screenshot Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before postin

Re[4]: mysql 4.0.8- crash on TCP connection

2003-01-09 Thread Andrew Sitnikov
x27;-O2 -mcpu=pentiumpro -felide-constructors' LD >> FLAGS='' ASFLAGS='' >> LIBC: >> -rwxr-xr-x1 root root 1384072 Oct 1 19:10 /lib/libc.so.6 >> -rw-r--r--1 root root 25215016

mysql 4.0.8- crash on TCP connection

2003-01-08 Thread Andrew Sitnikov
Hello mysql, I try use 4.0.8 (max & standard)in our production box, and it was crash every TCP connection, For 4.0.7 (standard) i has over 20 days uptime. Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 5649

4.0.6 + FLUSH QUERY CACHE -> mysqld got signal 11

2002-12-24 Thread Andrew Sitnikov
-+ | version | 4.0.6-gamma-debug-debug-log | +---+-+ 1 rows in set (0.00 sec) Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 Best regards, Andrew Sitnikov

mysql-4.0.5a+linux+FLUSH QUERY CACHE = crash

2002-12-05 Thread Andrew Sitnikov
ml contains information that should help you find out what is causing the crash. Number of processes running now: 0 021205 00:49:35 mysqld restarted Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+37

DateTime comparation problems

2002-11-06 Thread Andrew Sitnikov
t regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arc

MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS usage statistics

2002-09-05 Thread Andrew Sitnikov
Hello mysql, MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS usage statistics: http://www.mysqlstat.org/en/ Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109

mysql 4.0.3 --defaults-file problem

2002-08-30 Thread Andrew Sitnikov
ux-gnu-i686/my.cnf' Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http:/

Re[4]: TRUNCATE TABLE

2002-07-27 Thread Andrew Sitnikov
t TRUNCATE TABLE, not about CREATE ... SELECT ... Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php

Re[2]: TRUNCATE TABLE

2002-07-27 Thread Andrew Sitnikov
erately) All my tables has MyISAM type, but server running with InnoDB support. >> MySQL 3.23.51+InnoDB >> OS: Linux 2.4.18/ReiserFS Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 -

TRUNCATE TABLE

2002-07-25 Thread Andrew Sitnikov
Hello mysql, Why after TRUNCATE TABLE data file with indexes not freed ? and TRUNCATE TABLE is very slow ... MySQL 3.23.51+InnoDB OS: Linux 2.4.18/ReiserFS Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109

Feature request 4.0.x MAX_SLOW_QUERY_PER_HOURS

2002-05-22 Thread Andrew Sitnikov
Hello, I think that MAX_SLOW_QUERY_PER_HOURS is useful options for GRANT ... WITH MAX_QUERIES_PER_HOUR = N1 MAX_UPDATES_PER_HOUR = N2 MAX_CONNECTIONS_PER_HOUR = N3; statment. Thank. Best regards, Andrew Sitnikov e-mail

Feature request 4.0.x MAX_SLOW_QUERY_PER_HOURS

2002-05-22 Thread Andrew Sitnikov
Hello, I think that MAX_SLOW_QUERY_PER_HOURS is useful options for GRANT ... WITH MAX_QUERIES_PER_HOUR = N1 MAX_UPDATES_PER_HOUR = N2 MAX_CONNECTIONS_PER_HOUR = N3; statment. Thank. Best regards, Andrew Sitnikov e-mail

USING INDEX

2002-04-24 Thread Andrew Sitnikov
serID | 4 | u.UserID | 47 | |Using index | +---+--+++-+--+------+-+ Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php