RE: More info about 40001 SQL_NO_CACHE
Thank you...All I was doing was a musqldump of the tables in my data base to files, one file for each table. Yesterday I upgraded to mysql 5.0.27, so I will watch it for a while. It just started happening last Saturday night, and I had been running the system for a few months. Thanks for you response. 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. From: Howard Hart [mailto:[EMAIL PROTECTED] 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- From: Logg, Connie A. [mailto:[EMAIL PROTECTED] Sent: Wed 11/15/2006 8:18 PM To: mysql@lists.mysql.com Subject: More info about 40001 SQL_NO_CACHE This showed up in 'show processlist' and it had had an active time of about 4 days. Numerous other inquiries were hung behind it, although the other inquiries completed eventually...but they were so slow as to backup the data base entry code and extraditions for the analysis by several 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, Connie A. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 11:41 AM To: mysql@lists.mysql.com Subject: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message 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 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message
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 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
More info about 40001 SQL_NO_CACHE
This showed up in 'show processlist' and it had had an active time of about 4 days. Numerous other inquiries were hung behind it, although the other inquiries completed eventually...but they were so slow as to backup the data base entry code and extraditions for the analysis by several 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, Connie A. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 11:41 AM To: mysql@lists.mysql.com Subject: SELECT /*!40001 SQL_NO_CACHE */ * FROM `ROUTEDATA` message 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 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem installing PERL DBD::mysql
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 Linux WS release 4 (Nahant Update 4)
--
I am having a hard time installing DBD:mysql on 64 bit machine
snv1.ultralight.org
/usr/bin/perl MCPAN -e shell
CPAN install DBD::mysql
Dies with errors...so I decided to do it from the source, and it also
complainshere is the output from the source install:
[EMAIL PROTECTED] DBD-mysql-3.0006]# /usr/bin/perl Makefile.PL I will use the
following settings for compiling and testing:
cflags(mysql_config) = -I/usr/local/include/mysql
embedded (mysql_config) =
libs (mysql_config) = -L/usr/local/lib/mysql -lmysqlclient -lz
-lcrypt -lnsl -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb(default ) = test
testhost (default ) =
testpassword (default ) =
testsocket(default ) =
testuser (default ) =
To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'.
Using DBI 1.52 (for perl 5.008008 on x86_64-linux) installed in
/usr/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI/
Writing Makefile for DBD::mysql
[EMAIL PROTECTED] DBD-mysql-3.0006]#
[EMAIL PROTECTED] DBD-mysql-3.0006]# make
cc -c -I/usr/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI
-I/usr/local/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOO D -g
-fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSE
T_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\3.0006\
-DXS_VERSION=\3.0006\ -fpic -I/usr/lib/perl5/5.8.8/x86_64
-linux/CORE dbdimp.c
cc -c -I/usr/lib/perl5/site_perl/5.8.8/x86_64-linux/auto/DBI
-I/usr/local/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOO D -g
-fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include
-D_LARGEFILE_SOURCE -D_FILE_OFFSE
T_BITS=64 -I/usr/include/gdbm -O2 -DVERSION=\3.0006\
-DXS_VERSION=\3.0006\ -fpic -I/usr/lib/perl5/5.8.8/x86_64
-linux/CORE mysql.c
mysql.xs: In function `XS_DBD__mysql__GetInfo_dbd_mysql_get_info':
mysql.xs:647: warning: ignoring return value of `Perl_newSViv', declared with
attribute warn_unused_result
mysql.xs:650: warning: ignoring return value of `Perl_newSViv', declared with
attribute warn_unused_result
mysql.xs:653: warning: ignoring return value of `Perl_newSVpv', declared with
attribute warn_unused_result Running Mkbootstrap for DBD::mysql () chmod 644
mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH=/usr/local/lib/mysql /usr/bin/perl myld cc -shared
-L/usr/local/lib dbdimp.o mysql.o -o blib/arch/aut
o/DBD/mysql/mysql.so\
-L/usr/local/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm \
/usr/bin/ld: /usr/local/lib/libz.a(compress.o): relocation R_X86_64_32 against
`a local symbol' can not be used when making a shared object; recompile with
-fPIC
/usr/local/lib/libz.a: could not read symbols: Bad value
collect2: ld returned 1 exit status
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1
I have tried using -fPIC, but I think I do not know how to tell it to use that
correctly. I assume it is passed with --cflags on the 'perl Makefile.PL' line,
but I can't get that to work.
Can someone tell me the syntax on the 'perl Makefile.PL' line, or, what the
problem is and how can I get DBD::mysql to load?
By the way, perl Makefile.PL --help gives me..
[EMAIL PROTECTED] DBD-mysql-3.0006]# perl -Makefile.PL --help
Usage: perl [switches] [--] [programfile] [arguments]
-0[octal] specify record separator (\0, if no argument)
-a autosplit mode with -n or -p (splits $_ into @F)
-C[number/list] enables the listed Unicode features
-c check syntax only (runs BEGIN and CHECK blocks)
-d[:debugger] run program under debugger
-D[number/list] set debugging flags (argument is a bit mask or alphabets)
-e program one line of program (several -e's allowed, omit programfile)
-f don't do $sitelib/sitecustomize.pl at startup
-F/pattern/ split() pattern for -a switch (//'s are optional)
-i[extension] edit files in place (makes backup if extension supplied)
-Idirectory specify @INC/#include directory (several -I's allowed)
-l[octal] enable line ending processing, specifies line terminator
-[mM][-]module execute use/no module... before executing program
-n assume while () { ... } loop around program
-p assume loop like -n but print line also, like sed
-P run program through C preprocessor before compilation
-s enable rudimentary parsing for switches after programfile
Installing DBD::mysql - problems
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 PROTECTED] cal]# I have the following rpms installed [EMAIL PROTECTED] cal]# rpm -qa | grep -i mysql MySQL-devel-standard-5.0.20a-0.rhel4 MySQL-client-standard-5.0.20a-0.rhel4 MySQL-shared-standard-5.0.20a-0.rhel4 MySQL-server-standard-5.0.20a-0.rhel4 And DBI installed ok. [EMAIL PROTECTED] utils]$ ./seeperlmods Archive::Tar -- 1.29 CPAN -- 1.87 Compress::Zlib -- 1.41 Cwd -- 3.17 DBD::Multiplex -- 1.98 DBI -- 1.50 -- DBI::Shell -- 11.93 Data::ShowTable -- undef Digest::MD5 -- 2.36 IO::Tee -- 0.64 IO::Zlib -- 1.04 Net::Daemon -- 0.39 Net::Telnet -- 3.03 Perl -- 5.8.5 RPC::PlServer -- 0.2018 Storable -- 2.15 Term::ReadKey -- 2.30 Term::ReadLine -- 1.01 Text::Reform -- 1.11 When I try to install the DBD::mysql I get errors: [EMAIL PROTECTED] DBD-mysql-3.0002_5]# /usr/bin/perl Makefile.PL I will use the following settings for compiling and testing: cflags(mysql_config) = -I/usr/include/mysql -g -pipe -m64 embedded (mysql_config) = libs (mysql_config) = -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ps-protocol (default ) = 1 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Multiple copies of Driver.xst found in: /usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ / usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 741 Using DBI 1.50 (for perl 5.008005 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/site_perl/5.8.5/ x86_64-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::mysql probably ok as it picked one When I run make: [EMAIL PROTECTED] DBD-mysql-3.0002_5]# make gcc -c -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -g -pipe - m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr /local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\ 3.0002_5\ -DXS_VERSION=\3.0002_5\ -fPIC -I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE dbdimp. c gcc -c -I/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBI/ -I/usr/include/mysql -g -pipe - m64 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT -D_GNU_SOURCE -DDEBUGGING -fno-strict-aliasing -pipe -I/usr /local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -m64 -DVERSION=\ 3.0002_5\ -DXS_VERSION=\3.0002_5\ -fPIC -I/usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.so /usr/bin/perl myld gcc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so -L/usr/lib64/mysql -l mysqlclient -lz -lcrypt -lnsl -lm /usr/bin/ld: /usr/lib64/mysql/libmysqlclient.a(libmysql.o): relocation R_X86_64_32 against `a local symbol' ca n not be used when making a shared object; recompile with -fPIC /usr/lib64/mysql/libmysqlclient.a: could not read symbols: Bad value collect2: ld returned 1 exit status make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1 [EMAIL PROTECTED] DBD-mysql-3.0002_5]# I tried using /usr/bin/perl Makefile.PL --cflags fPIC And doing the make afterword, but that failed miserably with many many errors snip dbdimp.c:3017: error: dereferencing pointer to incomplete type dbdimp.c: In function `mysql_describe': dbdimp.c:3126: error: dereferencing pointer to incomplete type dbdimp.c: In function `mysql_st_fetch': dbdimp.c:3151: error: `MYSQL_ROW' undeclared (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, 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is the proper (least expensive) way to do this
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` varchar(255) default NULL, `f_time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`asnInfoID`), UNIQUE KEY `asNumber` (`asNumber`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Multiple Ips can share the same ASN value. Is it better to do an 'insert ignore' into ASNINFO when I have to look one up, or is it better to try to fetch the ASN information to see if it exists, and then if it does not exist, do the insert. I figure the fetch is one sql command, and the insert is one sql command, so if an asn does not exist, it is two data base accesses, where if I do an 'insert ignore' it is only one command and if the value is in the table, the insert is ignored. Thanks, Connie 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How can I limit the sockets mysql opens?
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 tcp0 0 iepm-bw.slac.stanford:54332 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54331 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54330 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54329 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54328 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54327 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54326 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54325 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54324 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54323 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54322 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54321 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54399 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54397 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54396 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54395 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54394 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54393 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54392 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54391 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54390 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54389 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54388 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54387 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54386 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54385 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54384 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54383 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54382 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54381 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54380 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54379 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54378 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54377 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54376 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54375 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54374 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54373 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54372 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54371 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54370 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54369 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54368 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54367 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54366 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54365 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54364 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54363 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54362 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54361 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54360 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54359 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54358 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:54357 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp
Help please
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 tcp0 0 iepm-bw.slac.stanford.:1000 iepm-bw.slac.stanford:38775 TIME_WAIT tcp0 0 iepm-bw.slac.stanford.:1000 iepm-bw.slac.stanford:38781 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38780 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38781 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38782 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38783 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38776 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38777 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38778 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38779 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38772 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38773 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38774 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38768 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38769 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38770 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38771 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38764 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38765 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38766 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38760 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38761 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38762 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38763 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38756 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38757 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38758 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38759 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38752 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38753 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38754 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38755 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38748 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38749 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38750 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38751 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38744 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38745 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38746 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38747 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38742 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38743 iepm-bw.slac.stanford.:1000 TIME_WAIT tcp0 0 iepm-bw.slac.stanford:38672 iepm-bw.slac.stanford.:1000 ESTABLISHED One of the messages in /var/log/messages is too many orphaned sockets. Do the above indicate orphaned sockets? I logged into mysql root and did a 'show full processlist' and there were only one or two mysql processes. Can someone explain why there might be so many tcp sockets taken up to connect to mysql (which is running on port 1000). Thanks, Connie Logg SLAC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help...I am desparate
No...One machine eventually worked on port 1000, and another I changed the port back to the standard port 3306. I have run into this before and don't know what makes it finally run. My security folks asked me to run on port 1000 or another port less than 1024. Fortunately the machine they were concerned about did finally work on 1000...but I do not know why. Thanks for everyone's suggestions, Connie 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. -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: 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] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? 060103 15:54:02 [ERROR] Aborting 060103 15:54:02 InnoDB: Starting shutdown... 060103 15:54:04 InnoDB: Shutdown completed; log sequence number 0 386242 060103 15:54:04 [Note] /usr/sbin/mysqld: Shutdown complete 060103 15:54:04 mysqld ended My /etc/my.cnf file is: [EMAIL PROTECTED] v3src]$ more /etc/my.cnf [mysqld] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [mysqld.server] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [client] socket=/home/iepm/mysql/mysql.sock port=1000 The system had crashed and burned because of a disk error so I have loaded it with the following rpms [EMAIL PROTECTED] v3src]$ rpm -qa | grep -i mysql MySQL-client-standard-5.0.18-0.rhel3 MySQL-server-standard-5.0.18-0.rhel3 MySQL-standard-debuginfo-5.0.18-0.rhel3 MySQL-shared-standard-5.0.18-0.rhel3 MySQL-devel-standard-5.0.18-0.rhel3 The machine is running: Linux socrates.xxx.xxx.xxx 2.4.21-27.0.2.ELsmp #1 SMP Tue Jan 18 19:25:35 CST 2005 i686 i686 i386 GNU/Linux And the release is: [EMAIL PROTECTED] v3src]$ more /etc/redhat-release Scientific Linux SL Release 3.0.4 (SL) [EMAIL PROTECTED] v3src]$ I have not been able to load the perl DBD bundle either. I do: /usr/bin/perl -MCPAN -e 'install::DBD::mysql' and it complains because the server isn't running. I actually am having this problem also on a system running mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) It will not sucessfully install the perl bundle there. I have run into these problems several times in the past, and eventually tried everything I have tried today, and something usually breaks it loose...but I have 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Yahoo! DSL - Something to write home about. Just $16.99/mo. or less. dsl.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help...I am desparate
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] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? 060103 15:54:02 [ERROR] Aborting 060103 15:54:02 InnoDB: Starting shutdown... 060103 15:54:04 InnoDB: Shutdown completed; log sequence number 0 386242 060103 15:54:04 [Note] /usr/sbin/mysqld: Shutdown complete 060103 15:54:04 mysqld ended My /etc/my.cnf file is: [EMAIL PROTECTED] v3src]$ more /etc/my.cnf [mysqld] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [mysqld.server] datadir=/home/iepm/mysql socket=/home/iepm/mysql/mysql.sock port=1000 [client] socket=/home/iepm/mysql/mysql.sock port=1000 The system had crashed and burned because of a disk error so I have loaded it with the following rpms [EMAIL PROTECTED] v3src]$ rpm -qa | grep -i mysql MySQL-client-standard-5.0.18-0.rhel3 MySQL-server-standard-5.0.18-0.rhel3 MySQL-standard-debuginfo-5.0.18-0.rhel3 MySQL-shared-standard-5.0.18-0.rhel3 MySQL-devel-standard-5.0.18-0.rhel3 The machine is running: Linux socrates.xxx.xxx.xxx 2.4.21-27.0.2.ELsmp #1 SMP Tue Jan 18 19:25:35 CST 2005 i686 i686 i386 GNU/Linux And the release is: [EMAIL PROTECTED] v3src]$ more /etc/redhat-release Scientific Linux SL Release 3.0.4 (SL) [EMAIL PROTECTED] v3src]$ I have not been able to load the perl DBD bundle either. I do: /usr/bin/perl -MCPAN -e 'install::DBD::mysql' and it complains because the server isn't running. I actually am having this problem also on a system running mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686) It will not sucessfully install the perl bundle there. I have run into these problems several times in the past, and eventually tried everything I have tried today, and something usually breaks it loose...but I have 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help...I am desparate
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@lists.mysql.com Subject: Re: Help...I am desparate Hi Connie, 060103 15:54:02 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 060103 15:54:02 [ERROR] Do you already have another mysqld server running on port: 1000 ? You can't bind to a port less than 1024 unless you're running as root. I suspect that's the problem here. Try another port, higher than 1024. I'm kind of curious why you aren't running it on the standard 3306? Regards, Jeremy -- Jeremy Cole MySQL Geek, Yahoo! Inc. Desk: 408 349 5104 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where is the perl DBI for version 5 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: 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Rpm installation problem
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.rpm All work fine except one: [EMAIL PROTECTED] cal]# rpm -i MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm warning: MySQL-shared-standard-5.0.16-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libz.so.0 is needed by MySQL-shared-standard-5.0.16-0.rhel3 Is this libz something that should have been installed with the redhat installation, and didn't? Also, where is the perl MYSQL bundle that matched this release of Mysql? Thanks, Connie 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Trouble setting root password
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 connection id is 5 to server version: 4.1.7-standard I have tried both the mysqld_safe --init-file=/home/iepm/v3src/minit which has the password setting statement in it And this does not work...I cannot get into mysql with the password. I have also tried mysqld_safe --skip-grant-tables --user=root And tried setting the password and doing flush privileges. This also does not work. I am at my wits end as to how to do this, which I have been able to do before. Any insight and assistance would be appreciated. Thank you, Connie 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Which version of linux rpm's should I use
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 #1 SMP Mon Sep 19 18:00:54 EDT 2005 x86_64 x86_64 x86_64 GNU/Linux I would like to use mysql 5.0. Thanks, Connie 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help starting mysql
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]# uname -a Linux snv1.xxx 2.6.13Fast100 #5 SMP Thu Oct 20 13:42:04 PDT 2005 x86_64 x86_64 x86_64 GNU/Linux And is running red hat version [EMAIL PROTECTED] mysql]# more /etc/redhat-release Red Hat Enterprise Linux WS release 4 (Nahant Update 2) Have I installed the correct rpm? And can you tell me what priv I do not have as root that gives the following message when I try to start mysqld_safe? 051031 16:06:20 mysqld started 051031 16:06:20 InnoDB: Started; log sequence number 0 43655 051031 16:06:20 [ERROR] Can't start server: Bind on TCP/IP port: Permission denied 051031 16:06:20 [ERROR] Do you already have another mysqld server running on port: 1020 ? 051031 16:06:20 [ERROR] Aborting 051031 16:06:20 InnoDB: Starting shutdown... 051031 16:06:22 InnoDB: Shutdown completed; log sequence number 0 43655 051031 16:06:22 [Note] /usr/sbin/mysqld: Shutdown complete 051031 16:06:22 mysqld ended I am not running another mysql server on this machine, and nothing is bound to port 1020. Thanks, Connie 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: max packet size question
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 [mailto:[EMAIL PROTECTED] Sent: Friday, October 21, 2005 8:01 PM To: 'MySQL list' Subject: max packet size question Is there a practical maximum for max packet size? Is it simply a function of the amount of memory that you have? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: max packet size question
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 use parallel streams, and the number of parallel streams you can optimally use also needs to be calibrated. Connie Logg Network Analyst Stanford Linear Accelerator Center -Original Message- From: Rob Brooks [mailto:[EMAIL PROTECTED] Sent: Friday, October 21, 2005 8:01 PM To: 'MySQL list' Subject: max packet size question Is there a practical maximum for max packet size? Is it simply a function of the amount of memory that you have? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error msg: ERROR 1030 (HY000) at line 52: Got error -1 from storage engine
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: Got error -1 from storage engine [EMAIL PROTECTED] mysql-backup]# 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to save graphs in a table?
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=InnoDB DEFAULT CHARSET=latin1 And I have allocated the user account the file privilege. The sql I am trying to use is: load data infile 'filename.png' into table GRAPHS (graphic); What happens is that the takes the file and breaks it up into lines and loads each line as a row, thus storing it over many columns. How can I get it to store the file in the 'graphic' blob with one 'graphid'. Thanks in advance. 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
