Posts tagged EXT3

MySQL: Beware of sync_binlog on EXT3

Feb 23rd

Posted by Christian in Life

Well, I just glazed again over my my.cnf for our web-cluster because I just moved a database from one cluster to another and getting quite different performance from it. So, as I expected, there is a slight difference between both configuration files:

@@ -55,8 +58,6 @@
 innodb_log_group_home_dir       = /var/lib/mysql/db
 innodb_log_file_size            = 512M
 innodb_thread_concurrency       = 8
-sync_binlog                     = 1

And apparently, according to the MySQL Performance Blog that’s really, really bad (as well, we’re currently running without write caching, as the battery module of the storage is dead).

, ,

Linux: Getting information about an EXT3 filesystem

Feb 13th

Posted by Christian in Life

You know, I’m not getting any younger. It’s getting harder remembering every damn command … so here is how you get information out of your EXT3 filesystem:

sles10sp2 ~ [0] > tune2fs -l /dev/sda2 | grep "^Filesystem"
Filesystem volume name:   <none>
Filesystem UUID:          8eec8235-4d9e-4b58-acf9-3c68c977d5ea
Filesystem magic number:  0xEF53
Filesystem revision #:    1 (dynamic)
Filesystem features:      has_journal resize_inode filetype 
                          needs_recovery sparse_super large_file
Filesystem state:         clean
Filesystem OS type:       Linux
Filesystem created:       Tue May 27 10:48:56 2008
, ,
123»