Got timeout reading communication packets

Hello, I am running MySQL 3.23.37-log and I was looking at my .err log file. What I found was a ton of entries like this one: 010709 16:35:01 Aborted connection 1040 to db: 'xsparts' user: 'xsparts_user' host: `localhost' (Got timeout reading communication packets) Any idea what this means?

RE: ACCESS DB, and MySQL which one better to handle database driven webpage

First off, I wouldn't really want to call Access a database, as its little more than just a file with 1/2 of a program trying to access it. And second, I would say that MS SQL is both over-priced, and way too bloated, buggy, slow, etc, etc. (but then again, everyone has their own opinion on

RE: what is the difference between, MDB and MySQL

Well, that all depends on what language your apps are written in. VB? Delphi? C? PHP? Perl? and what database architecture are you using within the language (ie, in VB are you using ADO, or ODBC, or DAO, etc)... Also, for a good comparison of databases, look at this:

RE: [MySQL] DATE_FORMAT

$Result = @mysql_query (SELECT DATE_FORMAT(EventStartDate,'%M %D %Y') AS EventStartDate FROM EventsTable); $Row = mysql_fetch_array($Result); printf(Event Date:%s, %Row['EventStartDate']; Hope this helps :o) --Patrick # -Original Message- # From: Tim Thorburn [mailto:[EMAIL

RE: RTFM - Show locks

I too have wondered this... it looks like the manual just says (in your case) user 'b' will wait indefinitely for the lock held by user 'a' to be released. Maybe you could just have user 'a' hold a READ or READ LOCAL lock and not a WRITE lock, therefore user 'b' will still be able to do SELECTS

Auto_increment or manual??

Hello! I have a database with about 10 tables in it. In every table I have a RECORD_ID field so that I can at least uniquely identify a row if I need to, also its used in relationships. The question is should I use the AUTO_INCREMENT for this, or should I manually generate this value, getting the

RE: Auto_increment or manual??

This sounds encouraging, but are there any known problems with the MySQL replication model currently available?? Would the slave servers have the same auto_inc column attributes? Could this conflict somehow with the master server?? Thanks for the quick reply! Patrick # Personnaly, i have found

RE: Auto_increment or manual??

Thank you Chris with this info! This will greatly help me out, so as I see it now, there is absolutely no advantage to generating your own unique numbers manually - just let MySQL do it for you am I correct in this assumption? Again, thanks! Patrick #

What is most stable??

How stable is InnoDB, BDB, MyISAM, etc?? I am developing a production system using MySQL, and wanted to know that stability status on these table types. I wanted to use transactions if I could - is the transaction-enabled table types stable enough for production? Or should I stick with MyISAM and

How Stable is InnoDB / BDB

I am in the process of building a database/php app that is going to require transaction support. Which table type should I go with? BerkeleyDB or Innobase?? It looks like the InnoDB has some neat features like row-level locking, etc. but is it stable enough for a production system, or should it

RE: Need help with a Freebsd install..

Larry, if you haven't resolved this yet - you might want to install from the sources, like I do. I am also running FreeBSD 4.2, here is what I did, and it seems to work like a champ. 1) get the source from www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.37.tar.gz 2) put this file in some directory

RE: Inserting data to multiple table at once

Yeah, it does require one insert command per table, thats why some people like transaction capability in tables. If we all could insert data into multiple tables with one insert command then we wouldn't need transaction support would we? H, that would be nice though! :o) Patrick

Re: INSERT records into multiple tables

Yeah, this is why some people like the idea of having transaction supports in the tables, to make sure both the inserts to the two tables succeed, or none of them do. Currently MyISAM does not support this, only the newly introduced Berkeley DB tables support this feature although it is assumed

RE: Simple Multi-Master/Slave Fail-Over Set Up {Was Re: parallel Mysql ?}

You might want to take a look at this site: http://www.phpbuilder.com/columns/tanoviceanu2912.php3 --Patrick -Original Message- From: Van [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 15, 2001 8:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Simple Multi-Master/Slave

MySQL Database and NAS

Hello all; Are there any known problems with storing the database files on a NAS (network attached storage) device?? also, can you run multiple MySQL daemons pointing to one common database, so you could have a "cluster" of database servers and one database?? Thanks! Patrick