re: replication newbie questions

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

Re: InnoDB vs. other storage engines

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: ignore-db-dir

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: Exporting to CSV. Error Code: 2013. Lost connection to MySQL server during query

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: mysqlcheck 5.5 -a -o

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: 5.1.x review

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

Help keep the Internet free

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: Help saving MySQL

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 saving MySQL

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: Question!

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

Re: WL#946 and Changing time literal format

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: WL#946 and Changing time literal format

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

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: Monty left sun...

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: MySQL Server 5.1.30 has been released

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: MySQL Server 5.1.30 has been released

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

MySQL 5.1 declared "GA"

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[4]: SELECT DISTINCT with ORDER BY implementation

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 >>

Re: Help requested to provide bug reports for 5.1

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

Help requested to provide bug reports for 5.1

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: Urgent problem

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

Help us at MySQL user conference

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

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

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

MySQL 5.0.0 has been released

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

MySQL Testing Problems

_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

Re: printing reports

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

add this to a wish list please.

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

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

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

do long delete/update and view progress?

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]

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

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]

All Tables MyISAM and still InnoDB Datafiles?

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

MyISAM rebuilding questions

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

building MySQL on Alpha-Dec-OSF4 with gcc

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/ __ ___ ___ __

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

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

High list latency?

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

MySQL 4.0.8 is released

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]> / /|_/ / // /\ \/ /_/ / /__

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

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

MySQL Security Flaw - Dropped Databases

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

MySQL AB has reached a settlement with NuSphere Corporation

-- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check

What if binary log's suffix number exceeds 999?

happens? Chung> next suffix number is 1000 or 001? Otherwise error occurres? Next used suffix is 1000 and there should not be any problems when going from .999 to .1000 Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ _

RE: What is relay-bin log?

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

RE: What is relay-bin log?

have a problem that old relay logs are not deleted, try to upgrade to MySQL 4.0.4 ; We recently fixed a bug in this code. If you want to delete all old binary log files, then the command is RESET MASTER. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___

Where's safe_mysqld?

sqld_safe in 4.0 The reason for this was that it's easier for the MySQL users if all MySQL commands starts with my... Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMA

Retrieving Table Schema

ble name, it prevents me from deleting the table. We just fixed a bug in MySQL when using mixed table names. This is fixed in the upcoming 3.23.53 and 4.0.4 MySQL versions. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___

Retrieving Table Schema

Hi! > "Michael" == Michael J Fuhrman <[EMAIL PROTECTED]> writes: Michael> Hello All, Michael> Suggestions Feedback Requested: Michael> I'm looking for a solution that will not lock a table, yet allow me to Michael> retrieve the: Michael>field name, field type as integer, field size

optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb

st case. If you can do the above, we will try to fix the problem for next MySQL release. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]>

optimizer bug in selecting fields that don´t belong to the index used by mysql

Hi! > "rafarife" == rafarife <[EMAIL PROTECTED]> writes: rafarife> Description: rafarife> Hello, rafarife> I am working with mysqld-max-nt under windows 2000 and unsing InnoDb rafarife> tables. rafarife> I have the following table: rafarife>I don´t understa

"BUG": 'strend' function in libmysql needs to be private

efore) What is it that core dumps; csh or your application ? Does your application work if you are running 'sh' ? Ben> FWIW I renamed the function to _strend, recompiled/installed, and my Ben> problems went away... Regards, Monty -- For technical support co

AES_DECRYPT(garabage, key) problem (4.0.4 bk snapshot)

ab79945bf'); Sergey> SELECT * FROM atest WHERE tmp=AES_DECRYPT(tmp,"password"); Thanks for the test case. This is now fixed in the upcoming 4.0.4 release. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __

Re: optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Rafa, Heikki> OR's are generally difficult to optimize. Heikki, this is true if you are using OR on different keys. MySQL can fully optimise the query when using OR on different key parts of the same key (which is the case

optimizer bug in selecting fields that don´t belong to the index used by mysql/innodb

. Can you please ftp them to ftp://support.mysql.com/pub/mysql/secret so that we can try to fix ASAP ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL P

Re: MySQL and Service Pack 3

Hi! > "Miguel" == Miguel Angel Solórzano <[EMAIL PROTECTED]> writes: >> Hello, >> >> I have a very strange problem with all of the Windows versions of MySQL. >> I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will >> not work period. Has anyone ran into this problem and

Re: LOAD DATA, \N, and auto_increment

Hi! > "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes: Benjamin> How-to-repeat: shell> cat >/tmp/in < 1 Benjamin> 2 Benjamin> \N Benjamin> \N Benjamin> 10 Benjamin> \N Benjamin> EOF shell> chmod a+r /tmp/in mysql> CREATE TABLE ntest2 ( a INT UNSIGNED NOT NULL AUTO_INCREMENT

Re: Lost connections on Freebsd

piled in, but it's needless to say not really the desired Chris> result. How did you configure MySQL in this case ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Mi

MySQL ERROR 1133 MEANING?

ws this problem) to: ftp://support.mysql.com/pub/mysql/secret and we will try to repeat this. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL P

Feature Request: --log-update to add 'drop table' after 'create temporarytable'

at actually happens? Thanks! The later MySQL 3.23 and 4.0.3 version already logs drop table into the MySQL binary log. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PRO

Problem in deleting multi table

not work. Can you produce a test case for this so that we can look into it? If yes, send it to ftp:://support.mysql.com/pub/mysql/secret and we will try to fix this. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___

compiling 4.0.2

nstead of 'bison'. Fix: Execute in the MySQL directory: cd sql bison -d sql_yacc.yy && mv y.tab.c sql_yacc.cc cd .. make all Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __

ERROR 1030: Got error 22 from table handler

ich case you probably have to do re-format your disk to get it to support larger files. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / //

RE: Load problems with 3.23.51

Hi! > "Steven" == Steven Roussey <[EMAIL PROTECTED]> writes: Steven> I tried the skip-name-resolve and it had no effect. So there goes my Steven> hypothesis. Steven> Here are the results from test: Steven> Benchmark DBD suite: 2.14 Steven> Date of test:2002-06-24 11:19:19 Steven>

[sql_big_tables option changes results when set for some queries]

eatable test case base on of our benchmark programs in the sql-bench directory ? (test-insert should be a good candidate for this). If you can do a test case, we will do our best to fix this in next MySQL release (if it's not already fixed). Regards, Monty -- For technical support co

Argh! I am still getting the error...

select worksets.* from worksets left join works on worksets.wrk_inst = works.wrk_inst where works.wrk_inst is null; Another option is to enlarge the value 'tmp_table_size' to be big enough to hold the temporary set. Regards, Monty -- For technical support contracts, goto https://order

Re: Load problems with 3.23.51

Hi! > "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: Jeremy> On Sat, Jun 22, 2002 at 05:25:59PM -0700, Steven Roussey wrote: >> Hi all, >> >> I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and >> tried 51. No dice. It does not handle load, CPU and the load avera

Re: MySQL dump/recovery probable bug

mes. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_

Re: Re[2]: counting rows ...

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Victoria Reznichenko writes: >> Hi! >> SM> Are you using our binaries ?? >> >> Yes. >> SM> If yes, send me a dump of the table and exact queries ... >> >> It's a strange... >> >> Seems, troubles occur when there i

Spams on MySQL mailing lists

Hi! I was going through some of the old emails on the MySQL mailing list and noticed the many threads that discussed spams. (There seemed to be more emails discussing spams than true spams, but this is a separate issue). We here at MySQL AB do a lot of work to avoid spam and we are working on n

Re: Fwd: A column of the SELECT-part of a query returns allways NULL in some cases.

; --- 3676,3682 if (blob_count == 0) { /* We need to ensure that first byte is not 0 for the delete link */ ! if (param->hidden_field_count) hidden_null_count++; else null_count++; Regards, Monty -- For technical support contracts, g

Re: Re: MySQL 3.23.44 not using indexes

Hi! >>>>> "Luciano" == Luciano Barcaro <[EMAIL PROTECTED]> writes: Luciano> Hi Monty, Luciano> Michael Widenius wrote: >>> Hi! Jeremy> Is that supposed to happen in 4.0.x? I don't recall having seen a Jeremy> commit that aff

Grant Tables Creation

rk. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\

Re: InnoDB, possible bug?

Hi! > "Heikki" == Heikki Tuuri <[EMAIL PROTECTED]> writes: Heikki> Andrei, Heikki> this is probably not a bug in InnoDB. In theory, 4000 random disk seeks Heikki> would use more time than scanning the whole table of 700 000 rows. Heikki> The optimizer was tuned .48 (not yet in 4.0.1) to fa

Re: MySQL 3.23.44 not using indexes

Hi! >>>>> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes: Jeremy> On Fri, May 17, 2002 at 11:41:49AM +0300, Michael Widenius wrote: Jeremy> [snip] Jeremy> That reminds me. A while back (9 months, maybe), I seem to remember Jeremy> you dis

Possible Bug in UPdATE in MySQL 4.0.1 alpha

Hi! > "Michael" == Michael B Venezia <[EMAIL PROTECTED]> writes: >> Description: Michael>Possible Bug in UPDATE in MySQL 4.0.1 Michael> Attempting backtrace. You can use the following information to find out Michael> where mysqld died. If you see no messages after this, something

db name alias proxy

Does anyone need such tool, should I post it on web somewhere? You could always add it to the MySQL portal section at: http://www.mysql.com/portal/software/html/index.html Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ _

Re: Re: Bug in fulltext search in latest mysql-4.0.2 source

TEXT... do the same trick? Yes, this would do the same thing as REPAIR, but a bit slower. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAI

RE: RE: ECS Error with 4.0.07 opening DB (still) again -EMEA2490

the old code should work as SQL_UINTEGER should be of type uint. If the old code crashes, it means that ValuePtr is not pointing at a valid uint address, in which case the bug is in the application or the driver manager. Regards, Monty -- For technical support contracts, goto https://orde

Re: MySQL 3.23.44 not using indexes

Hi! >>>>> "Myk" == Myk Melez <[EMAIL PROTECTED]> writes: Myk> Michael Widenius wrote: >> You can check if the index are ok with CHECK TABLE; If this says the >> index is ok, they are not corrupted. >> Myk> Apparently this doesn't wo

Re: [BUG] CONCAT_WS + GROUP BY display problem

Hi! > "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes: >> In order to get predictable result you need to use: >> >> select concat_ws('.',oct1,oct2,oct3,oct4) as IP, count(*) as c from >> ips group by IP [having c > 1]; Benjamin> I have tested this and it doesn't fix the prob

Re: Slave crashes with SEGV on master shutdown

> At this point, I have two theories: Sasha> a) There is something wrong with your gethostbyname_r function We have been able to verify that this is the case and we will have a workaround for this in 3.23.51 and MYSQL 4.0.2 Regards, Monty -- For technical support contracts, goto https:/

Re: Solved (Re: 4.0.2 Replication still buggy...)

Hi! > "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes: Sasha> On Wednesday 01 May 2002 11:34 pm, Jeremy Zawodny wrote: >> After even more tracking stuff down, I managed to isolate it to a >> change made in MySQL 4.0.1. ?The query in question was doing: >> >> ? INSERT INTO ... SELECT ...

Re: problem with libmysqlclient_r.so

Hi! > "Andrey" == Andrey Kotrekhov <[EMAIL PROTECTED]> writes: Andrey> -LДобрый день.-A Andrey> Are mysql know about this!!! >> >> Sorry but if your OS doesn't support gethostbyname_r(), then >> mysql_real_connect() is not thread safe (I have just updated our >> documentation about this)

Re: problem with libmysqlclient_r.so

Hi! > "Michael" == Michael Chang <[EMAIL PROTECTED]> writes: >> For example, have you called mysql_thread_init() before calling >> mysql_real_connect() in all your threads ? Michael> However, to my understanding, mysql_thread_init() is not needed if Michael> only one database connection is

Re: problem with libmysqlclient_r.so

stbyname_r >> (function exist but not thread-safe) >> >> Are mysql know about this!!! Just a note about this problem: We will add a wrapper for gethostbyname() in 3.23.51 and the 4.0.2 that will fix things for OS where gethostbyname is not threadsafe. Regards, Mon

Re: Pre-release of MySQL 3.23.50

build machine because we want to use a newer glibc library. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL

Re: MySQL 3.23.44 not using indexes

queries: SELECT count(*) FROM bugs WHERE bug_status IN ('NEW', 'ASSIGNED', 'REOPENED'); SELECT count(*) FROM bugs; If the first query returns more than 30 % of the second, then MySQL works as expected in this case. Regards, Monty -- For technical support

Re: checksum errors

ally interested in having a test case that shows how to crash MySQL. Without a test case, I can't really give you any good advises of what could be the problem. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ _

BDB wrapped transaction id's

e this happens on a clean database :( Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\_

RE: mysqlimpor and fixed length files.

.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com

Re: mysql_real_query and escaping a semicolon

Hi! > "Anna" == Anna Fowles-Winkler <[EMAIL PROTECTED]> writes: Anna> I removed the semicolon from the end of the query string, and I still get the Anna> same syntax error: Anna> You have an error in your SQL syntax near ''.1' at line 10 Anna> This is what the query looks like: Anna> INSE

How to make the Win target from source?

Hi! > "Dennis" == Dennis George <[EMAIL PROTECTED]> writes: Dennis> I downloaded mysql-3.23.49-win-src.zip. Dennis> There are various files missing (e.g. Makefile) that would enable compiling with gcc. Dennis> Has anyone out there made mysql from source on Win platform Dennis> with gcc?

Re: How does DISTINCT really work ?

WHERE searchmainpresencepc4.numreponse=searchjoinpresencepc4.numreponse AND (mot='les') group by topic ORDER BY d DESC LIMIT 0,40; And just ignore the d column from the result Regards, Monty -- For technical support contracts, goto https://order.mysql.com/

column restrict:fraction < 10 ???

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.

SQL Bugs/Missing INFO

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

RE: memory leaks in libmysqlclient.

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

Re: problem with libmysqlclient_r.so

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

Fw: user problem

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: table lock - which connection id own's it

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

table lock - which connection id own's it

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]> / /|_/ / // /\ \/ /_/

Pre-release of MySQL 3.23.50

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

How to speed up mods to large table?

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

Re: Syntax error with merge tables

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

  1   2   3   4   5   >