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

root 25215016 Oct 1 18:56 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 1 18:56 /usr/lib/libc.so Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] - Before posting

Re[2]: mysql monitoring?

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 posting, please

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

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-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before

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

,queries,smallint :) Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

mysql 4.0.8- crash on TCP connection

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) 56491109

4.0.6 + FLUSH QUERY CACHE - mysqld got signal 11

| 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 e-mail : [EMAIL PROTECTED

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

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: (+372) 56491109

DateTime comparation problems

Hello bugs, SELECT ... FROM table o WHERE o.date = 2002090100 AND o.date=2002110624 MySQL 3.23.xx - work (returns 0 rows) MySQL 4.0.4 - not work (returns 0 rows) P.S. also in 4.0.4 not work BETWEEN in this case (but as i can see it will be fixed in next release) Best regards, Andrew

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

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

/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://lists.mysql.com

Re[2]: TRUNCATE TABLE

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 - Before posting, please check: http

Re[4]: TRUNCATE TABLE

CREATE ... SELECT ... Best regards, Andrew Sitnikov e-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

TRUNCATE TABLE

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

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

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

| c.CustomerID | 18 | || | ac| ref | UserID | UserID | 4 | u.UserID | 47 | |Using index | +---+--+++-+--+--+-+ Best regards, Andrew