Are there any documents on how to performance tune mySQL 4.x?
sean.
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hello,
Yes, there are lots of good documentation:
First, the official MySQL Technical Reference, Section 5 at
http://www.mysql.com/doc/en/index.html
Then scroll down to "5 MySQL Optimisation" and read those.
Also, check this:
http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html
It's a bit older, but still useful.
And finally, use www.google.com. :-)
Regards,
Iikka
On Wed, 28 Aug 2002, Sean Hager wrote:
> Are there any documents on how to performance tune mySQL 4.x?
>
> sean.
>
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail
> To unsubscribe, e-mail
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
******************************************
* Iikka Meriläinen *
* E-mail: Iikka.Merilainen@pato.vaala.fi *
* Vaala, Finland *
******************************************
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
In the Ziff Daveis eWeek benchmark
http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp )I noticed the
following:
MySQL's great performance was due mostly to our use of an in-memory query
results cache that is new in MySQL 4.0.1. When we tested without this cache,
MySQL's performance fell by two-thirds.
I couldn't find any information in the online document on how to configure
this in-memory query results chache. Can anyone point me to some
information on how to do this?
sean.
> -----Original Message-----
> From: imerilai@pato.vaala.fi
> [mailto:imerilai@pato.vaala.fi]On Behalf Of
> Iikka Meriläinen
> Sent: Wednesday, August 28, 2002 8:37 AM
> To: Sean Hager
> Cc: mySQL (E-mail)
> Subject: Re: performance tunning 4.x
>
>
> Hello,
>
> Yes, there are lots of good documentation:
> First, the official MySQL Technical Reference, Section 5 at
> http://www.mysql.com/doc/en/index.html
> Then scroll down to "5 MySQL Optimisation" and read those.
>
> Also, check this:
> http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html
> It's a bit older, but still useful.
>
> And finally, use www.google.com. :-)
>
> Regards,
> Iikka
>
> On Wed, 28 Aug 2002, Sean Hager wrote:
>
> > Are there any documents on how to performance tune mySQL 4.x?
> >
> > sean.
> >
> >
> >
> >
> ------------------------------------------------------------ ---------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail
> > To unsubscribe, e-mail
>
> > Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> >
>
> ******************************************
> * Iikka Meriläinen *
> * E-mail: Iikka.Merilainen@pato.vaala.fi *
> * Vaala, Finland *
> ******************************************
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail
> To unsubscribe, e-mail
>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
On Wed, 28 Aug 2002, Sean Hager wrote:
> In the Ziff Daveis eWeek benchmark
> http://www.eweek.com/article/0,3658,s=3D708&a=3D23115,00.asp )I noticed =
the
> following:
>
> MySQL's great performance was due mostly to our use of an in-memory query
> results cache that is new in MySQL 4.0.1. When we tested without this cac=
he,
> MySQL's performance fell by two-thirds.
>
> I couldn't find any information in the online document on how to configur=
e
> this in-memory query results chache. Can anyone point me to some
> information on how to do this?
>
Hi,
Start by looking at the MySQL documentation:
http://www.mysql.com/doc/en/Query_Cache.html
Read the entire 6.9 section.
It offers quite a bit of information on how the cache operates, how
you should configure it and so on.
Regards,
Iikka
******************************************
* Iikka Meriläinen *
* E-mail: Iikka.Merilainen@pato.vaala.fi *
* Vaala, Finland *
******************************************
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>Hi,
>
>Start by looking at the MySQL documentation:
>http://www.mysql.com/doc/en/Query_Cache.html
>Read the entire 6.9 section.
>
>It offers quite a bit of information on how the cache operates, how
>you should configure it and so on.
>
>
>Regards,
>Iikka
likka,
I read it too but I have a question about the cache, this sentence
in particular.
>>NOTE: The query cache does not return stale data. When data is modified,
any relevant entries in the query cache are flushed. <<
If I have a select statement like:
select col1, col2 from table1 where col1='A'
1) will the cache be flushed if someone changes a non-referenced column for
one of the retrieved rows:
Update table1 set col3 = 'x' where col1='A'
this update changes col3 that falls within the Where of the query but it
affects a column that is not returned by the query.
2) or will the cache be flushed if someone changes a row that falls outside
of the query's Where clause:
insert into table1 (col1, col2, col3) values('D', 'x', 'y');
This last query updates the same table as the select query, but the row
that is added is outside the range of the query's where clause.
So how smart is the cache?
a) Is it smart enough to allow table updates and if the update doesn't
affect the query, will it continue to use the cache? (This requires a lot
of intelligence.)
b) Or will any update to the rows that fall within the range of the query
(regardless of whether the column is in the query) will flush the cache?
c) Or will any update to the table automatically flush the cache?
MONTY:
I would like to see the Explain command to say if it is using the cache or
not (CACHE:Yes/No). This would help developers make better use of the cache
if they know how what affects it.
Mike
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi people,
I have a FreeBSD server where I installed mysql 3.23 with linux threads
from a port collection, the procedure was simple enough
(WITH_LINUXTHREADS=yes make). All my attempts then to build it from
sources were unsuccessfull, however it was not important consdering
that it could be installed from ports. But now I wish to upgrade it to
4.0.3 (keeping the linuxthreads option), so can anybody advice on the
procedure of building it from scratch?
If I look at the options which were in effect for the port version they
are a bit complex, should I just try repeating them now and it'll solve
it, or the procedure should be some different? Here are the options for
reference:
Compilation info: CC='cc' CFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT
-D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads' CXX='cc'
CXXFLAGS='-O -pipe -D__USE_UNIX98 -D_REENTRANT -D_THREAD_SAFE
-I/usr/local/include/pthread/linuxthreads -felide-constructors -fno-rtti
-fno-exceptions' LDFLAGS=''
Configure command: ./configure '--with-comment=FreeBSD port:
mysql-server-3.23.49' --with-extra-charsets=complex
--enable-thread-safe-client --enable-assembler --with-named-z-libs=no
--disable-shared --with-innodb
'--with-named-thread-libs=-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_ R
-D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib
-llthread -llgcc_r' --prefix=/usr/local/mysql-linux
i386-portbld-freebsd4.5
Thank you for any hints on the subject.
Regards
----
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hello,
A MySQL developer would be able to answer to these questions more
accurately, but I'll try to answer _logically_. So don't bet a million
dollars on the correctness of my answer.
> >>NOTE: The query cache does not return stale data. When data is modifie=
d,
> any relevant entries in the query cache are flushed. <<
>
> If I have a select statement like:
>
> select col1, col2 from table1 where col1=3D'A'
>
> 1) will the cache be flushed if someone changes a non-referenced column f=
or
> one of the retrieved rows:
>
> Update table1 set col3 =3D 'x' where col1=3D'A'
>
> this update changes col3 that falls within the Where of the query but it
> affects a column that is not returned by the query.
I think this flushes the cache. Think about a situation where col1 is a
computed column that derives its values from the data in col3. When col3
is updated, the value of col1 in the query cache would become invalid.
> 2) or will the cache be flushed if someone changes a row that falls outsi=
de
> of the query's Where clause:
This shouldn't explicitly flush the cache, but I don't know the details of
the implementation. This insert shouldn't have any effect on the
aforementioned SELECT query, because col1 here is 'D'.
> insert into table1 (col1, col2, col3) values('D', 'x', 'y');
>
> This last query updates the same table as the select query, but the row
> that is added is outside the range of the query's where clause.
>
>
> So how smart is the cache?
> a) Is it smart enough to allow table updates and if the update doesn't
> affect the query, will it continue to use the cache? (This requires a lot
> of intelligence.)
> b) Or will any update to the rows that fall within the range of the query
> (regardless of whether the column is in the query) will flush the cache?
> c) Or will any update to the table automatically flush the cache?
>
> MONTY:
> I would like to see the Explain command to say if it is using the cache =
or
> not (CACHE:Yes/No). This would help developers make better use of the cac=
he
> if they know how what affects it.
>
> Mike
>
>
******************************************
* Iikka Meriläinen *
* E-mail: Iikka.Merilainen@pato.vaala.fi *
* Vaala, Finland *
******************************************
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please don't hijack threads; you replied to a message titled
"performance tunning 4.x".
In the last episode (Aug 29), Varshavchick Alexander said:
> I have a FreeBSD server where I installed mysql 3.23 with linux
> threads from a port collection, the procedure was simple enough
> (WITH_LINUXTHREADS=yes make). All my attempts then to build it from
> sources were unsuccessfull, however it was not important consdering
> that it could be installed from ports. But now I wish to upgrade it
> to 4.0.3 (keeping the linuxthreads option), so can anybody advice on
> the procedure of building it from scratch?
Try the attached port; it builds and runs fine on my -current system,
and it should work on 4.*. Extract it, uncomment the
WITH_LINUXTHREADS=yes line, and make.
--
Dan Nelson
dnelson@allantgroup.com
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi everyone,
I am running a FreeBSD server with MySQL 3.23
I want to let my virtual users create/drop tables and limit the size of each
table, and also the number of tables they can create.
Can someone please tell me how I can do this?
Is it possible wit applications such as webmin, or phpMyAdmin?
Thanks so much
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
On Thu, 29 Aug 2002, Dan Nelson wrote:
>
> Please don't hijack threads; you replied to a message titled
> "performance tunning 4.x".
sorry, my fault...
>
> In the last episode (Aug 29), Varshavchick Alexander said:
> > I have a FreeBSD server where I installed mysql 3.23 with linux
> > threads from a port collection, the procedure was simple enough
> > (WITH_LINUXTHREADS=yes make). All my attempts then to build it from
> > sources were unsuccessfull, however it was not important consdering
> > that it could be installed from ports. But now I wish to upgrade it
> > to 4.0.3 (keeping the linuxthreads option), so can anybody advice on
> > the procedure of building it from scratch?
>
> Try the attached port; it builds and runs fine on my -current system,
> and it should work on 4.*. Extract it, uncomment the
> WITH_LINUXTHREADS=yes line, and make.
>
thanks a bit, this is just what was needed!
> --
> Dan Nelson
> dnelson@allantgroup.com
>
----
Alexander Varshavchick, Metrocom Joint Stock Company
Phone: (812)118-3322, 118-3115(fax)
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mos,
Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>Start by looking at the MySQL documentation:
>>http://www.mysql.com/doc/en/Query_Cache.html
>>Read the entire 6.9 section.
>>
>>It offers quite a bit of information on how the cache operates, how
>>you should configure it and so on.
m> I read it too but I have a question about the cache, this sentence
m> in particular.
m> NOTE: The query cache does not return stale data. When data is modified,
m> any relevant entries in the query cache are flushed.
m> If I have a select statement like:
m> select col1, col2 from table1 where col1='A'
[skip]
m> c) Or will any update to the table automatically flush the cache?
Yes, relevant entries in the query cache are flushed when any changes were made on the
table.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
At 07:58 AM 8/30/2002, you wrote:
>mos,
>Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>
> >>Start by looking at the MySQL documentation:
> >>http://www.mysql.com/doc/en/Query_Cache.html
> >>Read the entire 6.9 section.
> >>
> >>It offers quite a bit of information on how the cache operates, how
> >>you should configure it and so on.
>
>m> I read it too but I have a question about the cache, this sentence
>m> in particular.
>
>m> NOTE: The query cache does not return stale data. When data is modified,
>m> any relevant entries in the query cache are flushed.
>
>m> If I have a select statement like:
>
>m> select col1, col2 from table1 where col1='A'
>
>[skip]
>
>m> c) Or will any update to the table automatically flush the cache?
Victoria,
>Yes, relevant entries in the query cache are flushed when any changes were
>made on the
>table.
Can you define "relevant"? Do you mean all caches for that table?
Are you saying any change at all to the table, say I add a row, delete a
row, or modify a row even if it is not in the scope of the cached query,
will cause all caches for that table to be discarded? Argghhh! :-O
Example:
select customer_name from customers where state = 'NY' //<-Adds query to cache
insert into customers (customer_name, state) values('jones',
'CA') //<-Flushes the cache for customers table?
select customer_name from customers where state = 'NY' //<-No longer in cache?
If you are correct, then I feel caching is useful primarily for readonly
access to a table. As soon as a row is modified in any way, the caches for
that table are flushed. Would you agree?
Mike
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
At 11:04 -0500 8/30/02, mos wrote:
>At 07:58 AM 8/30/2002, you wrote:
>>mos,
>>Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>
>>>>Start by looking at the MySQL documentation:
>>>>http://www.mysql.com/doc/en/Query_Cache.html
>>>>Read the entire 6.9 section.
>>>>
>>>>It offers quite a bit of information on how the cache operates, how
>>>>you should configure it and so on.
>>
>>m> I read it too but I have a question about the cache,
>>this sentence
>>m> in particular.
>>
>>m> NOTE: The query cache does not return stale data. When data is modified,
>>m> any relevant entries in the query cache are flushed.
>>
>>m> If I have a select statement like:
>>
>>m> select col1, col2 from table1 where col1='A'
>>
>>[skip]
>>
>>m> c) Or will any update to the table automatically flush the cache?
>
>Victoria,
>
>>Yes, relevant entries in the query cache are flushed when any
>>changes were made on the
>>table.
>
>Can you define "relevant"? Do you mean all caches for that table?
Queries in the cache that use the table that has been changed.
>
>Are you saying any change at all to the table, say I add a row,
>delete a row, or modify a row even if it is not in the scope of the
>cached query, will cause all caches for that table to be discarded?
>Argghhh! :-O
Yes. How will the server know that the row is in the scope of the query
unless it reruns it again? If you change the thing from which the cached
result is derived, the cache becomes invalid.
How would you do it otherwise?
>
>Example:
>
>select customer_name from customers where state = 'NY' //<-Adds
>query to cache
>
>insert into customers (customer_name, state) values('jones', 'CA')
>//<-Flushes the cache for customers table?
>
>select customer_name from customers where state = 'NY' //<-No
>longer in cache?
>
>If you are correct, then I feel caching is useful primarily for
>readonly access to a table. As soon as a row is modified in any way,
>the caches for that table are flushed. Would you agree?
Yes. How would you suggest that it be done otherwise?
>
>Mike
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mos,
Friday, August 30, 2002, 7:04:25 PM, you wrote:
m> At 07:58 AM 8/30/2002, you wrote:
>>mos,
>>Thursday, August 29, 2002, 5:45:05 PM, you wrote:
>>
>> >>Start by looking at the MySQL documentation:
>> >>http://www.mysql.com/doc/en/Query_Cache.html
>> >>Read the entire 6.9 section.
>> >>
>> >>It offers quite a bit of information on how the cache operates, how
>> >>you should configure it and so on.
>>
>>m> I read it too but I have a question about the cache, this sentence
>>m> in particular.
>>
>>m> NOTE: The query cache does not return stale data. When data is modified,
>>m> any relevant entries in the query cache are flushed.
>>
>>m> If I have a select statement like:
>>
>>m> select col1, col2 from table1 where col1='A'
>>
>>[skip]
>>
>>m> c) Or will any update to the table automatically flush the cache?
m> Victoria,
>>Yes, relevant entries in the query cache are flushed when any changes were
>>made on the
>>table.
m> Can you define "relevant"? Do you mean all caches for that table?
m> Are you saying any change at all to the table, say I add a row, delete a
m> row, or modify a row even if it is not in the scope of the cached query,
m> will cause all caches for that table to be discarded? Argghhh! :-O
Yes.
And it's described in the manual:
http://www.mysql.com/doc/en/Query_Cache_How.html
m> Example:
m> select customer_name from customers where state = 'NY' //<-Adds query to cache
m> insert into customers (customer_name, state) values('jones',
m> 'CA') //<-Flushes the cache for customers table?
m> select customer_name from customers where state = 'NY' //<-No longer in cache?
m> If you are correct, then I feel caching is useful primarily for readonly
m> access to a table. As soon as a row is modified in any way, the caches for
m> that table are flushed. Would you agree?
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi everyone,
I am running a FreeBSD server with MySQL 3.23
I want to let my virtual users create/drop tables and limit the size of each
table, and also the number of tables they can create.
Can someone please tell me how I can do this?
Is it possible wit applications such as webmin, or phpMyAdmin?
Thanks so much
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hey,
You can limit the size of the database by specifying a quota on the
directory created by MySQL for that database.
When you create a database, all MySQL does is create a directory under
the data directory for that database. You can then set a quota on that
directory using whatever tools your OS supplies.
This won't limit the number of tables, or the specific size of any one
table, but it might be all you need...
Dean.
> -----Original Message-----
> From: Soheil Shaghaghi [mailto:soheils@jhanna.com]
> Sent: Sunday, 1 September 2002 9:35 am
> To: mysql@lists.mysql.com
> Subject: limiting the user
>
> Hi everyone,
> I am running a FreeBSD server with MySQL 3.23
> I want to let my virtual users create/drop tables and limit the size
of
> each
> table, and also the number of tables they can create.
>
> Can someone please tell me how I can do this?
> Is it possible wit applications such as webmin, or phpMyAdmin?
>
> Thanks so much
>
>
>
> ------------------------------------------------------------ ---------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail
> To unsubscribe, e-mail
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--0015175caad2cba215048f1afdd3
Content-Type: text/plain; charset=ISO-8859-1
Hi All,
In performance tunning what are the steps can follow,please help
me
Thanks & Regards,
Kranthi kiran
--0015175caad2cba215048f1afdd3--
--000325575aeac46075048f1bf89d
Content-Type: text/plain; charset=ISO-8859-1
1. Find out what is slow
2. Fix it
3. GOTO 1
On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran
> Hi All,
> In performance tunning what are the steps can follow,please help
> me
>
> Thanks & Regards,
> Kranthi kiran
>
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--000325575aeac46075048f1bf89d--
On 31/08/2010 12:23 p, Johan De Meersman wrote:
> 1. Find out what is slow
> 2. Fix it
> 3. GOTO 1
>
Good one Johan, Performance tuning depends alot on your table types,
your server, the version of MySQL, how you client applications access
your database, the size of your data, type of queries, indexes, data
types: basically each setup is different.
This might be a good start
http://www.mysqlperformanceblog.com/
--
Jangita | +256 76 91 8383 | Y! & MSN: jangita@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--001485f9221813fac3048f1dd9f3
Content-Type: text/plain; charset=ISO-8859-1
So, it's not just me that is stuck in this infinite loop? I thought I had
gone mad!
--
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net
On Tue, Aug 31, 2010 at 5:23 AM, Johan De Meersman
> 1. Find out what is slow
> 2. Fix it
> 3. GOTO 1
>
> On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran
>
>
> > Hi All,
> > In performance tunning what are the steps can follow,please help
> > me
> >
> > Thanks & Regards,
> > Kranthi kiran
> >
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--001485f9221813fac3048f1dd9f3--
This is a good place to start:
https://launchpad.net/mysql-tuning-primer
-----Original Message-----
From: Johnny Withers [mailto:johnny@pixelated.net]
Sent: Tuesday, August 31, 2010 5:38 AM
To: Johan De Meersman
Cc: kranthi kiran; mysql@lists.mysql.com
Subject: Re: Performance Tunning
So, it's not just me that is stuck in this infinite loop? I thought I had
gone mad!
--
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net
On Tue, Aug 31, 2010 at 5:23 AM, Johan De Meersman
e:
> 1. Find out what is slow
> 2. Fix it
> 3. GOTO 1
>
> On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran
>
>
> > Hi All,
> > In performance tunning what are the steps can follow,please he=
lp
> > me
> >
> > Thanks & Regards,
> > Kranthi kiran
> >
>
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
This message contains confidential information and is intended only for the=
individual named. If you are not the named addressee, you are notified th=
at reviewing, disseminating, disclosing, copying or distributing this e-mai=
l is strictly prohibited. Please notify the sender immediately by e-mail i=
f you have received this e-mail by mistake and delete this e-mail from your=
system. E-mail transmission cannot be guaranteed to be secure or error-fre=
e as information could be intercepted, corrupted, lost, destroyed, arrive l=
ate or incomplete, or contain viruses. The sender therefore does not accept=
liability for any loss or damage caused by viruses or errors or omissions =
in the contents of this message, which arise as a result of e-mail transmis=
sion. [FriendFinder Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089,=
USA, FriendFinder.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg