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-
From: Logg, Connie A. [mailto
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
.
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, Connie
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
(first use in this function)
dbdimp.c:3151: error: syntax error before cols
dbdimp.c:3156: error: dereferencing pointer to incomplete type
I am at a loss how to resolve this.
I would appreciate any guidance. I have also tried DBD-mysql-3.0002_4 and
DBD-mysql-3.0002_3
Connie Logg
Connie Logg
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,
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
.
-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.
--- Logg, Connie A. [EMAIL PROTECTED] wrote
had no luck for several days now.
Any help you can provide will be greatly appreciated.
Connie Logg
Connie Logg, Network Analyst
Stanford Linear Accelerator Center
ph: 650-926-2879
Happiness is found along the way, not at the end of the road, and 'IF' is the
middle word in life.
--
MySQL
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: mysql
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:
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
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
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 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]#
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
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
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:
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`)
)
20 matches
Mail list logo