One thing I left out is that we are running 4.1.8-Max-log not
4.1.8-standard-log
Could that have anything to do with it?
Thanks for any insight,
Frank
On Mon, 17 Jan 2005 15:55:06 -0500, Frank Febbraro
[EMAIL PROTECTED] wrote:
Hey all,
I have setup replication in the past on 4.0.x
- make sure log-bin is enabled on both master and slave (looks like it is not
present in the slave config)
Why is log-bin needed on the slave? I thought the master logs changes
and the slave reads those changes and updates it's copy. Why should
the slave also log changes it is making? There
Hey all,
I have setup replication in the past on 4.0.x servers so I figured I
knew what I was doing...silly me. I reread all of the docs and best I
can tell I followed them sufficiently.
When I start my slave, the SQL Thread starts, but the I/O thread never
starts, and thus the Master Thread
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,
Thanks for the response
If you provide more informations like the query and how
many rows it returns, it should be easier help you.
The query is: select * from cmContent;
The query returns 228 rows.
mysql describe cmContent;
The MySQL-client is 4.1.7, too?
Yes
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:
Are you seeing the slowdown only from your java app? Or from all clients?
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
What character set are you using in the JDBC driver? Does it happen to
be utf-8?
I have tried it with both utf8 and latin1, no difference in delay.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have tried it with both utf8 and latin1, no difference in delay.
Sorry, to be more specific.
I have tried it originally with everything as UTF-8 (database, tables,
connections) I thought that the encoding could be the problem so I
converted/configured everything to latin1 (ISO-8859-1) and
This might be related to a bug I filed a couple months ago, assuming
your server is running on Windows
http://bugs.mysql.com/bug.php?id=5787
Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be exact.
--
MySQL General Mailing List
For list archives:
This might be related to a bug I filed a couple months ago, assuming
your server is running on Windows
http://bugs.mysql.com/bug.php?id=5787
Sorry, I did not mention it, we are running on Linux, Fedora Core 3 to be
exact.
My client machine (the remote machine in this mix) is a
The final question, does the windows box have reverse DNS setup for it? If
not add it to the /etc/hosts file on your fc3 linux box. And reconnect to
mysql.
WOW! That was it. Things are lightning fast now.
Sorry for going completely down the wrong path.
What would have been the best way to
I've been using mysql 4.1 since the first day it was out; it's all been
trial and error. If I remember correctly, I found it on 4.1.0 when I was
doing a processlist, and noticed that some of the boxes connecting to mysql
had reverse and others didn't. So now we actually go to the /etc/hosts
13 matches
Mail list logo