Posted this yesterday, but it never showed up...?
Hi,
I have the following table (sorry if the formatting gets tweaked) and
query. The table is around 36k rows long, and the query returns about
350 rows. The query takes 12.15 seconds.
Is there any way I can speed this up?
Thanks,
Bryan
Hi,
We have a somewhat tricky problem that I need some help with. What we have
is one machine (the master) that we use for database development, and two
dedicated nodes (slaves) on a beowulf cluster that house the non-dev
databases.
What we need is to mirror the master to the slaves, but not
Is there a mysql newsgroup somewhere? Or some other forum? I am the kind
of user that has one question every couple weeks or so, and rather than fill
up my mailbox, I prefer to subscribe, ask my question and then unsubscribe.
This works well with other services, but it takes me (no
I recently got into a discussion with a colleague that was interesing. He
is a database warehouse guy, so I assume he knows more than I do on this
subject, but he was unable to explain things to me very well :)
The question is how does mysql organize data between the physical table, the
select
Hi, I am experiencing some really bizzare behaviour in MySQL v3.23.36...
I have a perl script that takes some html form based user input, parses
it into an array and then loops throught the array inserting each
element into a table. This table is then left outer joined with others
for a quick
Hi,
I have a perl script that loops through and executes 2 queries 50
times. I need to make sure that I have done all I can to make these
queries and the indexing on the table as efficient as possible.
Would someone do me the gargantuan favor of taking a peek at the info
below and offer any
Yep. In fact, if I replace 'myid' by s.some_pk the query works as well.
This is what make me think it was a feature (bug?) with IFNULL in that it
would not recognize aliases. But then theres the query that does work :P
Bryan
-Original Message-
From: Cal Evans [mailto:[EMAIL
I would try:
select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid
from data_table s, other_data_table
where s.some_pk=232 order by myid;
Although I don't get the purpose of the IFNULL or the order by if you're
selecting only a single value of s.some_pk.
--jfarr
The single
Hi, I am having a small formatting problem maybe someone can help with.
I have a query that does a left outer join, which generates a table with a
few NULL values in some columns. All okay so far. But what I need to do is
sort on this column, and I need to put NULL values at the end. Normally
Hi,
I am running a MySQL server on a nice machine (dual pIII 1gHz/1g ram), with
RedHat 7.0. Currently, I am using the rpm version of mysql, which is
3.23.37.
Our database is large, and getting larger, with several tables approaching
the 1gig mark. In addition, the database will be moving to
I am working on a mysql database with many large tables (1.5 million rows on
some) and came across a beeg problem.
I have need for a query like this:
mysql select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as
Okay, here is the full monty from the database regarding the query in
question, any suggestions on how to improve any of it are greatly
appreciated!
Also, if any more info is needed, just let me know.
Thanks!
Bryan
QUERY:
mysql select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
-
From: Jeremy D . Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 3:30 AM
To: Bryan Coon
Cc: [EMAIL PROTECTED]
Subject: Re: Replication troubles
On Fri, Mar 23, 2001 at 10:45:00AM -0800, Bryan Coon wrote:
I have two machines which I am trying to set up replication on. I
this query to mysql, and would appreciate any thoughts or insights on how to
do this.
Thanks!
-Original Message-
From: Geoff Coffey [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:52 PM
To: Bryan Coon; 'Jason Landry'; [EMAIL PROTECTED]
Subject: Re: Small select question...
on 3
...THEN.
Thanks!
-Original Message-
From: Jason Landry [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 12:00 PM
To: Bryan Coon; [EMAIL PROTECTED]
Subject: Re: Small select question...
You'll have to be more specific in your example -- your select statement
below is rather ambiguous
Have you checked the permissions on mysql.sock? This happened to me once.
Since your webserver is running as 'nobody' you need to make sure the
permissions are correct for the socket and directories...
Just a thought.
Bryan
-Original Message-
From: denis mettler [mailto:[EMAIL
more time :)
Bryan
-Original Message-
From: Eric Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 4:43 PM
To: Bryan Coon; [EMAIL PROTECTED]
Subject: Re: MySQL and XML?
Well list, I think we have a new weekly dead horse to with which to use our
sticks
Can anyone offer some insight into the following topic?
I would like to provide web access to search a large database of
information. Currently, I am using MySQL to do this, and it works great.
However, this database is almost entirely static, there are virtually no
inserts or updates done.
Hopefully this is not too lame a question...
In oracle, I can do this:
select a, b, c from A, B, C where a = A.a (+) and b = B.b (+) and c = C.c;
What is the equivalent in MySQL? The (+) allows that 'where' statement to
be kind of optional (I think). Basically I want to do a select on
Hi,
We are implementing a linux cluster, and rather than get gouged by oracle
(in performance and licensing) would much rather use MySQL. I searched
through the archives and found several references to failover and
replication but still have some questions.
If I understand correctly,
Hi,
We are implementing a linux cluster, and rather than get gouged by oracle
(in performance and licensing) would much rather use MySQL. I searched
through the archives and found several references to failover and
replication but still have some questions.
If I understand correctly,
21 matches
Mail list logo