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 log file to see
or not the second part is found or not.
The solution I presently have does a query for the first criteria.
Then, I loop through the results of that query and do another query
for each returned row. This produces the desired results but requires
a lot of queries, i.e.-- if the first query returns 1000
: 4/9/04 8:20 AM
Subject: Better Solution than Multiple Queries?
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each
* Tim McDonough
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two criteria whether or
Tim McDonough writes:
The solution I presently have does a query for the first criteria.
Then, I loop through the results of that query and do another query
for each returned row. This produces the desired results but requires
a lot of queries, i.e.-- if the first query returns 1000 customers
here. Is there some way I can get around 2 queries
and do this as one?
Use UNION:
http://www.mysql.com/doc/en/UNION.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net
Hi,
My MySQL server is running on a 2-cpu machine with SMP RedHat 9.0. Currently I'm
executing a lot of small INSERT-queries on it. My client program is single-threaded
using the basic mysql-API functions and causes 20% load. The client closes the
connection to the server upon completion
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending on whether rows
Matt Chatterley wrote:
One option would be to 'union' the two queries (assuming the columns are the
same type and length), allowing you to run one query string:
Select serial from blacklist where serial = x
Union
Select serial from seriallist where serial = x
Would return 1 or 2 rows, depending
to.
As you can see, this is pretty basic. I never did much with queries being
sent this fast (100+ a minute) so any advise is welcome.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Chris,
You would have to send the table structures including any indexes and also
the real queries.
It would also help if you would send an explain on your select statements.
100+ a minute is not much, I have one server currently doing:
Queries per second avg: 3157.235
Yes, that's per second
never did much with queries being
sent this fast (100+ a minute) so any advise is welcome.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
queries
and do this as one?
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
[EMAIL PROTECTED]Novato, CA U.S.A.
--
MySQL General
Casey Sheridan [EMAIL PROTECTED] wrote:
I have a table that has employee names, pay rates, and unique IDs. I want
to select all of the distinct employee names, and if there are two employees
with the same name, I want to be able to choose only one; the one with the
highest pay rate. If there
I have a table that has employee names, pay rates, and unique IDs. I want
to select all of the distinct employee names, and if there are two employees
with the same name, I want to be able to choose only one; the one with the
highest pay rate. If there are two identical employee names with the
Hello,
$a = mysql_query(Select a,b FROM t WHERE category=1)
while($a) {
$x = $a[a];
//some echo
//another query
$b = mysql_query(Select * FROM t WHERE subcategory=$x)
while ($b) {
//some echo
}
}
Poent is thet I have menus, parents with childes (childes are not
parents) and I want to display
dr zoidberg wrote:
Hello,
$a = mysql_query(Select a,b FROM t WHERE category=1)
while($a) {
$x = $a[a];
//some echo
//another query
$b = mysql_query(Select * FROM t WHERE subcategory=$x)
while ($b) {
//some echo
}
}
Not tested and might need some tweaking in the where clause, but should be at
field UNIQUE on data load. This would reduce the data for
other queries to be run but maybe it makes sense to have a few table sets.
2) change the numeric fields from varchars to ints, smallints or something
like that.
3) Not sure if NULL values are slower or faster than using a comparison
: Chris Fossenier [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 10:38 AM
To: [EMAIL PROTECTED]
Subject: Optimizing Queries
Hello,
I'm trying to determine the best way to optimize the query below. Right
now
it is taking around 9mins and we need it to take no more than 30 seconds
Hello Chris,
Tuesday, March 9, 2004, 4:38:00 PM, you wrote:
CF I'm trying to determine the best way to optimize the query below. Right now
CF it is taking around 9mins and we need it to take no more than 30 seconds (we
CF can get it under 30s on MS SQL):
CF | 1 | SIMPLE | speedlink | ref
Chris,
Is it faster if you remove the 'IS NOT NULL'? I know that's not the
results
you want, but we have found that is NOT NULL will do a full scan. But
we
normally use it with a join. Since you are using one table, I'm not
sure
how it would affect it.
Donny
This is an interesting
Why does it only use the one index?
Chris.
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 11:00 AM
To: [EMAIL PROTECTED]
Subject: Re: Optimizing Queries
Hello Chris,
Tuesday, March 9, 2004, 4:38:00 PM, you wrote:
CF I'm trying
Hello Chris,
Tuesday, March 9, 2004, 6:15:56 PM, you wrote:
CF Why does it only use the one index?
It will evaluate the best index to use for the query and if all you
have are single-field indexes, it can only select one of those.
From the MySQL manual:
If a multiple-column index exists on
: Tuesday, March 09, 2004 11:00 AM
To: [EMAIL PROTECTED]
Subject: Re: Optimizing Queries
Hello Chris,
Tuesday, March 9, 2004, 4:38:00 PM, you wrote:
CF I'm trying to determine the best way to optimize the query below.
CF Right now it is taking around 9mins and we need it to take no more
CF than 30
: Optimizing Queries
Rich,
Thanks for the email. I created a multi-field index using the fields that
are in the query and the query only took 0.91 seconds. That's better than
9
minutes and definitely under 30 seconds.
Thanks.
Chris.
-Original Message-
From: Richard Davey [mailto
Hello Chris,
Wednesday, March 10, 2004, 12:48:02 AM, you wrote:
CF Thanks for the email. I created a multi-field index using the fields that
CF are in the query and the query only took 0.91 seconds. That's better than 9
CF minutes and definitely under 30 seconds.
Glad to hear it.
Farewell MSSQL
not supposed to be able to use
mysql_get_metadata on the SHOW queries?
mysql_get_metadata() will work with any other result set returning command (and with
SHOW queries too). But currently it's not implemented.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
on the SHOW queries?
--
Nathaniel Blanchard
Developer
Sane Solutions, LLC
401-295-4809 ext 142
401-295-4154 fax
[EMAIL PROTECTED]
This e-mail message may contain confidential information. If you are not
the intended recipient, any use, dissemination, distribution or copying
of this e-mail message
G B U [EMAIL PROTECTED] wrote:
Recently I've come around that mysql (4.1.0 at least) treats different
queries containing non-english characters (in my case characters from
cp1251 charset) as the same query and therefore returns wrong results.
For example the following queries are regarded
Just to be sure that this question is not supressed here :)
Recently I've come around that mysql (4.1.0 at least) treats different
queries containing non-english characters (in my case characters from
cp1251 charset) as the same query and therefore returns wrong results.
For example the following
Recently I've come around that mysql (4.1.0 at least) treats different
queries containing non-english characters (in my case characters from
cp1251 charset) as the same query and therefore returns wrong results.
For example the following queries are regarded as identical while they are not:
SELECT
Does anybody know the product able to serialize multiple similar queries coming from
different sources to the one SQL server? Could
be nice to have something as a SQL proxy with cashing pool, expiration, etc to put the
main server load down and release his
resources.
Thanks in advance
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users wherelocations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for
Gregorio [EMAIL PROTECTED] wrote:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax. Check the manual that
What MySQL version are you running?
Original Message dated 2/25/04, 9:19:43 AM
Author: Gregorio [EMAIL PROTECTED]
Re: Nested queries:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
Gregorio [EMAIL PROTECTED] wrote on 25/02/2004 15:19:43:
This is the query i want to run but i doesn't work.
select id from c_table where users_id in (select id from users where
locations_id=3) order by data_ora
But it gives me this error:
You have an error in your SQL syntax.
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.
So, it's hard to track down and work on the queries
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
I have a query where I want to display the column headings as row
headings.
Here is my query:
Code:SELECT DISTINCTROW Avg(DateDiff(OrderDate, POItem.ReceivedDate))
AS AvgLeadTime,
Min(DateDiff(Po.OrderDate, POItem.ReceivedDate)) AS MinLeadTime,
Max(DateDiff(Po.OrderDate, POItem.ReceivedDate))
to speed up queries such as
select * from bla where attributes 1;
Are there any plans to add a special key type for bit fields (just as
there is a special key type for full-text search now)?
Or is there a key type for sets by now? ([1] claims there isn't.)
Thanks,
Hanno
[1] http
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;
wrote:
Hi all,
now that MySQL 5 has support for Stored Procedures,
i was wondering if anyone managed to port (or migrate) the
Stored Procedures from MS Access to MySQL ??
(With Stored Procedures i'm referring to "queries" as they're
called in MS Access)
Regards to all /
Hi all,
now that MySQL 5 has support for Stored Procedures,
i was wondering if anyone managed to port (or migrate) the
Stored Procedures from MS Access to MySQL ??
(With Stored Procedures i'm referring to queries as they're
called in MS Access)
Regards to all / Mihalidis
--
MySQL
Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update
from APT seems to have destroyed mysql somehow.
Mysql Version is 3.23.58-1.9
Any query kills the child process of mysqld and it has to respawn. This
does not seem to be the proper behaviour and it is causing many
Have you looked in the hostname.err logs for the MySQL server?
Original Message
On 2/4/04, 2:00:53 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Mysql ECHILD resets on Queries:
Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update
from APT seems to have destroyed
Mysql ECHILD resets on Queries:
Ive got a machine running redhat 9 kernel 2.4.20-28.9 and a recent update
from APT seems to have destroyed mysql somehow.
Mysql Version is 3.23.58-1.9
Any query kills the child process of mysqld and it has to respawn. This
does not seem
The hostname.err log will generally be located in the data directory.
Original Message
On 2/4/04, 2:42:02 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
Where exactly SHOULD these be and is it something I need to enable in
my.cnf
the generic /var
A locate *.err returns nothing?
What happens when you attempt to start MySQL with safe_mysqld?
Original Message
On 2/4/04, 3:04:54 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
nothing of the sort. no .err files on the machine nothing named
to start MySQL with safe_mysqld?
Original Message
On 2/4/04, 3:04:54 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
nothing of the sort. no .err files on the machine nothing named
redstone.err or localhost.err.
Just baffling. something
If the server is up and running can you log in a perform a
show variales from the mysql monitor. From this information you can learn
where your logs are being stored.
...
Also, what sort of logging are you currently performing? Are you logging
just errors , slow queries or everything
your logs are being stored.
...
Also, what sort of logging are you currently performing? Are you logging
just errors , slow queries or everything?
...
Original Message
On 2/4/04, 3:27:55 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries
All logging will grow very rapidly on a `busy` server. To enable all
logging you can add the --log option to the safe_mysqld command.
safe_mysqld --log
Original Message
On 2/4/04, 3:48:46 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
its pretty
On 2/4/04, 3:48:46 PM, Daniel Powell [EMAIL PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
its pretty default. I'd like to enable all logging if possible. What
specificly should I enable in my.cnf?
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
If the server
PROTECTED] wrote
regarding Re: Mysql ECHILD resets on Queries:
its pretty default. I'd like to enable all logging if possible. What
specificly should I enable in my.cnf?
On Wed, 4 Feb 2004 [EMAIL PROTECTED] wrote:
If the server is up and running can you log in a perform
Greetings!
Is anyone familiar with/can recommend any software capable of helping design
complex (well for me anyway) queries/updates/inserts with joins?
Thanks for any info!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
I am trying to query a table that has field names with # characters in them.
For example a table emp_earn has a field called FILE#
I need to do a query where FILE# = 1332, but anything I try errors out.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
From: Howell, Scott [mailto:[EMAIL PROTECTED]
I am trying to query a table that has field names with #
characters in them.
For example a table emp_earn has a field called FILE#
I need to do a query where FILE# = 1332, but anything I try
errors out.
I can't seem to even create a table
Hello Howell,
See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution.
Basically enclose FILE# with `, e.g. where `FILE#` = 1332
Bernard
On Thursday 29 January 2004 12:55, Howell, Scott wrote:
I am trying to query a table that has field names with # characters in
them. For
select * from emp where `file#` = 1332;
returns
ERROR 1054: Unknown column 'file' in 'where clause'
-Original Message-
From: Bernard Clement [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:19 PM
To: Howell, Scott; Mysql (E-mail)
Subject: Re: HELP! Select queries for tables
PROTECTED]
Sent: Thursday, January 29, 2004 1:19 PM
To: Howell, Scott; Mysql (E-mail)
Subject: Re: HELP! Select queries for tables that has fields with #
characters
Hello Howell,
See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution.
Basically enclose FILE# with `, e.g
.
-- This takes some work, but it might speed up other queries, if you
frequently
need to select all of the children for a particular parent.
HTH
Bill
Date: Thu, 22 Jan 2004 20:09:42 +0100
From: Benjamin PERNOT
To: [EMAIL PROTECTED]
Subject: JOIN 10 times quicker than LEFT JOIN on big tables
Here is my problem:
I have 2 tables, a parent table and a child table. The parent table has got 113
rows, the child table has got 3 000 000 rows.
parent:
---
| p_id | name |
---
| 1| A |
| 2| B |
| ... |... |
| 112 | C |
|
Noamn wrote:
Judging by some of the comments posed on this list, I wonder whether the
following statements are true:
1. There is no point having an index on a field if that field can only have
a few values
Not for query speed reasons. There may be other reasons
(uniqueness for instance), but for
In general, is it more efficient to do many queries or one large query
with many joins?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 02:54 PM 1/20/2004, you wrote:
In general, is it more efficient to do many queries or one large query
with many joins?
Good question. :)
I would break it down into smaller queries and use a loop because a large
query, would consume a huge amount of memory and a join needs to create
Judging by some of the comments posed on this list, I wonder whether the
following statements are true:
1. There is no point having an index on a field if that field can only have
a few values
2. A table should have at least ten entries, in order to prevent all the
table being scanned to find a
in queries and response times below,
but can send more if needed.
- Due to the patterns in the data, there are many many duplicate
values in the indexes. I suspect this might be important.
- This is not a results transport issue. I'm able to retrieve
about 1000 rows/second, which is OK. It's
It sounds like you are trying to do full text searching, but you
implemented it manually. Was MySQL's full text indexing not
sufficient for your needs or am I totally missing what you are trying
to do?
On Jan 15, 2004, at 1:53 PM, Gregory Newby wrote:
I'm using MySQL for an information
On Thu, Jan 15, 2004 at 02:52:30PM -0500, Brent Baisley wrote:
It sounds like you are trying to do full text searching, but you
implemented it manually. Was MySQL's full text indexing not
sufficient for your needs or am I totally missing what you are trying
to do?
You're absolutely right:
of variety in queries and response times below,
but can send more if needed.
- Due to the patterns in the data, there are many many duplicate
values in the indexes. I suspect this might be important.
- This is not a results transport issue. I'm able to retrieve
about 1000 rows/second
Gregory
mysql,select,query
I agree with Joe, use multiple-column index. Much more efficient.
All queries should be sub 5-10 seconds or less.
David
-Original Message-
From: Gregory Newby [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 15, 2004 11:53 AM
To: [EMAIL PROTECTED
with test data consisting of about 7 days worth
of data (630,000 rows).
The fulltext index is over two fields and I have 7 other indexes, each over a single
field. Queries are always done over at least the fulltext fields and one other indexed
field. I am using MySQL verison 4.0.17-standard-log
on 12/29/03 9:54 AM, Dave G wrote:
$wsQuery = SELECT improvwsid FROM improvws WHERE wsdate ' . $today
. ' AND wsdate ' . $sevenDays . ' AND cancelled = 0;
$wsResult = mysql_query($wsQuery);
$wsid = mysql_result($wsResult, 0, improvwsid);
$emailQuery = SELECT members.email AS email,
One extra join will do it. You're looking for all improvws in
the next seven days that aren't cancelled, right?
Yes... thank you. I see where I was going wrong now. The extra joins I
needed were to match the wsid to the member.id by matching both to where
they appear in the attend table.
MySQL Gurus,
Hello, I am new to this list. I have looked through the archives
and online, but the particulars of my situation still leave me perplexed
as to how to solve this. It may be more of a lack of ability to
logically sort my query than it is an issue of syntax.
I have three
for update; //waits until another process
updating the table if necessary
...php logicestimating new state for order
update order.state=1 where id=100 for update;
COMMIT;
we use default global isolation level REPETABLE-READ
From that moment we have many identical slow queries (about 4000 per day
dont think i couldnt really convert it ...
Select Payment_Date from payments where Payment_Id in
(select max(Payment_id) from payments where Payment_Claim_Id=#Claim_Id#)
wat option do i have other than using 2 queries ...
Also i am doing my developement using mysql 4.0 version ... i see
subquery is as follow and i dont think i couldnt really convert it ...
Select Payment_Date from payments where Payment_Id in
(select max(Payment_id) from payments where Payment_Claim_Id=#Claim_Id#)
wat option do i have other than using 2 queries ...
Also i am doing my developement using mysql
Could you please tell me more about the pass through queries. i dont have an
idea abt it
sandeep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sandeep N Seshadri wrote:
Could you please tell me more about the pass through queries. i dont have an
idea abt it
sandeep
Sure.
Create a new query in Access.
Instead of adding tables to the query design view like normal, simply
click the 'query' menu, and select 'SQL Specific
H. Steuer [EMAIL PROTECTED] wrote:
im just wondering if there are any limitations in cross database queries like:
SELECT one.* FROM db1.one, db2.two;
are there any differences in joining tables from within various databases to joinin
tables from within the same database
hello guys,
im just wondering if there are any limitations in cross database queries like:
SELECT one.* FROM db1.one, db2.two;
are there any differences in joining tables from within various databases to joinin
tables from within the same database?
the background of my question is that various
I posted this few days ago, but with no answer, also posted it to
benchmark list..
Executing this SQL, takes ~5 sec.
select artists.name , cds.title , tracks.title from artists, tracks,
cds
where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid
and MATCH (artists.name) AGAINST
One of my apps in a test enviroment is showing some strange behaviour.
Up-front-answer: No, there are no loops in this segment of code.
Snippet:
$password = sha1(stripslashes($eval['tpassword']));
$query = INSERT INTO logins (login_parent, login_name, login_password, fname,
lname) values ($id,
table.
Regards
Can you post EXPLAIN SELECT of those queries as well, please?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 11:50
To: Uros Kotnik
Cc: [EMAIL PROTECTED]
Subject: Re: Once again, three queries, same result, huge speed
difference
On Thu, 4 Dec 2003, Uros Kotnik wrote:
I posted this few days ago, but with no answer, also posted it to
benchmark list
or the fastest. Doing it this way will make sure that
the cache is used equally for all queries.
You should also do and EXPLAIN to see how MySQL is executing each query.
On Dec 4, 2003, at 5:35 AM, Uros Kotnik wrote:
Same result but the speed difference is quite a different, why is that
?
This is only
Hmmm, if I execute this 3 queries at any time in any order I get the
same execution time.
Yes, explain...
explain select artists.name , cds.title , tracks.title from artists,
tracks, cds
where artists.artistid = tracks.artistid and cds.cdid = tracks.cdid
and MATCH (artists.name) AGAINST
It's not the order in which you execute the queries, it's how many
time. Execute the first one 5 times, then the second one 5 times, then
the third one 5 times. See if the times are different between each of
the 5 runs for each query.
Also, you could try reordering your query. Perhaps
Hi all:
Having some doubts with sql select queries here :
Right now, I have a student and a withdraw tables.
For example, when student John has withdrawn, his name will be inserted
into withdraw table but John's record will be kept in student table for a
period of 30 days before
Hi all:
Having some doubts with sql select queries here :
Right now, I have a student and a withdraw tables.
For example, when student John has withdrawn, his name will be inserted
into withdraw table but John's record will be kept in student table for a
period of 30 days before
On 12/3/03 7:27 PM [EMAIL PROTECTED] wrote:
Hi,
yah that's what I'm looking for, creating a cronjob whereby this cron will
automatically delete the record once 30 days is up...maybe using something
like that:
DELETE FROM tablename
WHERE (DATA_SUB(NOW()), INTERVAL 30 DAY)
On Monday 01 December 2003 02:28, [EMAIL PROTECTED] wrote:
creating a web-site which has a spot to make a query as well as text boxes
to input data into the database. This way I won't have to type all the
mysql commands to add new entrys.
I already have the mySQL database installed, as well
I've been wanting to learn mySQL and phpmyadmin and make a website that enables me to
make queries to my database and add information to the database. I'm not sure how I
could go about doing this though. My main goal is to database all my software and then
be able to access the database over
Greetings,
From what I can gather the Queries per second average quoted by status
is a pure division of Questions by Uptime in show status. Is there a
way to flush these figures periodically? I want to be able to set the bin
interval for this average, otherwise fluctuations get smoothed out
701 - 800 of 1256 matches
Mail list logo
