localhost vs. 127.0.0.1 error: 'Lost connection to MySQL server during query'
OK here goes I've had a problem for a few days that I can't resolve. At the OS level If I ping the name localhost I get a good return and if I ping 127.0.0.1 I also get a good return as noted below. [EMAIL PROTECTED]:~# ping localhost -c 2 PING localhost (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.034 ms 64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.028 ms --- localhost ping statistics --- 2 packets transmitted, 2 received, 0% packet loss, time 999ms rtt min/avg/max/mdev = 0.028/0.031/0.034/0.003 ms [EMAIL PROTECTED]:~# ping 127.0.0.1 -c 2 PING 127.0.0.1 (127.0.0.1) 56(84) bytes of data. 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.031 ms 64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.029 ms --- 127.0.0.1 ping statistics --- 2 packets transmitted, 2 received, 0% packet loss, time 999ms rtt min/avg/max/mdev = 0.029/0.030/0.031/0.001 ms when I run the restart script I get the following in syslog Jan 10 15:35:51 www mysqld[2334]: 060110 15:35:51 [Note] /usr/sbin/mysqld: Normal shutdown Jan 10 15:35:51 www mysqld[2334]: Jan 10 15:35:51 www mysqld[2334]: 060110 15:35:51 InnoDB: Starting shutdown... Jan 10 15:35:54 www mysqld[2334]: 060110 15:35:54 InnoDB: Shutdown completed; log sequence number 0 43884 Jan 10 15:35:54 www mysqld[2334]: 060110 15:35:54 [Note] /usr/sbin/mysqld: Shutdown complete Jan 10 15:35:54 www mysqld[2334]: Jan 10 15:35:54 www mysqld_safe[2590]: ended Jan 10 15:35:55 www mysqld_safe[2649]: started Jan 10 15:35:55 www mysqld[2652]: 060110 15:35:55 InnoDB: Started; log sequence number 0 43884 Jan 10 15:35:55 www mysqld[2652]: /usr/sbin/mysqld: ready for connections. Jan 10 15:35:55 www mysqld[2652]: Version: ' 4.1.11-Debian_4sarge2-log' socket: '/var/run/mysqld/mysqld.sock' port: 43306 Source distribution All looks good so far here is my my.cnf file [EMAIL PROTECTED]:/etc/mysql# grep -v ^# my.cnf [client] port= 43306 socket= /var/run/mysqld/mysqld.sock [mysqld_safe] socket= /var/run/mysqld/mysqld.sock nice= 0 [mysqld] user= mysql pid-file= /var/run/mysqld/mysqld.pid socket= /var/run/mysqld/mysqld.sock port= 43306 basedir= /usr datadir= /var/lib/mysql tmpdir= /tmp language= /usr/share/mysql/english skip-external-locking key_buffer= 16M max_allowed_packet= 16M thread_stack= 128K query_cache_limit= 1048576 query_cache_size= 16777216 query_cache_type= 1 log-bin= /var/log/mysql/mysql-bin.log max_binlog_size= 104857600 skip-bdb [mysqldump] quick quote-names max_allowed_packet= 16M [mysql] [isamchk] key_buffer= 16M here is the variables from mysqladmin -u root -p variables +- +--+ | Variable_name | Value | +-+--+ | back_log| 50 | | basedir | /usr/ | | bdb_cache_size | 8388600 | | bdb_home| | | bdb_log_buffer_size | 0 | | bdb_logdir | | | bdb_max_lock| 1 | | bdb_shared_data | OFF | | bdb_tmpdir | | | binlog_cache_size | 32768 | | bulk_insert_buffer_size | 8388608 | | character_set_client| latin1 | | character_set_connection| latin1 | | character_set_database | latin1 | | character_set_results | latin1 | | character_set_server| latin1 | | character_set_system| utf8 | | character_sets_dir | /usr/share/mysql/charsets/ | | collation_connection| latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server| latin1_swedish_ci | | concurrent_insert | ON
quick question about set
OK quick question, Is there a limit to the amount of data the can be defined when I create a field as a set. I am looking to have about 39 words in there at the moment I have them in another table and have an index pointing to them, but would like to move them to a set. if it is possible thanks Lance Rochelle [EMAIL PROTECTED] http://ulands.idlegames.com (607) 775-2681 --- Being a Systems Administrator is like hitting yourself in the bead with a brick. After a while you don't feel the pain. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs. AS/400
OK mine are more respected :) j/k another point of view. 1st You are assuming this only runs on Intel machines. I have MySQL running on a Sun E-4500 (8 x400mhz procs / 8GB RAM) running Solaris 8 on a financial institution on a very mission critical application. 2nd IBM support is piss poor at best unless you are on their 'call list' in which is it is almost as good as Microsoft's, plus the amount of money you would pay for support I better get a Full Time SE on-site. 3rd You are assuming that everyone runs this on a ISP budget. We have ours attached to an EMC array snapshot backups, well you got the idea. three way mirror with another machine that is attached the EMC the third mirror breaks we back it up then put the 3rd mirror back in-line. 4th a full TCP stack don't you mean a full IP stack. 5th Java is now available, I have been using that for almost 2 1/2 years now. 6th Security is best left up to the Security person (a good SA can secure a system) but then again the only true secure system is one that is turned off and locked in a closet. Where everyone who had a key to the closet melted it down and it requires a retina scan from JFK. (wait that might be to much) I do have to give IBM so credit some of their apps are Open System 'like'. - Original Message - From: Rich Duzenbury [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 3:00 PM Subject: Re: MySQL vs. AS/400 I realize my opinion may be unpopular in this forum, however, I have to say that if it's mission critical, I would want an IBM AS/400. As a consultant, I work with numerous hospital and health care companies that each manage tens of gigs of data on their machines. There is very little unscheduled downtime, and the machines have a great track record. All sorts of configurations are available, from small machines to quite large multi CPU boxes, much larger than my perception of intel boxes. All manner of redundancy is available, directly from IBM with quite complete support: Unprotected disk, Mirrored disk, as well as numerous hardware RAID arrays with and without hot swap capabilities. The backup facilities match the capabilities of the disks - large automated tape arrays are available for completing unattended backups, and the operating system has built in save-while-active technology. In other words, a complete snapshot of the system can be taken while the users are using the database, and it does not interrupt their work. The AS/400 is a made for business machine which excels at data storage and retrieval. The primary programming language on the box is RPG, which is extremely effective at building database applications of the kind you would also consider building with MySQL. I've never found an environment that matches it in terms of being able to build an application system quickly. On top of all that, IBM has made a commitment to make the box more open system accessible. There is a full TCP stack, so the internet is completely accessible. Java is now available on the machine, along with some extensions for accessing the database and other internal machine facilities. Also available are a C compiler, and full access to the standard C library from any integrated language environment. Further, the machine can act as a web server either through the IBM http server, or the Apache web server. The machine is also designed for high security implementations. There is a definite layer between the internal system and the user program level that is difficult to penetrate. Every program and file can be secured in numerous ways, up to an including a list of only authorized user id's that are allowed to use it. If that doesn't convince you, be aware that you may also install an intel based linux server (called an X-series by ibm) into an AS/400, and share some of the AS/400 advanced hardware, such as disk and RAM with the linux hardware. As far as your question regarding the sharing of data, you may move data off the machine through a socket client program. You could write a program on the 400 to collect records, put them in a buffer, and transmit them to a socket server on your linux machine. The socket server on the linux machine could be a perl program as I understand it, although you may want it to be a bit faster by writing it in C. I was hoping for an AS/400 mysql client, but no such port has been done -- I've got the code here, but it looks like such a big job, I'm not sure I'm up to the task. Regards, Rich At 04:37 AM 9/11/01, Toni Mueller wrote: Hello, I need some facts on how MySQL compares to an AS/400 with their integrated data base engine. I'm talking to an AS/400 user who claims that there is no software in the market that can hold up against the AS/4000 in terms of speed and reliability. One claim is that it didn't fail him once in 15 years, and speed is
Re: MySQL Sock error
Actually it came sometimes be worse in *nix depending on how anal retentive your administrator is. - Original Message - From: adam [EMAIL PROTECTED] To: MySQL Mail List [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 12:20 AM Subject: RE: MySQL Sock error Thank you everyone who helped :o) I got MySQL up and running... as it turned out it was a permissions problem... go figure.. i hoped i left that all behind with NT :o) -Adam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sorry if this is a duplicate got a failure notice back: SQL basica question again
Sorry I am new to SQL and any help would be greatly appreciated Here is my table CREATE TABLE host_list ( number mediumint(9) NOT NULL auto_increment, date datetime NOT NULL default '-00-00 00:00:00', hostname varchar(75) NOT NULL default '', PRIMARY KEY (number) ) TYPE=MyISAM; here is my sql query SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER BY count DESC here is my current output 283 host1 210 host2 200 host10 110 host 3 . 1 host941 what I would like to do is list say just the hosts that have greater then 10 in the left column Lance Rochelle [EMAIL PROTECTED] http://ulands.idlegames.com (607) 775-2681 --- Being a Systems Administrator is like hitting yourself in the bead with a brick. After a while you don't feel the pain. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL question
SQL question which I am new to. How would I count the number of times a specific entry is in field. For instance I have a table that has the following two fields numberhostname 1 10.1.1.1 2 10.1.1.2 3 10.1.1.3 4 10.1.1.1 and I want the query to return something like the following 2 10.1.1.1 1 10.1.1.2 1 10.1.1.3 What I may be asking may need to have an external program but I figure it might be able to be done inside one SQL statement. Lance Rochelle [EMAIL PROTECTED] (607) 775-2681 --- Being a Systems Administrator is like hitting yourself in the bead with a brick. After a while you don't feel the pain. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php