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
DB: Started >> Hello Gelu, >> >> GG> Hi, >> GG> What OS you use ? >> System: Linux gap 2.4.20-grsec #1 SMP Fri Dec 6 23:17:05 EET 2002 i686 GG> unknown >> Architecture: i686 >> >> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake GG> /home/

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

Com_select not increment when used QUERY_CACHE and if query exists in cache.

2002-12-10 Thread sitnikov
>Description: Com_select not increment when used QUERY_CACHE and if query exists in cache >How-To-Repeat: 1. enable QUERY_CACHE 2. Run 2 equal SELECT statment >Originator: Andrew Sitnikov >Organization: Infonet Ltd. >Severity: non-critical >Category:

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:/

mysqld --help -> Segmentation fault

2002-08-30 Thread sitnikov
>Description: Segmentation fault when starti mysqld with --help >How-To-Repeat: mysqld --help Server version: mysql-4.0.3-beta-pc-linux-gnu-i686 >Environment: System: Linux gap 2.4.18 #3 SMP Fri Mar 15 14:40:03 EET 2002 i686 unknown Architecture: i686 Some paths: /usr/

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

timestamp(8) GROUP BY problem

2002-05-27 Thread sitnikov
Description: Problem with timestamp(8) and GROUP BY How-To-Repeat: mysql> CREATE TABLE test ( -> id int auto_increment, -> dd timestamp(8), -> data int, -> PRIMARY KEY (id) -> ); Query OK, 0 rows affected (0.01 sec) mysql> INSERT INTO test (data) VALUES(1),(2),(3),(4

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

3.23.49 - Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!

2002-02-18 Thread sitnikov
>Description: MysQL 3.23.48 works fine, but after upgrade to 3.23.49: Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists! >How-To-Repeat: Upgade from 3.23.48 to 3.23.49 >Fix: Downgrade to 3.23.48 >Release: mysql-3.23.48