n the first place. It almost seems
to me that the server is getting into some strange
state while writing to temporary table. For some
reason, this fails and instead of erroring out, the
query stays in a perpetual running state.
On MySQL 4.0.16, a "key_buffer_size" of 134217728
translates
In my experience, inserting into a table with a unique key and more than
5 million records can be very slow because (AFAIK) it has to scan the
entire index to check if the new record is unique from the PRIMARY KEY's
point of view. (I think)
If you don't have much ram (your 128 meg key buffer sugge
Here's the whole the query, table structure, table
length and show variables output:
mysql> desc summary;
+-+--+--+-+-++
| Field | Type | Null |
Key | Default | Extra
Please include the full query you're running, the table structure, and
the number of rows in the table. A dump of 'show variables;' would be
helpful too.
On Wed, 2004-11-10 at 21:44, foo bar wrote:
> Hi Everyone,
>
> I've been Googling unsuccessfully for specific issues
> relating to queries run
Hi Everyone,
I've been Googling unsuccessfully for specific issues
relating to queries run on MySQL version 4.0.16
against "tmp" tables. I have witnessed several
occurrences where queries running on various platforms
hang in a "Copying to tmp table" state for hours or
days at a time. When the sa
tat output:
MYSQL 4.0.16
[EMAIL PROTECTED] sql-bench]# /usr/bin/perl ./test-create --server=mysql -cmp=mysql
--user=root --password='pa$$word' --log >
"output/create-mysql-Linux_2.4.21_9.ELsmp_i686-cmp-mysql" 2>&1
[EMAIL PROTECTED] sql-bench]# more
output/create-m
Ginger Cheng <[EMAIL PROTECTED]> wrote:
>I am just wondering if anyone has seen this before querying an innoDB table:
>
> select count(*) from Table where field1=3;
> returned 782 rows
>
> select count(*) from Table where field1=3 and field2 is not null;
> returned 666 rows
>
> Here come
Hello, MySQL Gurus,
I am just wondering if anyone has seen this before querying an innoDB table:
select count(*) from Table where field1=3;
returned 782 rows
select count(*) from Table where field1=3 and field2 is not null;
returned 666 rows
Here comes the shocking part:
select coun
jdavis <[EMAIL PROTECTED]> wrote:
> Hello,
> i have a sql file that i use to build a table. It works on my Debian
> testing box with mysql 4.0.16 but not on my woody box using mysql 3.23.
>
> The error when i try to use the source command with my sql file
> and
Hello,
i have a sql file that i use to build a table. It works on my Debian
testing box with mysql 4.0.16 but not on my woody box using mysql 3.23.
The error when i try to use the source command with my sql file
and version 3.23 of mysql is...
ERROR 1064: You have an error in your SQL syntax
"naveen" <[EMAIL PROTECTED]> wrote:
> Hi
> i am using mysql 4.0.16 for my applications and it has around 10
> records .if i move the data from mysql 4.0.16 to 4.0.17 will that create any
> inconsistancy .
> in my database.
> does mysql provide anytool t
Hi
i am using mysql 4.0.16 for my applications and it has around 10
records .if i move the data from mysql 4.0.16 to 4.0.17 will that create any
inconsistancy .
in my database.
does mysql provide anytool to migrate data from mysql4.0.16 to 4.0.17
- Original Message -
From
Hello,
I am using MySQL 4.0.16 on Debian GNU/Linux at the moment. In this database
there are over 4,5 Mio. entries!
The Database crashs with follow errors:
031217 19:21:06 mysqld started
/opt/lampp/sbin/mysqld: ready for connections.
Version: '4.0.16-log' socket: '/opt/
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Thursday, December 11, 2003 2:29 AM
Aihe: Re: MySQL 4.0.16 64bit crash report
Hi Heikki,
Heikki Tuuri wrote:
Don,
it is the assertion below which fails.
Do you use FOREIGN KEY ON UPDATE CASCADE?
Nope.
Do you have any idea which query causes
t; <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Thursday, December 11, 2003 2:29 AM
Aihe: Re: MySQL 4.0.16 64bit crash report
>
> Hi Heikki,
>
> Heikki Tuuri wrote:
>
> > Don,
> >
uot;Don MacAskill" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 10, 2003 7:49 PM
Subject: MySQL 4.0.16 64bit crash report
I'm running 4.0.16 on a dual-Opteron using the 64bit mysql-max binary
distribution (tar.gz, not rpm) from mysql.com. I
c, i, &len);
dfield = dtuple_get_nth_field(entry, i);
ut_a(len == dfield_get_len(dfield));
- Original Message -
From: "Don MacAskill" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 10, 2003 7:49 PM
Subject: M
I'm running 4.0.16 on a dual-Opteron using the 64bit mysql-max binary
distribution (tar.gz, not rpm) from mysql.com. I have 8GB of RAM, and
it was using about 4.5GB at the time of the crash.
031210 9:24:34 InnoDB: Assertion failure in thread 1171265904 in file
row0upd.c line 713
InnoDB: Fail
Hi ,
Is anyone else experiencing a degrade in performance after upgrading from
3.23.53 to mysql 4.0.16.
After the upgrade the system load is extremly high +/- 6 and up and the cpu
is about 98% busy with the mysql process.
Regards
Stanley
variables below.
SQL-querySQL-query (126 Records
>
> -Original Message-
> From: Stefaan Van Dooren [mailto:[EMAIL PROTECTED]
> Sent: vrijdag 21 november 2003 15:28
> To: [EMAIL PROTECTED]
> Subject: RE: MySQL 4.0.16 on SCO OpenServer 5.0.6
>
>
> I hate to respond to myself, but.
>
> I have it working now.
Hello Stefaan,
> Stefaan Van Dooren wrote:
> > Hi,
> >
> > I'm trying to install (compile, since there are no binaries for this
> > system) MySQL on an SCO OPenServer 5.0.6 system.
> >
> > Prior to compiling MySQL, I installed the following packages for SCO :
> >
> > FSU Pthreads (ver 3.9)
>
Hello Stefaan,
Stefaan Van Dooren" <[EMAIL PROTECTED]> wrote:
> I'm totally lost now..
>
> As you can (could) see in my previous post, I managed to get MySQL working
> on SCO with "--with-debug" as a configure option.
> Whenever I remove "--with-debug", I can compile and install it, but I
ease explain what this "--with-debug" adds that makes it run
on my system ?
Stefaan
-Original Message-
From: Stefaan Van Dooren [mailto:[EMAIL PROTECTED]
Sent: vrijdag 21 november 2003 15:28
To: [EMAIL PROTECTED]
Subject: RE: MySQL 4.0.16 on SCO OpenServer 5.0.6
I hate to respon
To: <[EMAIL PROTECTED]>
Sent: Friday, November 21, 2003 11:36 PM
Subject: RE: MySQL 4.0.16 on SCO OpenServer 5.0.6
> Since I got no answers, I will put another question
>
> Is anybody using MySQL 4.x on SCO OpenServer 5.x ?
>
> Stefaan
>
> Stefaan Van Dooren wrote:
>
I hate to respond to myself, but.
I have it working now... MySQL 4.0.16-debug on SCO OPenServer 5.0.6a
Stefaan
Stefaan Van Dooren wrote:
> Since I got no answers, I will put another question
>
> Is anybody using MySQL 4.x on SCO OpenServer 5.x ?
>
> Stefaan
>
&g
Since I got no answers, I will put another question
Is anybody using MySQL 4.x on SCO OpenServer 5.x ?
Stefaan
Stefaan Van Dooren wrote:
> Hi,
>
> I'm trying to install (compile, since there are no binaries for this
> system) MySQL on an SCO OPenServer 5.0.6 system.
>
> Prior to compiling
Hi,
I'm trying to install (compile, since there are no binaries for this system)
MySQL on an SCO OPenServer 5.0.6 system.
Prior to compiling MySQL, I installed the following packages for SCO :
FSU Pthreads (ver 3.9)
GNU Development Tools (ver 5.0.7Kj)
Netscape Communicator (ver 4.7.0e)
OSS63
We were unsuccessful getting the MySQL AMD64 rpms to work on RHEL3 AS.
I downloaded the source rpm and rebuilt the rpms on our Opteron server
and they have mostly worked, only one crash so far which we are in the
process of reporting to the MySQL support group.
Of course, we are experiencing s
Hi,
Did anyone get the 4.0.16 binary to work on RedHat 3 Enterprise for IA64?
I read that the same happens on RH3AS for AMD64.
"This was thoroughly tested with our production team and it works truly
just fine. " according to MySQL support :-\
031102 22:07:17 mysqld started
mysqld got signal 11;
Hello, I tried to compile the latest mysql rpm on fedora.
The compilation is ok , but when I try to install the compiled
MySQL-client rpm the system exits with:
perl(the) is needed by MySQL-client-4.0.16-0
Does someone have an idea?
Thanks
Daniele
--
MySQL
4.0.16 stop working
Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run
mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen.
I download Mysql for Windows but not purchase the Commercial Licence yet. Is
there a time based restriction here?
--
MySQL
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) V
William IT wrote:
Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run
mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen.
I download Mysql for Windows but not purchase the Commercial Licence yet. Is
there a time based restriction here?
No, there is
Today, Mysql 4.0.16 for WinXP stop working. I try to restart my PC and run
mysqld-nt, also try Start Service from WinMysqlAdmin, but nothing happen.
I download Mysql for Windows but not purchase the Commercial Licence yet. Is
there a time based restriction here?
--
MySQL General Mailing List
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 ap
c.
> - http://friendfinder.com/go/p40688
>
>
> -->-Original Message-
> -->From: Admin-Stress [mailto:[EMAIL PROTECTED]
> -->Sent: Tuesday, November 11, 2003 11:44 AM
> -->To: [EMAIL PROTECTED]
> -->Subject: After installing MySQL 4.0.16 (rpm), i
->Sent: Tuesday, November 11, 2003 11:44 AM
-->To: [EMAIL PROTECTED]
-->Subject: After installing MySQL 4.0.16 (rpm), it did not create
-->/etc/my.cnf ?
-->
-->Hi,
-->
-->My server is using RedHat 9.0.
-->
-->I just CHANGED the mysql from 3.23.58 (rpm) to 4.0.16 (rpm).
-
server.
I can change the root password using mysqladmin.
I can create database.
But I cant find /etc/my.cnf
is this normal ?
I verified by issuing: rpm -ql MySQL-server ...
But again, I did not see /etc/my.cnf
Anyone know what is the 'standard' my.cnf for MySQL 4.0.16
, g4 wrote:
Hi list,
I'm still trying to ascertain if this is in fact an MySql problem,
here goes.
I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I
have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The
site is an e-commerce site (PHP 4.3). Whe
: [EMAIL PROTECTED]
Subject: strange OS X (Panther) & MySql 4.0.16 behaviour!!! HELP!!!
Hi list,
I'm still trying to ascertain if this is in fact an MySql problem, here
goes.
I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I
have a live site on a FreeBSD box
Hi list,
I'm still trying to ascertain if this is in fact an MySql problem, here
goes.
I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I
have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The
site is an e-commerce site (PHP 4.3). When I try an
Interestingly enough, when I configure 4.0.16 like this it builds ok:
./configure --prefix=/usr/local --sysconfdir=/ --enable-shared
--with-server-suffix=-imax-G5 --with-mysqld-user=mysql --with-comment
--with-query-cache --without-docs --with-innodb
--enable-thread-safe-client --with-bench -
wn risk as I
am guessing!
Greg
-Original Message-
From: Owen Scott Medd [mailto:[EMAIL PROTECTED]
Sent: 03 November 2003 15:08
To: [EMAIL PROTECTED]
Subject: Re: MySQL 4.0.16 on RHEL3 AS AMD64
I should sleep before posting, I suppose.
I suppose this is the issue with the NPTL threads librar
Sent: 03 November 2003 15:08
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL 4.0.16 on RHEL3 AS AMD64
>
>
> I should sleep before posting, I suppose.
>
> I suppose this is the issue with the NPTL threads library?
> If so, has
> anyone dealt with that issue with MySQL?
I should sleep before posting, I suppose.
I suppose this is the issue with the NPTL threads library? If so, has
anyone dealt with that issue with MySQL? I remember hearing that
perhaps using a dynamically linked mysqld would work around the problem.
Owen
Owen Scott Medd wrote:
I have Red Ha
I have Red Hat Enterprise Linux 3 AS installed on a dual Opteron server
with 16GB of memory (hoping to solve innodb_buffer_pool size issues
under x86). I upgraded the MySQL included with RHEL3 (3.23.58) to the
4.0.16 rpms from the MySQL website.
I had thought this would be a piece of cake, as
When testing my application code I note that
mysql_query() does not return a non-zero
result when a lock timeout occurs -- the error is detected
when I try to retrieve the result set and get a NULL
value.
However, this finding is not consistent; for example
in one block of code a mysql_query() (usi
source='sort.c' object='sort.o' libtool=no \
depfile='.deps/sort.Po' tmpdepfile='.deps/sort.TPo' \
depmode=gcc3 /bin/sh ../depcomp \
gcc -DHAVE_CONFIG_H -I. -I. -I.. -I./../include -I../include -O3
-DDBUG_OFF -c `test -f sort.c || echo './'`sort.c
/bin/sh ../libtool --mode=link gcc -O3 -DDB
s I'm tierd to stay with an old
version of mysql :(
Thanks in advanced.
( p.s. a binary is NOT an option )
-Original Message-
From: Richard Pijnenburg [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 26, 2003 3:48 PM
To: 'Patrik Fimml'
Cc: [EMAIL PROTECTED]
Subject: RE:
AM
To: Richard Pijnenburg; [EMAIL PROTECTED]
Subject: Re: compile error mysql-4.0.16
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> gcc: cannot specify -o with -c or -S and multiple compilations
> make[2]: *** [libmysql.lo] Error 1
> make[2]: Leaving directory
> `/usr/local/src/web/mysql-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> gcc: cannot specify -o with -c or -S and multiple compilations
> make[2]: *** [libmysql.lo] Error 1
> make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.16/libmysql_r'
> make[1]: *** [all-recursive] Error 1
> make[1]: Lea
iple compilations
make[2]: *** [libmysql.lo] Error 1
make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.16/libmysql_r'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/web/mysql-4.0.16'
make: *** [all] Error 2
i'm trying this with mysql-4.0.16,
iple compilations
make[2]: *** [libmysql.lo] Error 1
make[2]: Leaving directory `/usr/local/src/web/mysql-4.0.16/libmysql_r'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/local/src/web/mysql-4.0.16'
make: *** [all] Error 2
i'm trying this with mysql-4.0.16,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.16, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary form
for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites
54 matches
Mail list logo
