Re: Mysql 4.0 always executes case insensitive queries

You should use: SELECT username FROM workflow.user WHERE username LIKE BINARY 'NicO' LIMIT 1; reference: http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html On 12/12/05, Nico Sabbi <[EMAIL PROTECTED] > wrote: > > Hi, > my mysql always executes case insensitive queries: > > >

Re: Mysql 4.0 always executes case insensitive queries

Nico Sabbi wrote: Hi, my mysql always executes case insensitive queries: SELECT username FROM workflow.user WHERE username = 'NicO' LIMIT 1; +--+ | username | +--+ | nico | +--+ 1 row in set (0.01 sec) that field is of varchar(255) type. I don't understand the r

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

Mohsen wrote: > But himself solved his problem. > with : mysql_query("SET NAMES utf8"); > Even 4.0.x Wrong. I decided to prepare two different versions for my software: - A MySQL 4.0-friendly version using Romanizing method (Hats off to you, Ehsan) - A MySQL 4.1-compatible

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 18:36:25: > On 24/11/2005, Alec worte: > > > I think this is your problem: MySQL does not properly support Unicode > > until version 4.1. I am successfully using FullText with MySQL > 4.1 to sort > > UTF-8 encoded Japanese text.

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

On 24/11/2005, Alec worte: > I think this is your problem: MySQL does not properly support Unicode > until version 4.1. I am successfully using FullText with MySQL 4.1 to sort > UTF-8 encoded Japanese text. I see no reason why it should not work for > Arabic - if you upgrade. Dea

Re: MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

AmirBehzad Eslami <[EMAIL PROTECTED]> wrote on 24/11/2005 17:48:29: > Dear list, > > I'm considering programming a simple "Search Engine" for a website, > to find Arabic/Persian data within a MySQL database. > This database contains a huge amount of data, encoded with Unicode(UTF-8). > >

Re: Mysql 4.0 cpu usage

I have solved this problem, I was missing a slash in the path to the data directory Thanks, James - Original Message - From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: Sent: Wednesday, October 26, 2005 4:41 AM Subject: Re: Mysql 4.0 cpu usage > Hello. > > A

Re: Mysql 4.0 cpu usage

Hello. Are you able to connect to the server and found the states of its threads with SHOW PROCESSLIST statement? > Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have tried to > revert back to 4.0. > > I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850

Re: Mysql 4.0 cpu usage

On Tue, 2005-10-25 at 15:39 -0300, James Sherwood wrote: > Mysql 4.1 and 5 will NOT seem to play nice with french characters so I have > tried to revert back to 4.0. > > I am trying to install 4.0 on a Win2003 Dell PowerEdge 2850 and when I run > the service it uses a constant 25%cpu and seems l

Re: mysql 4.0 to 4.1 migration and charset problems

Hello. It is not clear from you message what's the problem. From your calculations I can see that the length of int field in a flat file row (BTW please send a piece of your file) is different in mysqldump programs with different versions? How is the length of integer fields related to cha

Re: mysql 4.0 to 4.1 migration and charset problems

the version is 4.1.12. show variables like this, | character_set_client| latin1 | character_set_connection| latin1 | character_set_database | latin1 | character_se

Re: mysql 4.0 to 4.1 migration and charset problems

Hello. > Any possible problems with this approach? It is good, if it solved your problems. >> So it works for me. > > I've ended doing this in a different way. I've created a patch which forces= > a=20 > file to be read - /etc/mysql/mysql-client.conf (which is the same as .my.cn

Re: mysql 4.0 to 4.1 migration and charset problems

On Monday 11 of July 2005 16:24, Gleb Paharenko wrote: > Hello. > > I've tested your solution. It doesn't work for users which have SUPER > privilege. This mentioned at: > http://dev.mysql.com/doc/mysql/en/server-system-variables.html > > However, it works with with ordinary users which don't hav

Re: mysql 4.0 to 4.1 migration and charset problems

Hello. I've tested your solution. It doesn't work for users which have SUPER privilege. This mentioned at: http://dev.mysql.com/doc/mysql/en/server-system-variables.html However, it works with with ordinary users which don't have SUPER privilege. Here are pieces of my my.cnf (the init_co

Re: mysql 4.0 to 4.1 migration and charset problems

On Thursday 07 of July 2005 00:16, Gleb Paharenko wrote: > Hello. > > > For a pity, I could give explanations only for your query about > selecting @@global.xxx variables. I think server returns correct > results, because you're selecting global variables, while > character_set_client, character_se

Re: mysql 4.0 to 4.1 migration and charset problems

Hello. For a pity, I could give explanations only for your query about selecting @@global.xxx variables. I think server returns correct results, because you're selecting global variables, while character_set_client, character_set_connection, character_set_results are session variables. A

Re: MySQL 4.0 and concat

A bit of a warning, if the fields are DATETIME rather than DATE, add the appropriate hours:minutes:seconds to the test WHERE datetimefield >'1999-02-01 23:59:59'. When comparing DATETIME fields with date strings '00:00:00' is assumed and that can cause problems if one forgets that. > Have you consi

Fwd: Re: MySQL 4.0 and concat

Sorry. This should have gone back to the list. -- Mensaje reenviado -- Subject: Re: MySQL 4.0 and concat Date: Lun 11 Oct 2004 11:37 From: Alfredo Cole <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] El Lun 11 Oct 2004 08:35, escribió: > Have you considered NOT comparing

Re: MySQL 4.0 and concat

Have you considered NOT comparing dates as strings but rather as date values? That will avoid the use of CONCAT() completely. SELECT * FROM sampletable WHERE datefield >= '1999-01-12' and datefield <'1999-02-01' This example query will get all of the records from sampletable that were entere

Re: Mysql 4.0 windows XP Downloads

cess denied for user: '@localhost' to database 'mysql' I can only bypass this error if I use -u root ? Thanks, Francois A -Original Message- From: Julian [mailto:[EMAIL PROTECTED] Sent: Friday, August 20, 2004 12:04 PM To: [EMAIL PROTECTED] Subject: Re: Mysql 4.0 windows

Re: Mysql 4.0 windows XP Downloads

> May someone please send me the link to download mysql Binary distribution > for the first time on windows XP, I have looked into mysql/downloads and > they only have X86. Windows XP, and every other windows platform, runs on X86 architecture. That is the download you want. Jeff -- My

Re: MySQL 4.0.x charset

It's possibly due to your ssh connection but I couldn't answer you about this because I only use mysql with phpmyadmin. Regards Yves wrote: Thanks, As it turns out, I was trying show variables like -- And had a syntax mistake Does SHOW VARIABLES only show a certain number of lines? When I ran

Re: MySQL 4.0.x charset

Thanks, As it turns out, I was trying show variables like -- And had a syntax mistake Does SHOW VARIABLES only show a certain number of lines? When I ran this command, character_set was not listed... the list seemed cut off just before it. Unless it is an issue with SSH only showing x amoun

Re: MySQL 4.0.x charset

You can see it by executing the "SHOW VARIABLES" query on your server. You will find the used charset in the 'character_set' variable. You can also use the query "SHOW VARIABLES LIKE 'character_set'" which will directly match what you want. Yves wrote: Hello, How can I see what char set is bein

Re: Mysql 4.0 -Oracle Stored Procedure Trigger Conversion

Garg, Piyush (EM, GECIS) wrote: Hi Everybody, Is there any way we can tranform the Stores procedure and Triggers present under Oracle Custom Application to mysql. Please tell ways or any tools which can help us rewrite the logic in Mysql. Thanks and regards, Piyush Stored Procedures ar

Re: MySQL 4.0 - Download - Viruses ?

At 17:25 -0700 3/16/04, Sasha Pachev wrote: Kevin Carpenter wrote: While downloading this a I got a number of virus warnings from McAfee. I aborted the download. Anyone else experienced this? I emailed MySQL but didn't hear back. Kevin: Were you downloading a Windows or some other binary? If i

Re: MySQL 4.0 - Download - Viruses ?

Kevin Carpenter wrote: While downloading this a I got a number of virus warnings from McAfee. I aborted the download. Anyone else experienced this? I emailed MySQL but didn't hear back. Kevin: Were you downloading a Windows or some other binary? If it was Windows, I would be concerned - the bu

Re: MySQL 4.0 crashed; Please help

Here are the instructions for doing a stack trace. http://www.mysql.com/doc/en/Using_stack_trace.html >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/13/04, 2:24:30 PM, Jaco

Re: MySQL 4.0 crashed; Please help

[EMAIL PROTECTED] wrote: Did you perform a stack trace? No, how do I do that? /Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.0 crashed; Please help

Did you perform a stack trace? >> Original Message << On 2/13/04, 2:36:42 AM, Jacob Friis Larsen "[Eksperten" "admin]" <[EMAIL PROTECTED]> wrote regarding MySQL 4.0 crashed; Please help: > Can someone help me find out what caused this crash? > My system is a Red

Re: MySQL 4.0 Installation Problem -- trying again

he questions. I have 3.23 that came with my Linux distribution and it's not uninstalled -- but I don't think that should be the cause, though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:36 AM To: [EMAIL PROTECTED]

RE: MySQL 4.0 Installation Problem -- trying again

What does the .err file tell you? -Original Message- From: Zhao, Charles [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 12:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Thanks ... but yeas, I have done both

RE: MySQL 4.0 Installation Problem -- trying again

EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 08, 2004 10:36 AM To: [EMAIL PROTECTED] Subject: RE: MySQL 4.0 Installation Problem -- trying again Charles, First, you need to run the mysql_install_db script. That

RE: MySQL 4.0 Installation Problem

Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno 13) ... Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am not sure if I have to unstall the latter before I install the former, the manual does not mention that, I went ahead to do a fresh bi

Re: MySQL 4.0.x LOAD DATA FROM MASTER wiping out tables...

Gabriel Ricard <[EMAIL PROTECTED]> wrote: > I'm running MySQL 4.0.14 on Mac OS X 10.2.6 on a development server. We > have around 60 tables on the development server and the production > servers. 18 tables that exist on the production server are replicated > to our development server. We use the

Re: MySQL 4.0 Slave to 3.23.55 master Replication

Devin <[EMAIL PROTECTED]> wrote: > > I noticed that my MySQL 4.0.13 Slave Replication server is having > a wierd problem. If you look at the master.info file on the slave > it keeps updating like it is really updating the slave but in > the mysql.err log it shows: > > 030609 16:12:08 Slave I/O t

Re: MySQL 4.0 Installation Problems

> -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > On Sat, 24 May 2003, Egor Egorov wrote: > >> DAVID CLARK <[EMAIL PROTECTED]> wrote: >> > OK, I messed up. I've been running MySQL 3.23, and I >> > wanted to upgrade to 4.0 so I could use the new >> > boolean functions. So I downloaded th

re: MySQL 4.0 and UNICODE

On Wednesday 26 February 2003 18:49, Juan wrote: > Does the last binary version available of MySQL > (4.0xx) support UNICODE? Unicode will be available since 4.1. There is no binaries for 4.1 yet. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is spons

Re: MySQL 4.0 and ODBC 3.51

* Dieter Stelzner [...] > I have opened a conection to a MySQL-Server database. How I can get a list > of all available tables inside the database via ODBC with an SQL > statement? Send a "SHOW TABLES" command. Full syntax: SHOW [OPEN] TABLES [FROM db_name] [LIKE wild] http://www.mysql.com/doc/e

Re: Mysql 4.0 and ssl

hi all, i get the following error logdid anyone try to compile mysql with ssl before? 030116 14:34:13 InnoDB: Started /usr/local/mysql-4.0.9-gamma/libexec/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 t

Re: MySQL-4.0 and PHP with Red Hat 8.0

Your probably better off getting it and compiling it by hand. Dave - Original Message - From: "Florin Andrei" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 4:36 PM Subject: MySQL-4.0 and PHP with Red Hat 8.0 > Anyone tried to use MySQL-4.0 and the precom

RE: MySQL 4.0 and LIKE "%string%"

That optimization is for fields without an index AFAIK. Sincerely, Steven Roussey http://Network54.com/?pp=e sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.c

Re: MySQL 4.0 stable release

On Tue, 27 Aug 2002, Dean Ellis wrote: > The annoying thing about it, for me, is that MySQL 4.0 has been perfectly > stable and perfectly usable for us until 4.0.3, which so far has yet to > produce a usable client library. I keep pulling from CVS and recompiling, > hoping that one day soon I

Re: MySQL 4.0 on Debian

Hello On Thu, 1 Aug 2002, Quinten Steenhuis wrote: > Has anyone successfully gotten MySQL 4.02 running on Debian? I'm > running into problems if I use alien to convert the RPMs. Yep, we're using 4.0.2 on Debian. You may want to grab MySQL .tar.gz instead of .rpm and install it somewhere into /

Re: Re: MySQL 4.0 stable release

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sql,query ... On Tuesday 27 August 2002 02:30 pm, walt wrote: > There has been some issues with gcc 3.x if I remember correctly. I know > RedHat released another beta because of problems with gcc 3.x. Have you > tried it on a box with gcc 2.9x ?

Re: MySQL 4.0 stable release

Dean Ellis wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote: > > As soon as it actually *is* stable :) > > > > On a more serious note, we are currently working on preparing the first > > release of 4.0 (4.0.3) that will be declar

Re: MySQL 4.0 stable release

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 27 August 2002 11:39 am, Lenz Grimmer wrote: > As soon as it actually *is* stable :) > > On a more serious note, we are currently working on preparing the first > release of 4.0 (4.0.3) that will be declared "Beta" instead of "Alpha". The

Re: MySQL 4.0 stable release

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tuesday 27 August 2002 17:17, Scott Pippin wrote: > When will MySQL 4.0 be released as a stable version? As soon as it actually *is* stable :) On a more serious note, we are currently working on preparing the first release of 4.0 (4.0.3)

Re: MySQL 4.0 stable release

On Tue, Aug 27, 2002 at 09:17:46AM -0600, Scott Pippin wrote: > When will MySQL 4.0 be released as a stable version? Where there have been no reported bugs for a sufficient amount of time. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http:

Re: MySQL 4.0 on Debian

On Thu, Aug 01, 2002 at 09:50:33PM -0400, Quinten Steenhuis wrote: > > Hello all, > > Has anyone successfully gotten MySQL 4.02 running on Debian? I'm running > into problems if I use alien to convert the RPMs. I could install from > source, but I want to avoid cruftiness and make it easy to upg

Re: MYSQL 4.0

On Thu, Jun 27, 2002 at 04:21:43PM +0200, Sander Pilon wrote: > > It has not been for us. Replication, query cache and fulltext stuff > is borked. But, it's an alpha. Alpha's aren't supposed to be stable. What replication problems have you seen? -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technic

Re: MYSQL 4.0

Hi, I've currently my website and two forum which runs with MySQL 4.0.2 flawlessly (and which a huge number of visitors for one of my forum). mysql> \s -- mysql Ver 12.10 Distrib 4.0.2-alpha, for pc-linux-gnu (i686) Connection id: 125151 Current database: Current user:

Re: MYSQL 4.0

On Thu, 27 Jun 2002, Benjamin Pflugmann wrote: > On Thu 2002-06-27 at 16:33:43 +0530, [EMAIL PROTECTED] wrote: > >> But Still Noone have throwed some light on the Date when MySql 4.0 >> Release will be made formally which could enable me to use the Unions >> Can anyone in this group please let m

RE: MYSQL 4.0

> -Original Message- > From: Daniel Koch [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 13:11 > To: Arul > Cc: MySQL > Subject: Re: MYSQL 4.0 > > > Arul wrote: > > >Hi > > > >Any idea when MySQL 4.0 stable release wi

Re: MYSQL 4.0

Hi. On Thu 2002-06-27 at 16:33:43 +0530, [EMAIL PROTECTED] wrote: > > But Still Noone have throwed some light on the Date when MySql 4.0 Release > will be made formally which could enable me to use the Unions > > Can anyone in this group please let me know... Nobody throws in a date, because

RE: MYSQL 4.0

Hi I'm running MySQL 4.0.2 compiled from the source tree on this site: www.gnist.no (The largest online bookstore in Norway) Used 4.0.1 earlier but that version had some small problems with fulltext search. Server version: 4.0.2-alpha-log Uptime: 2 days 12 hours 40 min 2

Re: MYSQL 4.0

uot;Thomas Spahni" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 3:42 AM Subject: Re: MYSQL 4.0 > Hi Thomas > > I am always ready to give a try .. > But u see Managers will not be ready to take such a risk...and Morever our

Re: MYSQL 4.0

Arul wrote: >Hi > >Any idea when MySQL 4.0 stable release will be made.. >As of now only Alpha is released.. > >Also any sites which run on 4.0 Alpha > > > 4.0.1 has been very stable for us: [root@db1 root]# mysqladmin version mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i6

Re: MYSQL 4.0

ni" <[EMAIL PROTECTED]> Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 2:12 PM Subject: Re: MYSQL 4.0 > Hi Thomas > > I am always ready to give a try .. > But u see Managers will not be ready to take such a risk...and Morever our > client w

Re: MYSQL 4.0

t; Cc: "MySQL" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 1:27 PM Subject: Re: MYSQL 4.0 > Arul, > > as you are intending to use open source software for free why not give it > a try and help with debugging? > > 4.0.1 is remarkably stable except for some g

Re: MYSQL 4.0

Arul, as you are intending to use open source software for free why not give it a try and help with debugging? 4.0.1 is remarkably stable except for some glitches in replication and boolean fulltext search. Alpha status applies mainly to the newly developed features. Go ahead and have fun! Thom

Re: MYSQL 4.0

On Thu, Jun 27, 2002 at 05:27:29PM +0930, G r e g L a w r i e wrote: > Jeremy, > > Would you mind sharing how many machines 'half your servers' might > be, what type of work are they doing and how long have they been up > for / how stable would you consider them to be? Half of "my" server is,

RE: MYSQL 4.0

TED]] Sent: Thursday, 27 June 2002 16:23 To: Arul Cc: MySQL Subject: Re: MYSQL 4.0 On Wed, Jun 26, 2002 at 08:15:11PM +0530, Arul wrote: > Hi > > Any idea when MySQL 4.0 stable release will be made.. > As of now only Alpha is released.. Rumor has it that 4.0.2 might be beta. > Also any sit

Re: MYSQL 4.0

On Wed, Jun 26, 2002 at 08:15:11PM +0530, Arul wrote: > Hi > > Any idea when MySQL 4.0 stable release will be made.. > As of now only Alpha is released.. Rumor has it that 4.0.2 might be beta. > Also any sites which run on 4.0 Alpha Yes. Half my servers have been moved to what will be 4.0.2.

Re: Mysql 4.0.x enough stable to be in production ?

What table types are you using? Anthony > I've been running 4.0.1-alpha on a development server for our new internet > bookstore. Holds around 1.3million books, 100k bookcovers and a lot of > other information. > > I haven't experienced any crash/problems except for one bug that brings > down My

Re: Mysql 4.0.x enough stable to be in production ?

I've been running 4.0.1-alpha on a development server for our new internet bookstore. Holds around 1.3million books, 100k bookcovers and a lot of other information. I haven't experienced any crash/problems except for one bug that brings down MySQL: using two 'match-against' in fulltext search wit

Re: MYSQL 4.0 Beta

On Thu, Apr 11, 2002 at 07:16:34AM -0700, va ku wrote: > Hi, > > We want to use only MYSQL4.0 for our production database. Please > let us know when the Beta release is scheduled. When it's ready. :-) Seriously, check the archives. This comes up a lot and the answer is nearly always the same.

Re: MySQL 4.0.x Replication Just Dumped Core...

On Sat, Mar 09, 2002 at 01:21:44PM -0700, Sasha Pachev wrote: > On Saturday 09 March 2002 12:46 pm, Jeremy Zawodny wrote: > > That reminds me of an easy feature request. ?Would it be possible to > > have a slave-auto-start=no option (or something like that) in my.cnf? > > There have been cases whe

Re: MySQL 4.0.x Replication Just Dumped Core...

On Saturday 09 March 2002 12:46 pm, Jeremy Zawodny wrote: > That reminds me of an easy feature request. ?Would it be possible to > have a slave-auto-start=no option (or something like that) in my.cnf? > There have been cases when I want to start a server but do not want > replication to start on i

Re: MySQL 4.0.x Replication Just Dumped Core...

On Sat, Mar 09, 2002 at 12:31:20PM -0700, Sasha Pachev wrote: > > Jeremy: > > I think I now understand what happened, or at least I have a > pausilble theory that explains what I see in the logs. > > When I had you kill the broken mysqld last time it went down in the > middle of updating db3-re

Re: MySQL 4.0.x Replication Just Dumped Core...

On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote: > The 4.0.x slave I had just rebuilt the other day died about 40 minutes > ago and produced a core file each time. ?It got caught in the cycle of > "core dump, restart, core dump, restart..." Jeremy: I think I now understand what happened

Re: MySQL 4.0.x Replication Just Dumped Core...

On Fri, Mar 08, 2002 at 05:10:02PM -0800, Jeremy Zawodny wrote: > > > > I have tracked down and fixed the assertion failure issue. However, > > I am still not certail why the sql thread does partial reads. I have > > pushed my fix into the public tree, so let's have you pull it and > > try again.

Re: MySQL 4.0.x Replication Just Dumped Core...

On Fri, Mar 08, 2002 at 03:14:31PM -0700, Sasha Pachev wrote: > On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote: > > The 4.0.x slave I had just rebuilt the other day died about 40 minutes > > ago and produced a core file each time. ?It got caught in the cycle of > > "core dump, restart, c

Re: MySQL 4.0.x Replication Just Dumped Core...

On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote: > The 4.0.x slave I had just rebuilt the other day died about 40 minutes > ago and produced a core file each time. ?It got caught in the cycle of > "core dump, restart, core dump, restart..." Jeremy: I have tracked down and fixed the asse

Re: MySQL 4.0.x Replication Just Dumped Core...

On Fri, Mar 08, 2002 at 10:41:32AM -0700, Sasha Pachev wrote: > On Thursday 07 March 2002 11:39 pm, Jeremy Zawodny wrote: > > 020307 21:39:03 ?Error in Log_event::read_log_event(): 'read error', > data_len=193,event_type=2 > > 020307 21:39:03 ?Slave SQL thread: I/O error reading > event(errno=-1

Re: MySQL 4.0.x Replication Just Dumped Core...

On Thursday 07 March 2002 11:39 pm, Jeremy Zawodny wrote: > 020307 21:39:03 ?Error in Log_event::read_log_event(): 'read error', data_len=193,event_type=2 > 020307 21:39:03 ?Slave SQL thread: I/O error reading event(errno=-1,cur_log->error=57) > assertion "mi->io_thd == thd" failed: file "slave.

Re: MySQL 4.0.x Replication Just Dumped Core...

On Thu, Mar 07, 2002 at 09:48:41PM -0800, Jeremy Zawodny wrote: > Hey Sasha, [snip] > I'll keep it off-line until I hear from you on what data you need. Oops. Here's the info form the error log: ---snip--- 020307 21:39:03 Slave I/O thread initialized 020307 21:39:03 Slave SQL thread initia

Re: Mysql 4.0 or 3.23 with innodb?

Varshavchick Alexander <[EMAIL PROTECTED]> writes: > Gentlemen, > > Can you advice please if I'd wish to change the database format from > myisam to innodb should I upgrade to mysql 4.0 to get better performance > and stability, or switching to innodb alone under 3.23 will do the > trick? Switc

Re: MySQL 4.0 released

Hi! First, please don't email things directly to me or to the announce list. The best way to get help for a problem, is to write an email only to [EMAIL PROTECTED]; In the future, please also change the subject line to something that is appropriate and don't respond to an email that has nothin

Re: MySQL 4.0 released

Hello, I'm encountering a serious program fault at using MySQL Win32 client library LIBMYSQL.DLL. I found LIBMYSQL.DLL not thread-safe. When 10 threads are launched to run the following two blocks of C statements, very quickly a program fault window pops up to LIBMYSQL.DLL. block #1 --

Re: Mysql 4.0

Hi, glad to hear that it is not only me... I got the same error on Pentium 200MMX, even when compiling the source. I found that configure prepared gcc for Pentium Pro, so the quick and dirty fix was to hardcode Pentium into the configure script. This must be a bug... Tor Rune Skoglund, Gyldenlø

Re: Mysql 4.0

Harald Fuchs writes: > In article , > Robert Alexander <[EMAIL PROTECTED]> writes: > > > I'm getting the exact same error when trying to install MySQL 4.0 on RedHat 7.0 -- >both the binary distribution and the RPM. > > Previous binary versions of MySQL have

Re: Mysql 4.0

I'm getting the exact same error when trying to install MySQL 4.0 on RedHat 7.0 -- both the binary distribution and the RPM. Previous binary versions of MySQL have worked just fine on the same machine. /Rob At 10:07 -0800 2001/12/06, em huynh wrote: >I also tried using the binary distribution

Re: MySQL 4.0 fulltext search truncation bug?

Hi! On Nov 26, sherzodR wrote: > > > Use "%" instead of "*" > > cheers > -- > sherzodR > > > On 26 Nov 2001, Harald Fuchs wrote: > > >According to the manual, section "New Features of Full-text Search to > >Appear in MySQL 4.0": > > > >* `*' is a truncation operator. > > > >The query > > S

Re: MySQL 4.0 fulltext search truncation bug?

Use "%" instead of "*" cheers -- sherzodR On 26 Nov 2001, Harald Fuchs wrote: >According to the manual, section "New Features of Full-text Search to >Appear in MySQL 4.0": > >* `*' is a truncation operator. > >The query > SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versailles'

Re: MYSQL 4.0 in production?

johnlucas-Arluna writes: > Hi folks > > I really need to use some of the new features of version 4, particularly the > UNION joins. > > Has anyone had any experience with using the UNION, does it work ok and > fast? > > Also, could you indicate your confidence level with regard to running ver >

Re: MySQL 4.0 updated?

> I think MySQL 4.0.0 is in it's alpha state. > Wouldn't it be more right to get a 4.0.0 beta and several release candidates than a 4.0.1 version? 4.0 is in its alpha state. 4.0.0 is the first alpha release, and 4.0.1 the second and so on. It is, IMO, essential to give every release its own id

Re: MySQL 4.0 updated?

uot; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, November 09, 2001 1:13 AM Subject: Re: MySQL 4.0 updated? > When a new version is available it will have a new version number. The > current version is 4.0.0 but there will almost certainly be a 4.0.1 > soon. If y

Re: MySQL 4.0 updated?

When a new version is available it will have a new version number. The current version is 4.0.0 but there will almost certainly be a 4.0.1 soon. If you look at the change history in the documentation, there have already been changes put into 4.0.0. If you need quicker access to changes, you ca

Re: [MySQL 4.0 compile fails on Linux]

Ed Carp writes: > >Description: > > make[3]: Entering directory `/usr/local/src/mysql-4.0.0-alpha/sql' > gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\"" - > DDATADIR="\"/usr/local/var\"" -DSHAREDIR="\"/usr/local/share/mysql > \""

Re: mysql 4.0

Sommai Fongnamthip wrote: > Hi, > If I install mysql-4.0 to upgrade in mysql-3.23.xx with old setting value > (use myisam type), Could I need to change or re-load my old db? AFAIK, If you are keeping the table type, you can just copy the .MYI, .MYD, and .frm files to the new location. O

Re: MYSQL 4.0 bug with fulltext (case change) updates

Hi! On Oct 19, Mark Maunder wrote: > Hi, > > I think this is a bug. The script to recreate the problem is included > below. This problem appears consistently as long as there's a fulltext > index and a regular index on the same field and you do an update to > change the case of a single char. I

Re: MYSQL 4.0 bug with fulltext (case change) updates

Mark Maunder wrote: > Hi, > > I think this is a bug. The script to recreate the problem is included > below. This problem appears consistently as long as there's a fulltext > index and a regular index on the same field and you do an update to > change the case of a single char. It doesn't matter

RE: MySQL 4.0 released

> Britt> o Lock optimization - MySQL executor acquired > Britt> more locks than required for common queries. > > Just a note: The extra locks are only relevant for Gemini and BDB tables, > not for MyISAM or InnoDB tables. The extra locks issue does apply to InnoDB for update statements

RE: MySQL 4.0 released

Hi! First I have to apologize to the email list for this discussion: It certainly doesn't belong here. On the other hand, as the creator of MySQL and one who has personally sued by NuSphere corporation I can't let things like this go unanswered. > "Britt" == Britt Johnston <[EMAIL PROTECTE

RE: MySQL 4.0 released

Hi! > "Britt" == Britt Johnston <[EMAIL PROTECTED]> writes: Britt> Now that the patch for Gemini has been created and made Britt> available for the new MySQL 4.0 alpha release we are Britt> back whole again. I wouldn't really agree with this. Britt> I am told that binaries for the compl

Re: MySQL 4.0 released

Hi! > "Michael" == Michael Furgal <[EMAIL PROTECTED]> writes: Michael> Monty and all: Michael> I have re-applied all the Gemini table handler support and Michael> ported it to MySQL 4.0. It is too large to send as an email Michael> so the patch can be found at: Michael> ftp://ftp.nusphe

RE: MySQL 4.0 - Order By & Limit

:31 AM > Cc: [EMAIL PROTECTED] > Subject: RE: MySQL 4.0 - Order By & Limit > > > > Point well taken.. The query is as follows:- > > SELECT * FROM dddeli WHERE title LIKE "%$keyword%" ORDER BY title > desc LIMIT $start,$end; > > Where $keyword is the k

RE: MySQL 4.0 released

Now that the patch for Gemini has been created and made available for the new MySQL 4.0 alpha release we are back whole again. I am told that binaries for the complete MySQL 4.0 with support for Gemini tables are now available via mysql.org for everyone to use (MyISAM and InnoDB also). These

Re: MySQL 4.0 released

> Hi! > > > "Michael" == Michael T Babcock <[EMAIL PROTECTED]> writes: > > Michael> On Wed, Oct 17, 2001 at 12:49:26AM +0300, Michael Widenius wrote: > >> We agreed a long time ago with NuSphere that the small hooks would be > >> copyrighted by MySQL AB, but as the concrete paperwork has not

  1   2   >