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

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 yu.watan...@jp.fujitsu.com It seems that MYD is the data file but this file size seems to be not increasing after the

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. Thanks,

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

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 helpful

Re: Monitor 'mysqladmin flush-hosts'

- Original Message - From: Brent Clark brentgclarkl...@gmail.com 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

Re: Data file for MyISAM engine

- Original Message - From: Yu Watanabe yu.watan...@jp.fujitsu.com 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

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 of