Re: RE:Re: RE:Re: Localization..
which version are u using? and pls state other info about ur OS! using with 3.23.38-max-nt in Windows2000 Advanced Server without problem when I search exactly your example. about the case %0xF4 0xF4%, have u really used it to search in where clause, or u just want to elaborate ur example? I am useing Mysql-3.23.39/40 on FreeBSD and Debian Linux, with default charset Latin1, column type is varchar(n) binary I didn't try the case %0xF4 0xF4%, but some unexpected answer come up when i search for multi-byted charactors (Big5 or UTF-8 in that column.) which is simular to this example.. - Original Message - From: shiuwaitai [EMAIL PROTECTED] To: SDiZ Cheng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 1:08 PM Subject: RE:Re: Localization.. Hi, try to use varchar or varchar binary instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. I have tried that. MySQL match all rows i needed. But i match some row i don't want too.. let me show you an example... The charactor ¤¤ in Big5 chinese is 0xA4 0xA4. The charactor ¤ô is 0xA4 0xF4, ôô is 0xF4 0xF4. To match ôô, we should use %0xF4 0xF4%, which, in result, it match ¤ô¤¤ .. 0xA4 0xF4 0xA4 0xA4 too.. i just don't want this kind of cross-charactor match happend. Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? the table i want to create is of mixed charsets, ie: Title VARCHAR(10), --- Latin desc_b5 VARCHAR(10), --- Big5 desc_gb VARCHAR(10), --- GB2312 desc_en VARCHAR(10), --- ASCII desc_(some other charsets...) I am now using a simple BINARY option to make this (seems) possible. INSERT work fine with this. However, _SELECT col_name from tbl_name LIKE '%(somthing)%';_ doesn't work as expected with multi-byted charsets... MySQL try to match across two characters. I don't want to use Unicode in this, as Unicode is not a complete superset of all charset i have to use, there will be some losses when i convect to other charsets.. That's why i am asking here. Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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: RE:Re: Localization..
- Original Message - From: shiuwaitai [EMAIL PROTECTED] To: SDiZ Cheng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 1:08 PM Subject: RE:Re: Localization.. Hi, try to use varchar or varchar binary instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. I have tried that. MySQL match all rows i needed. But i match some row i don't want too.. let me show you an example... The charactor ¤¤ in Big5 chinese is 0xA4 0xA4. The charactor ¤ô is 0xA4 0xF4, ôô is 0xF4 0xF4. To match ôô, we should use %0xF4 0xF4%, which, in result, it match ¤ô¤¤ .. 0xA4 0xF4 0xA4 0xA4 too.. i just don't want this kind of cross-charactor match happend. Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? the table i want to create is of mixed charsets, ie: Title VARCHAR(10), --- Latin desc_b5 VARCHAR(10), --- Big5 desc_gb VARCHAR(10), --- GB2312 desc_en VARCHAR(10), --- ASCII desc_(some other charsets...) I am now using a simple BINARY option to make this (seems) possible. INSERT work fine with this. However, _SELECT col_name from tbl_name LIKE '%(somthing)%';_ doesn't work as expected with multi-byted charsets... MySQL try to match across two characters. I don't want to use Unicode in this, as Unicode is not a complete superset of all charset i have to use, there will be some losses when i convect to other charsets.. That's why i am asking here. Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? == ·s®ö§K¶O¹q¤l«H½c http://sinamail.sina.com.hk - 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: Localization..
Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? the table i want to create is of mixed charsets, ie: Title VARCHAR(10), --- Latin desc_b5 VARCHAR(10), --- Big5 desc_gb VARCHAR(10), --- GB2312 desc_en VARCHAR(10), --- ASCII desc_(some other charsets...) I am now using a simple BINARY option to make this (seems) possible. INSERT work fine with this. However, _SELECT col_name from tbl_name LIKE '%(somthing)%';_ doesn't work as expected with multi-byted charsets... MySQL try to match across two characters. I don't want to use Unicode in this, as Unicode is not a complete superset of all charset i have to use, there will be some losses when i convect to other charsets.. That's why i am asking here. Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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: Localization..
Date |Wed, 8 Aug 2001 03:05:20 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC Yes, i have read that too. SC that tell me how to compile mysql with multi charset, SC but not create such kind of table. SC i expect there is somthing like SC CREATE TABLE tbl_name ( SC col_name type CHARSET=char_set, SC col_name2 type CHARSET=char_set2 ) ... SC CREATE DATABASE db_name DEFAULT_CHARSET=char_set SC where can i find these? Aha. so, i think nowhere. You can't do that. Can anyone tell me what exactly --with-extra-charset do? I can compile those charset in, but not use them? Or that's just for a localized error message? I think mysql have somthing like postgresql's CREATE DATABASE db_name ENCODEING=encode;. - 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: Localization..
- Original Message - From: Grigory Bakunov [EMAIL PROTECTED] To: SDiZ Cheng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 1:16 PM Subject: Re: Localization.. Date |Tue, 7 Aug 2001 04:01:17 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have a table which contain data of some different charsets, SC some of them are multi-byte character.. SC They are currently stored in raw, binary format.. SC In order to make % match those multi-byte characters correctly, SC I am planning to convect the table format to correct charset. SC However, i cannot find any infomation on how to create a table SC with multi-charsets. May anyone give me some hints here? Look here: http://www.mysql.com/doc/L/o/Localization.html And here: http://www.mysql.com/doc/M/u/Multi-byte_characters.html I have read these docs. I can't find any charset option in CREATE TABLE syntax. - 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: Localization..
Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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: Localization..
Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? - 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
Localization..
I have a table which contain data of some different charsets, some of them are multi-byte character.. They are currently stored in raw, binary format.. In order to make % match those multi-byte characters correctly, I am planning to convect the table format to correct charset. However, i cannot find any infomation on how to create a table with multi-charsets. May anyone give me some hints here? - 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: my sql pattern search and support for backslash??
try some more then..
try // or / or .. .
Hi,
I donot even get that with an additional backslash
also.In my case it just ignores the backslash and goes
ahead with the search .
Regards,
Ravi
--- Jeremy Zawodny [EMAIL PROTECTED] wrote: On
Mon, Jun 18, 2001 at 04:32:54PM +0100, VVM
Ravikumar Sarma Chengalvala wrote:
Even after escaping mysql just seems to be
ignoring it.
Odd. I'm seeing something other than what I first
expected. Watch
this...
---snip---
mysql CREATE TABLE slash_test ( foo VARCHAR(30) );
Query OK, 0 rows affected (0.02 sec)
mysql INSERT INTO slash_test VALUES ('blah\\blah');
Query OK, 1 row affected (0.01 sec)
mysql SELECT * FROM slash_test;
+---+
| foo |
+---+
| blah\blah |
+---+
1 row in set (0.01 sec)
mysql SELECT * FROM slash_test where foo like
blah\\%;
Empty set (0.00 sec)
mysql SELECT * FROM slash_test where foo like
blah\\\%;
+---+
| foo |
+---+
| blah\blah |
+---+
1 row in set (0.01 sec)
---snip---
Hm. I needed one more '\' than I would have thought
necessary.
Is that what you see as well?
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878Fax: (408) 349-5454Cell:
(408) 439-9951
MySQL 3.23.29: up 2 days, processed 15,793,960
queries (79/sec. avg)
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
-
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
-
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: mysqldump on large database..
- Original Message - In the last episode (Jun 15), SDiZ Cheng said: When i use mysqldump, seems that MySQL will open all the tables in the database. But, what i have is: a database will over 10,000 tables .. I get a Too much opened file error on this.. I think increasing open_file_limit is not possible, because of the limit of the OS itself.. Which OS are you running? You should be able to open 2 files (index+data) on most Unixes with a little tuning. I am using linux. yes, i can do they by a simple echo 4294967295 /proc/sys/fs/file-max But i don't want to see my system out of memory. as the kernel doc said, it won't free the memory once it use as a filehandle.. although those filehandle may be reuse, but, the problem is: i won't do that twice . It may be slow, but it should work. Alternatively, you can temporarily move tables 1000 at a time into another directory, mysqldump them, and move them back. thanks for your suggest.. i will try it =) - 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: Strange Mysql behaviour
I think the problem goes here:
PHP4 $result = mysql_query(insert into user values ('$username',
password('$password'), '$email'));
Please ensure $password is correct, and with no problem..
( eg. space/CRLF at the enter of the string ... etc.. )
-
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: Getting MySQL-3.23.35/up working on my box.
I am using the MySQL offical binary. It's okay now.. Just curious.. what distro and gcc/glibc version MySQL team use to compile their linux binary? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - 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
mysqlcheck
I can't use mysqlcheck -m -A and mysqlcheck -e -A It returns with a syntax error.. But i can run mysqlcheck -A with no error. It that a known problem? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - 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: Getting MySQL-3.23.35/up working on my box.
I have just checked bugs.debian.org . Debian Bug report logs - #81181 gcc: sig 11, reproducible and not machine-specific Somebody have file the same problem, with imapd. not mysql's bug =) -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - 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
mysqldump on large database..
When i use mysqldump, seems that MySQL will open all the tables in the database. But, what i have is: a database will over 10,000 tables .. I get a Too much opened file error on this.. I think increasing open_file_limit is not possible, because of the limit of the OS itself.. Can anyone suggest an alternative for mysqldump? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - 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: mysqldump on large database..
Yes.. I know.. But that's not my design. That will be change in a few month.. My job now is: dump all of them out. - Original Message - Wow! What kind of database would have 10,000 tables? Wouldn't you think the database design had a serious flaw in the first place? Seung-woo Nam SDiZ Cheng wrote: When i use mysqldump, seems that MySQL will open all the tables in the database. But, what i have is: a database will over 10,000 tables .. I get a Too much opened file error on this.. I think increasing open_file_limit is not possible, because of the limit of the OS itself.. Can anyone suggest an alternative for mysqldump? -- Cheng Yuk Pong (SDiZ) 4096/1024 DH/DSS 0xA4C6FAD3 FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3 - 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 - 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
Getting MySQL-3.23.35/up working on my box.
Hi all, I am a new subscriber of this list. I have a question that have confuse me for a long time. I am currently running MySQL-3.23.32 on Debian(woody) with kernel 2.4.x on a i386 box /w 1G Ram.. We are currently runing two different kind of database on the same server. One of them is a few table in a Database, each of them have over 10,000 rows, a Merge table in it. Another one is over 30,000 tables in a single Database, with no more then row in each of them.. ( Don't ask me why that happended.. I am not the one design this.) All of them are MyISAM tables. The server is now facing about 200 queries/second on average, and a peak of about 430 queries. All of them are simple LOCK, UNLOCK, SELECT, INSERT.. no join table, no union, no sort.. only simple queries.. most of them have no more then 10 rows of answer. Recently, we done a system upgrade, from kernel 2.4.2 to kernel 2.4.4 for a RealTex LAN Card SMP fix. At about the same time, we have changed some of our program... introducing some rename table and drop tables too.. a few days later, the sql server start core dumping on usual loading.. We have try using --debug option, but it can't help as it's handling too few queries per second, and the sql server just don't dump... I am quite sure that's was not damaged table problem, as we have run myisamchk many times, with differenet options.. -a -f -o -S -e -m -q for over ten times.. After hesitating for an moment, we desided to upgrade to 3.23.35 (ar.. in fact, we have try 3.23.31, .32, .35, .37 and .38 ... the following situation hanppens on .35, .37, and .38 ) After starting the mysql server seems work fine... but huh? why that's so slow? it's running with a maximum of 65 queries/seconds.. the load average climb up quickly... top tell me that mysqld is forking childs, each of them dieing quickly, keeping on average of 80 childs at the same moment..(child? or thread? fix me if i am wrong..) And nothing abnormal are printed to (hostname).err.. this make me more confusing.. i have heard that recent kernel will give childs created with fork() a higher priority.. it that related? Does anyone have the same problem before? should i file this as a bug? ( ar.. i know i am not providing enough infomation.. but.. whenever I start mysql with --debug, it don't dump, as i have said ) anyway.. i will try a downgrade to kernel 2.4.2 this night.. FYI, we compile mysql with --without-bench --without-docs --with-debug. we have tried different version of gcc, all of them are debian's cvs relaease. Here goes my my.cnf, the flush is something i added i discover this.. to protect my tables: [client] port= 3306 socket = /tmp/mysql.sock [mysqld] port= 3306 socket = /tmp/mysql.sock datadir = /usr/local/mysql/var skip-locking #enable-locking flush #temp-pool core-file user= root set-variable= flush_time=10 set-variable= back_log=256 set-variable= key_buffer=8M set-variable= max_allowed_packet=4M set-variable= table_cache=2048 set-variable= sort_buffer=4M set-variable= record_buffer=4M set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=16M set-variable= max_connect_errors=65536 set-variable= max_connections=512 myisam-recover = BACKUP,FORCE log = /usr/local/mysql/var/dump.log log-update - 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: Getting MySQL-3.23.35/up working on my box.
I cannot find the core file.. where is it? BTW, system seems somtimes run out of file handles / max processes. There is some more information to provide: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping 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, ebp=0xb3d8, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40078dd4 _end + 937886004 0x40077f05 _end + 937882213 0x80afda1 create_new_thread__FP3THD + 937 0x80b03a5 handle_connections_sockets__FPv + 1185 0x80af6a7 main + 2539 0x4010b2db _end + 938485307 0x8089971 _start + 33 New value of ebp failed sanity check terminating backtrace Number of processes running now: 0 010613 22:29:24 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections 010613 22:29:25 Warning: Checking table: './Counter/common_one_IP' 010613 22:29:25 Warning: Checking table: './Counter/common_one' 010613 22:29:29 Warning: Checking table: './user/log' 010613 22:29:29 Warning: Checking table: './Counter/taikoo_taikoo_IP' 010613 22:29:29 Warning: Checking table: './Counter/taikoo_taikoo' mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping 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, ebp=0xb3d8, backtrace may not be correct stack range sanity check, ok, backtrace follows 0x40078dd4 _end + 937886004 0x40077f05 _end + 937882213 0x80afda1 create_new_thread__FP3THD + 937 0x80b03a5 handle_connections_sockets__FPv + 1185 0x80af6a7 main + 2539 0x4010b2db _end + 938485307 0x8089971 _start + 33 New value of ebp failed sanity check terminating backtrace Number of processes running now: 0 010613 22:29:56 mysqld restarted /usr/local/mysql/libexec/mysqld: ready for connections - Original Message - Hi all, I am a new subscriber of this list. I have a question that have confuse me for a long time. I am currently running MySQL-3.23.32 on Debian(woody) with kernel 2.4.x on a i386 box /w 1G Ram.. We are currently runing two different kind of database on the same server. One of them is a few table in a Database, each of them have over 10,000 rows, a Merge table in it. Another one is over 30,000 tables in a single Database, with no more then row in each of them.. ( Don't ask me why that happended.. I am not the one design this.) All of them are MyISAM tables. The server is now facing about 200 queries/second on average, and a peak of about 430 queries. All of them are simple LOCK, UNLOCK, SELECT, INSERT.. no join table, no union, no sort.. only simple queries.. most of them have no more then 10 rows of answer. Recently, we done a system upgrade, from kernel 2.4.2 to kernel 2.4.4 for a RealTex LAN Card SMP fix. At about the same time, we have changed some of our program... introducing some rename table and drop tables too.. a few days later, the sql server start core dumping on usual loading.. We have try using --debug option, but it can't help as it's handling too few queries per second, and the sql server just don't dump... I am quite sure that's was not damaged table problem, as we have run myisamchk many times, with differenet options.. -a -f -o -S -e -m -q for over ten times.. After hesitating for an moment, we desided to upgrade to 3.23.35 (ar.. in fact, we have try 3.23.31, .32, .35, .37 and .38 ... the following situation hanppens on .35, .37, and .38 ) After starting the mysql server seems work fine... but huh? why that's so slow? it's running with a maximum of 65 queries/seconds.. the load average climb up quickly... top tell me that mysqld is forking childs, each of them dieing quickly, keeping on average of 80 childs at the same moment..(child? or thread? fix me if i am wrong..) And nothing abnormal are printed to (hostname).err.. this make me more confusing.. i have heard that recent kernel will give childs created with fork() a higher priority.. it that related? Does anyone have the same problem before? should i file this as a bug? ( ar.. i know i am not providing enough infomation.. but.. whenever I start mysql with --debug, it don't dump, as i have said ) anyway.. i will try a downgrade to kernel 2.4.2 this night.. FYI, we compile mysql with --without-bench --without-docs --with-debug. we have tried different version of gcc, all of them are debian's cvs relaease. Here goes my my.cnf, the flush is something i added i discover this.. to protect my tables: [client] port=
