At 05:49 AM 10/21/2011, you wrote:
how to optimize mysql in easy way step, i know indexing, mapping other than
that is any way.
--
Thanks Regards,
P.Benaya Paul
Apart from enrolling in Hogwarts, you may be interested in the
book High Performance MySQL 2nd Edition. It can be found
how to optimize mysql in easy way step, i know indexing, mapping other than
that is any way.
--
Thanks Regards,
P.Benaya Paul
http://www.codeasearch.com
http://www.iwannasearch.com
- Original Message -
From: Benaya Paul benayap...@gmail.com
how to optimize mysql in easy way step, i know indexing, mapping
other than that is any way.
Forsooth, three paths extend before thee. The right way is to learn about mysql
so you know what you're doing. The intermediate
its a linux server fedora with 2GB ram, insert mostly used through the
update, no load or on cpu during that time
mysql show status;
+++
| Variable_name | Value |
+++
| Aborted_clients
I need your recommendation, I have the following config file need to
be optimized, can any one recommend any modification on this file,
lately mysql went slow with update procedure
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL
Some other info you can post to the list to help us zero in on the problem:
1) What is the SQL used to update the tables
2) What is the table structure? Show Create Table mytablex
3) How long does it take for how many rows?
4) How busy is the CPU when the updates are occuring?
5) Show Status --
In the last episode (Apr 18), tech user said:
My mysql table has been created for long time, it increases day by
day, and become huge. Right now a full scan to the table for the
first time is very slow. So I was thinking to optimize it. This table
is stored in many non-sequential disk
Hello,
My mysql table has been created for long time, it increases day by day,
and become huge.
Right now a full scan to the table for the first time is very slow.
So I was thinking to optimize it.
This table is stored in many non-sequential disk fragments I think.
I want to make this table to be
hi,
i have attached my geometric query which is very slow. how to optimize this
query
regards
shann
___
Hot new product - Spider Networks introduces stunning online ePortfolio
solution for students and teachers
Try to run an explain on the query to see how mysql optimizes it.
Also have a look at your system resources while the query runs to see if
you have a problem with memory/swapping.
I am not sure (since i've never used union), but my guess is that mysql
uses temporary tables for this, so maybe
HI,
Currently 16 records in a table slow down the search alot.
Most of the queries are based on the date field. so I m adding index on
it at the moment.
I m wondering how much speed I can gain after finshed the index.
Apart from indexing, what other alternativies I can use to speed up the
Jon,
So how do I optimize memory usage? Where to start ?
If your server is compiled with debug=full, the command
mysqladmin proc stat
shows you total server memory use. Look in the manual at
How MySQL uses Memory
SHOW VARIABLES (for all vars that control server memory use)
I have a small PHP website that gets a fair amount of traffic. It's a
simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP API.
But here is the kicker. Each mySQL thread
In the last episode (Oct 07), Jon Shoberg said:
I have a small PHP website that gets a fair amount of traffic. It's
a simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP
Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
In the last
In the last episode (Oct 07), Jon Shoberg said:
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
In the last episode (Oct 07), Jon Shoberg said:
I have a small PHP website that gets a fair amount of traffic.
It's a simple layout with two tables. I average about 50
concurrently open
On Mon, 7 Oct 2002, Jon Shoberg wrote:
Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize
17 matches
Mail list logo