I've been told that InnoDB on a raw partition is the fastest setup.
Actually, you've been told that it's probably the fastest.
Correct. Sorry :)
Check the InnoDB docs. They explain how to setup raw disk
partitions. You'll be using device names, not mount points.
Thanks. I forgot to check the man
I've been told that InnoDB on a raw partition is the fastest setup.
To setup my system for this, could I create a partition called /innodb
and adjust the my.cnf like this?
innodb_data_home_dir = /innodb
innodb_log_group_home_dir = /var/lib/mysql/
innodb_log_arch_dir = /var/lib/mysql/
I suppose t
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
I am considering this:
mysqlbinlog --database=mydb logfiles | mysql -f
There is a faster way, but it is rather tricky.
4.0 slave can be tricked into thinking that those binary l
The InnoDB storage engine can use raw disks without a filesystem.
Would that be the fastest possible setup?
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need to restore 20 gigabytes of binary logfiles.
What should I do in order to get the job done as quickly as possible?
I am considering this:
mysqlbinlog --database=mydb logfiles | mysql -f
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
>> I've heard and read that the Reiser filesystem should be better for
>> MySQL than Ext3. Is this still true?
>>
>> We will be running MySQL on either Red Hat ES 3, Suse or Debian.
>>
Completely depends on your situation -- big files, small files? Lots of
writes or reads or both? Growing tables/f
I've heard and read that the Reiser filesystem should be better for
MySQL than Ext3. Is this still true?
We will be running MySQL on either Red Hat ES 3, Suse or Debian.
Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my