> -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,
>
>
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.
. To obtain some data. During the process I query around 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 10000 lin
STATUS
EXPLAIN SELECT (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
>
> 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 are too
> slow. Meaning, one-two inserts per second, while the other cas
cess (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 are too
slow. Meaning, one-two inserts per second, while the other cas
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 logg
*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 not writing to the file
I've read
http://dev.mysql.com/doc
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 - n
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*
2010/3/19 Olav Mørkrid
> 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 selecting on y
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 wou
eally sure what to look for yet (Rather new to MySQL and hope google
>> will
>> have some answers J )
>>
>>
>>
>>
>>
>> Thank you
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> From: John Daisley [mail
some of them now but not
> really sure what to look for yet (Rather 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
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: slo
> 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...
>
>
>
>
).
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
mands) and run mk-query-digest against it;
>> * Set 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.
>&g
> 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 of mysqldumpsl
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 can also try a patched
mented Sphinx search, there's an
> existing drupal module for integration.
>
> There's lots more that was done, but I can't provide all that info because
> a) it's company internal, and b) because I'm not a developer and thus don't
> know half of it :-)
>
company internal, and b) because I'm not a developer and thus don't
know half 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 t
ndric [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 w
this. 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
noon local time.
Thanks in advance,
--
Milan
--
MySQL General Mailing List
For
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
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 us
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_in
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 r
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
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 quer
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
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 do
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 to
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
>
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:
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 var
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 (`p
n 3GHz with 4GB ram
only running Msql.
Can someone see something I've done wrong? I have the same data in
flat files with one word 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 wit
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 unsubscri
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
2) How I can find out from the log that MySQL
creates as a result of 1) as to
which queries are running slow.
mysqls
> could give me your valuable 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
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
2) How I can find out from the log that MySQL
creates as a result of 1) as to
which queries are running
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&
>
>
> 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 | S
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
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 man
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 ea
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 i
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
> spac
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 u
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
[EM
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 i
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 b
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
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 pr
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 as
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
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.
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 ve
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 mon
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 card
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
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 in
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
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 INSE
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&
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 disk,
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 Pages/
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
simpl
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
[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 join
_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 4
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order;
# Time: 050107 17:41:45
# [EMAIL PROTECTED]: graphic[graphic] @ localhost []
# Query_time: 0 Lock_time: 0 Rows_sent: 62 Rows_examined: 62
ng of slow 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
---
TYPE=MyISAM |
| zen_products_to_categories | CREATE TABLE `zen_products_to_categories` (
`products_id` int(11) NOT NULL default '0',
`categories_id` int(11) NOT NULL default '0',
PRIMARY KEY (`products_id`,`categories_id`)
) TYPE=MyISAM |
+-
-
Friday, January 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
the mean time?
BD
-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_buff
-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 with slow query and parse times with a MySQL - PHP
ecommerce application I am testing out. Also gett
ed both 64M and just 64. 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?
tart.
Try adding 'set-variable = 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
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 My
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 vers
I was using myisam tables and converted them to innodb
with Alter 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:
dspam_
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 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
TECTED]
> Sent: Thursday, 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 th
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
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
>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');
+--+--+---+-+-+--+--+
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 c
>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
singl
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).
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 fo
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
T
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. Iv
ny sense, maybe 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 a
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 <[EM
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.
figuring that
query 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&
N??j??j{ z恨w???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;
cont
1 - 100 of 125 matches
Mail list logo
