Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Lms.Bmc Bmc wrote:
hi,
i am Installing My Sql -Standard-4.0.26-pc-linux-gnu-i686 Of Linux
Machine
But Facing some Problem
i am Getting thius Error ERROR 2002: Can't connect to local MySQL
hi,
i am Installing My Sql -Standard-4.0.26-pc-linux-gnu-i686 Of Linux Machine
But Facing some Problem
i am Getting thius Error ERROR 2002: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (2)
while i start MYSQl
Plzz Reply me Giving t he Solution For it
Hi, Can some help me with a date conversion problme
that I am having.
I have a date data in the following format:
'Month Days Year Hour:Minute AM/PM'
Example: 'Aug 21, 2004 2:00 PM'
So far the hours that I have spent have been in vain.
I tried using str_to_date, but it keeps failing.
Looks
Minh La wrote:
So far the hours that I have spent have been in vain.
Next time a couple of minutes with the Fine Manual instead? :-)
I tried using str_to_date, but it keeps failing.
Looks like it's not in version 4.0.2?
Quoting the FM:
STR_TO_DATE() is available as of MySQL 4.1.1.
FWIW,
--
Minh La wrote:
Hi, Can some help me with a date conversion problme
that I am having.
I have a date data in the following format:
'Month Days Year Hour:Minute AM/PM'
Example: 'Aug 21, 2004 2:00 PM'
So far the hours that I have spent have been in vain.
I tried using str_to_date, but it keeps
Hello.
Similar problems are often found in lists. Usually they are solved by
increasing file limits. You likely need to increase open-files-limit.
Help! I can't figure out a way to stop my server from topping out at 1024
threads. This is a very strange behavoir. I have tons of legit use
In the last episode (Nov 17), Gleb Paharenko said:
Help! I can't figure out a way to stop my server from topping out
at 1024 threads. This is a very strange behavoir. I have tons of
legit use on my database server but I don't think the threads are
dying does anyone have any suggestions for
Babineau
Web Developer
Criticalcode - http://www.criticalcode.com
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 17, 2004 8:26 AM
To: Gleb Paharenko
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL 4.0.2 is topping out at 1024 threads!
In the last episode
:
Matt Babineau
[EMAIL PROTECTED]
To:
[EMAIL PROTECTED]
Subject:
RE: MySQL 4.0.2 is topping out at
1024 threads!
Date:
Wed, 17 Nov 2004 11:18:04 -0800
(16:18 CLST)
This is a very strange problem. As you
In the last episode (Nov 17), Matt Babineau said:
This is a very strange problem. As you can see there isn't a lot going on,
under a million queries. No problem right? This is a dual cpu 2.8 Ghz
server. Ok Great. I am also including my.cnf so you can see my
configuration.
Here is some more
: [EMAIL PROTECTED]
Subject: RE: MySQL 4.0.2 is topping out at 1024 threads!
threads or connections ? if the problem is about connection maybe change the
parameter in your my.cnf :
max_connections = 1024
to a higher value ...
Hope this helps...
Saludos / Regards,
Alvaro.
On Wed, 2004-11-17
: Wednesday, November 17, 2004 11:37 AM
To: [EMAIL PROTECTED]
Subject: RE: MySQL 4.0.2 is topping out at 1024 threads!
wait_timeout
Will set the maximum amout of time a thread will be in the Sleep
state before MySQL drops it.
Eric Gunnett
System Administrator
Zoovy, Inc.
[EMAIL PROTECTED
Help! I can't figure out a way to stop my server from topping out at 1024
threads. This is a very strange behavoir. I have tons of legit use on my
database server but I don't think the threads are dying does anyone have any
suggestions for this?
Thanks,
Matt Babineau
Web Developer
Criticalcode -
ORDER BY autoinc_field;
By the way, if you are really using mysql 4.0.2, you should consider an
upgrade. 4.0.2 is over 2 years old. The current version is 4.0.20, and
there have been a lot of improvements and bug fixes since 4.0.2.
Michael
Cres Justado wrote:
can anyone help me with my problem
If you want them ordered by autoinc_field then add
ORDER BY autoinc_field.
Otherwise expect them to be returned in any order.
Cres Justado wrote:
can anyone help me with my problem regarding mysql 4.0.2. I'm having a
problem with the sequencing of the auto incremnt field. if my
application
can anyone help me with my problem regarding mysql 4.0.2. I'm having a
problem with the sequencing of the auto incremnt field. if my application
makes an insert mysql inserts the new row somewhere in the middle of the
sequence. example
autoinc_field data_field
1 qwe
2
I am trying to install the RPM and get a couple of errors saying the
libsqlclient.so.10 RPM is missing. I have tried to search for this but
cannot find the proper package for it. Any help would be appreciated!
Sincerely,
Chris Dietzler
ATT Enhanced Network Services
--
MySQL General Mailing
Hello Victoria,
As far as I see bug of muliple log files still not fixed regardless
of last change in 4.0.4:
'FLUSH LOGS removed numerical extension for all future update logs.'
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
sql query
At 12:09 +0400 9/10/02, Artem V. Ryabov wrote:
Hello Victoria,
As far as I see bug of muliple log files still not fixed regardless
of last change in 4.0.4:
'FLUSH LOGS removed numerical extension for all future update logs.'
This bugfix affects the update log, not the binary update
Hello Victoria,
Thursday, August 15, 2002, you wrote:
AVR In case of repliacation circle (A-B-A) query 'flush log' on any of
AVR this servers create endless loop, with creating new binary log file
AVR on each iteration. (about 30 new files every second in my case)
Thanks for bug report!
Artem,
Monday, September 02, 2002, 12:44:30 PM, you wrote:
AVR Thursday, August 15, 2002, you wrote:
AVR In case of repliacation circle (A-B-A) query 'flush log' on any of
AVR this servers create endless loop, with creating new binary log file
AVR on each iteration. (about 30 new files
I have just upgraded to mysql 4 to be able to perform delete queries
with join statement. I have a simple query where I would like to delete
a number of rows in tabel t1 depending on id's found in table t2. This
doesn't seem to work and I just don't understand why!?
mysql delete icl from
Christian,
Saturday, August 31, 2002, 11:09:47 AM, you wrote:
CL I have just upgraded to mysql 4 to be able to perform delete queries
CL with join statement. I have a simple query where I would like to delete
CL a number of rows in tabel t1 depending on id's found in table t2. This
CL doesn't
Christian Longberg wrote:
I have just upgraded to mysql 4 to be able to perform delete queries
with join statement. I have a simple query where I would like to delete
a number of rows in tabel t1 depending on id's found in table t2. This
doesn't seem to work and I just don't understand why!?
The MySQL database we use is a 4.0.2 source RPM on a RedHat 7.3
MySQL locks tables while they are being updated and unlocks the table
when the update is finished. But sometimes MySQL doesn't unlock certain
tables. And in the process list their is nothing being processed.
Does anybody know why
Subject: mysql 4.0.2 problems
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My
problem is that when I go to connect to it I get the error:
error while loading shared libraries: libmysqlclient.so.11: cannot
open shared object file: No such file or directory
Actually
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My
problem is that when I go to connect to it I get the error:
error while loading shared libraries: libmysqlclient.so.11: cannot open
shared object file: No such file or directory
Actually (just fixed it). All I had to do
, 2002 12:23 PM
Subject: mysql 4.0.2 problems
Ok I got mysql 4.0.2 installed on Mandrake and its up and running. My
problem is that when I go to connect to it I get the error:
error while loading shared libraries: libmysqlclient.so.11: cannot open
shared object file: No such file or directory
Hello mysql,
In case of repliacation circle (A-B-A) query 'flush log' on any of
this servers create endless loop, with creating new binary log file
on each iteration. (about 30 new files every second in my case)
--
Best regards,
Artem mailto:[EMAIL PROTECTED]
Artem,
Thursday, August 15, 2002, 12:06:07 PM, you wrote:
AVR In case of repliacation circle (A-B-A) query 'flush log' on any of
AVR this servers create endless loop, with creating new binary log file
AVR on each iteration. (about 30 new files every second in my case)
Thanks for bug
: mysql-4.0.2-alpha (Source distribution)
Environment:
aor System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown
aor Architecture: i686
aor Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
aor GCC: Reading specs from /usr
Hi,
it's a bit late reply, to my original mail sent to bugs list. Now the
problem reappeared as the box got rebooted. I was receiving in
$hostname.err:
020812 11:34:20 mysqld started
020812 11:34:20 Can't find messagefile
'mysql-4.0.2-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys
: medium
Category: mysql
Class: sw-bug
Release: mysql-4.0.2-alpha (Source distribution)
Environment:
System: Linux www2.osp.ru 2.2.19 #2 Wed Aug 15 16:02:45 MSD 2001 i686 unknown
Architecture: i686
Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin
Is anyone else seeing odd problems with heavy use of UNIONs on a MySQL
4.0.x server on FreeBSD?
I seem to be able to induce the problem on FreeBSD but not Linux. I
have a lot more testing to do yet, but if someone else is seeing it
that would really help to narrow the bug down.
Thanks,
Jeremy
DBs(ML),
Saturday, July 20, 2002, 3:50:48 PM, you wrote:
DM 2) Nope, I have nothing on the end of the line.
DM eg.
DM set-variable = back_log = 200
DM this works under 4.0.1 but not under 4.0.2
DM back_log = 200
DM this works under 4.0.2
DM Error: (from 4.0.2 when using set-variable =
On Wed, Jul 17, 2002 at 12:02:08PM +0300, Heikki Tuuri wrote:
Jon,
replication 4.0.1 - 4.0.2 does not work because the format in the 4.0
series has evolved. Currently, if your master of the 4.0 series, your slave
must be of the exact same release.
How likely is that to happen again? I
Jeremy,
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Jon Frisby [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, July 19, 2002 7:17 AM
Subject: Re: MySQL 4.0.2 replication going bonkers?
On Wed, Jul 17, 2002 at 12:02:08PM +0300
AM
Subject: RE: MySQL 4.0.2 replication going bonkers?
This seems to have not gotten through... Perhaps the spam filter ate it?
(sql, query)
-JF
-Original Message-
From: Jon Frisby [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 4:27 PM
To: [EMAIL PROTECTED]
Subject
Hi!
There is an error in the Windows download of MySQL-Max-4.0.2. It is a wrong
file, the same as MySQL-Max-4.0.1.
If you do not need BDB tables, please download the Windows version of
MySQL-4.0.2 (without the 'Max') instead.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions
Hi!
Thank you for your test case, thanks to which a bug was fixed when
--bind-address option is used.
Fix will be implemented in next MySQL versions, but this is a patch
that fixes it:
= mysqld.cc 1.321 vs edited =
*** /tmp/mysqld.cc-1.321-14677 Mon Jul 1 11:38:44 2002
---
We recently set up a 4.0.2 slave, which worked fine -- we loaded our data
snapshot (taken via mysqldump) and were able to perform complex queries
without problems...
However, as soon as we tried to get this machine to act as a slave to a
4.0.1 server it crashed. Immediately upon executing SLAVE
This seems to have not gotten through... Perhaps the spam filter ate it?
(sql, query)
-JF
-Original Message-
From: Jon Frisby [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 4:27 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0.2 replication going bonkers?
We recently set up
Hi!
Due to an error in the build process, the rpm of plain MySQL-4.0.2 does not
contain InnoDB.
Please download the rpm of MySQL-Max-4.0.2 instead.
The error in the build of the plain MySQL-4.0.2 rpm will be fixed in the
coming days.
Best regards,
Heikki Tuuri
Innobase Oy
:
==
(EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in
(CHANGE)
/* Define if you have the poll function. */
#define HAVE_POLL 1
(TO)
/* Define if you have the poll function. */
/* #define HAVE_POLL 1 */
==
The correct
, ./configure sets HAVE_POLL as defined, causing make to
fail with sys/poll.h not found.
WORKAROUND:
==
(EDITOR) /usr/ports/mysql-4.0.2-alph/configure.in
(CHANGE)
/* Define if you have the poll function. */
# define HAVE_POLL 1
(TO)
/* Define if you
In the last episode (Jul 14), R Blake said:
--On Sunday, July 14, 2002 2:04 PM -0500 Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Jul 13), R Blake said:
BUG #1:
sys/poll.h does not seem to exist in BSD variants (cref:
http://www.netsys.com/bsdi-users/2001-11/msg00093.html), but
Hi all.
I just upgraded to MySQL-4.0.2 (great work guys) and noticed that MyCC's
user administration isn't displaying privileges properly, ie doesn't
show them at all. (When I say upgrade, I mean a full uninstall new
install, and import from mysqldump backups). Granting seems to work OK
(I
make[2]: Leaving directory `/usr/ports/mysql-4.0.2-alpha/libmysql'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/usr/ports/mysql-4.0.2-alpha'
make: *** [all-recursive-am] Error 2
[root@server]
__
Richard S. Blake
Foster City, CA
ph
hi all,
three BUGS are reported here that have cropped up in mysql-4.0.2-alpha on
OSX 10.1.4 Server
current system has a SUCCESSFUL install of:
Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for
apple-darwin5.4 on powerpc
the 3 bugs:
(1) poll.h not present in BSD
three BUGS are reported here that have cropped up in mysql-4.0.2-alpha
current system has a SUCCESSFUL install of:
Server: /usr/local/mysql/bin/mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for
apple-darwin5.4 on powerpc
the 3 bugs:
(1) poll.h not present in BSD variants; HAVE_POLL set to #define
Hi!
I recently took a test drive for MySQL 4.0.2. Installation was a breeze
as always.
However, when I tried to start MySQL server using the same old my.cnf
which 4.0.1
had no problems with, 4.0.2 complained about the following and refused
to start.
020713 07:24:55 mysqld started
Unknown
Now that MySQL 4.0.2 has been released, does anyone know if Support for
always-index words is available?
This is mentioned in the todo:
http://www.mysql.com/doc/F/u/Fulltext_TODO.html
'Support for always-index words. They could be any strings the user wants
to treat as words, examples are C
Hi
As i already stated , i am not able to insert a null value in a child table
in 4.0.1 which i was able to do in 3.23.51
I have created a table parent and also another table child where parentid
column in child is a foreign key to the id column in parent table
It was possible that i have no
PROTECTED]]
Sent: Monday, July 01, 2002 9:14 AM
To: MySQL
Subject: Mysql 4.0.2
Hi
As i already stated , i am not able to insert a null value in a child table
in 4.0.1 which i was able to do in 3.23.51
I have created a table parent and also another table child where parentid
column in child
Arul,
Monday, July 01, 2002, 1:25:38 PM, you wrote:
A As i already stated , i am not able to insert a null value in a child table
A in 4.0.1 which i was able to do in 3.23.51
A I have created a table parent and also another table child where parentid
A column in child is a foreign key to the
Hi!
Vadim == Vadim P [EMAIL PROTECTED] writes:
Vadim Sergei Golubchik wrote:
rebuild your indexes (the proper way to do it is to issue
REPAIR table_name USE_FRM
Vadim Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick?
Yes, this would do the same thing as REPAIR,
Hi!
On May 16, Jocelyn Fournier wrote:
Hi,
I don't understand, I modified ulong ft_min_word_len=3; in
myisam/ft_static.c, and then recompiled MySQL using
BUILD/compile-pentium --without-innodb script, but show variables still
displays after restarting mysql :
| ft_min_word_len
: Re: Bug in fulltext search in latest mysql-4.0.2 source
Hi,
I don't understand, I modified ulong ft_min_word_len=3; in
myisam/ft_static.c, and then recompiled MySQL using
BUILD/compile-pentium --without-innodb script, but show variables still
displays after restarting mysql
Hi!
On May 15, Jocelyn Fournier wrote:
A small question :
I have :
CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 )
in the field 'nom' .
How could I match BCI-11N for exemple ? (BCI* return nothing :( )
Thanks,
Jocelyn
Actually, it's a question for [EMAIL PROTECTED],
Sergei Golubchik wrote:
rebuild your indexes (the proper way to do it is to issue
REPAIR table_name USE_FRM
Sergei, would ALTER TABLE.. DROP INDEX.. ADD FULLTEXT... do the same trick?
TIA,
Vadim.
/* sql, mysql to satisfy the spam police */
: Re: Bug in fulltext search in latest mysql-4.0.2 source
Hi!
On May 15, Jocelyn Fournier wrote:
A small question :
I have :
CANON BCI-11N Cartouche noir ( BJC-70 / BJC-80 / BN-700 )
in the field 'nom' .
How could I match BCI-11N for exemple ? (BCI* return nothing :( )
Thanks
Hi,
I'm just testing the new multi-table delete in MySQL-4.0.2 and I wonder if
I'm doing something wrong with this query :
mysql DELETE FROM searchmainhardwarefr2,searchjoinhardwarefr2 USING
searchmainhardwarefr2 as a,searchjoinhardwarefr2 as b,forumconthardwarefr2
as c WHERE b.numreponse
On Tuesday 12 February 2002 09:23 pm, you wrote:
Sasha,
I compressed it first, 'cause it was nearly 400MB in size. ?It's on
the FTP site as mysqld.core.bz2.
Jeremy:
Can you upload the binary itself also? I need it to be able to study the core.
--
MySQL Development Team
For technical
On Tuesday 12 February 2002 09:23 pm, you wrote:
Sasha,
I compressed it first, 'cause it was nearly 400MB in size. It's on
the FTP site as mysqld.core.bz2.
Jeremy - in case you are wondering why it is taking me so long to reply -
we've made a mess on our Linux build machine before the
I see people speaking about mysql 4.0.2... but where you get it? they write
some thing about it on web page but 4.0.2 is not in the download list...
maybe someone can say if mysql 4 is stable? I mean if I can use it without
100 crash in 1 hour :)
Sorry for bad english :)
Jean-Francois Dionne
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote:
I see people speaking about mysql 4.0.2... but where you get it?
they write some thing about it on web page but 4.0.2 is not in the
download list...
It's from the MySQL source tree. See this url:
http://www.mysql.com
So it's better using 4.0.1 of 4.0.2?
Jean-Francois Dionne
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Jean-Francois Dionne [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, February 15, 2002 8:12 PM
Subject: Re: information on mysql 4.0.2
On Fri, Feb 15, 2002
Hi,
No problem so far with mysql 4.0.x, no crash at all on a production server
with a really high load.
If you want to use mysql 4.0.2, take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From
68 matches
Mail list logo