re: replication newbie questions

Hi! Ed == Ed L mysql@bluepolka.net 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

Re: InnoDB vs. other storage engines

Hi! Manuel == Manuel Arostegui man...@tuenti.com writes: Manuel 2012/9/19 Mark Haney ma...@abemblem.com 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,

re: ignore-db-dir

Hi! Noel == Noel Butler noel.but...@ausics.net 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...

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

Hi! Fred == Fred G Fred 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 the

re: mysqlcheck 5.5 -a -o

Hi! Noel == Noel Butler noel.but...@ausics.net 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

re: 5.1.x review

Hi! Elim == Elim PDT e...@pdtnetworks.net 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,

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

Re: Help saving MySQL

Hi! Facundo == Facundo Garat fga...@strixsolutions.com 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.

Help saving MySQL

that the Open Source community is a true force and we take good care of our citizens and we prefer to work with companies that does the same! The future of MySQL is in your hands! Thanks for the help! Michael Widenius Creator of MySQL -- MySQL General Mailing List For list archives: http

re: Question!

Hi! Jarikre == Jarikre Efemena jefem...@yahoo.com 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

Re: WL#946 and Changing time literal format

Hi! Konstantin == Konstantin Osipov kos...@sun.com writes: Konstantin * Michael Widenius mo...@mysql.com [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 or find important enough

Re: WL#946 and Changing time literal format

Hi! Roy == Roy Lyseng roy.lys...@sun.com writes: cut 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

Re: WL#946 and Changing time literal format

Hi! Bernt == Bernt M Johnsen bernt.john...@sun.com writes: Michael Widenius wrote (2009-01-24 02:07:54): As Dmitri pointed out, we shouldn't deprecate '.' as substitute for dates. Another things is that we should stop making decisions about incompatible changes without listening

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 features of MySQL

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 from the MySQL

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 could be,

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:

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 ORDER BY. If that

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. Regards,

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

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 access all files.

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

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

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. Regards, Monty -- Michael Widenius [EMAIL PROTECTED] MySQL AB, CTO Helsinki, Finland Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives

MySQL 5.0.0 has been released

. 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 Grimmer Michael Widenius - -- Lenz Grimmer [EMAIL

MySQL Testing Problems

to avoid the above problem. Regards, Monty -- 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

Re: printing reports

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/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

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

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

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/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

do long delete/update and view progress?

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

, Jason from mysql.cc:54: Jason /usr/include/curses.h:112: syntax error before `,' Jason /usr/include/curses.h:143: syntax error before `;' cut This problem is covered in the Irix section of the MySQL online manual. Please check it for details how to solve it. -- Michael Widenius

All Tables MyISAM and still InnoDB Datafiles?

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://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL

building MySQL on Alpha-Dec-OSF4 with gcc

not that long ago. Regards, Monty -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland

MyISAM rebuilding questions

Users Conference - http://www.mysql.com/events/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com -- MySQL General Mailing

comment with foreign key text causes innodb CREATE TABLE failure

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/uc2003/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL

High list latency?

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

MySQL 4.0.8 is released

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

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

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

MySQL Security Flaw - Dropped Databases

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

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

What if binary log's suffix number exceeds 999?

? 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED

RE: What is relay-bin log?

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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED

RE: What is relay-bin log?

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

Where's safe_mysqld?

, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.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: Michaelfield name, field type as integer, field size, and other

Retrieving Table Schema

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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

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

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

Re: optimizer bug in selecting fields that dont 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 for the

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

); 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB

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

the function to _strend, recompiled/installed, and my Ben problems went away... Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

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: cut rafarifeI don´t understand why this

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

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

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 or know of a fix?

Re: LOAD DATA, \N, and auto_increment

Hi! Benjamin == Benjamin Pflugmann [EMAIL PROTECTED] writes: cut Benjamin How-to-repeat: shell cat /tmp/in EOF Benjamin 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

configure MySQL in this case ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland

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

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 PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

MySQL ERROR 1133 MEANING?

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

Problem in deleting multi table

:://support.mysql.com/pub/mysql/secret and we will try to fix this. cut Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

ERROR 1030: Got error 22 from table handler

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

compiling 4.0.2

y.tab.c sql_yacc.cc cd .. make all Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki

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

[sql_big_tables option changes results when set for some queries]

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 contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED

Argh! I am still getting the error...

; 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.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED

Re: MySQL dump/recovery probable bug

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

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 average go through

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 is a fulltext index and the

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

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

) hidden_null_count++; else null_count++; Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

Grant Tables Creation

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

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 affected the key cache yet. Sanja has been trying to do improvements to the key

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

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

, but a bit slower. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland

db name alias proxy

? 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED

Possible Bug in UPdATE in MySQL 4.0.1 alpha

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

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] cut Jeremy That reminds me. A while back (9 months, maybe), I seem to remember Jeremy you discussion a re-write of the key cache so that it would

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 work in all cases. CHECK TABLE told me Myk everything was fine, but dumping

Re: problem with libmysqlclient_r.so

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

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 used, and

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) Andrey Thank you. I have

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 ... rather than

Re: Slave crashes with SEGV on master shutdown

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://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED

Re: checksum errors

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

Re: MySQL 3.23.44 not using indexes

as expected in this case. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland

Re: Pre-release of MySQL 3.23.50

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

BDB wrapped transaction id's

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

RE: mysqlimpor and fixed length files.

creation until all data is loaded. To get more speed for index creation, you can set the myisam_sort_buffer_size variable to a high value. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael

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

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? I had been

Re: How does DISTINCT really work ?

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

Re: problem with libmysqlclient_r.so

: 'How to Make a Threaded Client' For example, have you called mysql_thread_init() before calling mysql_real_connect() in all your threads ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael

RE: memory leaks in libmysqlclient.

Hi! domi == domi [EMAIL PROTECTED] writes: domi Hi ! domi Thank You for the response ! cut 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 Maybe

SQL Bugs/Missing INFO

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

column restrict:fraction 10 ???

Hi! ydbxmhc == ydbxmhc Paul 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. cut

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

(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. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

Fw: user problem

to give access to the MySQL database. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

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

table lock - which connection id own's it

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

Re: Syntax error with merge tables

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

How to speed up mods to large table?

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

Re: MySQL 3.23.49 and HP-UX 10.20 Install

The conclusion is in Problem with setrlimit on HPUX 10.20 at Michael http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:94565 Michael In short, HP-UX 10.20 has a bug in dce/cma_ux.h which breaks setrlimit Michael when largefiles is enabled. If I understood him correctly, Monty (Michael Michael Widenius

Re: How does DISTINCT really work ?

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 join or not. Heikki Ok,

  1   2   3   4   >