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? How

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 ---

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 F

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 qu

Re: MySQL 3.23.35 is released

Hello all; Sorry to sound a little naive, but what is this new GEMINI thing I have been reading about? Is there any FAQ/Docs on it or what is so neet about it?? Thanks! Patrick - Original Message - From: Greg Cope <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent:

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 -Origina

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

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 be

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

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 a

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 # http://www.mysql.com/doc/R/e/Replication

RE: Auto_increment or manual??

Hummm, this is very interesting. It looks like using an AUTO_INC will work ok for a "1 master to many slaves" ok, but for mixed mode replication "many master to many slave" this would work out quite well, therefor not to stumble on eachothers unique keys generated. However, what about this approac

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 ok

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 PROTECT

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 this).

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: http://www.mysql.com/informat