On 09/12/2009, at 6:56 PM, machiel.richards wrote:
Good day guys (and girls if any)
I am constantly in a position where variables on a
production mysql database needs to be changed.
The database runs a 24/7 system and thus to reboot
is not
preffered and s
In the last episode (Apr 30), Krishna Chandra Prajapati said:
> I am worried about Key_blocks_unused. when Key_blocks_unused reach to
> 0. There will be no free blocks then how insert query will work.
The oldest block will be written to disk if it is dirty, and
discarded.
--
Dan Nelson
Krishna Chandra Prajapati schrieb:
Hi Dan,
I am worried about Key_blocks_unused. when Key_blocks_unused reach to 0.
There will be no free blocks then how insert query will work.
it is like any other cache system, if the cache is not usable (full, not
accessible or whatever) the cache will be
Hi Dan,
I am worried about Key_blocks_unused. when Key_blocks_unused reach to 0.
There will be no free blocks then how insert query will work.
Thanks
Krishna Chandra Prajapati
On Wed, Apr 30, 2008 at 10:42 AM, Dan Nelson <[EMAIL PROTECTED]>
wrote:
> In the last episode (Apr 30), Krishna Chandra
In the last episode (Apr 30), Krishna Chandra Prajapati said:
> Key_blocks_unused 952405
> Key_blocks_used395539
>
> Key_blocks_used is increasing day by day and Key_blocks_unused is
> decreasing day by day. Ater a month Key_blocks_unused will reach to
> 0. Do
At 6:12 PM -0500 7/15/01, Paul DuBois wrote:
>Sounds like that should do it. (O'Reilly also has a book "Using csh & tcsh"
Actually, after having problems finding this file I started looking
for a reference to buy and came across "Using csh & tcsh" and did
recognize the author. This book has a
At 12:39 PM -0700 7/15/01, Michael Collins wrote:
>At 11:09 AM -0700 7/15/01, Michael Collins wrote:
>>At 1:47 PM -0500 7/14/01, Paul DuBois wrote:
>>Any solution I've tried using the LassoMySQL/var/my.cnf or
>>~/.my.cnf files affect both the special installation as well as
>>the sta
At 11:09 AM -0700 7/15/01, Michael Collins wrote:
>At 1:47 PM -0500 7/14/01, Paul DuBois wrote:
>Any solution I've tried using the LassoMySQL/var/my.cnf or
>~/.my.cnf files affect both the special installation as well as
>the standard MySQL installation. I find I will always get the
At 1:47 PM -0500 7/14/01, Paul DuBois wrote:
Any solution I've tried using the LassoMySQL/var/my.cnf or
~/.my.cnf files affect both the special installation as well as
the standard MySQL installation. I find I will always get the
standard port.
>>>
>>>Settings in the [client] gr
>At 12:25 PM -0500 7/14/01, Paul DuBois wrote:
>>>Any solution I've tried using the LassoMySQL/var/my.cnf or
>>>~/.my.cnf files affect both the special installation as well as
>>>the standard MySQL installation. I find I will always get the
>>>standard port.
>>
>>Settings in the [client] group
At 12:51 PM -0500 7/14/01, MikeBlezien wrote:
>is this the default location it looks for a 'my.cnf' file or can
>this be defined
>some where?
Straight from the manual:
4.16.5 Option Files
MySQL Version 3.22 can read default startup options for the server
and for clients from option files. MyS
At 12:51 PM -0500 7/14/01, MikeBlezien wrote:
> >>On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
>>>
Also if a /etc/my.cnf is going to be used, once it's
been created does the MySQL server need to be shutdown and restarted to
recognize the new my.cnf
At 12:25 PM -0500 7/14/01, Paul DuBois wrote:
>>Any solution I've tried using the LassoMySQL/var/my.cnf or
>>~/.my.cnf files affect both the special installation as well as the
>>standard MySQL installation. I find I will always get the standard
>>port.
>
>Settings in the [client] group of your
>>On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>>
>>> Also if a /etc/my.cnf is going to be used, once it's
>>>been created does the MySQL server need to be shutdown and restarted to
>>>recognize the new my.cnf file??
>>
>>Yes.
is this the default location it look
At 10:11 AM -0700 7/14/01, Michael Collins wrote:
>At 11:46 AM -0500 7/14/01, Paul DuBois wrote:
>>At 11:32 AM -0500 7/14/01, MikeBlezien wrote:
>>>when you do a mysqladmin variables, where exactly are these
>>>variables stored,
>>>and can they be changed.
>>
>>They can be changed by placing set-
At 11:46 AM -0500 7/14/01, Paul DuBois wrote:
>At 11:32 AM -0500 7/14/01, MikeBlezien wrote:
>>when you do a mysqladmin variables, where exactly are these variables stored,
>>and can they be changed.
>
>They can be changed by placing set-variable= var_name=var_value lines
>in the [mysqld] group of
At 11:32 AM -0500 7/14/01, MikeBlezien wrote:
>when you do a mysqladmin variables, where exactly are these variables stored,
>and can they be changed.
They can be changed by placing set-variable= var_name=var_value lines
in the [mysqld] group of the /etc/my.cnf option file (or any other option
fi
17 matches
Mail list logo
