Re: fastest filesystem for MySQL

[JFL]

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]

Re: Restore 20 gigabytes of binary logfiles

[JFL]

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 logs are in 
fact the relay logs that it gathered from the master. So we trick the 
server into thinking it is a slave of the server that produced them. You 
just need to pick a server-id that is not the same as the one that 
produced them. Then if you list the logs in in the relay log info file 
in the correct order, hand-craft relay-log.info file to point at the 
first one), then start the slave with skip-slave-start, and then just 
start the SQL thread manually (SLAVE START SQL_THREAD), it will process 
them until it is done. Periodically run SHOW SLAVE STATUS to see if it 
got to the end of the last log.
Would that be faster than having converted the binary logs to sql 
commands in one file and then use that?

Thanks for your help,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB filesystem

[JFL]

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 that innodb_log_group_home_dir and innodb_log_arch_dir can not 
be on a raw disk?

Any other tips, pros and cons?

Thanks,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB filesystem

[JFL]

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 manual.

Any other tips, pros and cons?
Pros: performance and bypassing the filesystem cache.

Cons: loss of transparency and limited backup options.
What do you mean by transparency?

Thanks for your help,
Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Restore 20 gigabytes of binary logfiles

[JFL]

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:http://lists.mysql.com/[EMAIL PROTECTED]

fastest filesystem for MySQL

[JFL]

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.mysql.com/[EMAIL PROTECTED]

Re: fastest filesystem for MySQL

[JFL]

 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/files or lots of large dropped 
tables?
It's for a community site.
Lots of small data reads, less writes, many updates, and few deletes.
If you're into small files, go Reiser. Big data, JFS or XFS. 
EXT3 is slow, but, IIRC, it also is a true data journaling filesystem 
while some of the others aren't (and that's as deep as I go without a 
life-vest, if you know what I mean!).


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]