key_len: 4
ref: rqs_incs.quotation.part_id
rows: 1
---
Thanks very much.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
improvement,
not just a tweak like making a bigger sort_buffer_size or
getting faster disks.
Thanks for reading this far.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
suggestions.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
would want to do fairly commonly.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
matters given
that there's only 1 row being returned there.
Thanks.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, Nov 23, 2004 at 09:55:15PM +0100, [EMAIL PROTECTED] wrote:
* Jesse Sheidlower
[...]
CREATE TABLE `citation_subject` (
`id` int(11) NOT NULL auto_increment,
`citation_id` int(11) NOT NULL default '0',
`subject_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id
--it becomes trivial.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
using Perl to process the data, if there's a Perlish way of
doing things that would be easier than SQL.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
database.
I want my loading program to be able to determine this without
any input from me.
Thanks.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
want. But I
hope everyone reporting this is using optimized software, and isn't
complaining about a FreeBSD that's explicitly slowed down by running
under gobs of debugging code.
So I would imagine you'd see a huge speedbump from downgrading to 4.10.
Jesse Sheidlower
--
MySQL General Mailing List
may have a sample/example queries to accomplish this. Usually
working with 10 results per page display.
Paul DuBois provides easy-to-understand code for this exact format
in _MySQL and Perl for the Web,_ and his _MySQL Cookbook._
Jesse Sheidlower
--
MySQL General Mailing List
For list archives
to understand this.
Why not just set the day value to '00' if you don't have a value, and
then check that in your client code? That way, no extra columns. I.e. if
you don't have a day value, then your DATE will be
$sale-date-year . - . $sale-date-month . -00, or whatever.
Jesse Sheidlower
--
MySQL
this functionality within
MySQL, and tedious to have to do it in the relevant programming
language instead.
Jesse Sheidlower
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
as the next query came in. It was
not.
Is there any way to get logging restarted without stopping and
restarting the server itself, which is live and which I'd prefer
not to interrupt?
Thanks.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
On Tue, Sep 02, 2003 at 07:59:07AM -0700, Bruce Ferrell wrote:
flush logs from the mysql command line works
And so it does. Thank you. I misunderstood what the Manual
said about this command, though I should have tried it first
anyway.
Jesse Sheidlower
--
MySQL General Mailing List
For list
On Tue, Aug 26, 2003 at 09:26:55PM -0500, Matt W wrote:
Hi Jesse,
- Original Message -
From: Jesse Sheidlower
What I'm trying to understand is how you would set up these
indexes when you'd always be doing joins with another table.
Suppose you have The Canonical CD Database
column in this index. The experiments I've done
so far have been inconclusive, and I don't think I'm understanding
the process in the first place.
Thanks very much.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Fri, Aug 22, 2003 at 10:23:37AM -0400, Keith C. Ivey wrote:
On 21 Aug 2003 at 21:38, Jesse Sheidlower wrote:
Huh, I was told the exact opposite, that if most of the
entries are smaller than the maximum length of the field, you
should use an index about the size you expect most entries
On Fri, Aug 22, 2003 at 07:33:56AM -0700, Steven Roussey wrote:
Here's the CREATEs, somewhat edited to remove parts not relevant
to this discussion, to save space:
I never actually looked at your JOIN statement more than a quick
glimpse, but I will (though not just right now). Before I do,
On Fri, Aug 22, 2003 at 09:03:55AM -0700, Steven Roussey wrote:
All the indexes were single indexes, partly because I haven't
yet made the effort to understand composite index. I guess it's
time ;-).
Oh.
There are better places to start than this list. ;) The manual can be a
great
On Fri, Aug 22, 2003 at 12:42:27PM -0700, Steven Roussey wrote:
But since this data is read only, why not reformulate the data for the
queries you are going to make? This is the opposite of normalizing, and
will require more disk space, and is not flexible, but it will be fast.
Of course, it
(e.g. all words
in 'S') is large; the other limitations don't improve things.
Thanks.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thu, Aug 21, 2003 at 11:34:00AM -0400, Jesse Sheidlower wrote:
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
very slowly
as well--so the sort_buffer_size is now 8M; though
I don't usually have many simultaneous users, I'm still
nervous about making it much larger than that.
Best,
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
On Thu, Aug 21, 2003 at 06:01:31PM +0200, Cybot wrote:
Jesse Sheidlower wrote:
I'm struggling with speed issues on some queries that
I would have expected to be relatively fast. Perhaps
even more frustratingly, when I've tried to break
these down into their components, they still execute
other people have made to try to get it to do the smaller queries first
don't seem to be having much effect, unfortunately.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
where |
+---++-+-+-+-++-+
4 rows in set (0.00 sec)
Where do I go from here?
And thanks for all the thought people have been putting into this.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http
On Thu, Aug 21, 2003 at 06:58:29PM -0700, Steven Roussey wrote:
Jesse Sheidlower wrote:
Hmm. When I returned to the multiple-table query that started
this thread,
And it was slow. Yeah, one thing at a time. It makes it easier for
people reading this list now or in the future
. This is just a sample, and more complex queries end up
with more thoroughly erroneous results.
Any explanation for these results? Thanks in advance.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
, or questions. I'd be happy to
clarify anything or post code if required.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
tables will even further reduce the
number of possible matches, but perhaps this doesn't matter if
the fulltext search is done independently of these; I don't know
how the optimizer handles this.
Thanks.
Jesse Sheidlower
-
Before
issuing
LIMITed SELECT queries, things get much better.
Is there any way to improve on this?
Thanks.
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
up, or any explanation of why this is
so slow?
Thanks very much.
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
words--more
common than computer in the above example--though limited by
requirements in other tables not shown here, and it would be
rather problematic if these searches are going to take over a
second each.
Jesse Sheidlower
six
months I have only bought Fiction and Baseball, I'd like a
query that will give me Computing and Cooking.
I played around with a few LEFT JOINS but I still seem to be
missing something.
Thanks.
Jesse Sheidlower
-
Before
ft_min_word_len=2;
ERROR 1193: Unknown system variable 'ft_min_word_len'
mysql
---
Any idea what could be causing this? I did a Google search and someone
reported the same problem on a different mailing list, but with no
answer.
Thanks.
Jesse Sheidlower
FULLTEXT searches, but these are the
difficulties that sprung up right away.
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
configure flag might be causing
this, but if anyone has any ideas, I'd be grateful.
Thanks.
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
On Tue, Jan 28, 2003 at 01:17:30PM -0800, Jeremy Zawodny wrote:
On Tue, Jan 28, 2003 at 12:21:37PM -0500, Jesse Sheidlower wrote:
I've been trying to install MySQL 4.0.9 on FreeBSD 4.7, and
have been getting stuck in the configure phase. I'd be
grateful for any suggestions.
I'm
in
charge of the database and I'm willing to do something in a
manner that's somewhat of a pain to work with. But I also
don't want to do something that will be impossible to
maintain or convert to a better way.
I'm using Perl, if that matters.
Thanks for any ideas, sql query.
Jesse Sheidlower
-character-set=latin1_de, so I don't think it's
relevant to me.
Can anyone explain this to me, and more to the point, tell me
what I need to do to get the umlauted a, o, and u to match the
plain variety?
Thanks.
Jesse Sheidlower
SQL, query
'
---
I've looked for this error in various places and been unable to
find it.
Any ideas this time? And thanks again!
Jesse Sheidlower
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
mean, what the libraries are, etc.
I'd be grateful for any help anyone can give me. I've discussed this with
people who are knowledgable about MySQL and compiling in general, with no
luck, and I've checked the archives and can't find anything related.
Thanks.
Jesse Sheidlower
SQL, query
not to have mentioned in my original post that I'm running
gcc 2.95.2 and SunOS 5.8 on x86.
Thank you.
Jesse Sheidlower
On Tue, Oct 15, 2002 at 01:38:38PM -0400, walt wrote:
Jesse Sheidlower wrote:
I've been trying for a week to get MySQL installed on a Solaris
system running on Intel, not Sparc
to everyone for their
time.
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
of individual databases to something like 25M.
What's the best way of getting this done? The server is running
Solaris, if it's necessary to do it through the OS insteady of
through MySQL.
Thanks.
Jesse Sheidlower
[EMAIL PROTECTED]
sql, query
misunderstanding how one would work with the
results?
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread
to approach it with caution.
Thanks.
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
the value YR12345 don't get that record.
if column 'n' has the value XY5 get me that record.
if column 'n' has the value XY33456 get me that record.
so I am here ...
select * from thetable where BLAHBLAH
what is BLAHBLAH?
n like 'XY%';
Jesse Sheidlower
backup-file.sql
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
. Is their
no way for load data to do this automaticaly?
Paul DuBois has some useful scripts to convert dates in
the Early release software section of the page for
his forthcoming _MySQL Cookbook_ at http://www.kitebird.com/mysql-cookbook/
I think you'll find it pretty useful for this.
Jesse Sheidlower
command. Do I actually have to drop all the tables on my
development box before loading in from the backup?
Jesse Sheidlower
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
On Mon, Jul 01, 2002 at 01:23:38PM -0400, Keith C. Ivey wrote:
On 1 Jul 2002, at 12:30, Jesse Sheidlower wrote:
What should I be doing instead? The docs don't seem to specify this,
and there doesn't seem to be an ignore or replace option for the
mysql command. Do I actually have to drop
15.00
(The exact format isn't too important, I can figure that out
once I get the basic query down.)
What's the best way to construct this SQL query?
Thanks.
Jesse Sheidlower
-
Before posting, please check:
http
of systems, store
the data in some way, and display them back on the Web. I'd
think this would be a common requirement, but what I've been
able to find in the manual discusses the internal storage only.
Thanks.
Jesse Sheidlower
[EMAIL PROTECTED]
sql, query
55 matches
Mail list logo