OK I think I've found a bug with MySQL's compression support. :-/
I'm using two Java zlib implementations. One is jzlib 1.0.7 and the other
is java.io.DeflateOutputStream . Both of these are referenced by the zlib
implementation as being compatible.
I can compress/uncompress locally
This was New 4.1.2 Startup Trouble. The new title seemed more
appropriate given my testing.
Having installation problems with 4.1.2 on OS X 10.3.4.
From previous thread:
I've installed mysql 3 4 a dozen times or more, but I'm having
trouble with 4.1.2 on OS X Server (10.3.4).
Maybe it's not
On Jun 1, 2004, at 5:04 PM, Greg Willits wrote:
So,
- G4/OS X Server: 4.0.20 installs fine, but 4.2.1 does not on 10.3.4
- G3/OS X Standard: 4.2.1 installs fine on 10.3.2, but after 10.3.4
Standard was installed, 4.2.1 did not work, yet 4.0.20 continues to
install fine
The fact that 4.0.20 will
Peter Larsen [EMAIL PROTECTED] wrote:
Replication does not happend if inserts (update not tested) is made without
mysql_select_db(database, $connection); (yes, I use php..).
Working:
mysql_select_db(database, $connection);
mysql_query(INSERT INTO table (text1, text2) VALUES ('bah',
Hi..
Replication does not happend if inserts (update not tested) is made without
mysql_select_db(database, $connection); (yes, I use php..).
Working:
mysql_select_db(database, $connection);
mysql_query(INSERT INTO table (text1, text2) VALUES ('bah', 'bah'));
Not working (data only apreas in
Hi all,
My MySQL crashed during simultaneous execution of ALTER TABLE ... ENABLE
KEYS
and SHOW TABLE STATUS statements.
There were 2 threads: #3 and #4.
In thread #4 I executed:
4 Query DROP TABLE IF EXISTS History
4 Query CREATE TABLE History ...
4 Query
When using the client library with php:
Earler(earler mysql version) mysqllib:
SELECT userfield.*,user.* FROM .
[1] =123
[userid] = 123
Now with MySQL 3.23.54 mysqllib:
SELECT userfield.*,user.* FROM .
[1] =123
[userid] =
Here you can see that mysql doesn't give the
On Mon, Feb 24, 2003 at 10:19:01AM +0100, G. Hesen wrote:
When using the client library with php:
Have you also changed versions of PHP?
Earler(earler mysql version) mysqllib:
SELECT userfield.*,user.* FROM .
[1] =123
[userid] = 123
Now with MySQL 3.23.54 mysqllib:
Pada Tue, 12 Nov 2002 14:43:34 +0900
Chung Ha-nyung [EMAIL PROTECTED] menulis:
I compiled mysql 4.0.4 with option --prefix=/local/mysql --
datadir=/mnt/data but
it is likely that mysql still look for my.cnf file in $prefix/var
directory not in /mnt/data
Is it a bug?
add
I compiled mysql 4.0.4 with option --prefix=/local/mysql --
datadir=/mnt/data but
it is likely that mysql still look for my.cnf file in $prefix/var
directory not in /mnt/data
Is it a bug?
sql, query :(
--
Chung Ha-nyung alita@[neowiz.com|kldp.org]
Sayclub http://www.sayclub.com
NeoWiz
Glenn,
Friday, September 20, 2002, 5:27:01 AM, you wrote:
GW I was able to crash MySQL every time with the following -- it is
GW incorrectly formatted I know and I should be using GROUP BY in this
GW particular case
GW When I do the following query:
GW SELECT DISTINCT * FROM CUSTOMER INNER
Hi,
I was able to crash MySQL every time with the following -- it is
incorrectly formatted I know and I should be using GROUP BY in this
particular case
When I do the following query:
SELECT DISTINCT * FROM CUSTOMER INNER JOIN PRODUCT ON CUSTOMER.CUST_NO =
PRODUCT.CUST_NO
Without the
Hi!
If I don't put the tab before the the end of the line in the txt file that
contains the data, mySQL does not properly put the data into table using
LOAD DATA INFILE.
The courious thing is that this only happens with this one file. I was using
the same commands for all my other files and this
Hi,
first of all: I'm currently not reading this mailing list,
so if you answer I would be happy to receive a Cc:
I'm currently trying to switch a web site on a complete
new machine. The old machine was runnig MySQL 3.22.32,
the new machine runs on 3.23.49
The application used Phorum for
sql
Antoine Clanché
[EMAIL PROTECTED]
0663645239
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
Hi
I'm trying to extract data from 2 tables (A and B) with a subquery
A has the fields (ID_person, name)
B has the fields (ID_person,ID_country)
This is my query
select *
from A
where A.id_person IN (select B.id from B where B.ID_country =7)
But I receive a message error.
If I try to run each
Hi
I'm trying to extract data from 2 tables (A and B) with a subquery
A has the fields (ID_person, name)
B has the fields (ID_person,ID_country)
This is my query
select *
from A
where A.id_person IN (select B.id from B where B.ID_country =7)
Subqueries are not supported in mysql
Bonjour,
I have a problem with Mysql and access rights :
I have a user who has rights to access tables in the database
'membres' :
#/ mysqlaccess 192.168.0.1 myuser membres
Could not open outputfile
On Mon, Oct 01, 2001 at 04:41:58PM -0600, Spinlock wrote:
I was using gcc not g++
The guts of MySQL are written in C++, and hence the Gnu C++ compiler
will be used:
From the manpage gcc(1):
DESCRIPTION
The C and C++ compilers are integrated. Both process
input files
On Thu, Sep 27, 2001 at 07:19:02PM -0600, Spinlock wrote:
Hello. I am running mySQL 3.23.42 on FreeBSD 4.2.
I have compiled it with InnoDB and full debug to help figure out why it
keeps crashing. I've done a few core dumps and I'll paste 3 of them, it
keeps on crashing in the same function
I was using gcc not g++
---
Spinlock
Creator of EmpireQuest
http://www.empirequest.com
On Mon, 1 Oct 2001, Brian Reichert wrote:
On Thu, Sep 27, 2001 at 07:19:02PM -0600, Spinlock wrote:
Hello. I am running mySQL 3.23.42 on FreeBSD 4.2.
I have compiled it with InnoDB and full
Eric,
it was not immediately clear to me what your application
does. Does one connection update the table and
another connection do the SELECT? Then the problem
might be the consistent read. I have copied below a segment
from the InnoDB manual at www.innodb.com :
When you issue a consistent
On Fri, 17 Aug 2001, Heikki Tuuri wrote:
Problem resolved, thank you very much. It was indeed my missing a
concept, description below:
it was not immediately clear to me what your application
does. Does one connection update the table and
another connection do the SELECT?
Yes, as it's two
SM == Sinisa Milivojevic [EMAIL PROTECTED]
wrote the following on Mon, 4 Jun 2001 13:41:08 +0300 (EEST)
SM One more thing.
SM Can you try to run ANALYZE TABLE on sequence_data and see if
SM that changes anything ...
I got the
+--+-+--+--+
|
Ben Escoto writes:
message, but everything is the same as before (query still takes a
long time and explain says it is still using filesort).
--
Ben Escoto
-
Before posting, please check:
Hi, I think I found a bug in mysql. I tried the mysqlbug thing but it
didn't work right away. I hope this message will be detailed enough.
I am not subscribed to the mailing list.
In the following sections are the output of, respectively:
mysql -e SHOW VARIABLES
mysqldump sqmail
Ben Escoto writes:
Hi, I think I found a bug in mysql. I tried the mysqlbug thing but it
didn't work right away. I hope this message will be detailed enough.
I am not subscribed to the mailing list.
In the following sections are the output of, respectively:
mysql -e SHOW VARIABLES
Ben Escoto writes:
Thank you for the response. In which cases does DESC disable indexed
sorting? Perhaps there is a a way around this for the time being?
For instance, I noticed that although:
SELECT * FROM sqmail.sequence_data WHERE sid = 16 ORDER BY sid DESC,id
DESC LIMIT 10
uses
does not and is quite fast. Somehow the optimizer is getting confused
by the sid = 16. I was thinking that perhaps there is some magic
way of rephrasing the problem that MySQL would understand better.
Failing that, what is the recommended way of making this query
quicker? Should I insert
On Sun, Jun 03, 2001 at 11:01:50AM -0700, Ben Escoto wrote:
SM == Sinisa Milivojevic [EMAIL PROTECTED]
wrote the following on Sun, 3 Jun 2001 14:52:44 +0300 (EEST)
Hi, I think I found a bug in mysql. I tried the mysqlbug thing
but it didn't work right away. I hope this message
SM == Sinisa Milivojevic [EMAIL PROTECTED]
wrote the following on Sun, 3 Jun 2001 21:31:48 +0300 (EEST)
Thank you for the response. In which cases does DESC disable
indexed sorting? Perhaps there is a a way around this for the
time being? For instance, I noticed that although:
On Sun, Jun 03, 2001 at 12:37:50PM -0700, Ben Escoto wrote:
JDZ Did you try (sid 15 and sid 17), or something that means
JDZ the same thing as (sid = 16) if sid is an int?
JDZ Don't know if it'll help, but you never know...
Yep, I thought that was worth a try and attempted
32 matches
Mail list logo