Hi,
Quick question about the SHOW TABLE STATUS command and the
Data_free info in
particular.
You say: If it is high, then it's time to run OPTIMIZE TABLE...
What is considered high? As I'm looking at my output, I see that
most of my
tables show a value of 0, however, some have a value
On Thu, Jul 19, 2001 at 04:21:05PM -0700, Mike Wexler wrote:
We currently have a dedicate server for MySQL. The server is a dual
pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
RPM drives in it arranged in a Raid 1 configuration (mirror).
Sometime in the next 3-6 months
Hi,
We currently have a dedicate server for MySQL. The server is a dual
pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
RPM drives in it arranged in a Raid 1 configuration (mirror).
Sometime in the next 3-6 months we will be maxing out its
capacity. (We were maxed
Jeremy Zawodny wrote:
On Thu, Jul 19, 2001 at 04:21:05PM -0700, Mike Wexler wrote:
We currently have a dedicate server for MySQL. The server is a dual
pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
RPM drives in it arranged in a Raid 1 configuration (mirror).
Basil Hussain wrote:
Hi,
We currently have a dedicate server for MySQL. The server is a dual
pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000
RPM drives in it arranged in a Raid 1 configuration (mirror).
Sometime in the next 3-6 months we will be maxing out
Yes, you should definitely look at option #9 first. Here's a few pointers to
some things that immediately spring off the screen at me:
| Open_tables | 1296 |
| Open_files | 2180712|
| Open_streams | 0 |
| Opened_tables
Hi,
Thank you very much for the detailed analysis! One question:
where did he get all this data from?
You can show all of MySQL's status and configuration parameters by issuing
these statements:
SHOW STATUS;
SHOW VARIABLES;
Also, the following can come in handy if you want to see info
Hi,
Strange. My understanding was that RAID 5 was good for read bandwidth
but that keeping the parity disk uptodate slowed it down for write
bandwidth.
Well, what you say is almost true to a certain extent. Firstly, with RAID 5
parity is striped across the disks too, so there is no
Quick question about the SHOW TABLE STATUS command and the Data_free info in
particular.
You say: If it is high, then it's time to run OPTIMIZE TABLE...
What is considered high? As I'm looking at my output, I see that most of my
tables show a value of 0, however, some have a value around 300
On Fri, Jul 20, 2001 at 06:20:00AM -0700, Mike Wexler wrote:
I already increased table_cache from 128 to 2048. Which helped. And
last night I increase key_buffer from 16MB to 64MB. Maybe it should
be even larger?
Oh, you can easily make it quite a bit higher. On my 1GB systems, I
have it
We currently have a dedicate server for MySQL. The server is a dual
pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000 RPM
drives in it arranged in a Raid 1 configuration (mirror). Sometime in
the next 3-6 months we will be maxing out its capacity. (We were maxed
out a few days
portions, especially for concurrent queries).
Hope this helps...
- Original Message -
From: Mike Wexler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 4:21 PM
Subject: database server upgrade
We currently have a dedicate server for MySQL. The server is a dual
12 matches
Mail list logo