On Wed, May 16, 2001 at 03:01:26PM +0300, Heikki Tuuri wrote:
> Andreas,
>
> sorry, it is the default MySQL behavior to create a MyISAM table if
> another handler is not present.
>
> There was a long thread of emails between MySQL developers if MySQL
> should give an error message if a table can
Hi!
At 05:04 PM 5/16/01 +0200, you wrote:
>>>4) Ok, datafiles created overnight. Now trying alter table ...
>>type=innodb
>>on a
>>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>>files
>>this
>>>size is going to be problematic. Machine pegs with load of around 12! I
>
Hi!
I already found an easy solution. Write to the file in 16 MB chunks
instead of 1 MB chunks. Then I got 5 MB/s on our Linux Xeon.
I do not think MyISAM uses fsync at all. I need fsync because in
recovery I must know that some database pages have been cleanly written
on disk.
These fsync thin
>>4) Ok, datafiles created overnight. Now trying alter table ...
>type=innodb
>on a
>>file with 1.2mil records. Still waiting after about 12 hours. Dumping
>files
>this
>>size is going to be problematic. Machine pegs with load of around 12! I
>suggest
>>LOTS more testing on BIG tables. Small
Andreas,
sorry, it is the default MySQL behavior to create a MyISAM table if
another handler is not present.
There was a long thread of emails between MySQL developers if MySQL
should give an error message if a table cannot be created to be of
type BDB or InnoDB because the handler is not presen
Hello,
From: Richard Ellerbrock <[EMAIL PROTECTED]>
> Just installed MaxSQL 3.23.38 on a test system to check out InnoDB.
> Here are my observations:
May I add my ones ...
If there are some missing entries in the my.cnf or the INNODB
handler can't be started because of permission problems a
Richard,
I made some measurements with fsync. If I create first the big data file
without O_SYNC and after that make a single fsync, I get a write speed
of 5 MB/s, which is 5 times more than with O_SYNC.
On the other hand, opening a log file in the O_SYNC mode makes commits
much faster than by c
Richard,
thank you for the observations. Some comments:
>Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here
are my
>observations:
>
>1) Manual is not clear on permissions of directories - They should be
mysql.root
>owned. The error in the error log just says cannot create
