Re: fastest filesystem for MySQL
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
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
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
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
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
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
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]