PRIMARY
key: PRIMARY
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
t
seem to affect the underlying problem. Adding multiple-column
indexes also doesn't affect things in any significant way.
Any thoughts? I clearly need a significant speed 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]
REATE TABLE `subject` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`deleted` datetime default NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`)
) TYPE=MyISAM
Thank you for any suggestions.
Jesse Sheidlower
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on the mailing lists
recently, or in Paul's book, but I'd think it would be
something people 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]
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)
joins, that is faster.) I'm
running this in Perl.
Any suggestions? I'd like to get rid of the whole "temporary" and
"filesort" things, but I'm not sure if that's what 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]
ue--just that there is one--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]
ing a new batch, or adding to an existing 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]
so can't look there for advice. I'm
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]
ize performance.
---
If Linux is really twice as fast as FreeBSD, as people have reported
recently, then go ahead and use it if that's what you want. But I
hope everyone reporting this is using optimized software, and isn't
complaining about a FreeBSD that's explicitly slowed down
ot; [1] [2] [3] "Next" style format and was hoping
> someone 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 _MySQ
hen i'll need to properly
> craft my searches 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
to have to rewrite 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]
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 l
as soon 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.mys
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 anoth
in there too? What order should
the indexes be in?
If every search for song_title or song_length must be joined
against the album table, it's not clear which should be the
first named column in this index. The experiments I've done
so far have been inconclusive, and I don't think I&
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
On Fri, Aug 22, 2003 at 10:07:46AM -0700, Steven Roussey wrote:
> Hmmm, just in case you can't change the table layout...
>
> Run this through MySQL. First I get rid of the other index I made, then
> add chained indexes so there is no need for data file lookup. Also, one
> direction of the query t
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
>
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
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
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 thi
.q_id | 1 |
|
| cit | eq_ref | PRIMARY,sref_id | PRIMARY | 4 | q.cit_id| 1 |
|
| sref | eq_ref | PRIMARY,cd | PRIMARY | 4 | cit.sref_id | 1 | Using
where |
+---++-----+-+-+-+
gs
in some way, but these don't seem to be affecting things. The suggestions
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]
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
> >thes
e big GROUP BY
queries 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.c
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,
is indexed. Is there anything I can to do improve queries of this
nature? There are more complicated queries from this database, but the big
slowdown always seems to be when one of the possibilities (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]
cal tables and that the queries
are identical. 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
cation, without having to resort to the
kludgy things I'm doing now.
Thanks for any suggestions, 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]
s
unacceptably slow; generally after the COUNT, when I'm issuing
LIMITed SELECT queries, things get much better.
Is there any way to improve on this?
Thanks.
Jesse Sheidlower
-
Before posting, please check:
ht
given
that fulltext phrase searching is one of the main things I had
been hoping to use this database for? In many cases, other
restrictions from joined tables will even further reduce the
number of possible matches, but perhaps this doesn't m
E);
, it took 4.76 seconds--again, on a slower server, but this is
returning only 44 results.
It's certainly possible, and perhaps likely, that users will
need to do fulltext searches on extremely common words--more
common than "computer" in the abov
ger search that's joining in
a number of other tables, and with a number of concurrent users. Is there
anything I can do to speed things up, or any explanation of why this is
so slow?
Thanks very much.
Jesse Sheidlower
-
Before
ll', and 'Fiction', but in the last 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
-
en | 4 |
+-+---+
1 row in set (0.00 sec)
mysql> SET 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
_len: 4
ref: cit.sref_id
rows: 1
Extra: Using where
4 rows in set (0.00 sec)
Thanks for any ideas. I'll probably have further problems when
I start trying to use FULLTEXT searches, but these are the
difficulties that sprung up right away.
Jesse Sheidlower
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
&
rror: cannot compute sizeof (char), 77
I haven't experimented to see which configure flag might be causing
this, but if anyone has any ideas, I'd be grateful.
Thanks.
Jesse Sheidlower
-
Before posting, plea
re some standard way of doing this? It doesn't
necessarily have to be neat, in that I'm the only one 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 impos
ted a, o, and u. However, I didn't start my mysqld with
--default-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, a
ed for target `all-recursive'
Current working directory /usr/local/src/mysql-3.23.52
*** Error code 1
make: Fatal error: Command failed for target `all-recursive-am'
---
I've looked for this error in various places and been unable to
find it.
Any ideas this time? And thanks
Solaris.
Any other suggestions still welcome, thanks 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 arc
t it is I'm
missing.
I seem 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
#x27;t know any C and I don't know what any of these
compiler messages 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 c
he size 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
ional model, or more directly);
this project is bigger than anything I've worked on before and
I'm trying to approach it with caution.
Thanks.
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.co
ery
results? Or am I 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
st a short string
>
> to clarify ...
>
> if column 'n' has 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
atabase with the mysql command, e.g.
mysql -u -p database < backup-file.sql
Jesse Sheidlower
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
nloading everyday. 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'l
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"
cify this,
and there doesn't seem to be an "ignore" or "replace" option for the
mysql command. Do I actually have to drop all the tables on my
development box before loading in from the backup?
Jesse Sheidlower
<[EMAIL PROTECTED]>
---
002-02 2 30.00
2002-03 1 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
---
ntially wide variety 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
&
56 matches
Mail list logo
