RE: Performance Tunning
Hi All, In performance tunning what are the steps can follow,please help me Thanks Regards, Kranthi kiran
Re: Performance Tunning
1. Find out what is slow 2. Fix it 3. GOTO 1 On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran kranthikiran@gmail.comwrote: 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
Re: Performance Tunning
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: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 joh...@pixelated.net On Tue, Aug 31, 2010 at 5:23 AM, Johan De Meersman vegiv...@tuxera.bewrote: 1. Find out what is slow 2. Fix it 3. GOTO 1 On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran kranthikiran@gmail.comwrote: 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
RE: Performance Tunning
This is a good place to start: https://launchpad.net/mysql-tuning-primer -Original Message- From: Johnny Withers [mailto:joh...@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 joh...@pixelated.net On Tue, Aug 31, 2010 at 5:23 AM, Johan De Meersman vegiv...@tuxera.bewrote: 1. Find out what is slow 2. Fix it 3. GOTO 1 On Tue, Aug 31, 2010 at 11:13 AM, kranthi kiran kranthikiran@gmail.comwrote: 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 This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you are notified that reviewing, disseminating, disclosing, copying or distributing this e-mail is strictly prohibited. Please notify the sender immediately by e-mail if 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-free as information could be intercepted, corrupted, lost, destroyed, arrive late 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 transmission. [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=arch...@jab.org
Re: FreeBSD MySQL Performance Tunning suggestions???
Hi all ! VeeJay wrote: [[...]] At my job, I am going to build a Web Server with 1. FreeBSD 7.0-RELEASE amd64 2. Apache 2.2.8 3. PHP 4.4.8 (or may be PHP5, what do you suggest?) Server's hardware configuration is as follow: 2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB 16GB (8x2GB Dual Rank DIMMs) 667MHz FBD 6 x 450GB SAS 15k 3.5 HD Hot Plug PERC 6/i, Integrated Controller Card x6 backplane PE2950 III C5 MSS R10 Add-in PERC 5/i / 6/i 1 S TCP/IP Offload Engine 2P Broadcom TCP/IP Offload Engine functionality (TOE) Not Enabled For FreeBSD 7.0-RELEASE amd64 Which MySQL 5.0 would be used ? 1. FreeBSD 7.x (x86_64) or 2. FreeBSD 6.x (x86) Your machine has 16 GB of RAM. If you ever want to use really large caches in the MySQL server process, you need to use a 64 bit binary, called x86_64 in the MySQL package file names. I have done some googling and made these configuration files for Apache and MySQL? Apache: httpd.conf-start [[... file snipped ...]] MySQL: my.cnfstart [[... file snipped ...]] Is there something you can tune? You cannot tune without knowing which bottleneck you should widen, and how much resources still are available. IMNSHO, you need to start with some configuration, put load onto it (as representative as possible), then watch the system's behavior (take measurements !), and only then determine which part you want to improve. Example: Database caches are good to reduce disk I/O and so to increase performance, but you will not increase caches if your system is already paging heavily (= your RAM is too small). There is no need to change any parameter unless a) its current setting restricts your performance, and you have sufficient resources to raise the limit, or b) its current setting allocates more resources than needed here, which could be used better at some other place. You need some initial run and measurement to check that. HTH, Jörg -- Joerg Bruehe, MySQL Build Team, [EMAIL PROTECTED] Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: FreeBSD MySQL Performance Tunning suggestions???
Hi,
FreeBSD 7 should offer much better performance for MySQL. The FreeBSD
kernel developers have found ways to relieve some of the kernel
bottlenecks which permit multithreaded applications to operate much
better.
Regards,
Antony.
On 3 Jun 2008, at 03:43, VeeJay wrote:
Hi Guys
I need some performance tuning suggestions/help from you.
At my job, I am going to build a Web Server with
1. FreeBSD 7.0-RELEASE amd64
2. Apache 2.2.8
3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
Server's hardware configuration is as follow:
2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
16GB (8x2GB Dual Rank DIMMs) 667MHz FBD
6 x 450GB SAS 15k 3.5 HD Hot Plug
PERC 6/i, Integrated Controller Card x6 backplane
PE2950 III C5 MSS R10 Add-in PERC 5/i / 6/i 1 S
TCP/IP Offload Engine 2P
Broadcom TCP/IP Offload Engine functionality (TOE) Not Enabled
For FreeBSD 7.0-RELEASE amd64 Which MySQL 5.0 would be used ?
1. FreeBSD 7.x (x86_64)
or
2. FreeBSD 6.x (x86)
I have done some googling and made these configuration files for
Apache and
MySQL?
Apache:
httpd.conf-
start
# =
# Basic settings
# =
ServerType standalone
ServerRoot /usr/local/apache
PidFile /usr/local/apache/logs/httpd.pid
ScoreBoardFile /usr/local/apache/logs/httpd.scoreboard
ResourceConfig /dev/null
AccessConfig /dev/null
# =
# Performance settings
# =
Timeout 300
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 256
MaxRequestsPerChild 0
# =
# Apache modules
# =
ClearModuleList
AddModule mod_log_config.c
AddModule mod_mime.c
AddModule mod_dir.c
AddModule mod_access.c
AddModule mod_auth.c
AddModule mod_php4.c
AddModule mod_rewrite.c
AddModule mod_security.c
AddModule mod_setenvif.c
# =
# General settings
# =
Port 80
User apache
Group apache
ServerAdmin [EMAIL PROTECTED]
UseCanonicalName Off
ServerSignature Off
HostnameLookups Off
ServerTokens Prod
IfModule mod_dir.c
DirectoryIndex index.html
/IfModule
DocumentRoot /home/apache/www
# =
# Access control
# =
Directory /
Options None
AllowOverride None
Order deny,allow
Deny from all
/Directory
Directory /home/apache/www
Order allow,deny
Allow from all
/Directory
Directory /home/apache/www/vhosts/mydomain.com/public_html
Order allow,deny
Allow from all
/Directory
# =
# MIME encoding
# =
IfModule mod_mime.c
TypesConfig /usr/local/apache/conf/mime.types
/IfModule
DefaultType text/plain
IfModule mod_mime.c
AddEncoding x-compress Z
AddEncoding x-gzip gz tgz
AddType application/x-tar .tgz
AddType application/x-httpd-php .html
/IfModule
# =
# Logs
# =
LogLevel warn
LogFormat %h %l %u %t \%r\ %s %b \%{Referer}i\ \%{User-Agent}i
\
combined
LogFormat %h %l %u %t \%r\ %s %b common
LogFormat %{Referer}i - %U referer
LogFormat %{User-agent}i agent
ErrorLog /var/apache/logs/error_log
CustomLog /var/apache/logs/access_log combined
# =
# Virtual hosts
# =
NameVirtualHost *
VirtualHost *
DocumentRoot /home/apache/www/vhosts/mydomain.com/public_html
ServerName www.mydomain.com
ServerAlias mydomain.com
ErrorLog /var/apache/logs/vhosts/mydomain.com/error_log
CustomLog /var/apache/logs/vhosts/mydomain.com/access_log
combined
IfModule mod_rewrite.c
RewriteEngine on
RewriteRule ^/([a-z]{2})/index.html$ /index.html?topicid=$1
/IfModule
ErrorDocument 400 /page_error.html
ErrorDocument 401 /page_error.html
ErrorDocument 403 /page_error.html
ErrorDocument 404 /page_error.html
ErrorDocument 500 /page_error.html
/VirtualHost
#
# Logging GET/POST requests, defending against
# Cross-Site-Scripting (XSS) and SQL Injection attacks
#
IfModule mod_security.c
AddHandler application/x-httpd-php .html
#Turn the filtering engine On or Off
SecAuditEngine On
# Only log suspicious requests
SecAuditEngine RelevantOnly
SecAuditLog /var/apache/logs/audit_log
SecFilterScanPOST On
SecFilterEngine On
SecFilterDefaultAction deny,log,status:500
Re: Re: RE: performance tunning 4.x
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
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ 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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: performance tunning 4.x
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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: performance tunning 4.x
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: performance tunning 4.x
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: performance tunning 4.x
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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: performance tunning 4.x
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 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.
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 outside
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 cache
if they know how what affects it.
Mike
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* 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 [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
performance tunning 4.x
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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: performance tunning 4.x
In the Ziff Daveis eWeek benchmark http://www.eweek.com/article/0,3658,s=708a=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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: performance tunning 4.x
On Wed, 28 Aug 2002, Sean Hager wrote: In the Ziff Daveis eWeek benchmark http://www.eweek.com/article/0,3658,s=708a=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? 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: [EMAIL PROTECTED] * * 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
