mycnf components for myisam storage engine

2007-11-21 Thread Krishna Chandra Prajapati
Hi All, I am configuring mysql on a system for keeping only data of myisam storage engine type. So what component of my.cnf should i increase to get a good performance. Is it key_buffer or some more components are there. If yes then Please, let me know Thanks -- Krishna Chandra Prajapati MySQL

Re: ADDITIONAL SETTING IN MYCNF

2007-10-18 Thread Krishna Chandra Prajapati
Hi Samuel, The path /etc/mysql/conf.d/ is present in my.cnf file. When i checked conf.d/ contains a file named old_password.cnf The contents of the old_password.cnf is below #create by debconf [mysqld] old_password=false Thanks, Krishna On 10/18/07, Samuel Vogel <[EMAIL PROTECTED]> wrote: > > T

Re: ADDITIONAL SETTING IN MYCNF

2007-10-18 Thread Samuel Vogel
This line has not come later, it is standard in Debian, to be able to have parts of your configuration in different files. This line does all configuration files that are in "/etc/mysql/conf.d/. Since this directory is probably empty, nothing is done at all. So you are safe with just leaving th

ADDITIONAL SETTING IN MYCNF

2007-10-18 Thread Krishna Chandra Prajapati
Hi All, I have installed debian on a system and then install mysql. Later i found that in my.cnf file one more line has been add ie !include /etc/mysql/conf.d I don't know how it comes to my.cnf file. Is it going to harm mysql or OS. Why it has come. Please help me. Thanks, Krishna

MYCNF

2007-09-20 Thread Krishna Chandra Prajapati
Hi All, I am working on the mysql tuning (my.cnf). I would like to know that, if the parameters of mysql are too high or uneven. Then what is the impact on mysql. Whether mysql can crashed or what else. There is any tool or script which can show how much ram is being utilised. Thanks, Krishna