What queries, precisely, I can't tell you, but you can have a good idea
about how your cache performs using the stuff in "show global variables;"
and the online manuals about what it all means :)
Look at 'show global variables like %qcache%', for a start.
On Fri, May 7, 2010 at 2:22 PM, Darvin De
Can somebody help me with this?
Thanks!
On Thu, May 6, 2010 at 10:39 AM, Darvin Denmian
wrote:
> Hello,
>
> I've activated the query_cache in Mysql with the variable
> "query_cache_limit" value to 1 MB.
> My question is:
>
> How to know what queries wasn't cached because they have exceeded the
>
From: Philippe Poelvoorde <[EMAIL PROTECTED]>
Reply-To: "'mysql@lists.mysql.com '"
To: "'mysql@lists.mysql.com '"
Subject: Re: Queries inside UDF
Date: Mon, 21 Mar 2005 11:05:39 +
sguazt sguazt wrote:
Hi!
From: Philippe Poelvoorde <[EMAIL PRO
sguazt sguazt wrote:
Hi!
From: Philippe Poelvoorde <[EMAIL PROTECTED]>
Reply-To: "'mysql@lists.mysql.com '"
To: mysql@lists.mysql.com
Subject: Re: Queries inside UDF
Date: Thu, 17 Mar 2005 08:22:46 +
..
You can actually access a DB within a UDF, but you should do
Hi!
From: Philippe Poelvoorde <[EMAIL PROTECTED]>
Reply-To: "'mysql@lists.mysql.com '"
To: mysql@lists.mysql.com
Subject: Re: Queries inside UDF
Date: Thu, 17 Mar 2005 08:22:46 +
...
You can actually access a DB within a UDF, but you should do the same than
when
sguazt sguazt wrote:
Thanks for answering!
Your solution would be right if I can modify the database (and I have no
control on software that populate tables).
Unfortunately I can do only queries on that db; so the due date has to
be recalculated every time I want to perform the main report (that
lt;[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com,[EMAIL PROTECTED]
Subject: RE: Queries inside UDF
Date: Wed, 16 Mar 2005 15:20:09 -0500
Marco,
I think I understand why you might want the end date of your projects to
be dynamically calculated (assuming that's why you want this calculation
t
>From: [EMAIL PROTECTED]
> >To: "sguazt sguazt" <[EMAIL PROTECTED]>
> >CC: mysql@lists.mysql.com,[EMAIL PROTECTED]
> >Subject: RE: Queries inside UDF
> >Date: Wed, 16 Mar 2005 12:37:59 -0500
> >
> >
> >I can almost follow the logic of your pse
From: [EMAIL PROTECTED]
To: "sguazt sguazt" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com,[EMAIL PROTECTED]
Subject: RE: Queries inside UDF
Date: Wed, 16 Mar 2005 12:37:59 -0500
I can almost follow the logic of your pseudocode. Can you explain "what"
it is you are tryi
"sguazt sguazt" <[EMAIL PROTECTED]> wrote on 03/16/2005 11:54:26 AM:
> Hi!
>
> >From: Tom Crimmins <[EMAIL PROTECTED]>
> >To: sguazt sguazt <[EMAIL PROTECTED]>
> >CC: mysql@lists.mysql.com
> >Subject: RE: Queries inside UDF
> &g
Hi!
From: Tom Crimmins <[EMAIL PROTECTED]>
To: sguazt sguazt <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: RE: Queries inside UDF
Date: Wed, 16 Mar 2005 10:09:16 -0600
...
Can you explain exactly what you are using this for? What benefit does this
provide over just executi
On Wednesday, March 16, 2005 09:30, sguazt sguazt wrote:
> Hi folks!
>
> (I hope this is the right list ... if not please tell me where I can
> submit this post)
>
> I would like to create a MySQL UDF (i.e. User Defined Function) that
> embeds a query; for instance, suppose the UDF is named foob
min() and max() can use indexes so they shouldn't be slower.
On Mon, 14 Feb 2005 17:13:07 -0700, Ryan McCullough
<[EMAIL PROTECTED]> wrote:
> what about other functions like doing a min() or max()? are those slow
> limitations of innodb tables as well?
>
>
> On Mon, 14 Feb 2005 15:52:21 -0600,
what about other functions like doing a min() or max()? are those slow
limitations of innodb tables as well?
On Mon, 14 Feb 2005 15:52:21 -0600, Eric Bergen <[EMAIL PROTECTED]> wrote:
> Total row count is cached in the header for MyISAM tables. InnoDB has
> no such mechanism for this because tran
Total row count is cached in the header for MyISAM tables. InnoDB has
no such mechanism for this because transactions make it impossible to
keep an exact row count. In order for InnoDB to get a row count it
has to do a full scan inside a transaction which will take a long
time. One way around this
John Visicaro wrote:
Hi,
This is my first post so I hope I've done it right. I am having trouble
querying an email address from MySQL and then placing that field into the
PHP mail function. It doesn't work. Here's my code:
$query_string = "SELECT Email FROM instructors WHERE HSA_NO = '$insthsaid'";
Right thanks for all the tips the 3 column index has done the job,
queries coming back in 0.7 secconds now which is just the job before
they get cached.
Don't know how I missed that one as it was abovious...i even tried
countyid and old...forgot about price..
John
--
MySQL General Mailing List
It is a property of Mysql that such a query will benefit greatly from a
composite index. So I would not consider anything else without having tried
this.
Am Thursday 11 November 2004 16:29 schrieb John Smith:
> On Thu, 2004-11-11 at 14:59, Victor Pendleton wrote:
> > If you build the composit i
On Thu, 2004-11-11 at 15:51, mos wrote:
> John,
> Create a second table (MyISAM) but this time don't use compression
> on the table.
>
> create table newtable select * from oldtable;
>
Right will run that just now, good idea...just have to avoid the wife as
no doubt it will bog the sit
On Thu, 2004-11-11 at 15:45, Jigal van Hemert wrote:
> `price` is still in the ORDER BY, so removing it only from the WHERE clause
> will not help really.
No the query I ran didn't have an order by clause (sorry if the one I
pasted did..)
> - create an INDEX on the columns in the WHERE clause _an
At 07:52 AM 11/11/2004, you wrote:
Afternoon All,
The table is read only for most of the day and will get updated (once I
get the queries down to an acceptable level) nightly...if that helps.
Any suggestions or further tips would be very helpful as its taken me
months to get my code to input the da
From: "John Smith" <[EMAIL PROTECTED]>
> On Thu, 2004-11-11 at 14:36, Philippe Poelvoorde wrote:
> > Hi,
> >
> > could you try adding a key with
> > ALTER TABLE properties ADD INDEX(countyid,old,price);
> > It could maybe help getting less rows at a time.
>
> I dropped the old and price for the whe
On Thu, 2004-11-11 at 14:59, Victor Pendleton wrote:
> If you build the composit indexes as suggested, does your performance
> improve?
Erm, do you think it would? Its just that with such a large table and it
being compressed it takes ages?
--
MySQL General Mailing List
For list archives: htt
If you build the composit indexes as suggested, does your performance
improve?
John Smith wrote:
On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote:
What does the explain plan look like?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE prope
On Thu, 2004-11-11 at 14:36, Philippe Poelvoorde wrote:
> Hi,
>
> could you try adding a key with
> ALTER TABLE properties ADD INDEX(countyid,old,price);
> It could maybe help getting less rows at a time.
I dropped the old and price for the where clause and the number of rows
scanned were the sam
On Thu, 2004-11-11 at 14:37, Andy Eastham wrote:
> Have you got a single multi-column index on countyid, price and old, or do
> you have individual indexes on each of these fields? The former would be
> much better.
Its a single column on countyid, when I ran a select and just used
countyid = in
Hi,
could you try adding a key with
ALTER TABLE properties ADD INDEX(countyid,old,price);
It could maybe help getting less rows at a time.
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/
; To: Victor Pendleton
> Cc: [EMAIL PROTECTED]
> Subject: Re: Queries taking 60 seconds+
>
> On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote:
> > What does the explain plan look like?
> >
>
> id select_type table type possible_keys key key_len ref
&g
On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote:
> What does the explain plan look like?
>
id select_type table type possible_keys key key_len ref rows
Extra
1 SIMPLE properties ref old,price,countyid countyid 3 const 9233 Using where;
Using filesort
The filesort I know
What does the explain plan look like?
John Smith wrote:
Afternoon All,
I have the following table structure:
CREATE TABLE properties (
id int(11) NOT NULL auto_increment,
propid varchar(14) NOT NULL default '0',
townid varchar(255) NOT NULL default '',
countyid mediumint(5) NOT NULL default '0'
machine.
Victor
-Original Message-
From: Dan Johnson
To: [EMAIL PROTECTED]
Sent: 4/12/04 9:16 AM
Subject: Re: Queries per second average
Victor Pendleton wrote:
>I agree with Peter, 50 queries per second is not a MySQL limit. Have
you
>checked the slow
>query log or the *.err lo
Awesome. Hope it works out.
P
Dan Johnson <[EMAIL PROTECTED]>
04/12/2004 02:16 PM
To: [EMAIL PROTECTED]
cc:
Subject: Re: Queries per second average
Victor Pendleton wrote:
>I agree with Peter, 50 queries per second is not a MySQL limit.
Victor Pendleton wrote:
I agree with Peter, 50 queries per second is not a MySQL limit. Have you
checked the slow
query log or the *.err log file to see if anything is being logged or if
`bad-performing`
queries are causing this bottleneck? Have you checked your variables to see
what your
`max-c
Dan Johnson wrote:
The site that I am working on is experiencing MySQL freeze ups any
time after the 'Queries per second average'; seen on the STATUS
output; is at 48-50 in value. When the site owner asked the hosting
service about this they told him that the MySQL cannot go above that
limit.
At 08:16 AM 4/12/2004, you wrote:
The site that I am working on is experiencing MySQL freeze ups any time
after the 'Queries per second average'; seen on the STATUS output; is at
48-50 in value. When the site owner asked the hosting service about this
they told him that the MySQL cannot go above
I agree with Peter, 50 queries per second is not a MySQL limit. Have you
checked the slow
query log or the *.err log file to see if anything is being logged or if
`bad-performing`
queries are causing this bottleneck? Have you checked your variables to see
what your
`max-connections` variable is?
I've done hundreds if not thousands of queries per second...
I do not see how the server can be an issue unless it's configuration is
bare.. And I don't know how much
that should affect it if it's a decent server :-/ If there are
configuration constraints, it could be disk that's mussing
it up.
Quoting Jeremy Zawodny <[EMAIL PROTECTED]>:
> On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote:
> >
> > An example from just after restart (using myTop in 'm' mode showing
> > number of queries executed each 1 second interval):
>
> Dan has your answer on this. I'm just amazed th
On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote:
>
> An example from just after restart (using myTop in 'm' mode showing
> number of queries executed each 1 second interval):
Dan has your answer on this. I'm just amazed that anyone uses the 'm'
feature. I added it mostly as a d
In the last episode (Oct 15), Gavin Foster IFP said:
> From our calculations site usage should be generating around 6
> queries per second. This is confirmed by the frequency of queries
> appearing in the master binlog, and by increases in the 'questions'
> value of 'show variables' on the backup
Mike, what version of MySQL are you running?
A month ago or so, I tried 4.1alpha on a FreeBSD4.8 machine and noticed the same
thing you are describing. I had a bunch of threads inserting on a MyISAM table and
the threads would just wedge. They'd show up in SHOW PROCESSLIST and wouldn't
respond to
I use mytop. The only thing that I see is x "insert" queries all trying to
insert to the same table. Killing the oldest query doesn't help, in fact
killing any or all of them doesn't do any good either (they just appear to
get "marked" as killed).
Note that the table that they're waiting for is
On Thu, Jul 03, 2003 at 06:51:28PM +, Mike Lucente wrote:
> Hello,
>
> I have nine process that import data to tables with the same structure
> within about 1000 databases on a server. Each process fires at the same
> time, every 5 minutes.
>
> Lately I'm seeing these inserts hang, all wait
On Wed, Sep 18, 2002 at 02:00:54PM -0600, Mike Hillyer wrote:
> Hi All;
>
> Is there any way to get a real time queries per second in MySQL as opposed
> to the average given when I request the server status?
Use mytop:
http://jeremy.zawodny.com/mysql/mytop/
That's partly what I wrote it to d
From: Mike Hillyer
MH> > Is there any way to get a real time queries per second in MySQL as
MH> > opposed to the average given when I request the server status?
From: Dan Nelson
DN> Request status twice, with a 1-second delay in between.
I think what Mike is looking for is an average across a
In the last episode (Sep 18), Mike Hillyer said:
> Hi All;
>
> Is there any way to get a real time queries per second in MySQL as
> opposed to the average given when I request the server status?
Request status twice, with a 1-second delay in between.
--
Dan Nelson
[EMAIL PROTEC
At 14:00 -0600 9/18/02, Mike Hillyer wrote:
>Hi All;
>
>Is there any way to get a real time queries per second in MySQL as opposed
>to the average given when I request the server status?
"real time" defined how, exactly?
>
>Mike
-
On Tue, 9 Apr 2002 13:17:59 +0800
Alvin Chen <[EMAIL PROTECTED]> wrote:
> hi. I'm using MySQL 3.23.38, default settings for the mysql variables(my-large.cnf),
> linux 2.2.14-5.0smp kernel - Red Hat 6.2, Records 140750, Size 101.0 MB, mem 1G, CPU
>PIII 800.
> But for some reason queries take too
If you only want it ascending, take out the DESC as in:
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC LIMIT
3";
- Original Message -
From: "David Rice" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 12:19 PM
Subject: Queries help (part
$query = "SELECT * FROM gigs WHERE date > '$today' ORDER BY date ASC LIMIT
3";
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:20 PM
To: [EMAIL PROTECTED]
Subject: Queries help (part II)
Hey thanks i got it to work sort of
$query = "SELEC
D'oh. Forgot he wanted after now :)
Thanks.
On Thu, 2002-03-28 at 10:46, DL Neil wrote:
> David, Steven,
>
> > I think this is what you want?
> >
> > select * from table order by date_column ASC; ( for ascending order..)
> > select * from table order by date_column DESC; ( for descending
> ord
David, Steven,
> I think this is what you want?
>
> select * from table order by date_column ASC; ( for ascending order..)
> select * from table order by date_column DESC; ( for descending
order..)
>
> Replace 'table' with the name of your table and date_column with the
> name of the column that
Hey David.
I think this is what you want?
select * from table order by date_column ASC; ( for ascending order..)
select * from table order by date_column DESC; ( for descending order..)
Replace 'table' with the name of your table and date_column with the
name of the column that contains the dat
I don't think MySQL has a mechanism for doing any sort of stored procedure,
but, I just saw this earlier today and went adn looked at it.
It may help you, but I know nothing about it and con offer no further
advice.
Ken Hylton
Programmer Analyst IV
LEC Systems & Programming
Billing Concepts, In
On Tue, Jan 15, 2002 at 01:11:34PM -0800, James Montebello wrote:
>
> If the client closes the connection grace fully (using the MySQL
> handshaking to close the connection), then it will be cleaned up.
Yep.
> If the client severed the connection w/o performing the close
> handshake (say, if it
On Tue, Jan 15, 2002 at 02:59:05PM -0600, Greer, Darren (MED) wrote:
>
> If say, that client closes the connection at some point in the
> future...that will clean up then?
Then the entry will vanish from the list.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (4
up then? Or has the connection been severed?
>
> -Original Message-
> From: James Montebello [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 1:59 PM
> To: Greer, Darren (MED)
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: Queries entering "Sleep
EMAIL PROTECTED]'
Subject: Re: Queries entering "Sleep" state.
This is caused by a connection that's still held open by a client, or
(more commonly) by a connection that wasn't closed gracefully by the
client. One of the oddities of TCP is that one end of the connection
won&#
This is caused by a connection that's still held open by a client, or
(more commonly) by a connection that wasn't closed gracefully by the
client. One of the oddities of TCP is that one end of the connection
won't "know" that the other end has dropped the connection until it
tries to write somet
On Wed, Dec 05, 2001 at 04:57:42PM -0700, Jon Gardiner wrote:
>
> I can't speak for other table formats but in MyIsam tables you can
> take your database down, rename the table's files (.frm .MYI .MYD),
> and restart the server. I'd make a backup if you are going to try
> it, though.
Watch out i
inskis [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 05, 2001 4:16 PM
> To: [EMAIL PROTECTED]
> Subject: Re: queries on particular table produce errors
>
>
> On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote:
>
> > At 15:55 -0700 2001/12/05,
Alex Pukinskis writes:
> mysql> ALTER TABLE 'group' RENAME groups;
> ERROR 1064: You have an error in your SQL syntax near ''group' RENAME
> groups' at line 1
It should be ` (backtick) rather than ' (apostrophe/single quote). This
is explained i the manual section on table/column names if I'm
On Wednesday, December 5, 2001, at 04:08 PM, Robert Alexander wrote:
> At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>>> group is a reserved word, use groups as table name
>>
>> That being the case, how do I drop or rename a table called "group"?
>
> Try:
>
> ALTER TABLE 'group' RENAME new_ta
At 15:55 -0700 2001/12/05, Alex Pukinskis wrote:
>> group is a reserved word, use groups as table name
>
>That being the case, how do I drop or rename a table called "group"?
Try:
ALTER TABLE 'group' RENAME new_table_name
HTH,
/Rob
~
Robert Alexander, A
On Wednesday, December 5, 2001, at 03:44 PM, Philippe Parmentier wrote:
> group is a reserved word, use groups as table name
That being the case, how do I drop or rename a table called "group"?
-Alex
--
Alex Pukinskis
Internet Consultant
aboutChange
http://aboutchange.com
http://aboutcreati
Yes, group is a reserved word (think GROUP BY). See
http://www.mysql.com/doc/R/e/Reserved_words.html
I believe you can make this work by putting the table name in quotes, e.g.
Select * FROM 'group';
but you will probably find it easioer to rename your table.
Michael
On Wed, 5 Dec 2001, A
group is a reserved word, use groups as table name
-Original Message-
From: Alex Pukinskis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 11:39 PM
To: [EMAIL PROTECTED]
Subject: queries on particular table produce errors
Whenever I try to do anything with a specific table
[EMAIL PROTECTED] wrote:
>
> Hello,
> When you create a query, how do you save it? Is there a special
> command to save a query?
>
> Thanks Mark
>
Query is just text... if you are in unix under mysql monitor
you can do
\e
on any line after you run the query (and before you type a new
mySQL currently does not support stored queries or views, though views are
planned in a future version of mySQL according to
http://www.mysql.com/doc/T/O/TODO.html. You can achieve a good speed
increase using mySQL as a back end to Access. The amount of performance
improvement will depend great
69 matches
Mail list logo
