-Original Message-
From: Vikas Shukla [mailto:myfriendvi...@gmail.com]
Sent: Thursday, May 30, 2013 7:19 PM
To: Robinson, Eric; mysql@lists.mysql.com
Subject: RE: Are There Slow Queries that Don't Show in the
Slow Query Logs?
Hi,
No, it does not represents the time from
seconds to execute.
Sent from my Windows Phone From: Robinson, Eric
Sent: 31-05-2013 03:48
To: mysql@lists.mysql.com
Subject: Are There Slow Queries that Don't Show in the Slow Query Logs?
As everyone knows, with MyISAM, queries and inserts can lock tables
and force other queries to wait in a queue. When
10 times
other table per ISN.
e. Here is the problem. If I have a few files to process (around
3000-4000 lines in total, small array) this steps work fine, good speed.
But If I have big files or a lot of files (more than 1 lines in total,
big array), this steps are incredibly slow
(with substitutions filled in)
-Original Message-
From: Andrés Tello [mailto:mr.crip...@gmail.com]
Sent: Tuesday, October 09, 2012 7:04 AM
To: Adrián Espinosa Moreno
Cc: mysql@lists.mysql.com
Subject: Re: Slow queries / inserts InnoDB
You are forcing mysql to do full table scans with the substr
other table per ISN.
e. Here is the problem. If I have a few files to process (around
3000-4000 lines in total, small array) this steps work fine, good speed.
But If I have big files or a lot of files (more than 1 lines in total,
big array), this steps are incredibly slow. Queries and inserts
in total, small array) this steps work fine, good speed.
But If I have big files or a lot of files (more than 1 lines in total,
big array), this steps are incredibly slow. Queries and inserts are too
slow. Meaning, one-two inserts per second, while the other case inserts are
around 800 per second
Can't get slow querys to log. Does this not work in myisam?
*snip*
[mysqld]
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
*snip*
restarted mysqld - no log.
Created in file in /var/log/mysql/
*snip*
-rwxr--r-- 1 mysql mysql 0 May 7 10:33 mysql-slow.log
*snip*
still
At 12:04 PM 5/7/2010, Stephen Sunderlin wrote:
Can't get slow querys to log. Does this not work in myisam?
Sure it does. Have you tried:
slow_query_time = 1
Mike
*snip*
[mysqld]
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
*snip*
restarted mysqld - no log
-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
*snip*
restarted mysqld - no log.
Created in file in /var/log/mysql/
*snip*
-rwxr--r-- 1 mysql mysql 0 May 7 10:33 mysql-slow.log
*snip*
still not writing to the file
I've read
http://dev.mysql.com/doc/refman/5.0/en/slow-query
Hello Stephen,
Did u try this ??
mysql show global variables like '%log_output%';
+---+---+
| Variable_name | Value |
+---+---+
| log_output| FILE |
+---+---+
If only the log_output is FILE, then the slow queries will get logged in the
log
Dear MySQL forum.
I have performance problems when using left join x combined with
where x.y is null, in particularily when combining three tables this
way.
Please contact me by e-mail if you are familiar with these issues and
know how to eliminate slow queries.
I would really appreciate your
2010/3/19 Olav Mørkrid olav.mork...@gmail.com
Dear MySQL forum.
I have performance problems when using left join x combined with
where x.y is null, in particularily when combining three tables this
way.
With a left join, particularly when you're using *is (not) null*, you can't
use index
From: machi...@rdc.co.za
To: mysql@lists.mysql.com
Subject: slow queries not being logged
Date: Tue, 23 Feb 2010 09:59:13 +0200
Good day all
I hope you can assist me with this one...
We have a client where the slow query log was disabled
some answers J )
Thank you
From: John Daisley [mailto:mg_s...@hotmail.com]
Sent: 23 February 2010 10:24 AM
To: machi...@rdc.co.za; mysql@lists.mysql.com
Subject: RE: slow queries not being logged
From: machi...@rdc.co.za
To: mysql@lists.mysql.com
Subject: slow queries
From: John Daisley [mailto:mg_s...@hotmail.com]
Sent: 23 February 2010 10:24 AM
To: machi...@rdc.co.za; mysql@lists.mysql.com
Subject: RE: slow queries not being logged
From: machi...@rdc.co.za
To: mysql@lists.mysql.com
Subject: slow queries not being logged
Date: Tue, 23 Feb
new to MySQL and hope google
will
have some answers J )
Thank you
From: John Daisley [mailto:mg_s...@hotmail.com]
Sent: 23 February 2010 10:24 AM
To: machi...@rdc.co.za; mysql@lists.mysql.com
Subject: RE: slow queries not being logged
From
).
However, even though the slow query log is enabled, it is
not logging the queries to the file specified.
Can someone please assist in why this is not being done? I
thought that it might be logging to a default filename but there is only one
slow queries log file in the directory
the query log file to a filename which is a link to /dev/null and set a
cron script to relink it to a real filename at noon and another to relink it
to
/dev/null at 1pm - and then run the scripts you want.
* In newer versions you can log the slow queries to tables for analysis;
* Ultimately, you
which is a link to /dev/null and set a
cron script to relink it to a real filename at noon and another to relink it to
/dev/null at 1pm - and then run the scripts you want.
* In newer versions you can log the slow queries to tables for analysis;
* Ultimately, you can also try a patched version
it to a real filename at noon and another to relink it
to
/dev/null at 1pm - and then run the scripts you want.
* In newer versions you can log the slow queries to tables for analysis;
* Ultimately, you can also try a patched version of mysqldumpslow I was using
for some time, explained here
of it :-)
Suffice it to say, I don't like drupal for high-traffic interactive sites.
Get away from it if you can.
I'm logging slow queries but is there a way to see when the
slow queries take place also? I'd like to know what queries are being
processed during this window of poor response
logging slow queries but is there a way to see when the
slow queries take place also? I'd like to know what queries are being
processed during this window of poor response time, usually around
noon local time.
Thanks in advance,
--
Milan
--
MySQL General Mailing List
For list archives: http
[mailto:mand...@gmail.com]
Sent: Friday, July 31, 2009 11:15 AM
To: mysql@lists.mysql.com
Subject: logging slow queries with time
Hello,
I'm serving a burly Drupal install and at some points throughout the
day the mysql threads go way up and iowait peaks. I'm not sure which
is causing which but during
it to say, I don't like drupal for high-traffic interactive sites.
Get away from it if you can.
I'm logging slow queries but is there a way to see when the
slow queries take place also? I'd like to know what queries are being
processed during this window of poor response time, usually around
Perrin Harkins schrieb:
On Wed, Apr 23, 2008 at 9:22 PM, D Hill [EMAIL PROTECTED] wrote:
Can anyone shed some light if I should index wite_desc to speed things up?
No, since you don't use that column at all. If you're not on MySQL 5,
upgrading to MySQL 5 will help. Otherwise, you're best
D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed.
As soon as I enabled the option 'log_queries_not_using_indexes = 1' in
the configuration file, I started getting messages relating
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
IMHO not in this case, cause it is just a simple WHERE field IN ()
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't use the index with OR, it won't use it with IN.
What usually works is to
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_indexes
On Thu, 24 Apr 2008 at 10:16 -0400, [EMAIL PROTECTED] confabulated:
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
[EMAIL PROTECTED] wrote:
IMHO not in this case, cause it is just a simple WHERE field IN ()
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't use
D Hill schrieb:
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number
of slow queries. Perhaps it is because of some additional indexes
needed. As soon as I enabled the option
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_indexes = 1' in the
configuration file, I started getting messages relating to the select
On Wed, Apr 23, 2008 at 9:22 PM, D Hill [EMAIL PROTECTED] wrote:
Can anyone shed some light if I should index wite_desc to speed things up?
No, since you don't use that column at all. If you're not on MySQL 5,
upgrading to MySQL 5 will help. Otherwise, you're best bet is to
rewrite the query
Hello
Recently I changed my servers.
The old server spec is Core2Duo E6600 with 4gb ram and 320gb SATA.
The new server spec is Dual Opteron 2.1ghz with 4gb ram and 73gb 15kRPM SAS.
Now here comes the problem.
I generated 3gb forum backup (sql format) and putted it back in to the new
server.
It
Sorry my question may have been bad.
MySQL version is 5.0.37.
I tried slow query logging with long query set to 1 sec.
I came up with 3 sec and 6 sec queries and both of them are select query.
When I searched google it said that I need to use paging but since it was
working on the old server I
and phrase on each row and one file for each
day and doing grep/sort/uniq -c in all thoose files is quicker on a
slower server with a lot of other procesess and with the files nfs
mounted.
mysqladmin status doesn't show any slow queries:
Uptime: 1215323 Threads: 2 Questions: 2191970 Slow queries: 0
Jon Molin wrote:
Hi list
I have 5 tables:
words (word_id int auto_increment, word varbinary(40)) (has ~3.5M
rows) with the keys:
PRIMARY KEY (`word_id`),UNIQUE KEY `word_ind` (`word`)
phrases (phrase_id int auto_increment, phrase varbinary(100)) (has
~11M rows) with the keys:
PRIMARY KEY
On 8/17/06, Chris [EMAIL PROTECTED] wrote:
Jon Molin wrote:
Hi list
I have 5 tables:
words (word_id int auto_increment, word varbinary(40)) (has ~3.5M
rows) with the keys:
PRIMARY KEY (`word_id`),UNIQUE KEY `word_ind` (`word`)
phrases (phrase_id int auto_increment, phrase
Unfortunately didn't that help, it leads to:
++-+---+---+---
| id | select_type | table | type | possible_keys
| key | key_len | ref | rows| Extra
|
++-+---+---+---
| 1
On 8/17/06, Chris [EMAIL PROTECTED] wrote:
Unfortunately didn't that help, it leads to:
++-+---+---+---
| id | select_type | table | type | possible_keys
| key | key_len | ref | rows| Extra
|
Thanks, Philip.
On 8/2/06, Philip Hallstrom [EMAIL PROTECTED] wrote:
..
http://hackmysql.com/mysqlsla
.
That's definitely of immense help.
--
Thanks a zillion,
Asif
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
1) What parameters I need to set in my.cnf to
log slow queries so that they stick out conspicuously and get noticed,
and
2) How I can find out from the log that MySQL
creates as a result of 1) as to
which queries are running slow
advice that I need right now.
I just need to know
1) What parameters I need to set in my.cnf to
log slow queries so that they stick out conspicuously and get noticed,
and
http://dev.mysql.com/doc/mysql/search.php?version=4.1q=slow+query+loglang=en
1) What parameters I need to set in my.cnf to
log slow queries so that they stick out conspicuously and get noticed,
and
2) How I can find out from the log that MySQL
creates as a result of 1) as to
which queries are running slow.
mysqlsla
Hey list,
I have a question regarding the slow queries log, and queries not using index.
I have a small table, with say 10 entries, like that :
ID | Element
-
1 | One
2 | Two
3 | Three
4 | Four
5 | Five
6 | Six
7 | Seven
8 | Eight
9 | Nine
10 | Ten
I want to get
I have a question regarding the slow queries log, and queries not using
index.
I have a small table, with say 10 entries, like that :
ID | Element
-
1 | One
2 | Two
3 | Three
4 | Four
5 | Five
6 | Six
7 | Seven
8 | Eight
9 | Nine
10 | Ten
I want to get all
Thanks Alexey,
This is enough explanation for me ;)
Cheers,
HMax
AP I have a question regarding the slow queries log, and queries not using
index.
AP I have a small table, with say 10 entries, like that :
AP ID | Element
AP -
AP 1 | One
AP 2 | Two
AP 3 | Three
AP 4
Hi,
I have a query that keeps coming up in my slow queries log. The whole
database is innodb and i'm using mysql 4.1.11 on 64bit intel running red
hat linux. There are less than 100 rows in the offending table at anyone
time, and the server load rarely creeps up above 0.5
If i try to manually
Hi,
First of all, thanks to everyone that provided pointers on this matter.
The route I chose to take was to make 2 tables. One is for cumulative
network stats; this table can be used for the weekly,monthly,yearly
reports. I also created a table for daily stats which will be dropped
at midnight
Paul Halliday wrote:
srcaddr VARCHAR(15),
dstaddr VARCHAR(15),
Are these ip-adresses? If they are, consider using UNSIGNED INT columns
and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
space, thus increase the amount of data your hw can handle.
They are indeed
Hello,
I am working on a database that deals with network statistics. I have
a program that generates web reports based on this data every ten
minutes.
The table layout looks something like this:
CREATE TABLE traffic
(
unix_secs INT UNSIGNED NOT NULL,
dpkts INT UNSIGNED NOT NULL
At 02:22 PM 5/10/05, Paul Halliday wrote:
Now, as time progresses the queires are getting slower and slower.
I know this is expected,
I don't think so. I thought that if the number of rows returned does not
change and an index is properly used, then query time should not change
significantly
Don't forget to run an analyze to adjust the statistics for the
optimizer/indexes. Also, after any updates (on dynamic tables which yours is)
or any deletes run an optimize.
Quoting Paul Halliday [EMAIL PROTECTED]:
Hello,
I am working on a database that deals with network statistics. I have
a
On Tue, 2005-05-10 at 14:56 -0400, Frank Bax wrote:
At 02:22 PM 5/10/05, Paul Halliday wrote:
Now, as time progresses the queires are getting slower and slower.
I know this is expected,
I don't think so. I thought that if the number of rows returned does not
change and an index is
I'm somewhat a newbee on this database but some observations:
As your table grows (and indexes) INSERTS will definitly slow because of the
indexes.
Consider MySQL's version of Oracle's partitioning and using MERGE TABLES
feature. Just remember that if you change 1 table, all of them have to be
Hi,
you have to play with explain to see which index is used in your queries.
Since you defined only mono-column indexes, i think they are not used in
queries with multi-criteria search.
Consider adding indexes with all used columns and eventually drop the not used
ones to not slow updates and
We did something similar for our large statistic tables. The older data
that no longer changes would get shipped off into a very fast read only
table with a cron job and then that is the table we would generate the
reports on. Even with millions of entries it is incredibly fast.
Eric Jensen
Paul Halliday wrote:
srcaddr VARCHAR(15),
dstaddr VARCHAR(15),
Are these ip-adresses? If they are, consider using UNSIGNED INT columns
and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
space, thus increase the amount of data your hw can handle.
I have read
On 5/10/05, Roger Baklund [EMAIL PROTECTED] wrote:
Paul Halliday wrote:
srcaddr VARCHAR(15),
dstaddr VARCHAR(15),
Are these ip-adresses? If they are, consider using UNSIGNED INT columns
and the INET_NTOA() and INET_ATON() funtions. It will save you a lot of
space, thus
Hello.
There could be a lot of reasons for such a delay. First, you
should switch to bulk inserts and perform all operation as a single
transaction. Avoid usage of the autoextended or per-table tablespaces.
Are you able to upgrade? There could be some performance improvements
in the newer
confirm it?
Thanks,
Narasimha
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 10:19 PM
To: Gleb Paharenko
Cc: mysql@lists.mysql.com
Subject: Re: Slow queries, why?
Yes, indexes slow down inserts (or updates that change the value of a
column that is indexed).
Also
Hello.
We're running MySQL 4.11 on a machine with 2GB memory, the table is
InnoDB with a compound primary key, and additional indexes on all rows
with searchable options in the API. Any generic advice or admin tools
would be great.
Use EXPLAIN to determine how efficient your
me in this, it is very urgent.
Thanks,
Narasimha
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 1:11 PM
To: mysql@lists.mysql.com
Subject: Re: Slow queries, why?
Hello.
We're running MySQL 4.11 on a machine with 2GB memory, the table
Yes, indexes slow down inserts (or updates that change the value of a
column that is indexed).
Also, remember that MySQL only uses one index per per table in a query.
So if there are some columns in your table that are indexed, but,
1) Have poor cardinality (number of distinct values - low
Thanks! Explain and InnoDB monitor were exactly what I needed to
diagnose and fix the problem! In case you were curious, the issue was
that the statement I was expecting to run was not the statement that
was running, but the first hundred and some-odd characters in both
were the same. Using the
So here's my situation: we have a database that has a table of about 5
million rows. To put a new row into the table, I do an INSERT ...
SELECT, pulling data from one row in the table to seed the data for
the new row. When there are no active connections to the DB other than
the one making the
on 5/3/05 7:25 PM, Joseph Cochran at [EMAIL PROTECTED] wrote:
So here's my situation: we have a database that has a table of about 5
million rows. To put a new row into the table, I do an INSERT ...
SELECT, pulling data from one row in the table to seed the data for
the new row. When there
Hello. I am wondering why some of my queries are slow on the first run, but
speedy on subsequent runs. They are not being query cached, as I have
query_cache_type set to DEMAND. Is it something as simple as pulling the
data into RAM from disk, or is there something else going on? Here's a
Most likely it's the OS cache caching all those disk
segments in memory. Also in InnoDB, MySQL uses the
Buffer Pool Size to cache data pages in addition to
the OS cache.
If you're running ona Windows machine, you can easily
tell what's going on by opening up Performance Monitor
and watching
On Mar 10, 2005, at 11:20 AM, Bob O'Neill wrote:
Hello. I am wondering why some of my queries are slow on the first
run, but
speedy on subsequent runs. They are not being query cached, as I have
query_cache_type set to DEMAND. Is it something as simple as pulling
the
data into RAM from
the disadvantages of losing the data on system shutdown.
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 10, 2005 1:43 PM
To: Bob O'Neill
Cc: mysql@lists.mysql.com
Subject: Re: Slow queries only the first time
On Mar 10, 2005, at 11:20 AM, Bob O'Neill
nasty table scans. This can
seriously degrade your performance, if you can find the queries in question
then modify/add indexes or change sql which will reduce number of rows
scanned.
Lines in my.cnf
log-slow-queries = /var/lib/mysql/data/slow.log
set-variable = long-query-time=5
log-long-format
Hi,
I'm having a problem with slow query and parse times with a MySQL - PHP
ecommerce application I am testing out. Also getting an error message with
the key_buffer variable.
I tried to improve MySQL speed/performance by adding key_buffer=50M
to my my.cnf file for [mysqld]. When I restarted
= key_buffer = 64M' to your my.cnf.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: BD
Sent: Friday, January 07, 2005 9:07 AM
To: mysql@lists.mysql.com
Subject: Slow queries, need advice on how to improve; key_buffer?
Hi,
I'm having a problem
. Should I
also enter tick marks? I tried that too.
BD
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Friday, January 07, 2005 11:20 AM
To: BD
Cc: mysql@lists.mysql.com
Subject: RE: Slow queries, need advice on how to improve; key_buffer?
[snip]
I tried to improve
AM
To: mysql@lists.mysql.com
Subject: Slow queries, need advice on how to improve; key_buffer?
Hi,
I'm having a problem with slow query and parse times with a MySQL - PHP
ecommerce application I am testing out. Also getting an error message with
the key_buffer variable.
I tried to improve MySQL
-Original Message-
From: Tom Crimmins [mailto:[EMAIL PROTECTED]
Sent: Friday, January 07, 2005 12:08 PM
To: BD
Cc: mysql@lists.mysql.com
Subject: RE: Slow queries, need advice on how to improve; key_buffer?
[snip]
I tried to improve MySQL speed/performance by adding key_buffer=50M to my
my.cnf
07, 2005 11:21 AM
To: Tom Crimmins
Cc: mysql@lists.mysql.com
Subject: RE: Slow queries, need advice on how to improve; key_buffer?
Hi Tom,
OK thanks I just added the set-variable = key_buffer = 64M line to my my.cnf
file and at least I got no errors and the MySQL server restarted OK and I
got my
PROTECTED]
Sent: Friday, January 07, 2005 12:23 PM
To: BD
Cc: mysql@lists.mysql.com
Subject: RE: Slow queries, need advice on how to improve; key_buffer?
[snip]
The problem now is, this did not do anything to improve the query and parse
times.
I'm testing out an on line store which has about
queries.
[mysqld]
set-variable = long_query_time=2
log-long-format
log-slow-queries = /var/log/mysqld.slow.log (or whatever file you want, just
make sure the user mysqld is running as has write permissions to it.)
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original
To: BD
Cc: mysql@lists.mysql.com
Subject: RE: Slow queries, need advice on how to improve; key_buffer -
zen-cart?
[snip]
The application I am using for the site is www.zen-cart.com so I'm not sure
I can do anything about changing the table indexes because it is a pre
written php-MySQL open source
[snip]
# Time: 050107 17:40:41
# [EMAIL PROTECTED]: zencarttest[zencarttest] @ [xxx.xxx.xxx.xxx]
# Query_time: 13 Lock_time: 0 Rows_sent: 148 Rows_examined: 1567270
use zencarttest;
select distinct m.manufacturers_id, m.manufacturers_name from
zen_manufacturers m
left
I was using myisam tables and converted them to innodb
with Alter table table TYPE=INNODB; A query that used
to take 23 minutes, does not complete in hours. There
about 33M rows in the table and I was doing a count of
the rows. Some queries with more conditions seem fine.
Here is the table:
What you sent is important information to diagnosing your problem but it
would have really helped if you had posted your query along with an
EXPLAIN of it.
Also, it is a WELL KNOWN fact that InnoDB does NOT know exactly how many
rows are in a table at any particular moment (because of the
Thanks Brent and Donny, hopefully this info will help get to the root of the problem
with the fulltext search.
The table structure is very, very simple:
mysql describe product_fulltext;
+-++--+-+-+---+
| Field | Type | Null | Key | Default | Extra
If you are sorting the result, setting a limit only speeds things up
for data transfer of the result set since MySQL still has to find all
the records, sort them, then deliver only the first X records. You can
usually tell how much time is spent on the transfer of the result set
vs. finding
I'm gathering by the lack of response that perhaps MySQL is incapable of executing a
count of the number of fulltext matches on 3 million rows.
I really thought that MySQL 4 was really suppose to be able to handle such a load
I still think my configuration may be to blame
?
- John
Capable? I can't think if why it wouldn't be capable. From your posts I
assume your definition of capable in this case is a quick response.
Are you running 4.0 or 4.1? I think the indexing was changed in 4.1 so
it would give you better response. 5-20 seconds does seem long,
assuming your
, August 26, 2004 8:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Slow Queries on Fast Server?
I'm gathering by the lack of response that perhaps MySQL is incapable of
executing a count of the number of fulltext matches on 3 million rows.
I really thought that MySQL 4 was really suppose to be able
I'm running into a problem with some queries running on a dedicated mysql server (2.0
GHz, 2GB RAM). Fulltext searching really exemplifies this as most MATCH, AGAINST
queries are taking 5-20 seconds. Performance was excellent for some reason one day
(0.2 - 0.75 seconds) but it was only fast
Have you checked the Optimization section of the manual yet?
http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
It's probably the best place to start.
Cheers,
--V
[EMAIL PROTECTED] wrote:
I'm running into a problem with some queries running on a dedicated mysql server (2.0
GHz, 2GB RAM).
Have you checked the Optimization section of the manual yet?
http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
Oh yes, as I've attempted to configure the my.cnf file for best performance. The
query is correct. The fulltext index is correct as I built the fulltext index on the
single
Could you send the output of an EXPLAIN for your query?
--V
[EMAIL PROTECTED] wrote:
Have you checked the Optimization section of the manual yet?
http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html
Oh yes, as I've attempted to configure the my.cnf file for best performance. The query is
Could you send the output of an EXPLAIN for your query?
Sure, pretty sure the index is fine though:
mysql EXPLAIN SELECT COUNT(*) FROM product_fulltext WHERE MATCH (search_text) AGAINST
('black');
caching and/or the key buffer could be resulting in repeated queries
being optimized):
set-variable = query_cache_type=0
set-variable = key_buffer_size=0
...but, I haven't managed to reproduce the slow queries reliably.
Does anything know what might be going on and if there's some setting I can
use
From: Bill Marrs [mailto:[EMAIL PROTECTED]
I've found a performance issue with a series of mysql queries
that I make to generate a web page. But, when I go to
investigate it, reloading the page a few times, I find the
performance of the pages within a couple tries becomes very
fast.
Are you logging slow queries? Have you run an explain plan for the
queries in question?
Original Message
On 2/24/04, 10:29:33 AM, Bill Marrs [EMAIL PROTECTED] wrote regarding
disabling optimizations to identify slow queries:
I've found a performance issue with a series of mysql queries
there is some other unknown
factor influencing this.
At 11:39 AM 2/24/2004, [EMAIL PROTECTED] wrote:
Are you logging slow queries? Have you run an explain plan for the
queries in question?
Yes, but the problem is more that I'm doing a number of not-super-fast
queries, so the accumulated effect
On 24 Feb 2004 at 12:00, Bill Marrs wrote:
Actually, I just noticed that even after I restart mysql, the speed
stays. That doesn't make any sense, maybe there is some other unknown
factor influencing this.
Sounds like it's your operating system's caching of the disk reads.
--
Keith C. Ivey
At 12:07 PM 2/24/2004, Keith C. Ivey wrote:
Sounds like it's your operating system's caching of the disk reads.
Yikes... that would explain it.
um... anyone know how to disable disk caching on Linux 2.6 kernel?
-bill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
N??j??j{zw???oz??
?i, all
I have a mysql server (dual P4 2.0G, 1G MEM, RH8.0, Mysql 4.0.12),
There are 2 tables defined as follow:
create table a (
imgid int not null,
parent int,
imgtype char(3),
img longtext,
primary key (imgid),
key (parent, imgid)
) type = innodb;
1 - 100 of 122 matches
Mail list logo