postcd
05-20-2014, 03:01 PM
Hello,
i have issue with mysql which writing alot of data to disk, mysql config appears to be optimised.
here is more about that: http://www.dbforums.com/mysql/1701717-mysql-write-too-much-data-disk.html
DB is 8gb in size around
total 7.8G
-rw-rw---- 1 mysql mysql 2.4G May 20 18:03 post.MYD
-rw-rw---- 1 mysql mysql 1.5G May 20 18:03 post.MYI
-rw-rw---- 1 mysql mysql 638M May 7 18:15 guestviews.MYD
-rw-rw---- 1 mysql mysql 606M May 20 18:02 postlog.MYD
-rw-rw---- 1 mysql mysql 336M May 7 18:21 moderatorlog.MYD
-rw-rw---- 1 mysql mysql 281M May 17 15:14 moderatorlog.MYI
-rw-rw---- 1 mysql mysql 252M May 20 18:02 postparsed.MYD
-rw-rw---- 1 mysql mysql 227M May 17 15:12 guestviews.MYI
-rw-rw---- 1 mysql mysql 181M May 20 18:02 tagthread.MYI
and the forum is quite a crap without big value. So i think about closing it and turing it into html somehow? Please is there any easy tool or process to do it?
i have issue with mysql which writing alot of data to disk, mysql config appears to be optimised.
here is more about that: http://www.dbforums.com/mysql/1701717-mysql-write-too-much-data-disk.html
DB is 8gb in size around
total 7.8G
-rw-rw---- 1 mysql mysql 2.4G May 20 18:03 post.MYD
-rw-rw---- 1 mysql mysql 1.5G May 20 18:03 post.MYI
-rw-rw---- 1 mysql mysql 638M May 7 18:15 guestviews.MYD
-rw-rw---- 1 mysql mysql 606M May 20 18:02 postlog.MYD
-rw-rw---- 1 mysql mysql 336M May 7 18:21 moderatorlog.MYD
-rw-rw---- 1 mysql mysql 281M May 17 15:14 moderatorlog.MYI
-rw-rw---- 1 mysql mysql 252M May 20 18:02 postparsed.MYD
-rw-rw---- 1 mysql mysql 227M May 17 15:12 guestviews.MYI
-rw-rw---- 1 mysql mysql 181M May 20 18:02 tagthread.MYI
and the forum is quite a crap without big value. So i think about closing it and turing it into html somehow? Please is there any easy tool or process to do it?