1. Get rid of the offending $hostname.index file that keeps track of
binlogs (Thanks, Olaf!).
2. Fix permissions (Thanks, Gerald Clark!).
Have a nice day!
Chris
On Jul 18, 2007, at 2:19 PM, Olaf Stein wrote:
You have bin log enabled and it might be looking for the last bin
log
Hi there,
Is it true that problems related to error 11 are most likely bugs in MySQL?
I have a query involving a union statement with a group and order by
statement around it. The total data that has to be handled by the union
statement is in the 100,000 or millions rows. I am using Windows
Hi,
What does exactly happens when the AUTOINC lock is
happening ?
Why is it not a problem on our amd (quadcore) machine
with the data sitting on a raid10 partition, we have
never seen this problem before, its apparently
happening so fast that it doesn't matter.
With the intel machine
all,
I have need to simulate the somewhat unique behavior/properties of an Oracle
sequence object in MySQL (obviously for porting legacy code).
I have come up w/the following solution which seems to work but wanted to
run it by the collective to see if I failed to consider anything:
create
It is exactly the same process. InnoDB and MyISAM are about the
storage engine, the replication is quite seperate.
Initializing it is a bit more challenging.. there are some quick
low-level approaches but the simplest way is to populate your slave
from a mysqldump file.
- michael dykman
On
Whenever I alter a mysql table like add a new field it gets really slow and
all other processes lag.
Is there a memory variable I can adjust for this?
--
View this message in context:
http://www.nabble.com/MySQL-slow-when-altering-tables.-tf4119161.html#a11714643
Sent from the MySQL - General
On Fri, July 20, 2007 12:32, Andrew Rosolino said:
Whenever I alter a mysql table like add a new field it gets really slow
and
all other processes lag.
Is there a memory variable I can adjust for this?
--
View this message in context:
Without more information it might be hard to answer. A
I'm looking for some clarification with the documentation for the rules
regarding the binary log.
In the Binary Log portion of the docs (
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html ) , in the part
where it's showing the evaluation steps used to determine what gets
written to the