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?
>
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, ucp.user_id,ucp.p
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
mys
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 S
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 database
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 an
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 highSco
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 ta
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 prod
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
decidin
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 dynam
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 t
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 | Unspecifie
I *think* that's 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]
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 th
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 beli
[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 th
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 platforms,
statement 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.mys
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 processors
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 Inno
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?
RT, CREATE, ... ON db4.* TO 'username'@'hostname' IDENTIFIED
BY 'password';
Grant the necessary privileges to each database individually and leave out
'mysql'.
Unfortunately, you cannot grant privileges to all databases and revoke
privileges from one schem
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
permi
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'
IDE
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 value
[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 opti
From: [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 woul
you
would 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 Relatio
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 (if
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 operations
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 a
red 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
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|
| BLA
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 not
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
Kishor
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
S
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!
ug: my own 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.Key
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
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 '
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:
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: "
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" <[EMA
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
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-ba
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
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
right
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 s
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 in
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 do
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
, lB.
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,
unde
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
>
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 o
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.
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 Rela
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 i
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
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 lat/
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 ta
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.
e_name Value
> Qcache_free_blocks1
> 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-
>
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
> 1
'0',
> `called_party_from_src_num_type` int(1) default '0',
> `call_source_realm_name` char(3) default NULL,
> `call_dest_realm_name` char(3) default NULL,
> `call_dest_crname` char(50) default NULL,
> `call_dest_custid` char(20) default NULL,
> `call_zone_d
orden
> Prairie Area Library System
>
> -----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 loo
call_dest_crname| char(50)
> | YES | | NULL| |
> | call_dest_custid| char(20)
> | YES | | NULL| |
> | call_zone_data | char(20)
> | YES | | NULL| |
> | calling_party_on_dest_num_type | int(1)
> | YES | | 0 | |
> | calling_party_from_src_num_type | int(1)
>
the keys, do the import, then re-enable the keys, it takes
> just as long,
> if not longer.
>
>
> I have just about 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
gt; AgencyInfo.agencyid, BuildingInfo.buildingid FROM BuildingInfo INNER
> JOIN AgencyInfo ON BuildingInfo.agencyid = AgencyInfo.agencyid ORDER BY
> AgencyInfo.Name, BuildingInfo.Name;
>
> There are indexes on the id and name related fields used in the WHERE
> clauses.
>
> Kathy Mazur W
;INSERT INTO ITEMS (USER_KEY, SUBKEY, VERSION_STAMP_HASH, VERSION_STAMP,
> USER_DATA, LAST_ACCESS_TIME, TYPE, DATA_HASH, HINTED_STORAGE_ID,
> USER_KEY_HASH) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
>
> "DELETE FROM ITEMS WHERE USER_KEY = ? AND SUBKEY = ? AND VERSION_STAMP_HAS
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:
>
>
>
>
to take a look at
your schema and a sample of your 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
--
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
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 restar
ur name 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 arch
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
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 memb
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 *
>
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 B
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 ma
amme und Entwuerfe');
You can read more about LAST_INSERT_ID() here:
http://dev.mysql.com/doc/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]
ouping.State = advisor_counts.State
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"
apterType
) AS advisor_counts
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 P
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 iss
sao`)) 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,
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
dish, the
pronunciation of My sounds more like "Me"...
:)
p.s. That is also where "Max-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, MySQ
[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
ave used the COALESCE function 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: [E
none 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
? Can you 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
awodny) 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,
--
sting them with the EXPLAIN
function. This alone has let me to speed up our operations 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
good time for the select ? How can I run this select in less time?
I 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 PROTECT
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 in
Hi Eko!
It shouldn't be an issue with table size. More likely, it is due to
duplicate records in the import file. Can you post the SHOW CREATE
TABLE for your table in full (including primary key information)? Also,
any output from your import run would be useful.
Thanks!
--
Jay
1 - 100 of 104 matches
Mail list logo
