Greetings!
We are glad to announce MicroOLAP Database Designer for MySQL version
1.9.9 release (July 29, 2009).
This release introduces Wine support, new diagram drawing algorithm,
several minor improvements and bugfixes.
Product page: http://microolap.com/products/database/mysql-designer/
Fu
Before I simulate a total server failure, master1 is using binary file
msyql-bin1 position 2231467 and it's slave master2 is following the
correct file at the correct position. This is after initial setup. Once I
restart master1, it will then start to use msyql-bin2 position 98 and
mas
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing which but during this time the server is unresponsive. I
would like to determine if there is a poorly optimized query causing
this. I'm log
Bryan,
How are you restarting mysql? In the case a master crashes, it's definitely
common for the slave to miss the fact that the master is using a different
binlog. The slave advances to a position past the end of the previous binlog,
and stops with and error like "tried to read impossible po
Entries in the slow log have a timestamp. You can read the file directly, but
it's much easier to use a tool like maatkit for parsing the results of the log.
Try this:
http://www.maatkit.org/doc/mk-query-digest.html
Regards,
Gavin Towey
-Original Message-
From: Milan Andric [mailto:ma
Yes I am trying to simulate total failure. In this test case I am using 2
Virtual Machines and I just kill one and then when it comes back I have the
challenge described.
How can I go about getting the slave back in tune with the newly restarted
master?
Thanks
-Original Message-
From
On Fri, Jul 31, 2009 at 8:14 PM, Milan Andric wrote:
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing which but during this time the server is unresponsive. I
would like to determine if th
Bryan,
When the slave encounters that error, you can simply set it to replicate from
the next binlog file in the sequence starting at position 98. It should be
easy to have a script automate this process.
Regards,
Gavin Towey
-Original Message-
From: Cantwell, Bryan [mailto:bcantw...@
Michael,
We're counting on batch inserts of constant 2 leftmost columns of the
primary key.
We would be selecting within constant values for the leftmost columns as well.
For example, our primary key is
country_id, city_id, auto_inc, ...
We'll always be looking for data from within the same coun
