Re: innodb space free decreasing by more then the amount of data we're adding

;>>> 2011/11/22 12:44 -0800, Sean Sidelko We just moved a large amount of data off one of our db servers to another one (75gb of data). One thing I've noticed is that over the last couple days the free innodb space has been decreasing by over 2.5 gb a day while we've only been adding 400 mb

Re: Data file for MyISAM engine

- Original Message - > From: "Yu Watanabe" > > So, which memory corresponds to 'pages' for the MyISAM then? > It would be helpful if you can help me with this. None, as Reindl said. This is not a memory issue, it's a function of I/O optimization. Records are stored in pages, and pages a

Re: Monitor 'mysqladmin flush-hosts'

- Original Message - > From: "Brent Clark" > > I was wondering. Is there anyway Mysql can be monitored for when you > need to run mysqladmin flush-hosts? You'd only need to run that when the DNS entries for a client changes, so it's not really a mysql monitoring issue. Usually, that's r

Re: Data file for MyISAM engine

you should try to understand what pages are your data + keys + fragmentation overhead if deleted records are the size of the files Am 24.11.2011 10:46, schrieb Yu Watanabe: > Hi Reindl. > > Thanks for the reply. > > So, which memory corresponds to 'pages' for the MyISAM then? > It would be help

Re: Data file for MyISAM engine

Hi Reindl. Thanks for the reply. So, which memory corresponds to 'pages' for the MyISAM then? It would be helpful if you can help me with this. Thanks, Yu Reindl Harald さんは書きました: >key buffer is memory and has nothing to do with file sizes >filesize increeases by data and keys >key buffer is as

Re: Data file for MyISAM engine

key buffer is memory and has nothing to do with file sizes filesize increeases by data and keys key buffer is as the name says a memory-buffer for kyes Am 24.11.2011 10:25, schrieb Yu Watanabe: > Hello Johan. > > Thank you for the reply. > I see. So it will depend on the key buffer size. > > Tha

Re: Data file for MyISAM engine

Hello Johan. Thank you for the reply. I see. So it will depend on the key buffer size. Thanks, Yu Johan De Meersman さんは書きました: >- Original Message - >> From: "Yu Watanabe" >> >> It seems that MYD is the data file but this file size seems to be not >> increasing after the insert sql. > >

Fwd: 'myisam_use_mmap' unstable like hell

and the next one without "memlock" 24 09:50:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 24 09:50:35 mysqld_safe Starting mysqld daemon with databases from /Volumes/dune/mysql_data 24 9:50:35 [Note] Plugin 'InnoDB' is disabled. 24 9:50:35 [Note] Plugin '