> Everything I've seen on this list indicates that using LEFT JOIN negates
> using an index. (WARNING: This is 3rd hand info and as such should be
viewed
> skeptically!)
>
> Have you tried:
>
> SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id
> ORDER BY files.date DESC LIMIT 1;
>
>
what were your results?
Cal
http://www.calevans.com
-Original Message-
From: Jordan Russell [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 12, 2001 2:27 PM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: Re: Need help optimizing this (simple) query
Hi,
Thanks for the reply.
> Hve you rea
Hi,
Thanks for the reply.
> Hve you read
>
http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L
EFT_JOIN_optimization
> ?
Yes, many times, as well as just about everything else in the Performance
chapter. Am I missing something totally obvious? Should I even be using a
LE
L. Clark
Cc: [EMAIL PROTECTED]
Subject: Re: Need help optimizing this (simple) query
> A .03 sec left join PREVENTS you from using MySQL.
>
> This must be a troll.
Sigh...
I guess I failed to mention this was a deliberately simplified example in
order to pose my question in a easy-to-u
> You have no where clause, so no index is used.
Oops, missed this part.
Where exactly do I need a WHERE clause, and for what? The first query
doesn't have a WHERE clause and yet it appears to be using the "date" index.
Jordan Russell
--
> A .03 sec left join PREVENTS you from using MySQL.
>
> This must be a troll.
Sigh...
I guess I failed to mention this was a deliberately simplified example in
order to pose my question in a easy-to-understand manner. In reality, there
are much more records, and a more complex query, where the t
A .03 sec left join PREVENTS you from using MySQL.
This must be a troll.
You have no where clause, so no index is used.
Jordan Russell wrote:
>
> Hi everyone,
>
> I'm stuck on one issue which is preventing me from using MySQL in production
> on one particular database. (This is similar to my
Hi everyone,
I'm stuck on one issue which is preventing me from using MySQL in production
on one particular database. (This is similar to my last post but this time
I'll explain better what I'm attempting to do.)
I'm trying to create a database of filenames and directories using MySQL. I
have tw
This is a permissions issue. Check the directories mysql is located in
and grant executable permissions. Also verify ownership requirements for
each of these directories.
Charles Hagen
On Mon, 12 Mar 2001, Russ Heaton wrote:
>
> I just installed RH 7.0 selecting the 'install everything' optio
I just installed RH 7.0 selecting the 'install everything' option. Now
when I use safe_mysqld, it starts then ends immediately with the
following message in the log.
010310 12:43:30 mysqld started
010310 12:43:30 Can't start server : Bind on unix socket: Permission
denied
010310 12:43:30 Do y
I am a computer science student who has a project to in a few weeks.
I have been trying to get my Java program make connections to mysql server running on
my windows PC. I got the right drivers but I keep getting bad handshake error..
This is what I used
String address = "jdbc:mysql://10.6.5.117
Go back to redhat.com and get the RPM that works,
Or search the mysql list archives.
This has been answered a hundred times ( No exageration. )
Charles L Hagen wrote:
>
> OK, here is the story.
>
> I have a PII Linux RedHat 7.0 server. I installed the Mysql package that
> comes with it an
Charles L Hagen schrieb:
>
> mysqld dead but subsys locked
>
it's successfully installed and running,
but not really killed
killall mysqld
and start again
you shouldn't post those long nonsense listings
-- http://it97.dyn.dhs.org --
IrmundThum
-
OK, here is the story.
I have a PII Linux RedHat 7.0 server. I installed the Mysql package that
comes with it and also the dependent applications as specified.
I try to start the mysqld and it gives me an OK and then I status it and
it says
mysqld dead but subsys locked
I am asking fo
Charles, you need to be more descriptive about exactly what
problem you're having. Spell out your hardware, OS, MySQL
version, etc., and describe what isn't working.
Charles L. Hagen [[EMAIL PROTECTED]] wrote:
> I cannot seem to get this database program to work correctly. I am asking for any
is happening?
Cheers
Jon
-Original Message-
From: Charles L. Hagen [mailto:[EMAIL PROTECTED]]
Sent: 04 March 2001 04:12
To: [EMAIL PROTECTED]
Subject: trying to install on RedHat 7.0 and need help
Importance: High
I cannot seem to get this database program to work correctly. I am
I cannot seem to get this database program to work correctly. I am asking for any
help I can get. I need to start this asap.
Charles Hagen
[EMAIL PROTECTED]
Dear our mailing list friends,
i am very new and i tried to install mysql to my computer(windows based ,i
downloaded the software for windows ) but i failed.
the error is:
setup is unable to find installation languages in
C:\PROGRA~1\ALZIP_HZTMP_\SETUP.LID file
Error 105
i am looking for your he
Thanks Rolf
>From: "Rolf Hopkins" <[EMAIL PROTECTED]>
>To: "David Jacobowitz" <[EMAIL PROTECTED]>,
><[EMAIL PROTECTED]>
>Subject: Re: Need help with select statement.
>Date: Tue, 27 Feb 2001 09:21:57 +0800
>
>No it's not pos
No it's not possible but you can just read in all tables anyway and ignore
the columns you don't want.
- Original Message -
From: "David Jacobowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 7:33
Subject: Need help wit
Dear Sir,
I have looked in the manual but could not find any clue so I am seeking your
assistance. I have a table with 25 fields and I use most of these fields but
not all in different DBI scripts. Currently I use:
SELECT field_1, field_4, ...getting tired typing field names... FROM myTest;
I
From: "Mehmet agar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 21, 2001 8:57
Subject: need help to set mysql up
>
>
> i am a very beginner level and i tried to set mysql up but i failed.
> i downloaded the software from mysql.com but i co
i am a very beginner level and i tried to set mysql up but i failed.
i downloaded the software from mysql.com but i couldnot find any setup icon.
what kind of compiler do i need?
i wonder to know whether you can send me some information how to set mysql
up.
thank you for your interest.
>Fr
Alan Halls ([EMAIL PROTECTED]) writes:
> Here is what our company uses to do the page division on adoptablekids.com I
> have used it for a few other applications with minimum changes
> This code would give you five per page.
>
>
>
> select * from profile order by id DESC
>
ay, February 20, 2001 10:32 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Two query issues -- need help
Hi all, I have two little problems:
1.In a query, I get errors when a record's field contains the '
character. In fact the query starts like http://www.mysql.com/manual.php
Hi all, I have two little problems:
1.In a query, I get errors when a record's field contains the '
character. In fact the query starts like
> I am new to MySQL and have just installed the MySQL rpm files to my Linux
> box.
>
> I have run "mysql_install_db" with no problems and I have then run
> "safe_mysqld &" this comes up with the messsage
>
> "starting mysql daemon with databses from /var/lib/mysql
>
> mysqld daemon ended"
>
> I as
Matt, I'm fairly new to MySQL myself, but it sounds like your
mysqld is not starting up when you issue safe_mysqld. Instead
of invoking safe_mysqld directly, find the "mysql.server" file that
got installed with mysql, and start mysqld with that by doing
something like:
cd /dir/to/mysql.serve
There'll be a .err file in your ~mysql/var directory - have a
look at it, and it should give you a pointer as to the precise problem.
regards,
P
On
Fri, 9 Feb 2001, Matt Davis wrote:
> I am new to MySQL and have just installed the MySQL rpm files to my Linux
> box.
>
> I have run "mysql_insta
I am new to MySQL and have just installed the MySQL rpm files to my Linux
box.
I have run "mysql_install_db" with no problems and I have then run
"safe_mysqld &" this comes up with the messsage
"starting mysql daemon with databses from /var/lib/mysql
mysqld daemon ended"
I assumed that this wa
with no debugging to bloated and slow, with full debugging.
> Each one of the crashes.
>
> I know the table that is causing MySQL to segfault, but I can't reproduce
> yet the sequence of queries that caues it to happen.
>
> What I really need help with is instructions
full debugging.
Each one of the crashes.
I know the table that is causing MySQL to segfault, but I can't reproduce
yet the sequence of queries that caues it to happen.
What I really need help with is instructions on how to make mysqld write its
core file after it crashes. I have "core"
You should ponder install mysql using
ports
eg
/usr/ports/database/mysql-server.xxx.xx
make install
make clean
This will put files in standard places for FreeBSD It will install any
dependencies for you automatically.
If you don't know how to insitall mysql using ports email me off the mysq
rror, then say what error you've got.
Good luck!
- Original Message -
From: "System Administrator a.k.a. The Root of the Problem"
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, January 26, 2001 10:00 PM
Subject: Re: nee
Right, I trying to compile MySQL latest stable on FreeBSD 4.2 but I
get stuck sql_yacc.cc ..
Any pointers?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
414-5359
-
Hi,
I am trying to install MySQL on my Sun workstation
which has Solaris 2.6 installed. I have completed
following steps
1. configure
2. make
After step 2 when I am doing "make install" (step3)
it is giving me following error:
---
Warning: Y
Hi!
We get a lot of mail from users that would like to know if MySQL
works on BeOS. Unfortunately we don't have any person who knows BeOS
or has time to do a port :(
We are interested in finding someone to do a port, and we will help
them with any technical questions they may have while doing t
On Tue, 23 Jan 2001, Alexei Sh. wrote:
|Ok I need help
|So i have table with primary key ID,
|it's fills with something like 1,2,4,5
|So and i have another table in which i would like to put data from first
|table from row ID
|how to do this
||| ||
||
Ok I need help
So i have table with primary key ID,
it's fills with something like 1,2,4,5
So and i have another table in which i would like to put data from first
table from row ID
how to do this
|| ||
| test1 | | test2 |
|| ||
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
901 - 940 of 940 matches
Mail list logo