Re: Urgent problem

2006-05-24 Thread Michael Widenius
Hi! > "Peter" == Peter Lauri <[EMAIL PROTECTED]> writes: Peter> Best group member, Peter> My computer stopped working. And I was able to install Windows on another Peter> partition and now I face one problem. I was running Windows with MySQL 4.1. Peter> I have all C: working, and can acces

MySQL 5.1 declared "GA"

2008-11-29 Thread Michael Widenius
Hi! If you want to know what to expect from MySQL 5.1 GA and when to start using it, please check my blog at: http://monty-says.blogspot.com/ Regards, Monty Creator of MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: MySQL Server 5.1.30 has been released

2008-12-07 Thread Michael Widenius
Hi! > "Daevid" == Daevid Vincent <[EMAIL PROTECTED]> writes: Daevid> Monty Widenius (MySQL co-founder who recently left Sun), on the other Daevid> hand, doesn't cast a very favorable light on 5.1 for production use. Daevid> Good read: Daevid> "If you plan to use any of the new feat

Re: MySQL Server 5.1.30 has been released

2008-12-07 Thread Michael Widenius
Hi! > "David" == David Giragosian <[EMAIL PROTECTED]> writes: David> On 12/1/08, Daevid Vincent <[EMAIL PROTECTED]> wrote: >> >> Monty Widenius (MySQL co-founder who recently left Sun)... David> What's the news on this? I haven't left Sun. When MySQL was acquired by Sun, I did move out f

Re: Monty left sun...

2008-12-07 Thread Michael Widenius
Hi! > "David" == David Giragosian <[EMAIL PROTECTED]> writes: David> Thanks. Just finished the blog, and I think I'm getting the drift. Don't belive everything you read :) I am still fully committed to work on MySQL AND the Maria engine. It's true that I haven't been as happy at Sun as I

Re: WL#946 and Changing time literal format

2009-01-30 Thread Michael Widenius
Hi! > "Roy" == Roy Lyseng writes: >> The question here is how PostgreSQL and ANSI does this and also what >> is the logical interpretation of the number. Roy> ISO 9075 (ANSI SQL) is very strict about this. It only allows TIME Roy> literals with 3 or 4 digit groups, and it only allows th

Re: WL#946 and Changing time literal format

2009-01-30 Thread Michael Widenius
Hi! >>>>> "Bernt" == Bernt M Johnsen writes: >>>>>>>>>>>>> Michael Widenius wrote (2009-01-24 02:07:54): >> As Dmitri pointed out, we shouldn't deprecate '.' as substitute for >> dates. >>

Re: WL#946 and Changing time literal format

2009-02-03 Thread Michael Widenius
Hi! >>>>> "Konstantin" == Konstantin Osipov writes: Konstantin> * Michael Widenius [09/01/30 14:53]: >> Its more important that we don't break things for current users than >> try to be concerned about possible wrong usage that no one seams to do

re: Question!

2009-04-02 Thread Michael Widenius
Hi! > "Jarikre" == Jarikre Efemena writes: Jarikre> Dear sir, Jarikre>   Jarikre> I am young web developer using PHP Script in designing interactive website. I desire to include Mysql database on my websites. Jarikre>   Jarikre> Please, how do I import, upload/export Mysql database to a w

Help saving MySQL

2009-12-12 Thread Michael Widenius
uld be able to compete with Oracle c) I trust Oracle and I suggest that EC will approve the deal unconditionally. Let us prove to Oracle and EC that the Open Source community is a true force and we take good care of our citizens and we prefer to work with companies th

Re: Help saving MySQL

2009-12-15 Thread Michael Widenius
Hi! > "Facundo" == Facundo Garat writes: Facundo> i don't really thinks this is about open source or not. Agree, this has to do about competition and that Oracle, the leader in revenue for databases are trying to buy MySQL, the leader in users just to kill it off. Facundo> MySQL became mo

Help keep the Internet free

2009-12-29 Thread Michael Widenius
Hi! We have just launched a worldwide, multilingual petition at http://helpmysql.org to get signatures to show the regulators in the EU and other places that it's important that MySQL continues to be available and developed as a strong Open Source product for all database needs. If you care abou

re: 5.1.x review

2010-08-20 Thread Michael Widenius
Hi! > "Elim" == Elim PDT writes: Elim> There are so many versions of 5.1, Is there some review or Elim> recommendations for a stable one? thanks Just download the latest MySQL 5.1 or MariaDB 5.1 release for your platform. Both should be stable enough for your usage. Regards, Monty -- M

re: mysqlcheck 5.5 -a -o

2011-01-17 Thread Michael Widenius
Hi! > "Noel" == Noel Butler writes: Noel> In all previous versions we were able to run -Aao --auto-repair Noel> Anyone know WHY, in 5.5, -a and -o , must be run separately, this Noel> is kind of silly I think, requiring two passes now. I checked the 5.0 code and even there you coul

Re: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

2012-07-31 Thread Michael Widenius
Hi! > "Fred" == Fred G writes: Fred> Thanks Dhaval. Putting the join condition before INTO outfile doesn't seem Fred> to work, either. Fred> When I try to use the same outfile name 'test123.csv' I get Error Code: Fred> 1086 File 'test123.csv' already exists. But then when I try to find

re: ignore-db-dir

2012-09-10 Thread Michael Widenius
Hi! > "Noel" == Noel Butler writes: Noel> Shaun, Noel> Is this option planned for backport into 5.5.x ? Another option is to provide a patch and suggest to have it included in MariaDB 5.5. You can of course also consider to sponsor this so that we can do this for you... Regards, Monty Cr

Re: InnoDB vs. other storage engines

2012-09-22 Thread Michael Widenius
Hi! > "Manuel" == Manuel Arostegui writes: Manuel> 2012/9/19 Mark Haney >> I hope this doesn't end in some kind of flame war. I'm looking to >> optimize my tables (and performance in general) of the DB my web app is >> using. I'm tweaking things a little at a time, but I'm curious as to

re: replication newbie questions

2013-08-29 Thread Michael Widenius
Hi! > "Ed" == Ed L writes: Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave Ed> replication. Here's my scenario... Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via Ed> master-slave configuration to a new, beefier server running same mysql

Help requested to provide bug reports for 5.1

2008-07-16 Thread Michael Widenius
Hi! This is a request to all MySQL users to help mysql developers, by providing information, so that we can help you, by providing a more stable MySQL server for your needs. As you may know, MySQL 5.1 has been in state of release candidate (RC) for some time. The last RC was announced as the las

Re: Help requested to provide bug reports for 5.1

2008-07-18 Thread Michael Widenius
Hi! > "Mark" == Mark Callaghan <[EMAIL PROTECTED]> writes: Mark> Can MySQL share the results of performance testing that has been done to Mark> compare 5.1 with 5.0? I would really like to see them too :) I will ask around and see if I can find what was done and what the results where. Re

Re[4]: SELECT DISTINCT with ORDER BY implementation

2008-09-30 Thread Michael Widenius
Hi! > "Andrew" == Andrew Aksyonoff <[EMAIL PROTECTED]> writes: Andrew> Hello Sergey, Andrew> Monday, September 15, 2008, 10:41:31 PM, you wrote: >>> in MySQL but in general case it can't assume any order and will have >>> to re-sort the sub-select result by outer GROUP BY instead of inner >>

MySQL Testing Problems

2003-12-20 Thread Michael Widenius
_db Chris> Last_errno Last_error Skip_counter The above is a timing error that only influences the test suite. you can safely skip this. In MySQL 4.0, we have done some changes to the test suite to avoid the above problem. Regards, Monty -- Michael Widenius <[EMAIL PROTECTED

MySQL 5.0.0 has been released

2003-12-24 Thread Michael Widenius
ls to get out new stable features faster. THe MySQL 4.1 branch seams to be relatively stable and we will, if we don't find any new unexpected hard bugs that will require a new design decisions, make a beta release of 4.1 in January followed by a gamma release ASAP. Merry Christmas, Lenz G

Urgent: Prepared Statements C API hangup the Server - Help Urgent....

2004-02-21 Thread Michael Widenius
low the instructions in the MySQL manual of how to debug MySQL and give us a stack trace of where mysqld is hanging. Another option is to use the debug version of mysqld and start it with --debug. The trace file that is written (in C:\ or /tmp) should give us a good idea of where the bug could be. R

URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

2003-06-05 Thread Michael Widenius
ed in the Irix section of the MySQL online manual. Please check it for details how to solve it. -- Michael Widenius <[EMAIL PROTECTED]> MySQL AB, CTO Helsinki, Finland Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

do long delete/update and view progress?

2003-08-03 Thread Michael Widenius
ich could be used for progess bars etc, but this is still at least 3-5 months in the future. -- Michael Widenius <[EMAIL PROTECTED]> MySQL AB, CTO Helsinki, Finland Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql-standard-4.1.0-alpha-pc-linux-i686.tar.gz changed since April 12 2003?

2003-08-26 Thread Michael Widenius
we will start doing release testing of 4.1.1, which can take anywhere between 2-6 weeks. (Just now things looks good, but one never knows what is going to show up) -- Michael Widenius <[EMAIL PROTECTED]> MySQL AB, CTO Helsinki, Finland Are you MySQL certified? www.mysql.com/cer

add this to a wish list please.

2003-09-28 Thread Michael Widenius
Hi! > "Dathan" == Dathan Vance Pattishall <[EMAIL PROTECTED]> writes: Dathan> Sometimes I get this error on a slave... for unknown reasons Dathan> Error 'Incorrect key file for table: 'hasit'. Try to repair it' on query Dathan> 'REPLACE INTO hasit Dathan> If there is a wish list could

Re: printing reports

2003-10-15 Thread Michael Widenius
as he is in this list). I just want that everyone that is trying to be helpful on this list should get the treatment and respect that he/she deserves. Respectfully, Monty -- Michael Widenius <[EMAIL PROTECTED]> MySQL AB, CTO Helsinki, Finland Are you MySQL certified? www.mysql.com/certific

Help us at MySQL user conference

2004-03-25 Thread Michael Widenius
Hi! I assume most of you know that we will have our annual MySQL User conference at April 14-15 in Orlando. During the conference we will give a lot of information about new MYSQL features that are already implemented in MySQL 4.1 and 5.0 and also about the new features we plan to implement in f

MySQL Security Flaw - Dropped Databases

2002-12-19 Thread Michael Widenius
eporting this! Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finl

What does this mean? : Warning: thr_alarm queue is full

2002-12-31 Thread Michael Widenius
one line)> Release: Operating system: Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /

MySQL 4.0.8 is released

2003-01-07 Thread Michael Widenius
when a locking SELECT caused a deadlock or a lock wait timeout. Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__

High list latency?

2003-01-27 Thread Michael Widenius
onference -> http://www.mysql.com/events/uc2003/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com ---

comment with "foreign key" text causes innodb CREATE TABLE failure

2003-03-16 Thread Michael Widenius
oDB. In 4.1 MySQL will handle the parsing of the foreign key definition and will store the foreign key definitions in the normal table definition file. This will fix these kind of problems once and for all. Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2

building MySQL on Alpha-Dec-OSF4 with gcc

2003-03-27 Thread Michael Widenius
tead; MySQL 4.0 is know to compile without any problems on a lot of platforms and I am think that I have myself compiled MySQL 4.0 on DEC-OSF4 not that long ago. Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ __ ___ ___ __

MyISAM rebuilding questions

2003-03-27 Thread Michael Widenius
sistence, Wynne> Wynne Crisman Wynne> patternWare Systems, Inc. Regards, Monty -- MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MyS

All Tables MyISAM and still InnoDB Datafiles?

2003-03-28 Thread Michael Widenius
f you aren't using InnoDB tables. If you are only using MyISAM tables and don't wont to have the above files (and save a bit of memory), you can start mysqld with the --skip-innodb option or put this into your my.cnf file. Regards, Monty -- MySQL 2003 Users Conference -> http://w

Re: Fulltext problems 4.0.1 part two (fwd)

2002-02-06 Thread Michael Widenius
Hi! > "Alex" == Alex Aulbach <[EMAIL PROTECTED]> writes: Alex> I found out, that the fulltext engine is misbehaving with less than 5 Alex> entries. Seems to me, that this is exactly the same case... Alex> Perhaps a flush inside the engine or so isn't made with such less entries? Alex> The

Re: BEGIN/COMMIT statements not written to the binary log : may it cause problems with replication ?

2002-02-06 Thread Michael Widenius
message to Sasha. Heikki> Best regards, We have this in our todo and it will be fixed in MySQL 4.0 or 4.1. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[E

Re: Erroneous results from a join after a delete

2002-02-10 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> John Heitmann writes: >> Thanks for the quick response. >> >> > > select t1.*, t2.name from t1, t2 where t2.id=t2_id; >> > >> > The above is actually expected behaviour, as you are not doing a join >> > at all, but a

MySQL 3.23.48 is released.

2002-02-10 Thread Michael Widenius
Hi! MySQL 3.23.48 is now released This version fixes some small bugs, and for most people there should not be any big reason to upgrade. Changes in release 3.23.48 -- * Changed to use `autoconf' 2.52 (from `autoconf' 2.13) * Fixed bug in complicated join with `c

Re: Bug in MySQL API ?!?

2002-02-10 Thread Michael Widenius
Hi! I have a couple of small comments to Sinisa answer. > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Skriniar Gregor writes: >> Dear all, >> >> I experienced some problems with using MySQL API: >> My problem is that if I don't use database a long time it is disconn

Re: Memory limit issue with 64 bit mysql.3.23.46

2002-02-10 Thread Michael Widenius
hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Albert Chin writes: >> >> $ grep SIZEOF_LONG config.h >> #define SIZEOF_LONG 8 >> #define SIZEOF_LONG_LONG 8 >> >> $ grep SIZEOF_LONG incldue/my_config.h >> #define SIZEOF_LONG 8 >> #define SIZEOF_LONG_LONG 8 >> >>

Re: PostgreSQL

2002-02-10 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsrød writes: >> "Vernon A Webb" <[EMAIL PROTECTED]> writes: >> >> > Anyone know the difference between MySQL and PostgreSQL? >> >> PostgreSQL has a lot of features MySQL don't have yet (transactions

Re: PostgreSQL

2002-02-10 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsrød writes: >> Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >> >> There is a slight difference between advanced, non-standardized >> tuning/backup/load-balancing like that and core SQL functionalit

Re: Manual references to safe_mysqld

2002-02-12 Thread Michael Widenius
. These files are automaticly generated from the manual. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\

MyODBC 3.51 released

2002-02-12 Thread Michael Widenius
t MyODBC, visit http://www.mysql.com/products/myodbc/index.html Regards Venu & Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|

Re: Manual references to safe_mysqld

2002-02-12 Thread Michael Widenius
Hi! > "Ken" == Ken Menzel <[EMAIL PROTECTED]> writes: Ken> Hi Jeremey! >> >> I think so. I just did that recently in my book. Imagine how many >> times I got it backwards and ended up second-guessing myself. :-( Ken> Yes I have that confusion all the time, but it is good to have all Ken

MyODBC 3.51 released

2002-02-12 Thread Michael Widenius
t MyODBC, visit http://www.mysql.com/products/myodbc/index.html Regards Venu & Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|

Re: BEGIN/COMMIT statements not written to the binary log : may it cause problems with replication ?

2002-02-12 Thread Michael Widenius
message to Sasha. Heikki> Best regards, We have this in our todo and it will be fixed in MySQL 4.0 or 4.1. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[E

Re: Erroneous results from a join after a delete

2002-02-12 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> John Heitmann writes: >> Thanks for the quick response. >> >> > > select t1.*, t2.name from t1, t2 where t2.id=t2_id; >> > >> > The above is actually expected behaviour, as you are not doing a join >> > at all, but a

MySQL 3.23.48 is released.

2002-02-12 Thread Michael Widenius
Hi! MySQL 3.23.48 is now released This version fixes some small bugs, and for most people there should not be any big reason to upgrade. Changes in release 3.23.48 -- * Changed to use `autoconf' 2.52 (from `autoconf' 2.13) * Fixed bug in complicated join with `c

MySQL 3.23.48 is released.

2002-02-12 Thread Michael Widenius
Hi! MySQL 3.23.48 is now released This version fixes some small bugs, and for most people there should not be any big reason to upgrade. Changes in release 3.23.48 -- * Changed to use `autoconf' 2.52 (from `autoconf' 2.13) * Fixed bug in complicated join with `c

Re: Bug in MySQL API ?!?

2002-02-12 Thread Michael Widenius
Hi! I have a couple of small comments to Sinisa answer. > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Skriniar Gregor writes: >> Dear all, >> >> I experienced some problems with using MySQL API: >> My problem is that if I don't use database a long time it is disconn

Re: Memory limit issue with 64 bit mysql.3.23.46

2002-02-12 Thread Michael Widenius
hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Albert Chin writes: >> >> $ grep SIZEOF_LONG config.h >> #define SIZEOF_LONG 8 >> #define SIZEOF_LONG_LONG 8 >> >> $ grep SIZEOF_LONG incldue/my_config.h >> #define SIZEOF_LONG 8 >> #define SIZEOF_LONG_LONG 8 >> >>

Re: PostgreSQL

2002-02-12 Thread Michael Widenius
Hi! > "Sinisa" =3D=3D Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsr=F8d writes: >> "Vernon A Webb" <[EMAIL PROTECTED]> writes: >>=20 >> > Anyone know the difference between MySQL and PostgreSQL?=20 >>=20 >> PostgreSQL has a lot of features MySQL don't have yet (

Re: PostgreSQL

2002-02-12 Thread Michael Widenius
Hi! > "Sinisa" =3D=3D Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Trond Eivind Glomsr=F8d writes: >> Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >>=20 >> There is a slight difference between advanced, non-standardized >> tuning/backup/load-balancing like that and core SQL func

Re: Suggestion re: floating point comparison (was Re: Problem with

2002-02-13 Thread Michael Widenius
the long run cause even more confusion than the current scenario. But a near function/operator would probably be a good idea; We will put this on our todo. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ /

Re: AW: Bug in MySQL API ?!?

2002-02-13 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >> mysql_fix_pointers(mysql, &tmp_mysql); /* adjust connection pointers */ >> ... >> this method contains (unlike version known to me) function call >mysql_fix_pointers(), which probably handles pointers of MYSQL struct.

Re: Manual references to safe_mysqld

2002-02-14 Thread Michael Widenius
ould be good to have it online ASAP! As the 4.0 manual includes a lot of new stuff, that is highly relevant also for 3.23, I don't think this is a good way to go either. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___

Re: MySQL 4.0 released

2002-02-18 Thread Michael Widenius
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: MAX Key Limit

2002-03-01 Thread Michael Widenius
ng key_map; and in sql/unireg.h #define MAX_KEY 32 to #define MAX_KEY 64 and in include/myisamdef.h #define MI_MAX_KEY 32 to #define MI_MAX_KEY 64 Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ /

Re: Re: 3.23.47 compile problems with sun's forte compiler

2002-03-01 Thread Michael Widenius
> "mysql" == mysql <[EMAIL PROTECTED]> writes: mysql> Your message cannot be posted because it appears to be either spam or mysql> simply off topic to our filter. To bypass the filter you must include mysql> one of the following words in your message: mysql> sql,query mysql> If you just re

[Fwd: mysql 3.23.49 porting problem on POSIX 1003.1-2001 hosts]

2002-03-01 Thread Michael Widenius
Build and run Mysql on a host that insists on POSIX 1003.1-2001 Paul> semantics. >> Fix: Thanks for the patch! I have now applied this for the uppcoming 3.23.50 version Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ __

Re: Can somebody help me with "round (columna,columnb) "?

2002-03-02 Thread Michael Widenius
Hi! > "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes: Benjamin> Hi. Benjamin> IMHO your query should work. This looks like a bug to me. I can Benjamin> confirm this on 3.23.46, but have no more current version available Benjamin> for testing. >> I'm having a simple but annoy

Re: NuSphere v. MySQL 4

2002-03-02 Thread Michael Widenius
as InnodB is already included in the standard MySQL 4.0.1 version, I would suggest that you use this instead... Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>

Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49

2002-03-04 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> [EMAIL PROTECTED] writes: >> >Description: >> LOAD DATA LOCAL INFILE ... >> >> leads to 'The used command is not allowed with this MySQL version' >> >> This happens regardless of whether I have a >> >> local-infile

Re: extra max() function possibly very useful?

2002-03-05 Thread Michael Widenius
to use something like the following (not tested) trick to do this: SET @b=0; SELECT *,(@a:= IF(@b=id,@a+1,1)) as cnt, @b:=id from mytable order by id having cnt<5; Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __

Re: InnoDB frightens me...

2002-03-05 Thread Michael Widenius
nty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\_

Feature idea inspired by bug report

2002-03-06 Thread Michael Widenius
Hi! > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Monday 04 March 2002 02:41 pm, Vladimir V. Kolpakov wrote: >> -- >> P.S. so far, it's helpful bug: I use it as catch >> for poor queries!:) Sasha> This actually gives me an idea for a feature. --disable-disk-temp-table

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-11 Thread Michael Widenius
problem so that we can help you with it? If you have already a ticket, please email me the ticket number so that we can check this up. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMA

Re: 4.0.2 Replication Bug...

2002-03-11 Thread Michael Widenius
Hi! > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Thursday 07 March 2002 12:42 am, Jeremy Zawodny wrote: >> My 4.0.2 slave has run through about 14 million queries and it's going >> well. Sasha> Good news >> >> Do you have any feel for how much slower a debugging versio

mysqldumpslow errors

2002-03-12 Thread Michael Widenius
even> s/^# Time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//; Steven> To: Steven> s/^# Query_time: (\d+) Lock_time: (\d+) Rows_sent: (\d+).*\n//; Applied to 4.0.2 source. Thanks! Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___

Re: [Re: LOAD DATA LOCAL INFILE in Alpha 3.23.49]]

2002-03-12 Thread Michael Widenius
Hi! > "Thomas" == Thomas Birchmire <[EMAIL PROTECTED]> writes: Thomas> I tried putting --local-infile in my server script and local-infile in the Thomas> /etc/my.cnf file. I also placed a number or logging cammands in the startup Thomas> script hoping to catch lower level messages. There

Re: Re: Feature idea inspired by bug report

2002-03-12 Thread Michael Widenius
get something like this in 4.1 Ken> Just a vote! I have added this to our worklog and this should be added to 4.1 Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMA

Losing connection during a REPAIR TABLE

2002-03-13 Thread Michael Widenius
same problem with MySQL 3.23.49, can you give us access to a copy of that table so that we can fix this problem ASAP ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROT

SELECT is using wrong key AND getting wrong results

2002-03-15 Thread Michael Widenius
Hi! > "Mike" == Mike Wexler <[EMAIL PROTECTED]> writes: >> Description: Mike> SELECT fullTextMatches.realname, fullTextMatches.address, Mike>fullTextMatches.address2, fullTextMatches.city, Mike> fullTextMatches.state, Mike>fullTextMatches.zip, fullTextMatches.country, Mike>

Re: bug: segfaults with mysql_read_default_group!

2002-03-18 Thread Michael Widenius
racts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --

Re: MySql "fatal error" in mysql-opt.exe

2002-03-19 Thread Michael Widenius
er. I can't get MySql to run. Fix: Change in your my.ini file: c:\serve to c:/serve or c:\\serve (The problem is that the MySQL configure files uses \ as a escape symbol) Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ___

What is "Com_change_db"

2002-03-21 Thread Michael Widenius
cutes. But hisol> what does change_db mean? This is number of times 'use database' is executed. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]&

Backtrace for (Re: 4.0.x memory bug on FreeBSD...?)

2002-03-21 Thread Michael Widenius
b/mysql/secret so that we can check if there is some code that is not freeing memory properly. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\_

mysqldump : help needed very urgent

2002-03-24 Thread Michael Widenius
Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com -

how to use checker to debug mysql applications

2002-03-25 Thread Michael Widenius
r technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com

grant tables failed

2002-03-26 Thread Michael Widenius
support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com --

mysqlmanager

2002-04-01 Thread Michael Widenius
Hi! > "Russell" == Russell E Glaue writes: Russell> in the '{MYSQLROOT}/bin' there are two executables in particular. Russell>mysqlmanager Russell>mysqlmanagerc Russell> I see these are version 1.0, and such are recently added. Russell> Can anyone tell me: Russell>W

Group by?

2002-04-05 Thread Michael Widenius
eature if you are not 100 % sure how it works) Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/

MySQL Power ?

2002-04-05 Thread Michael Widenius
e for you. As there is no licenses involved, I would recommend you to set up MySQL on your server and test it out! Richard> Rick Richard> -- Richard> Richard Spangenberg Regards, Monty -- For technical support contracts, goto https://order.mysql.com/

Re: How does DISTINCT really work ?

2002-04-15 Thread Michael Widenius
Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> From: "SDiZ (UHome)" <[EMAIL PROTECTED]> >> I think every thing are documented. >> >> http://www.mysql.com/doc/B/u/Bugs.html >> a.. The optimiser may handle DISTINCT differently if you are using >> 'hidden' columns in a jo

Re: MySQL 3.23.49 and HP-UX 10.20 Install

2002-04-19 Thread Michael Widenius
el> when largefiles is enabled. If I understood him correctly, Monty (Michael Michael> Widenius) acknowledged that his copy of HP-UX 10.20 has this flaw, but he Michael> says his copy of the official binary works there, though I honestly cannot Michael> see how. This problem should ha

Re: Syntax error with merge tables

2002-04-21 Thread Michael Widenius
ile now and has in practice proven to be be quite stable.. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTE

How to speed up mods to large table?

2002-04-22 Thread Michael Widenius
rds, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com -

Pre-release of MySQL 3.23.50

2002-04-23 Thread Michael Widenius
Hi! 3.23.50 is basicly just a bug fix release compare do 3.23.49a There is however two things one should be aware of regarding 3.23.50 (both only affecting our Linux x86 binaries (normal and RPM's): - We have switched to a new updated glib library, because we found a critical memory corrupti

table lock - which connection id own's it

2002-04-23 Thread Michael Widenius
will automaticly delete all temporary tables and all table locks. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/

RE: table lock - which connection id own's it

2002-04-24 Thread Michael Widenius
dd to SHOW OPEN TABLES a list of threads that has locks on the table (or maybe a SHOW LOCKS command) to better cover this case in the future. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Mic

Fw: user problem

2002-04-24 Thread Michael Widenius
ave to do a GRANT command to tell MySQL which other users you want to give access to the MySQL database. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EM

Re: problem with libmysqlclient_r.so

2002-04-25 Thread Michael Widenius
before calling mysql_real_connect() in all your threads ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki

RE: memory leaks in libmysqlclient.

2002-04-26 Thread Michael Widenius
Hi! > "domi" == domi <[EMAIL PROTECTED]> writes: domi> Hi ! domi> Thank You for the response ! domi> so I don't think it's solaris-problem. domi> Ofcource it can still be "my code" but I have not found domi> the problem... domi> So I took a chance and passed this question to list. domi

SQL Bugs/Missing INFO

2002-04-26 Thread Michael Widenius
support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com ---

column restrict:fraction < 10 ???

2002-04-26 Thread Michael Widenius
Hi! > "ydbxmhc" == ydbxmhc writes: ydbxmhc> Good day, everyone, and thank you for your time! ydbxmhc> I am not a member of the mailing list (I had to swear them off as ydbxmhc> addictive =o) but am posting this question in the hope that some ydbxmhc> generous soul will assist me anyway.

  1   2   3   4   5   >