, it is an advantage if OpenBSD doesn't destroy the MyISAM files,
however, this is a MySQL replication setup with backups and everything.
The client replicants are available in quite a large number. You could
speak of a read-only load balance cluster of MySQL machines.
If one dies? Who cares, reinstall
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daniel Ouellet wrote:
Marian Hettwer wrote:
060915 17:33:29 [Warning] /usr/local/libexec/mysqld: ignoring option
'--low-priority-updates' due to invalid value 'ON'
- -- Seems like that parameter doesn't exist anymore in MySQL 5.0 ...
I'll
Marian Hettwer wrote:
Q: How can I use replication to improve performance of my system?
A: You should set up one server as the master and direct all writes to
it. Then configure as many slaves as you have the budget and rackspace
for, and distribute the reads among the master and the slaves.
Marian Hettwer wrote:
Starting by looking at errors and then making sure a replication setup
doesn't have any errors is always a good thing before saying it doesn't
work. So, when no errors happen, may be many things will work just fine.
I haven't said that it doesn't work. I said its bloody
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Daniel,
Daniel Ouellet wrote:
Marian Hettwer wrote:
As soon as replication starts, mysql gets very unresponsive:
- -bash-3.1$ time mysqladmin -uroot -p proc stat
Enter password:
25222 _mysql-50 185M 50M sleep/0 biowai 0:14 1.42% mysqld
Well... to me it looks like the box is idle... why is MySQL still pretty
unresponsive (I tend to say slow).
It's not idle, it's waiting for i/o to complete.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hej Stuart,
Stuart Henderson wrote:
On 2006/09/18 11:46, Marian Hettwer wrote:
Okay... but by looking in iostat, it looks like pretty low traffic. 1 to
2 MB/sec. A higher number of transfers per second, though.
You only sent that to me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- -BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stuart Henderson wrote:
25222 _mysql-50 185M 50M sleep/0 biowai 0:14 1.42% mysqld
Well... to me it looks like the box is idle... why is MySQL still pretty
unresponsive (I tend to say
Marian Hettwer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Daniel,
Daniel Ouellet wrote:
Marian Hettwer wrote:
As soon as replication starts, mysql gets very unresponsive:
- -bash-3.1$ time mysqladmin -uroot -p proc stat
Enter password:
Okay... but by looking in iostat, it looks like pretty low traffic. 1 to
2 MB/sec. A higher number of transfers per second, though.
You are right! Yes But the question is also, is there something else then...
A few ideas below. Sure not all apply for sure, but just to show you
that assuming
Marian Hettwer wrote:
As soon as replication starts, mysql gets very unresponsive:
- -bash-3.1$ time mysqladmin -uroot -p proc stat
Enter password:
++-+---++-+--+---+--+
|
11 matches
Mail list logo