TED]
Sent: Thursday, November 16, 2006 8:41 AM
To: Logg, Connie A.
Subject: RE: More info about 40001 SQL_NO_CACHE
Looks like this may have been fixed in 5.0.25 or above, so if it's the same
bug, you're good to go.
http://bugs.mysql.com/bug.php?id=21288
Howard
-----Original Message-
eral hours.
Can someone please enlightn me on this problem? Like I mentioned, the web
search entries indicated that this hanging was a mysql problem.
I have upgraded to 5.0.27. But I will not know until tomorrow if the mysqldump
that I do tonight works.
-Original Message-----
From: Logg
I am running mysql version 5.0.24 and am seeing this error when running
mysqldump.
>From what I can find on the web, this message is generated by an error in the
>mysql code.
Please correct me if I am wrong.
Is this fixed in mysql 5.0.27 ?
Thanks,
Connie Logg, Network Analyst
Stanford Linear
Machine info:
[EMAIL PROTECTED] utils]$ uname -a
Linux snv1 2.6.9-34.0.2.ELsmp #1 SMP Fri Jun 30 10:32:04 EDT 2006 x86_64 x86_64
x86_64 GNU/Linux
[EMAIL PROTECTED] utils]$ perl -v
This is perl, v5.8.8 built for x86_64-linux
[EMAIL PROTECTED] utils]$ more /etc/redhat-release
Red Hat Enterprise Lin
I am trying to install DBD::mysql on the following node:
[EMAIL PROTECTED] cal]# uname -a
Linux snv1 2.6.9-34.ELsmp #1 SMP Fri Feb 24 16:56:28 EST 2006 x86_64 x86_64
x86_64 GNU/Linux
[EMAIL PROTECTED] cal]# more /etc/redhat-release
Red Hat Enterprise Linux WS release 4 (Nahant Update 3)
[EMAIL P
I have a database for ASN information in which I save asn information for
reference by other scripts (asn lookup can be expensive).
CREATE TABLE `ASNINFO` (
`asnInfoID` int(11) NOT NULL auto_increment,
`asNumber` int(11) NOT NULL default '0',
`description` varchar(255) default NULL,
`comment`
Netstat -a shows the following:
tcp0 0 iepm-bw.slac.stanford:54335 iepm-bw.slac.stanford.:1000
TIME_WAIT
tcp0 0 iepm-bw.slac.stanford:54334 iepm-bw.slac.stanford.:1000
TIME_WAIT
tcp0 0 iepm-bw.slac.stanford:54333 iepm-bw.slac.stanford.:1000
TIME_WAIT
tcp
Two days ago, a system that has been running fine started crashing...It could
be for a variety of reasons which I am researchinig. However (running mysql
5.0.18) I notice the following from netstat:
tcp0 0 iepm-bw.slac.stanford.:1000 iepm-bw.slac.stanford:38672
ESTABLISHED
tcp
the
middle word in life."
-Original Message-
From: Caroline Jen [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 05, 2006 10:13 AM
To: Logg, Connie A.
Subject: Re: Help...I am desparate
Is there anything in your PC listening to Port 1000?
It seems that there is a conflict.
--- "
I was asked (told) by my security people to use a port < 1024. I am running
with 1000 other places, and was running with 1000 on both of these machines.
-Original Message-
From: Jeremy Cole [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 03, 2006 4:25 PM
To: Logg, Connie A.
Cc: my
I am trying to start mysql and I keep getting the following error. There is no
other server or anything else using port 1000. I have checked netstat and the
port is not active.
60103 15:54:02 mysqld started
060103 15:54:02 InnoDB: Started; log sequence number 0 386242
060103 15:54:02 [ERROR]
I have done various searches, and cannot locate the perl dbi for mysql 5.0.16.
I assume that the old one for mysql 4 will not work.
Can someone please provide me the url for mysql 5's perl dbd/dbi bundle?
Thanks, Connie
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-
I am trying to install the following rpm on a red hat linux machine.
MySQL-client-standard-5.0.16-0.rhel3.i386.rpm
MySQL-devel-standard-5.0.16-0.rhel3.i386.rpm
MySQL-server-standard-5.0.16-0.rhel3.i386.rpm
MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm
MySQL-standard-debuginfo-5.0.16-0.rhel3.i386.
I tried to go into mysql with root and the password I had set, and access was
refused.
I finally gave up and decided to reset the root password using the techniques
described on
http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html
This is a linux machine running mysql Your MySQL co
I have installed the following rpm's for mysql on my node
[EMAIL PROTECTED] mysql]# rpm -qa | grep -i mysql
MySQL-client-standard-5.0.15-0.rhel4
MySQL-server-standard-5.0.15-0.rhel4
MySQL-shared-standard-5.0.15-0.rhel4
MySQL-devel-standard-5.0.15-0.rhel4
The node is:
[EMAIL PROTECTED] mysql]# unam
I have just received a new machine to install mysql on and I do not know how to
tell which version of the rpm's I should use
[EMAIL PROTECTED] config]# more /etc/redhat-release
Red Hat Enterprise Linux WS release 4 (Nahant Update 2)
[EMAIL PROTECTED] config]# uname -a
Linux snv1 2.6.9-22.ELsmp #
I forgot to mention that the buffer sizes, block sizes and window sizes you use
can also make a big difference. You need to calibrate those for your systems
and you need to understand the characteristics of your source and destination
nodes. If you are desparate for performance, you may need to
The max packet size depends on the MTU your network and interface settings
allow.
The common packet size is 1500, however, if you can use 9000, you will get much
better performace.
Connie Logg
Network Analyst
Stanford Linear Accelerator Center
-Original Message-
From: Rob Brooks [mailt
I am trying to reload/rebuild a table from the backup and I get this message. I
cannot find any references for it.
[EMAIL PROTECTED] mysql-backup]# mysql -u root -p iepm <
/home/iepm/privatedir/mysql-backup/iepm-bw.cern.ch.iepm-abwedata.08-16-2005
Enter password:
ERROR 1030 (HY000) at line 52: G
I would like to save graphs in a mysql data base. The table definition I have
set up is:
CREATE TABLE `GRAPHS` (
`graphid` int(11) NOT NULL auto_increment,
`graphic` blob, `f_time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on
update CURRENT_TIMESTAMP,
PRIMARY KEY (`graphid`)
) ENGINE=
20 matches
Mail list logo