Re[4]: mysql 4.0.8- crash on TCP connection
Hello Gelu, GG Hi Andrew, GG I can not reproduce your case.For me work good.The only difference is that i GG use source distribution and you use a binary distribution. GG Please take a look in mysql log and tell me what you see there. GG Regards, 030108 20:12:09 mysqld started 030108 20:12:10 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=1 max_connections=200 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211614 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8704638 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb397f608, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806f3bb 0x8269928 0x807724c 0x8077665 0x82670dc 0x829c67a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at (nil) is invalid pointer thd-thread_id=10 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 10 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 030108 20:12:25 mysqld restarted 030108 20:12:26 InnoDB: 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/local/sitnikov/bin/gcc /home/local/sitnikov/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro' CXX='gcc' GG CXXFLAGS='-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 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, 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
Re[2]: mysql monitoring?
Hello David, DL is there an snmp mib or something available for snmp to monitor mysql DL server? or, does anyone have a script that they would like to share that DL they use to monitor and gather statistics about mysql? MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS usage statistics Types of stats: 1. Number of queries (queries/sec) 2. Number of Connections (conn/sec) 3. Data In/Out (bytes/sec) 4. Key write requests (requests/sec) 5. Key read requests (requests/sec) 6. Key writes (writes/sec) 7. Key reads (reads/sec) 8. Types of queries 9. 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 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
Re[4]: mysql 4.0.8- crash on TCP connection
Hello Gelu, No, the glibc gethostby* will walk the tree defined in hosts.conf, normally files,dns. A non-find in /etc/hosts followed by a NXDOMAIN GG If you said soanyhow gethostby* is used by DNS and no reverse. GG The Name Server(named) use this both functions depending by the order line GG in /etc/host.conf.And after this read the /etc/hosts.Depend on the action GG this file is call host database file or static table for host names. All this is very interesting, BUT i have two binary builds (4.0.7 4.0.8), downloaded 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-mail : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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
Re[4]: mysql 4.0.8- crash on TCP connection
Hello , GG Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If GG this functions didn't find an entry for the client, will be crashed. GG I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i GG don't see nothing about it. # uname -a Linux gap 2.4.20-grsec #1 SMP Fri Dec 6 23:17:05 EET 2002 i686 unknown #cat /etc/SuSE-release SuSE Linux 7.3 (i386) VERSION = 7.3 # rpm -qa | grep glibc glibc-i18ndata-2.2.4-77 glibc-profile-2.2.4-77 glibc-html-2.2.4-77 glibc-info-2.2.4-77 glibc-devel-2.2.4-77 glibc-2.2.4-77 GG What i see is, he use 2.95.x which is declared by GG MySQL like unstable.In this context can be a coincidence what is happened. I used binary distribution. GG Also i don't find difference in MYSQL daemon source code(hostname.cc) GG between 4.0.7 and 4.0.8. I thing that 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, 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
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 - 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
4.0.6 + FLUSH QUERY CACHE - mysqld got signal 11
Hello mysql, Hello mysql, shell#resolve_stack_dump -s mysqld.sym -n mysqld.stack mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402 653 184 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=2 max_connections=200 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211614 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x88ec5d0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xb761f208, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8071b8a handle_segfault + 450 0x82929e8 pthread_sighandler + 184 0x80f1673 move_by_type__11Query_cachePPcPP17Query_cache_blockPUlP17Query_cache_block + 875 0x80f124c pack_cache__11Query_cache + 196 0x80ee5f2 pack__11Query_cacheUlUi + 70 0x8081c9b reload_acl_and_cache__FP3THDUlP13st_table_list + 215 0x807f993 mysql_execute_command__Fv + 13067 0x80807e6 mysql_parse__FP3THDPcUi + 214 0x807bafa dispatch_command__F19enum_server_commandP3THDPcUi + 1594 0x807b4b6 do_command__FP3THD + 310 0x807ab8e handle_one_connection + 698 0x829019c pthread_start_thread + 220 0x82c58aa thread_start + 4 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x88efd10 = FLUSH QUERY CACHE thd-thread_id=1643 mysql show variables like 'query_cache%'; +---+--+ | Variable_name | Value| +---+--+ | query_cache_limit | 1048576 | | query_cache_size | 67108864 | | query_cache_type | ON | +---+--+ 3 rows in set (0.00 sec) mysql show variables like 'version'; +---+-+ | Variable_name | Value | +---+-+ | 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 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 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
mysql-4.0.5a+linux+FLUSH QUERY CACHE = crash
Hello mysql, after FLUSH QUERY CACHE in error.log 021127 17:25:17 mysqld started 021127 17:25:19 InnoDB: Started /usr/local/mysql/bin/mysqld: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=402649088 read_buffer_size=2093056 sort_buffer_size=2097144 max_used_connections=115 max_connections=200 threads_connected=6 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1211610 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8a7e870 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfd1f2a8, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x806eedb 0x8268018 0x80de403 0x80de1ab 0x80dcbd9 0x807dc27 0x807bdb3 0x807cad5 0x8077d4b 0x8077795 0x8077007 0x82657cc 0x829ad6a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Res olved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x66daadf0 is invalid pointer thd-thread_id=431408 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 431408 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid. The manual page at http://www.mysql.com/doc/C/r/Crashing.html 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: (+372) 56491109 - 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
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 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 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
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 - 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
mysql 4.0.3 --defaults-file problem
Hello mysql, Can not start mysqld with --defaults-file mysqld --no-defaults--defaults-file=/usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/my.cnf /usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686/bin/mysqld: ERROR: unknown variable 'defaults-file=/usr/local/mysql-4.0.3-beta-pc-linux-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://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
Re[2]: TRUNCATE TABLE
Hello Benjamin, Why after TRUNCATE TABLE data file with indexes not freed ? BP See http://www.mysql.com/doc/A/d/Adding_and_removing.html (2nd paragraph) BP and http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#InnoDB_File_space BP (second link does not work in the searchable doc, whyever) and TRUNCATE TABLE is very slow ... BP See http://www.mysql.com/doc/T/R/TRUNCATE.html BP and http://www.mysql.com/doc/I/n/InnoDB_restrictions.html BP (in short: because it's InnoDB on 3.23, it's deleting all rows BP seperately) 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 - 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
Re[4]: TRUNCATE TABLE
Hello Benjamin, BP Hi. BP First, when you start an independend question, please start a new BP thread, but at least change the subject accordingly. This is not independent question. Manual say what TRUNCATE TABLE will recreate table from frm file, but when i use TRUNCATE TABLE, index file will not recreated, becouse it have old data and it size is biger than after CREATE TABLE ... If table recreated from table.frm why it not recreate indexes file? BP Because this is the documented behaviour: BP http://www.mysql.com/doc/C/R/CREATE_TABLE.html ;-) I spoke about 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 (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
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 - 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
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 : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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
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 : [EMAIL PROTECTED] GSM: (+372) 56491109 - 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
USING INDEX
Hello mysql, Why sum() influences use of indexes for the table ac (tblAccountActivity) mysql EXPLAIN - SELECT - c.CustomerID, c.CompanyName, - c.ContactFirstName, c.ContactLastName, c.BillAddress1, - c.MobilPhone, c.WorkPhone, c.HomePhone, - sum(ac.Credit), sum(ac.Debit) - FROM tblCustomer c - INNER JOIN tblUser u ON u.CustomerID=c.CustomerID - INNER JOIN tblAccountActivity ac ON u.UserID=ac.UserID - WHERE c.Dealer=4 - GROUP BY c.CustomerID; +---+++-+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | |Extra | +---+++-+-+--++-+ | ac| ALL| UserID | NULL|NULL | NULL | 141800 | |Using temporary | | u | eq_ref | PRIMARY,CustomerID | PRIMARY | 4 | ac.UserID| 1 | | | | c | eq_ref | PRIMARY,K1,IDX2| PRIMARY | 4 | u.CustomerID | 1 | |where used | +---+++-+-+--++-+ mysql EXPLAIN - SELECT - c.CustomerID, c.CompanyName, - c.ContactFirstName, c.ContactLastName, c.BillAddress1, - c.MobilPhone, c.WorkPhone, c.HomePhone - FROM tblCustomer c, tblUser u, tblAccountActivity ac USE INDEX (UserID) - WHERE c.Dealer=4 AND u.CustomerID=c.CustomerID AND u.UserID=ac.UserID - GROUP BY c.CustomerID; +---+--+++-+--+--+-+ | table | type | possible_keys | key| key_len | ref | rows | |Extra | +---+--+++-+--+--+-+ | c | ref | PRIMARY,K1,IDX2| IDX2 | 2 | const| 407 | |where used; Using temporary | | u | ref | PRIMARY,CustomerID | CustomerID | 4 | c.CustomerID | 18 | || | ac| ref | UserID | UserID | 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 (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