We just installed MySQL 4.1.7 (we were previously using 4.0.22)

Our applications have now become extremely slow. When executing
queries directly on the database server, our response times are "228
rows in set (0.00 sec)" When we execute them from our development
servers (via mysql query browser, or using Connector/J) we get 228
rows in 5172 msec.

I do not really know what to do to try to determine the cause of the
slowdown. Using trace route there is only one hop directly to the DB
server and large files transfer lightning quick so I do not think it
is a network problem, but rather a MySQL connection problem.

Can someone please provide a pointer or two to try to determine what
is going on? 4.0.x was significantly faster, but I now need
subqueries.

Thanks in advance,
Frank

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

Frank,

If you provide more informations like the query and how
many rows it returns, it should be easier help you.

Ronan



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

Thanks for the response....

The query is: select * from cmContent;
The query returns 228 rows.

mysql> describe cmContent;
+-------------------------+------------------+------+-----+---------------------+----------------+


Really nothing special to speak of.

Thanks for helping me out,
Frank

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

Hmmm...
The MySQL-client is 4.1.7, too?

I realy don´t know if it make some difference, but perhaps
it does.

Ronan



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

The localhost mysql command is version 4.1.7-standard

The remote query browser is version 1.1.1 gamma
The remote JDBC driver is version 3.0.16-ga

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

Frank,

Wouldn´t it because the client driver (ODBC version)?
Perhaps it´s faster in the local server because it uses a mysql-4.1.7
client.

Ronan



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

Frank Febbraro wrote:
Are you seeing the slowdown only from your java app? Or from all clients?

In the changelog for the 3.0.16 connector, they disabled BufferedInput
as they were having problems with it on some systems. You should be
able to pass useUnbufferedInput=true in the jdbc url to get this back.
I think they are working on their own implementation to get buffered
input back in the new 3.1 connector.

Greg

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

I see this slowdown from my java app AND from the remote MySQL client
application (called MySQL Query Browser 1.1.1 and 1.1.2). Basically I
see the slowdown from all clients that are remote machines, but I do
not see it when I execute the queries on localhost (the server on
which the database is running)

I experienced the slowdown with the 3.0.15 driver so I upgraded to the
3.0.16 driver and have the same problem.

Any insight?

THanks again,
Frank

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Frank Febbraro wrote:
Frank,

What character set are you using in the JDBC driver? Does it happen to
be utf-8?

-Mark

- --
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
Office: +1 708 332 0507
www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBtfk7tvXNTca6JD8RAqIKAJ9VWXpIxD0NNJwShZrcgN pjwklJ4gCgmINX
bCCMT15MyxvqqWe5G6LZ2q8=
=a6bd
-----END PGP SIGNATURE-----

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw

Got me then?! I am still running 4.0.22. Waiting for the connecter/J
to come out of gamma and for 4.1.* to stabilize a bit, so I can't offer
much other than what I have read.

Frank Febbraro wrote:

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=m...ie.nctu.edu.tw