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
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 failin
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,
--
Ha
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 lik
: 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
au
Cc: [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-
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
rom:
> 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
> (
s All!
Matt 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 t
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 suggesti
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
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 -
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
applic
eld, data_field FROM yourtable 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 an
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
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
AT&T Enhanced Network Services
--
MySQL General Mailing Li
Hi!
On Friday 01 November 2002 15:03, Jon Frisby wrote:
> Why not just do:
> DELETE FROM MyChannels;
> DELETE FROM MyPackages;
>
> If you're concerned about atomicity, simply acquire a lock on both
> tables at once first.
Exactly, it was my concern. I'm not using MySQL tables with transaction
sup
xpected.
> Tables are very simple: MyChannels contains two int columns,
> MyPackages - just one int column.
>
>
> >How-To-Repeat:
>
> >Fix:
>
>
> >Submitter-Id:
> >Originator:
> >Organization:
>
> >M
How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: none
>Synopsis: Multi-table delete is broken in MySQL 4.0.2
>Severity: serious
>Priority: high
>Category: mysql
>Class: sw-bug
>Rel
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,
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
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 ne
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 r
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
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
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 ca_x_in
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 or
MAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 20, 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:
>> er
TED]>
Sent: Tuesday, August 20, 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
> s
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 was
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 r
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]
ator:Artem Ryabov
>>Organization:
>>MySQL support: none
>>Synopsis: too many bin-log files
>>Severity: serious
>>Priority: medium
>>Category: mysql
>>Class: sw-bug
>>Release: mysql-4.0.2-alpha (Source distribution)
;Severity: serious
>Priority: 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/
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/eng
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 =
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 rep
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?
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 - tr
.mysql
Sent: Tuesday, July 16, 2002 4:30 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]
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?
&g
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
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
--- edited/mys
ive file ...
ar -r [-cuTLv] archive file ...
ar -r [-abciuTLv] position archive file ...
ar -t [-TLv] archive [file ...]
ar -x [-ouTLv] archive [file ...]
make[2]: *** [libmysqlclient.la] Error 1
make[2]: Leaving directory `/usr/ports/mysql-4.0.2-alpha/libmysql'
make[1]: *** [a
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 s
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:
> >> does not seem to exist in BSD variants (cref:
> >>http://www.netsys.com/bsdi-users/2001-11/msg00093.html), bu
3.html), but
>> nonetheless, "./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)
ot;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 have the poll function. */
>
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
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 #def
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
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 tre
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 th
lto:[EMAIL 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
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 e
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 e
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 t
;
Sent: Thursday, May 16, 2002 1:58 PM
Subject: 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,
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
TED]>
Sent: Thursday, May 16, 2002 12:58 PM
Subject: 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-7
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 */
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 PRO
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
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 s
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
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
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 thi
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 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
72 matches
Mail list logo
