matt ryan wrote:
There is a perl script that comes with MySQL called mysqldumpslow.
You can just run it on your slow log and it will output summary
statistics about the slow log.
I saw that in the docs, but I definitly dont want to install perl on a
production server, I never looked to see
Michael Sleman [EMAIL PROTECTED] wrote:
key_buffer = 384M
Try to enlarge this up to, say, 1G and check it out how that helps.
sort_buffer_size = 2M
You may want to enlarge this as well.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
My 5 cents... tuning the MySQL database config file is half a solution.
In my experience optimizing the application code and table/index
structure delivers performance results.
Michael Sleman wrote:
Hello,
We're running 1 web server (apache 2 php) / 1 dedicated DB server
(MySQL
I agree with Matthew. A database is a lot like a car. You can have a
well-built, high-powered vehicle that could do 200mph while still carrying
15 people (good hardware + good tuning) but if you drive it off-road,
alone, and in second gear (bad table structure, poor index coverage, poor
SQL
I went over your data. This is what I noticed first:
| Select_full_join | 0|
| Select_full_range_join | 0|
| Select_range | 1|
| Select_range_check | 0|
| Select_scan | 301 |
What command will provide this data?
--
This is part of the results of a SHOW STATUS command. See one of the
earlier posts for the full list of his settings.
Read These For More:
http://dev.mysql.com/doc/mysql/en/SHOW.html
http://dev.mysql.com/doc/mysql/en/SHOW_STATUS.html
Hmm
I'm guessing my stats arent too good, lots of full table scans, but this
is to be expected, my users can query any table by any column, and I
cant index all column combinations
Variable_name
Value
Resend, firefox did not send the way it looked when I typed it!
I'm guessing my stats arent too good, lots of full table scans, but this
is to be expected, my users can query any table by any column, and I
cant index all column combinations
Variable_name Value
Select_full_join
From: http://dev.mysql.com/doc/mysql/en/Server_status_variables.html
Key_reads
The number of physical reads of a key block from disk. If Key_reads is
big, then your key_buffer_size value is probably too small. The cache miss
rate can be calculated as Key_reads/Key_read_requests.
I've found the slow query log is useless to me, it's 50 meg right now.
Is there a tool that will identify common querys? I could probably
come up with some sql's if I load it into a table, but it would take
quite a while to sort out.
I posted a request on the mysql bugtraq to move it to a
Hi,
On Thursday, July 22, 2004, at 01:42 PM, matt ryan wrote:
I've found the slow query log is useless to me, it's 50 meg right now.
Is there a tool that will identify common querys? I could probably
come up with some sql's if I load it into a table, but it would take
quite a while to sort
There is a perl script that comes with MySQL called mysqldumpslow.
You can just run it on your slow log and it will output summary
statistics about the slow log.
I saw that in the docs, but I definitly dont want to install perl on a
production server, I never looked to see if I could do it
Hello,
We're running 1 web server (apache 2 php) / 1 dedicated DB server
(MySQL 4.0.20-standard) and are experiencing serious performance issues
on the DB during some load testing.
Hardware on both
Dual Xeon 2.8GHz, 2GB RAM
The database size is a little under 1 GB.
Naturally, we started
13 matches
Mail list logo