Hi,
Key_blocks_unused 952405
Key_blocks_used 395539
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. Does
it mean that i need to increase the key_buffer_size. Already
key
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 should be the absolute last resort.
when you do a mysqladmin variables, where exactly are these variables stored,
and can they be changed. 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??
Again, Thx for the help :)
Mike(mick
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
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
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
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
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
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
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 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-
>>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 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
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: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: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 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 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 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 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
Hi!
Does anyone know any mysql options I can change in the my.ini file or mysql
variables to increase the speed of select statements?
About database:
-uses only select statements for queries
-no transactions
-if database becomes corrupt in anyway, not a big deal I can recreate it
-it is a small
; From: Derick Smith [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 19, 2003 9:08 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: suggestions - server options/mysql variables
>
>
> Hi!
> Does anyone know any mysql options I can change in the my.ini
> file or
ake a big difference.
Thanks
Eric
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "Derick Smith"
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If y
ECTED]>,
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If you have queries that are only selects, in small tables, with few
rows, you should have very fast performance as is. Are you
I've been frying my brain over this problem for the past 24 hours and I'll
be very grateful for any hints.
I'm trying to recognize when the value for a field is changing value from
one record to the next. For an example, look at this:
mysql> select sezione from faq limit 20;
+---+
| sezi
Hi all,
Having just upgraded my MySQL server to the latest 3.23.32 version, I
thought it would be a good idea to have a review of the configuration and
try to optimise the setup further. I hope someone can help me by answering a
few queries I have.
Here's a bit of info about the spec. of the ser
am I missing something?
- Original Message -
From: "Luca Accomazzi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 17:02
Subject: Help! MySQL variables laugh at me
> I've been frying my brain over this problem for the past 24 hours
> I have only had a quick look over this and already have a question for the
> simple example you've provided. How are you determining the last value
> entered before entering the new value? The only way I see you of
> effectively accomplishing this is through the use of a datetime column. Or
>
> I have only had a quick look over this and already have a question for the
> simple example you've provided. How are you determining the last value
> entered before entering the new value? The only way I see you of
> effectively accomplishing this is through the use of a datetime column. Or
>
.
- Original Message -
From: "Luca Accomazzi" <[EMAIL PROTECTED]>
To: "Rolf Hopkins" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, June 04, 2001 20:47
Subject: Re: Help! MySQL variables laugh at me
> > I have only had a quick look o
ne 04, 2001 11:02 AM
To: [EMAIL PROTECTED]
Subject: Help! MySQL variables laugh at me
I've been frying my brain over this problem for the past 24 hours and I'll
be very grateful for any hints.
I'm trying to recognize when the value for a field is changing value from
one record to the
On Tue, Jan 30, 2001 at 10:56:56AM +, Basil Hussain wrote:
>
> Having just upgraded my MySQL server to the latest 3.23.32 version,
> I thought it would be a good idea to have a review of the
> configuration and try to optimise the setup further. I hope someone
> can help me by answering a few
Hi,
>> 1. I think I need to optimise table_cache. It's currently set to the
>> default of 64. There are a total of 70 tables on the system. The
>> manual says you should increase table_cache if the Opened_tables
>> status variable is big. How large is 'big'? This value is currently
>> 274 on my s
On Wed, Jan 31, 2001 at 09:12:05AM +, Basil Hussain wrote:
>
> I think I understand this now. The table_cache is the maximum number
> of tables MySQL can keep open all the time. If your table_cache is
> lower than the actual number of tables in use (in my case 64 versus
> 70), then when a tab
Hello there guys,
Latelly our database server is going into a very big problem, our current
configuration (is in an attachment file), is having huge load of leak memory
and a variable *innodb_log_file_size *is off cause when i up it the mysqld
doesn't start, our server is having this status(averag
35 matches
Mail list logo