Invalid ENUM values after upgrading from 4.0 to 4.1
Hi, I'm facing a problem with the new 4.1 branch. I've built MySQL from sources with default-language=hebrew and extra-languages=utf. I've also used default-collation=hebrew_general_ci. After installing, this is what I get for few of the variables: mysql show variables like '%char%'; +--++ | Variable_name| Value | +--++ | character_set_server | hebrew | | character_set_system | utf8 | | character_set_database | hebrew | | character_set_client | hebrew | | character_set_connection | hebrew | | character-sets-dir | /usr/local/mysql/share/mysql/charsets/ | | character_set_results| hebrew | +--++ 7 rows in set (0.00 sec) mysql show variables like '%coll%'; +--+---+ | Variable_name| Value | +--+---+ | collation_connection | hebrew_general_ci | | collation_database | hebrew_general_ci | | collation_server | hebrew_general_ci | +--+---+ 3 rows in set (0.00 sec) Sounds great, right? But when I try to work with databases, and their tables, that were upgraded from 4.0 with the new 4.1 server, I see question marks (???) for values in ENUM() field type. By the way, I noticed that default values for such fields (when having ``NOT NULL``) display perfectly in Hebrew. Explanation? Is there any specific ``upgrade procedure`` I should do to overcome this problem? Thanks in advance. Noor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unknown auto ROLLBACK
What is that option? Never saw it before. If this is the case indeed, how do you change its value? Thanks again. Noor -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 4:52 PM To: Noor Dawod Cc: MySQL List Subject: Re: Unknown auto ROLLBACK Because you did not set autocommit on? Noor Dawod wrote: Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to the old beahvior (each command sent is carried out and performed instantly, with no rollback option.) Please CC me in your replies. Thanks in advance. Noor - 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
Unknown auto ROLLBACK
Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to the old beahvior (each command sent is carried out and performed instantly, with no rollback option.) Please CC me in your replies. Thanks in advance. Noor - 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 crashing on FreeBSD 4.6-STABLE
Hi all, I've been trying to install version 4.0.3 of the new MySQL branch 4.0 but got a problem that I cannot seem to solve. Installing MySQL 4.0.3, both in binary and source compilation, yields always the following error when I try to visit a website written in PHP: 020912 09:46:19 mysqld restarted /disk3/mysql-4.0.3-beta-unknown-freebsdelf4.6.2-i386/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=8388600 read_buffer_size=131072 sort_buffer_size=2097144 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Note that MySQL 3.23.52 runs smoothly in the same machine, and that's what I did after not being able to install version 4.0.3. Anyone got a clue how to approch this problem, and how to solve it? By the way, I've re-compiled PHP, mod_ssl and Apache against the new header and library files of MySQL 4.0.3 before I posted this e-mail. When I installed 3.23.52 back, I re-compiled PHP, mod_ssl and Apache again against them. Any suggestions? Noor - 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
Unix_TimeStamp()
Hi, Does the function Unix_TimeStamp() work in MySQL under Windows NT? It doesn't seem to work here in simple queries, such as this query: Select Unix_TimeStamp(); Thanks Noor - 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
Exporting data from MySQL to Oracle
Hello, I'm having a problem exporting MySQL BLOB's to Oracle, especially those records that has "Carriage Return" or "Line Feed" characters in them. Has anyone done this before, and how did they do it? I need an immediate help in this subject. I'd appreciate you help very much. Thanks Noor - 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
TEXT's are giving us headaches!
Hello, We operate a forums website and use Phorum web application (PHP/MySQL backend), more info: http://www.phorum.org After operating for two years now, we are facing a serious problem. Giving the fact that the forums are full of content, ONE (1) search operation on a single forum is draining a "Xeon 933-Mhz 1GB RAM" of its power entirely! The MySQL daemon goes to 97% CPU usage, and all other queries are delayed until the search query finishes. This usually takes up from few tens of seconds to minutes until the search is over. The messages themselves that are added to the different forums are inserted into a TEXT field. We use MySQL 3.23.32, so I recently added a FULLTEXT index for this field on all forums and changed the source code to make use of the MATCH() AGAINST() MySQL call. This still doesn't help much, and the CPU usage after one search operation is unbearable. I need solutions, and I would like to get yours if you have any. The my.cnf file that we use is as follows: -- [client] port= 3306 socket = /mysql/mysql.socket [mysqld] port= 3306 socket = /mysql/mysql.socket pid-file= /mysql/mysql.pid tmpdir = /mysql/tmp/ set-variable= key_buffer=256M set-variable= max_allowed_packet=2M set-variable= table_cache=256 set-variable= sort_buffer=64M set-variable= tmp_table_size=8M set-variable= record_buffer=4M set-variable= myisam_sort_buffer_size=32M set-variable= thread_cache=16 set-variable= thread_concurrency=2 # Try number of CPU's*2 set-variable= max_connections=256 skip-locking skip-name-resolve log log-slow-queries -- By the way, one of the solutions that were suggested is to turn into a commercial SQL solution, such as Oracle or DB2, and solve this problem for good, but I still like MySQL and its speed and simplicity. Thank you for your help. Noor - 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: TEXT's are giving us headaches!
Hi Hmm, this seems to me like redundant code.. if you're holding info in Score, and not using it but only using the same operation that was used to create it, then it's a redundant code.. Are you sure the second form works faster than the first one? Noor -Original Message- From: Jason Terry [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 6:07 PM To: Noor Dawod Cc: [EMAIL PROTECTED] Subject: Re: TEXT's are giving us headaches! A mistake I made for a long time with MATCH AGAINST is to not include it in the WHERE clause eg I did SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq instead of SELECT ID,MATCH Q,A AGAINST ("This") AS Score FROM faq WHERE MATCH Q,A AGAINST ("This") The latter will give much better performance - Original Message - From: "Noor Dawod" [EMAIL PROTECTED] To: "MySQL List" [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 7:51 AM Subject: TEXT's are giving us headaches! Hello, We operate a forums website and use Phorum web application (PHP/MySQL backend), more info: http://www.phorum.org After operating for two years now, we are facing a serious problem. Giving the fact that the forums are full of content, ONE (1) search operation on a single forum is draining a "Xeon 933-Mhz 1GB RAM" of its power entirely! The MySQL daemon goes to 97% CPU usage, and all other queries are delayed until the search query finishes. This usually takes up from few tens of seconds to minutes until the search is over. The messages themselves that are added to the different forums are inserted into a TEXT field. We use MySQL 3.23.32, so I recently added a FULLTEXT index for this field on all forums and changed the source code to make use of the MATCH() AGAINST() MySQL call. This still doesn't help much, and the CPU usage after one search operation is unbearable. I need solutions, and I would like to get yours if you have any. The my.cnf file that we use is as follows: -- [client] port= 3306 socket = /mysql/mysql.socket [mysqld] port= 3306 socket = /mysql/mysql.socket pid-file= /mysql/mysql.pid tmpdir = /mysql/tmp/ set-variable= key_buffer=256M set-variable= max_allowed_packet=2M set-variable= table_cache=256 set-variable= sort_buffer=64M set-variable= tmp_table_size=8M set-variable= record_buffer=4M set-variable= myisam_sort_buffer_size=32M set-variable= thread_cache=16 set-variable= thread_concurrency=2 # Try number of CPU's*2 set-variable= max_connections=256 skip-locking skip-name-resolve log log-slow-queries -- By the way, one of the solutions that were suggested is to turn into a commercial SQL solution, such as Oracle or DB2, and solve this problem for good, but I still like MySQL and its speed and simplicity. Thank you for your help. Noor - 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: Exporting data from MySQL to Oracle
I couldn't find such product on Oracle's website. Noor -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 5:51 PM To: Noor Dawod; MySQL List Subject: RE: Exporting data from MySQL to Oracle Didn't Oracle just release a MySQL to Oracle migration kit? Check the Oracle website. Cal http://www.calevans.com -Original Message- From: Noor Dawod [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 8:41 AM To: MySQL List Subject: Exporting data from MySQL to Oracle Hello, I'm having a problem exporting MySQL BLOB's to Oracle, especially those records that has "Carriage Return" or "Line Feed" characters in them. Has anyone done this before, and how did they do it? I need an immediate help in this subject. I'd appreciate you help very much. Thanks Noor - 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: Unexplained high-loads on FreeBSD
Hi Sinisa Is the FreeBSD problem previously submitted by me known to you? Noor -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 3:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Unexplained high-loads on FreeBSD Herald van der Breggen writes: Hello Noor, I am struggling with a similar problem on a linux based system. It's a Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L scsi controler. On certain moments, mostly in the peak hours, mysql suddenly behaves weird and the load increases very very quick. The swap used is also increasing very quick (was that also the case on your system ?). We use mysql in combination with Apache::Session which uses GET_LOCK. We saw that no lock could be obtained, which could be the cause for an increase og threads being used. At the moment the wevserver and mysql server are restarted automically when the number of threads is higher than 60 (by a cron job), which is a clumbsy solution of course I have seen this problem with 3.23.29-beta, 3.23.30-gamma and 3.23.31. I consider downgrading to 3.22.x :-/ Herald Hi! The above is an already reported problem that occurs only on SMP Linux on the high load. A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build properly MySQL on that setup. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: Unexplained high-loads on FreeBSD
Hello Jan and all, I have issued a "show processlist" all the time during the time that mysqld is at high loads, but I didn't notice slow queries of some kind. Furthermore, I personally go over all queries and tables produced by our developers to insure proper syntax and indexing, so I am pretty positive there are no slow queries. The only solution to this situation is to shut down mysqld completely, then restart it back. The minute mysqld goes over 95% of CPU usage, it would never go below that. I need to manually shut it down, then start it again. By the way, on our development server, there are TWO mysqld processes, each uses different ports. They have been up and running for ages now without a problem. Of course, such a server doesn't get as much hits as the productional and much more powerful server does. Someone on the list have suggested that BSD's threading support sucks (does it?) and he had the same problem exactly. Only after moving to Debian that he saw the end of these problems... What do you suggest? Noor -Original Message- From: Jan Tegtmeier [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 4:53 PM To: [EMAIL PROTECTED] Subject: Unexplained high-loads on FreeBSD Hi Noor, have you tried to run a "show processlist" within mysql during these OVERHEAT situations to find out if there is a query forcing this high load? You could also activate the logfile for slow queries (starting mysqld with --log-slow-queries[=file_name])... maybe you will get some info from this without having the monitor the server by yourself all the time. Do you shut down mysqld to proceed or is the CPU usage going down after some time? Mit freundlichen Gren Jan Tegtmeier NetGate Internetservice - 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