> - 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 w
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 th
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 neve
> 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/hos
> 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
> > 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
> 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: http://lists.mys
> 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 hav
> 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]
> 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 w
> 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:http://lis
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;
+-+--+--+-+-
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,
13 matches
Mail list logo
