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
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.
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
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
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
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. Does it
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
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
: 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 mysql
variables to increase the speed
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 you have queries that are only selects, in small tables, with few
rows, you should
: 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 your queries
properly indexed? What hardware are you running on? What do these
queries look
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] group of your ~/.my.cnf
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
standard port.
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 standard MySQL
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 1995
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 :)
At 11:32 AM -0500 7/14/01, MikemickaloBlezien 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
At 11:46 AM -0500 7/14/01, Paul DuBois wrote:
At 11:32 AM -0500 7/14/01, MikemickaloBlezien 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, MikemickaloBlezien wrote:
when you do a mysqladmin variables, where exactly are these
variables stored,
and can they be changed.
They can be changed by placing
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 looks for a '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
At 12:51 PM -0500 7/14/01, MikemickaloBlezien 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 file??
Yes.
At 12:51 PM -0500 7/14/01, MikemickaloBlezien 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
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
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 next. For an example, look
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;
+---+
|
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 and I'll
be very grateful for any hints.
I'm
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
am
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
am
.
- 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 over this and already have a question for
the
simple example
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 table
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
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
34 matches
Mail list logo