MySQL 5 is 25% slower then 4.1

Dear MySQL fans, I have a 260 GB huge file with 1045175762 rows. Two weeks ago, I wrote a Java program to read the huge plain text file into MySQL 4.1.12. 300 million of rows could be loaded in one day. Last Thursday, I updated the MySQL to 5.0.16 and then run the same program. Only 225 mi

Re: Moving databases from backups not working . . .

Thanks for the replies so far, I still haven't got this figured out, but I left out one important piece of information. I'm moving 3.23 databases to a 4.1 installation. Looking at the documentation, I see instructions for upgrading from 3.23 to 4.0 and then upgrading from 4.0 to 4.1. Does that mean

Re: ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

On 5/12/2005 11:56 a.m., Mike Smith wrote: Hi, Hi, I've already check my /etc/my.cnf file for a "binding" line. Its not there. I also found an item online that indicated adding: Look for the option "skip-networking". This disables TCP/IP so the server only accepts local connections v

sporadic batch update problem

Sporadically, the last few entries of a batch are not written. I'm writing to a mysql database using JDBC. Here's a short version of my code. Does anyone have suggestions on possible causes or other diagnostics? class DatabaseWriter{ int writeCount=0; public DatabaseWriter(){ PreparedStat

Re: parse error creating table

Hi Ferindo >The intended effect is to get a timestamp field that inserts the current system >time on inserts and continues to update the field with the current timestamp >on updates without the application or use needing to specify it are you >saying that the timestamp attribute alone wil

Re: parse error creating table

Thanks Peter. I did originally use this table in a Postgresql db. Thanks for you advice. Your suggestions below allowed me to create this table and I learned a thing t two about proper usage of the TIMESTAMP data type. The intended effect is to get a timestamp field that inserts the current sys

ERROR 2003 (HY000): Can't connect to MySQL server on 'gandalf' (111)

Hi, I've been dealing with this problem for a week now without resolution. I'm running an application called mythtv which uses mysql as its database. I've installed mythtv and mysql dozens of times without any problem. I'd been running two Mandrake 10.1 systems for the last nine months. One, gand

Re: parse error creating table

Ferindo One problem is: employment_status_id INTEGER REFERENCES employment_statuses(id) NOT NULL, NOT NULL should be before REFERENCES. Also, in: last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL, (i) NOT NULL is superfluous since the default is given by CURRENT_TIMESTAMP. (ii)

triggers? when they execute and locking

Im am trying to implement a task running system with mysql and Im coming across a few problems with what I am trying to do. Simply I am trying to insert a list of tasks into the DB for various computers to run, I want to track when they ran and where they ran. I also have to limit some of

INSERTS slower after upgrade from 4.0 to 5.0?

Hello! I wanted to upgrade from 4.0.16 to 5.0.16, but already notized a slow performance on restoring data with INSERTS. When dumping a table with mysqldump (4.0.16) and then restoring it with mysql <<, which consists only of INSERTS, the duration increases. For test reasons I have tried it

parse error creating table

I have been trying to create a table but mysql 5.0.15-nt-max is having a problem parsing the statement. Anyone know what the problem is in the syntax of the following table creation statement: CREATE TABLE registration_and_attendance ( idSERIAL NOT NU

Re: Band width consume

The bandwidth that mysql itself consumes is negligible. If you are connecting to a server across the net the majority of your bandwidth consumed is your result sets coming back. If you are talking about a single database then figure out what your average result set is and multiply that times t

Re: Band width consume

I don't have any stats but I would assume it's as big as your select statement plus as big as the result set. Mike - Original Message - From: "Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> To: Sent: December 4, 2005 7:02 AM Subject: Band width consume > Dear Friends > > Is their an

Band width consume

Dear Friends Is their an Page with data of how much bandwidth mysql consume when using remote servers? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: /etc/init.d/mysql hangs

On 12/3/05, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > > Hello. > > > > Check if you're able to start server manually using mysqld > > or mysqld_safe commands. Research error logs. See: > > http://dev.mysql.com/doc/refman/5.0/en/starting-server.html > > > > > Thanks. Running mysqld directly show

Band width consume

Dear Friends Is their an Page with data of how much bandwidth mysql consume when using remote servers? Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

.NET Connector Output Values

I have the following code: ... query = "INSERT INTO a_test_table (a_test_table_id,name,last_mod_date,create_date) VALUES (?a_test_table_id,?name,?last_mod_date,?create_date)"; ... command.Prepare(); ... command.Parameters.Add("?a_test_table_id", MySqlDbType.Int32); command.Parameters["?a_test_