Hello Chris,
Chris [EMAIL PROTECTED] writes:
Surendra Singhi wrote:
I am using mySQL 5.0 and I have 2 tables with few hundred millions of
records. To optimize things, I am using MyISAM tables, using the
smallest possible data
type and have set indexes.
Now, the problem which I am facing
Also, when a query takes too long I kill it by shutting down the
server, is this safe or is there a better alternative (MyISAM tables)?
Use show processlist to see the query that taking more time and use
kill processid; for terminating the query .
--
Praj
Surendra Singhi wrote:
Hello
I have an update operation where I am able to update 10 million records in
approx
2.5 mins.
But when I tried to do the same update on say 40-50 million records, mysql
takes forever to finish. Its the same table, and same update operation, i am
just changing the range of ids using where
Hi,
I am using mySQL 5.0 and I have 2 tables with few hundred millions of
records.
To optimize things, I am using MyISAM tables, using the smallest possible data
type and have set indexes.
Now, the problem which I am facing is that mySql process is wasting lot of
time in disk access the CPU
Surendra Singhi wrote:
Hi,
I am using mySQL 5.0 and I have 2 tables with few hundred millions of
records.
To optimize things, I am using MyISAM tables, using the smallest possible data
type and have set indexes.
Now, the problem which I am facing is that mySql process is wasting lot of
Hi All,
Our current setup has the mysql server and the client app run on the
same host. We are using mysql++ (ports/mysql++-1.7.9) for the database
client api. The application returns huge data sets in the order of 50K. When
we do a show processlist most of the threads spend their time in
Hello,
I was wondering if a more knowledgeable person could help me out with my
configuration and let me know how I could further optimize MySQL. Here's the
hardware on my dedicated server:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.40GHz
Processor #1
, November 18, 2004 10:56 AM
To: [EMAIL PROTECTED]
Subject: Optimizing MySQL
Hello,
I was wondering if a more knowledgeable person could help me out with my
configuration and let me know how I could further optimize MySQL. Here's
the hardware on my dedicated server:
Processor #1 Vendor
Shaun wrote:
Hello,
I was wondering if a more knowledgeable person could help me out with my
configuration and let me know how I could further optimize MySQL. Here's the
hardware on my dedicated server:
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Pentium(R) 4 CPU 2.40GHz
Thanks for your help Dathan, I will make the required changes. I just have
one other problem.
I'm not sure what queries don't use an index. I've attmepted to turn on the
slow-queries-log, but nothing ever shows up in the file. Here's what I have
in the my.cnf
[mysqld]
skip-locking
set-variable
Shaun wrote:
Thanks for your help Dathan, I will make the required changes. I just have
one other problem.
I'm not sure what queries don't use an index. I've attmepted to turn on the
slow-queries-log, but nothing ever shows up in the file. Here's what I have
in the my.cnf
[mysqld]
skip-locking
Thanks, I changed the permissions, restarted, and everything is working
great now. Thanks a lot.
Shaun wrote:
Thanks for your help Dathan, I will make the required changes. I just
have
one other problem.
I'm not sure what queries don't use an index. I've attmepted to turn on
the
Joseph,
How big your table files are? Are they MyISAM or Innodb ? Do you have
indexes? How much memory do you have? Is your MySQL running on a
dedicated server or do you run anything else on your db server?
This questions needs to be answered before suggesting anything logical.
But general
Group,
I have been working with Mysql for about 5 years - mainly in LAMP shops. The
tables have been between 20-100 thousand records size. Now I have a project
where the tables are in the millions of records.
This is very new to me and I am noticing that my queries are really
sloww!
What
On Tue, Jan 22, 2002 at 10:12:55AM -0600, Solsberry, Glendon wrote:
I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
RAM). The problem is that the main query (listed below) takes
approximately 3 hours to run.
[snip]
Wow! Thanks for all the detail.
The query is this:
I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
RAM).
The problem is that the main query (listed below) takes approximately 3
hours to run.
my.cnf looks like:
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=128M
We are trying to optimize mySQL. Right now, the max_connections is set to
100. We are only able to open 99 concurrent connections to the db, and even
then, some requests are unable to get a connection. We'd like to be able to
scale that up, but mySQL doesn't like what we've done, as it won't
On Thu, Dec 27, 2001 at 10:38:42AM -0600, Kim Albee wrote:
We are trying to optimize mySQL. Right now, the max_connections is set to
100. We are only able to open 99 concurrent connections to the db, and even
then, some requests are unable to get a connection. We'd like to be able to
scale
You need to set the max_connections variable like this in the my.cnf
file:
set-variable = max_connections=250
-- Jason
On Thu, 2001-12-27 at 11:38, Kim Albee wrote:
We are trying to optimize mySQL. Right now, the max_connections is set to
100. We are only able to open 99 concurrent
I have a MySQL myISAM database that has about 300 MB of information.
Recently the index files became corrupted and I ran the myisamchk
*.MYI -r -S to repair them.
Ever since then mySQLd process has been using up a ton of processor time.
And some of the queries that I run have started taking a
Recently the index files became corrupted and I ran the
myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect indexes since the statistics have not been updated.
You can also do this: myisamchk *.MYI -a
Sincerely,
Steven
I'm not an expert, but I've never heard of a db getting slower after an
index rebuild. It's possible that's just a red herring.
You've been speaking generally about things being slower, I'd suggest you
get specific. Track down the queries are slow now, use EXPLAIN on them to
see what
I have used optimize table on several tables however it has not
affected the
speed of the queries or the large amount of processor resources that are
being used.
Have you heard of a way to rebuild a table more efficiently?
Go back and do this:
myisamchk -o *MYI
myisamchk -a *MYI
myisamchk
Hi all,
I have been using Mysql to power my online database search engine(CGI). IT contains
more than 500K rows of records(12 columns).
Is there a trick to optimize Mysql Table( by using Index , temporary table??) so that
the search engine could get the result in
shorter time?
Should I
24 matches
Mail list logo
