Hi!
Check out db4free.net. :)
Cheers,
Jay
Andrew J. Leer wrote:
Is there a listing of public MySQL Databases anywhere?
Just if someone would be new to databases (not me...other people at my
office) and they would want to get a look at an existing working
database to learn SQL on?
I've
Please actually read my reply before asking the same question. As I
stated, InnoDB outputs *estimated* row counts in EXPLAIN, whereas MyISAM
outputs *accurate* row counts.
-jay
Krishna Chandra Prajapati wrote:
Hi,
On myisam storage system
mysql explain select ui.user_id,
The MyISAM isn't scanning more rows. It's that the InnoDB rows output
in EXPLAIN is an estimate and the MyISAM one is accurate...
-jay
Krishna Chandra Prajapati wrote:
Hi All,
I have same table configuration, every thing same except the storage engine.
Explain result on innodb system
You will likely need to be a lot more specific about what you are asking
for here, David. What is a large select? What constitutes a large
update? What number of joined tables composes a multi join in your
specific case? What is text functionality?
-jay
David Stoller wrote:
Can Someone
Nope, no difference, AFAIK.
Alex K wrote:
Any ideas pertaining this newbie question?
Thank you so much,
Hi Guys,
Is there a performance hit when joining across multiple databases as
opposed to joining multiples tables in one database? Suppose the same
tables are available across all
Are you using the PREPARE STATEMENT server-side syntax or an emulated
prepared statement like in PDO?
-jay
mos wrote:
I would like to speed up my Select queries since I'm executing approx
5,000 of them, same syntax but the search values for 2 columns will
change with each query. Will I see
No problem. I hope by now you figured out I made a typo... :) The
WHERE in the DELETE should be prod_price_chg_flag='O', not =X :)
-jay
Jerry Schwartz wrote:
Hi Jerry!
The very last sentence on:
http://dev.mysql.com/doc/refman/5.0/en/delete.html
is Currently, you cannot delete from a
You could use a view:
CREATE VIEW all_scores
SELECT s.tid, s.vid, s.uid, s.highScore
FROM score s
JOIN objects o
ON s.tid = o.tid
JOIN itemtypes it
ON s.vid = it.vid
JOIN users u
ON s.uid = u.uid
WHERE o.shortname = %s /* Should these ANDs really be ORs? */
AND i.itemtype LIKE %s;
SELECT
Hi Jerry!
The very last sentence on:
http://dev.mysql.com/doc/refman/5.0/en/delete.html
is Currently, you cannot delete from a table and select from the same
table in a subquery.
But, to bypass that, you can create a temp table and join to that:
CREATE TEMPORARY TABLE to_delete
SELECT
INSERT ... ON DUPLICATE KEY UPDATE:
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Cheers,
Jay
J Trahair wrote:
This is a question I want to know the answer to, as well! Is there any way of
avoiding looking up a specific record in a table to see if it exists, before
Sujatha S wrote:
Mysql should bring this as there new feature in there next release!
Unlikely. Dynamic changes are, well, dynamic. Permanent stuff goes in
the my.cnf.
-jay
Regards,
Sujatha
On Nov 27, 2007 11:44 AM, Shanmugam, Dhandapani
[EMAIL PROTECTED] wrote:
Hello,
The
Indeed, as you say, Brent, correlated subqueries are not well-optimized
in MySQL. The specific subquery (the IN() subquery) demonstrated in the
original post is, however, optimized in MySQL 6.0 :)
More comments inline.
Brent Baisley wrote:
You are using a correlated subquery, which MySQL is
Daevid Vincent wrote:
I'm trying to get some 'release/version numbers' to sort properly.
mysql SELECT ReleaseID, Name FROM releases ORDER BY Name DESC;
+---+-+
| ReleaseID | Name|
+---+-+
|18 |
right... :)
Cheers, and post back here if you've got any further ?s.
Jay Pipes
Program Chair, MySQL Conference and Expo 2008
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Craig,
would you mind posting the SHOW CREATE TABLE for the tables in question?
I'm having trouble determining what is the primary key for your
service ticket table...
Thanks,
-Jay
Weston, Craig (OFT) wrote:
Hello again,
I am having a duplication of results problem. I
Christoph Boget wrote:
I did a search and couldn't find anything like what I'm looking for and
though I doubt something like this does exist, I figured I'd ask anyway. Is
there a client (not phpMyAdmin) that can connect to a server (that is
running MySQL) using SSH and connect to the database
[EMAIL PROTECTED] wrote:
We have numerous identical tables with a varchar column that holds data
like this: 0 0 0 1 0 1 0 25 7 0 139 0 9. Essentially there are a bunch
of integers with a single space as a separator. There _should_ be no more
than 30 entries ( and 29 spaces ), but sometimes the
Andrew Braithwaite wrote:
Does anyone know if thread_concurrency works in linux or is it just
limited to Solaris and Windows?
Hi! That variable only affects Solaris, as the Solaris threading
library supports thr_setconcurrency().
innodb_thread_concurrency, however, can affect all
Hi! Comments inline.
Edoardo Serra wrote:
SELECT sum(usercost) FROM cdr WHERE calldate BETWEEN '2007-06-01
00:00:00' AND '2007-06-30 23:59:59'
If I run it on the MyISAM table, MySQL choose the right index (the one
on the calldate column) and the query is fast enough
If I run it on the
SELECTs don't lock the table. Are you having frequent UPDATEs while
selecting? That would be the reason for locks.
-jay
Justin wrote:
Ok.. Straight to the point.. Here is what I currently have.
MySQL Ver 14.12 Distrib 5.0.27
RHEL vs 5
584GB Raid 5 storage
8GB of RAM
and Dual 5130
and a write lock when the client issues an INSERT statement.
Implicit locks are acquired only for the duration of a single statement.
- Original Message -
From: Jay Pipes [EMAIL PROTECTED]
To: Justin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Monday, August 27, 2007 2:26:29 PM (GMT-0500
solidzh wrote:
2007/8/21, Jay Pipes [EMAIL PROTECTED]:
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
GRANT SELECT
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions everytime a new DB is added. Is there a way to do this?
GRANT SELECT, INSERT, CREATE, ... ON *.* TO 'username'@'hostname'
Yep.
Terry wrote:
Just to verify, will that include all new databases?
On 8/20/07, Jay Pipes [EMAIL PROTECTED] wrote:
Terry wrote:
Hello,
I want to grant a user all permissions to all DBs on the system as
well as any new DBs that show up. I want to avoid having to modify
permissions
privileges from one schema ('mysql' in this instance)
You must enumerate the databases you specifically want to grant the user
privileges to.
GUARD THE mysql SCHEMA WITH YOUR LIFE, PLEASE
- Original Message -
From: Jay Pipes [EMAIL PROTECTED]
To: Terry [EMAIL PROTECTED]
Cc: mysql
Ed Reed wrote:
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative
[EMAIL PROTECTED] wrote:
Problems again with the survey design and functionality. Page 4 asks
questions about Falcon, and to be honest I don't know anything about
Falcon, but you've required answers to advance and only offered yes' and
no' as choices. Without a Don't know choice as an option,
: [EMAIL PROTECTED]
Sent: Tuesday, August 07, 2007 9:35 AM
To: 'Jay Pipes' [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: RE: 2007 MySQL Community Survey - Got Ten Minutes to Spare?
Having a moment of altruism, I started doing the survey only to find that
it wouldn't let me advance to the next page
like to go into the drawing for the books, just include your email
address in the very last question...otherwise, just leave it blank.
Link to the 2007 Community survey:
http://www.surveymonkey.com/s.aspx?sm=ONCdTFPxjyq55NAUBUJ_2fvQ_3d_3d
Thanks much!
Jay Pipes
Community Relations Manager
and community projects.
Limited Registration
Registration for MySQL Camp II is restricted to only 200 participants,
and space is filling up quickly. To register, email Jay Pipes
([EMAIL PROTECTED]) the following information:
- Your Name
- Your Company or Affiliation
Hi Jerry, comments inline
Jerry Schwartz wrote:
I need (ultimately) to update some prices in a prod_price table. First, I
need to locate a product and its associated prices using a field
prod.prod_price_prod_id which is not unique, and is often null, but it is
indexed. (Subsequent
a production version.
Cheers,
Jay
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 18, 2007 10:04 PM
To: Brent Baisley
Cc: He, Ming Xin PSE NKG; mysql@lists.mysql.com
Subject: Re: Problem on millions of records in one table?
Brent Baisley wrote
Fionn Behrens wrote:
We recently switched to mysql5 and while we were at it we also changed
our logs from text to bin as suggested by the migration script we had
(probably created by debian people).
Now I unfortunately had to reconstruct what had happened during a faulty
run of our application
Brent Baisley wrote:
It all depends on how complicated your data and searches are. I've got
tables that add 2-3 million per day and I don't have performance
problems. Although we only retain at most 500 millions records, not a
full years worth.
That said, you can get horrible performance out
Baron Schwartz wrote:
Greetings,
On 5.2.3:
select plugin_name, plugin_license from plugins;
+-++
| plugin_name | plugin_license |
+-++
| binlog | GPL|
| partition | GPL|
| ARCHIVE | GPL|
|
Ales Zoulek wrote:
Hi,
I've read reacently, that it's not good to use columns with NULL
values in MySQL, because it slows down the select queries over that
columns. Is it true? Or do that affects only some situations or some
versions? Are there some relevant statistics about that?
There is
Could you post the actual code you are using for the INSERT? Also, what
storage engine are you using?
Jay
andrew collier wrote:
hello,
i am having some trouble getting mysql to perform decently on my machine. it is
a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit
Not sure what is going on, but the version of MySQL you are using is
ancient. The current version of MySQL is 5.0.37. Even MySQL 4.1 (which
has been end-of-lifed) has a latest version of 4.1.22. If it is a bug
you are seeing, it likely has been fixed in a later version.
Cheers,
Jay
Brown, Charles wrote:
Hello Dan. Try it and see if you can:
mysql create index indx101 on tab101(min(c1),c2) ;
Answer: Its not supported.
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 13, 2007 9:10 AM
To: Ananda Kumar
Cc: mysql@lists.mysql.com
Ed wrote:
Hi All,
I'm trying to figure out how to put a pdf file into a blob field.
I guess a pdf file is a binnary file and it will contain characters that will
mess things up, so my question is:
can it be done? Or better, how can it be done? ;)
Any pointers to documentation are a bonus!
SELECT *
FROM table_one t1
INNER JOIN table_two t2
ON t1.column_one = t2.column_one
LEFT JOIN table_three t3
ON t3.column_two = t1.column_three
AND t3.column_four = t1.column_five
WHERE column_six LIKE '%dsc%'
AND column_seven LIKE '%aaa%';
There is no need for a derived table.
Also, using LIKE
DELETE bm_KW FROM bm_KW
INNER JOIN (
SELECT kw2.KeywordID
FROM bmjn_KW kw1
INNER JOIN bmjn_KW kw2
ON kw1.KeywordID = kw2.KeywordID
AND kw2.ItemID != '1016'
WHERE kw1.ItemID = '1016'
) AS keywords
ON bm_KW.KeywordID = keywords.KeywordID;
Miles Thompson wrote:
This query works but is there any way
book Pro
MySQL (Apress, 2005) has a couple chapters on effective SQL coding.. :)
Cheers,
Jay
Regards - Miles Thompson
From: Jay Pipes [EMAIL PROTECTED]
DELETE bm_KW FROM bm_KW
INNER JOIN (
SELECT kw2.KeywordID
FROM bmjn_KW kw1
INNER JOIN bmjn_KW kw2
ON kw1.KeywordID = kw2.KeywordID
AND kw2
No, because you have no WHERE condition.
wangxu wrote:
sql:
SELECT *
FROM table_one INNER JOIN table_one table_one1 ON table_one1.column_one =
table_one.column_two
INNER JOIN table_one table_one2 ON table_one2.column_one =
table_one.column_three
Chris Boot wrote:
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've hardly
ever got anywhere near my connection limit.
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: Chris Boot [EMAIL
Chris Boot wrote:
Jay Pipes wrote:
Chris Boot wrote:
Rolando Edwards wrote:
Also consider
wait_timeout in my.ini
This is set to 28800. I don't consider this a problem since I've
hardly ever got anywhere near my connection limit.
- Original Message -
From: Rolando Edwards [EMAIL
software advocate wrote:
Wow, well that is just neat. It's too bad I left PHP for TurboGears.
The second problem is the buzz of frameworks (TurboGears, JBoss, etc) which
use/want to use MySQL as a backend. This is really the only issue I have
with MySQL. They do support other databases, and its
software advocate wrote:
On 2/22/07, Jay Pipes [EMAIL PROTECTED] wrote:
I have no idea what this means. :(
First, you were complaining about PHP and Jim noted that we have a PHP
native driver in the works. Then, you move on to Python and Java...
sounds like you're just flame-baiting.
I
software advocate wrote:
On 2/22/07, Jay Pipes [EMAIL PROTECTED] wrote:
I do see your point about the sockets layer/client protocol and that
language is being removed/has been removed from our website because it
has been, as you point out, a source of confusion; I will agree with you
Chris White wrote:
Jay Paulson wrote:
2) both tables have data in them.
This is most likely your issue then, depending on the table size, go
through and make sure that anything in the referenced column matches the
referencing column. You should also be able to use SHOW INNODB STATUS
to
Cory Robin wrote:
We have a statement that joins 8 different tables to pull
multiple rows from each table.
I have heard of people using triggers to create, update and
delete records in a table based on statements in other
tables.
The obvious result of this would be to SPEED up results
Kevin Burton wrote:
A little birdie:
http://forge.mysql.com/wiki/Top10SQLPerformanceTips
notes..
In 5.1 BOOL/BIT NOT NULL type is 1 bit, in previous versions it's 1 byte.
Is this true?
Hmm, I had wondered about that when someone yelled it out at MySQL Camp...
No, it's not true. The
Kevin Burton wrote:
I want to use a merge table so that I can direct all new INSERTs to a
new merge table and migrate old data off the system by having a
continually sliding window of underlying MyISAM tables.
The problem is that of I do INSERT ... ON DUPLCATE KEY UPDATE and
that value isn't
Miguel Vaz wrote:
I have three tables:
TABLE Person
- id_person, name, id_levelA, id_sizeA, id_levelB, id_sizeB
TABLE Levels
- id, desc
TABLE Sizes
- id, desc
Hi! You can always join a table twice :)
SELECT
p.id_person
, lA.desc as levelA
, sA.desc as sizeA
,
Or, another, perhaps easier way:
SELECT * FROM foobar
WHERE yourdatefield CURDATE() - INTERVAL 7 DAY;
Cheers,
Jay
Lars Schwarz wrote:
depending on your mysql version:
for the date/time field version:
select * from foobar where yourdatefield DATE_ADD( CURDATE( ) ,
INTERVAL -7 DAY )
i
For exact calculations, you need to use the DECIMAL data type. See this
section in the manual for the reasons why:
http://dev.mysql.com/doc/refman/5.1/en/precision-math-examples.html
Cheers,
Jay
Kerry Frater wrote:
I am running a small procedure for set jobs that calculates a running total
Daniel Kasak wrote:
VeeJay wrote:
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
Really? Seems pretty straightforward to me. One the downloads page,
under the
Make sure that all joined fields are of identical types, otherwise the
query executor must cast each and every join value, which may be
affecting the query time...
Jay
Chris Boget wrote:
Here is a query I'm trying to run. It doesn't look like it is overly
complex and, granted, it's joining on
Charles Danko wrote:
Hi,
I am trying to write a new table into main memory, but I am getting an out
of memory error.
Each entry consists of 2 medium_int and 1 tiny_int variables, and the table
contains just over 100,000,000 rows. By my count, this makes just over
700MB of data. The
is starting to materialize, and will be filling in
over the next week by the participants. If you are interested in
attending this free event, please head over to the camp website:
http://mysqlcamp.org and check out what's going on.
Hope to see everyone there!
Cheers,
Jay Pipes
Community Relations
On Thu, 2006-10-19 at 18:18 -0300, JoXo CXndido de Souza Neto wrote:
I tried to escape the pipe character but it does not work.
I shall try to explain better what is happening.
I have got a .sql file which create my whole database (including triggers).
When i run it at phpmyadmin it
On Tue, 2006-10-17 at 09:26 -0700, Robert DiFalco wrote:
I have an unavoidable filesort in a very large query. Can someone point
me to references for optimizing filesort? I'm assuming this is going to
be changes to my.ini or the hardware.
Well, one method to *eliminate* Using filesort is to
On Mon, 2006-09-25 at 06:09 -0700, Steffan A. Cline wrote:
Basically all 6 should come up in the big query because they are within the
same zip and that any other locations within the same area. They all have
the same latitude and longitude but only 1 shows up.
If they all have the same
Hi!
Please see the Forge wiki and provide comments at the end of the technical
specification for pluggable authentication and authorization. Thanks!
Jay
http://forge.mysql.com/wiki/PluggableAuthenticationSupport
http://forge.mysql.com/wiki/PluggableAuthorizationSupport
On Friday 22 September
Hi! Please post the actual SHOW CREATE TABLE statements for the tables
in question. Thanks!
Jay
On Mon, 2006-09-18 at 12:03 +0500, Asif Lodhi wrote:
Hi,
I have a multi-column index (TrnsxType, TrnsxDate, TrnsxID, DepartID).
This index along with
a multi-column index of some child tables
Also, depending on the number of permissions you are tracking, you could
use a single INT field and do bitwise ORing in your application to
determine permission checks...
Though I usually don't recommend denormalizing the schema, this is one
scenario that would potentially make life a bit easier.
SQL queries from the application? That
would help immensely. 70ms for an UPDATE seems very slow... and 200ms
is very slow.
Cheers,
--
Jay Pipes
Community Relations Manager, North America, MySQL, Inc.
[EMAIL PROTECTED] :: +1 614 406 1267
--
MySQL General Mailing List
For list archives: http
Could you post an example of a query you are expecting to be cached?
On Wed, 2006-08-30 at 11:43 -0500, Mazur Worden, Kathy wrote:
Hi,
I just turned on the query cache by modifying its size and limit and
restarting the server. However queries aren't being stored to it:
= ?;
These are the main queries that we execute.
Thanks
A
On 8/30/06, Jay Pipes [EMAIL PROTECTED] wrote:
On Wed, 2006-08-30 at 08:31 -0700, Phantom wrote:
We have an application that stores versioned data in MySQL. Everytime a
piece of data is retrieved and written to, it is stored
, BuildingInfo.Name;
There are indexes on the id and name related fields used in the WHERE
clauses.
Kathy Mazur Worden
Prairie Area Library System
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 12:07 PM
To: Mazur Worden, Kathy
Cc: mysql
given up on finding a solution for this and just
rotate my tables out
regularly once the imports take over 5 minutes to process roughly 10,000
records
--
George
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 12:06 PM
| int(1)
| YES | | 0 | |
+-+-
-+--+-+-+---+
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 1:44 PM
To: George
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 12:42 PM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: RE: query cache question
Those queries look just fine to me.
Could you output the result of the following:
SELECT
=latin1 MAX_ROWS=1;
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 3:06 PM
To: George Law
Cc: mysql@lists.mysql.com
Subject: RE: Degrading write performance using MySQL 5.0.24
Hi!
Could you please post a SHOW CREATE
Use MySQL Workbench:
http://dev.mysql.com/downloads/guitools/
On Wed, 2006-08-30 at 15:11 -0400, Jerry Schwartz wrote:
Automatically? Don't know. I did it by hand using Dia, a free alternative to
MS Visio. It was tedious.
Regards,
Jerry Schwartz
Global Information Incorporated
195
1
Qcache_free_memory10477008
Qcache_hits 0
Qcache_inserts0
Qcache_lowmem_prunes 0
Qcache_not_cached 20318
Qcache_queries_in_cache 0
Qcache_total_blocks 1
Thanks
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30
On Wed, 2006-08-23 at 22:23 +0200, spacemarc wrote:
Hi,
I have a query like this:
SELECT table1.*,(
SELECT COUNT( field2 )
FROM table2
WHERE id=10
) AS total
FROM table1
GROUP BY id
LIMIT 1
but the subqueries do not work with mysql 4.1. How can I convert it
(or make to work) in
It is likely you are also logging any queries not using an index (doing
full table scans). Check the configuration variable: log_long_format
Cheers,
Jay
On Tue, 2006-08-15 at 14:45 +0200, Dominik Klein wrote:
I have specified
log-slow-queries
long-query-time=10
in my.cnf and restarted
on the
participants page, and anything else.
Not familiar with barcamps? Check out http://barcamp.org to find out
about the concept!
Cheers!
Jay Pipes
Community Relations Manager, North America, MySQL, Inc.
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
On Fri, 2006-08-04 at 17:14 -0700, Tanner Postert wrote:
select text from table where user = 2 and id 3 order by id ASC limit 1;
select text from table where user = 2 and id 3 order by id ASC limit 1;
is it possible to do this using 1 query?
select text from table
where user = 2 and id 3
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
The question is, how do I query this? Say I want all records from table
T whose COLOR property value is ORANGE.
The only thing I can come up with (and I'm no SQL expert and this looks
wrong to me) is the following:
SELECT *
FROM T
On Wed, 2006-08-02 at 11:13 -0600, John Meyer wrote:
I have two tables:
MEMBERS:
MEM_ID
...
GROUPS:
GRO_ID:
...
And one joiner
MEM_GRO:
MEM_ID, GRO_ID
I want to print out a list like this
GROUP_NAME, NUMBER_OF_MEMBERS
Even when the number of members is 0, how do I do
On Tue, 2006-08-01 at 17:39 +0530, ViSolve DB Team wrote:
Hello Prashant,
If you do need the duplicate rows in the final result, use UNION ALL with
your query. Otherwise you can opt for UNION as UNION is faster than UNION
ALL.
I have never heard of any evidence of this; in fact, it makes
On Tue, 2006-08-01 at 16:23 -0700, Robert DiFalco wrote:
I have a table that contains properties that can be associated with any
table whose primary key is a LONG. Lets say that there is just one kind
of property. The table looks something like this:
TABLE StringVal
REF_ID BIGINT
/refman/5.0/en/information-functions.html
Cheers!
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http
AND primary_grouping.Sub = advisor_counts.Sub
AND primary_grouping.ChapterType = advisor_counts.ChapterType;
- Original Message - From: Jay Pipes [EMAIL PROTECTED]
To: Jesse [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Tuesday, June 27, 2006 7:22 PM
Subject: Re: Query Speed
Jesse wrote
INNER JOIN State ST
ON primary_grouping.State = ST.State
ORDER BY
State
, Sub
, ChapterType;
This should reduce the number of queries actually executed to 3 instead
of 700 million
Let us know the output of EXPLAIN and the speed difference.
Cheers,
--
Jay Pipes
Community Relations Manager
that something is problematic with permissions. It
probably is the PID directory, IMO. Make sure you know where MySQL is
trying to create the pid file...
Let us know how things work out.
Cheers!
Den 6/21/2006, skrev Jay Pipes [EMAIL PROTECTED]:
Probably a permissions issue. Ensure
is greatly appreciated.
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http://www.mysql.com/cluster
`)) ORDER BY emissao ASC
SELECT * FROM `sav00_sava0400_dbf`
emissao BETWEEN '2000-01-01' AND '2000-12-31'
UNION ALL
SELECT * FROM `sav00_sava0400_dbf`
emissao BETWEEN '1999-12-01' AND '1999-12-31'
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based
-DB comes from. Max is the name of
Monty's son, not an implication that Max-DB is better than MySQL.
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified
[EMAIL PROTECTED] wrote:
Any idea why libmysqlclient_r.so is not being created when I compile after a
configure --without-server?
Compile MySQL with --enable-thread-safe-client configure option.
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based
post the code you are using so we might suggest
an alternative solution?
Cheers,
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com
of its many transaction records
has the merchant bankA.
Wouldn't something like this suit your needs?
SELECT a.account_id
FROM accounts a
LEFT JOIN transactions t
ON a.account_id = t.account_id
AND t.next_charge_date = NOW()
AND t.merchant != 'bankA'
GROUP BY a.account_id;
--
Jay Pipes
Community
in the outer SELECT in order to
eliminate any possible NULL values from the results and replace those
with a correct value.
Hope this helps,
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1
as much as
30% in most cases.
Thanks
-dant
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming North America, based in Columbus, Ohio
email: [EMAIL PROTECTED]mob: +1 614 406 1267
Are You MySQL Certified? http://www.mysql.com/certification
Got Cluster? http
) as well as ApacheBench (ab), supersmack (really
customizable), and have used httperf in the past.
For general MySQL benchmarking, you can always run the MySQL benchmark
suite (included in source distributions) on one machine and on the
other, and see differences that way.
Cheers,
--
Jay Pipes
Please post your exact table schema using SHOW CREATE TABLE, and your
exact query, along with an EXPLAIN SELECT for the query.
Thanks!
-jay
Jan Gomes wrote:
Hy Guys,
I have a simple structure of tables, howewer has 50 million of registers and
2,5 GB of data.
The table is MyIsam and has 4
had make this optimization:
1-Compress the index
2-sort the index with myisamchk
PS.: This table is read-only, hasn't an insert, update or delete.
==
Atenciosamente,
Jan Gomes - [EMAIL PROTECTED]
--
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Roaming
(0.00 sec)
Hope this answers your questions!
Cheers,
-jay
Jay Pipes [EMAIL PROTECTED] wrote:
Yesmin Patwary wrote:
Dear All,
Need to find ids that are NOT in other two tables. With the help of PHP scripting and three queries I am able to do the task. Can this be done with one mysql query
1 - 100 of 104 matches
Mail list logo