^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: Dan Nelson [EMAIL PROTECTED]
To: Renars Jeromans [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, February 18, 2003 10:14 AM
Subject: Re: Slow retrieval of distinct on indexed fields
I grant you that, however my point was about the total count of the indexed
word's appearance, which would still stay the same, regardless of the
encoding of the position information.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http
I'm hoping that it's a MyIsam table.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: Jerry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 16, 2003 5:52 AM
Subject: Re: INSERTs
That body column wouldn't happen to be a fulltext index, would it? :)
If so, 'ave another coffee.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: david [EMAIL PROTECTED]
To: [EMAIL PROTECTED
Yes, and better go to the one across town to get it :)
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: Jerry [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 16, 2003 6:00 PM
Well, MySql stores all its index information in one index file, so when you
add another index it has to rebuild the WHOLE file. :)
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: david [EMAIL
You probably have a permissions issue in your data or temp directory...Mysql
is not able to create a temporary table when making the table alteration.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message
Make a temporary table, SELECT DISTINCT the rows from the old table to the
new table, rename the old table TABLE_OLD, rename the temporary table to the
original table name.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
What type of platform/file system are you using?
Very large files on filesystems can suffer from inode indirection
problems...but I wouldn't think they'd be too noticeable.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
manual on how to,
say in .pdf format out there ?
if not, a on-line link maybe ?
See http://www.mysql.com/documentation/index.html
Peter
^_^
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
Thanks-
Richard
BTW, exactly how did you acquire, install and execute mysql without visiting
mysql.com?
:)
Peter
^_^
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
- Original Message -
From: Richard Nagle [EMAIL PROTECTED]
To: list - MySQL [EMAIL
This probably isn't best handled by mysql...use associative arrays to store
members of members in the hierarchy, then print out the associative array's
contents in order.
Peter
^_^
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
You need the zlib library...that's where compress is defined.
It can be found at http://www.gzip.org
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: Ron Sorber [EMAIL PROTECTED]
To: [EMAIL
Really, for non-administrative tasks, you should look at the two sections in
the manual that deal with data definition (create, drop, etc) and data
manipulation (insert, select, delete)...you're after the data definition
stuff.
Peter
^_^
-
Peter Grigor
Yep, you're right. Never noticed that before :)
I think that would probably be considered a bug. But possibly for
efficiency's sake the check was made ultra simple.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original
I'm with you for sure...client processing is the way to go...fat servers
suck.
Peter
^_^
-
Peter Grigor
Hoobly Free Classifieds
http://www.hoobly.com
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Peter Grigor [EMAIL PROTECTED
...)
You'll have to rewrite your query using an inner join...not hard.
Peter
^_^
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
-
Before posting, please check:
http
that the mysqld has not started properly
('mysql ended'). That's why you can't connect to it via mysqladmin.
Check the mysqld log (/usr/local/mysql/data/your.machine.name.err) for
errors.
Peter
^_^
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
- Original Message -
From: J. A. Tovey [EMAIL PROTECTED]
To: Peter Grigor [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 9:34 AM
Subject: Re: socket error
ah ok, yes,
the error log says
030211 12:10:27 mysqld started
030211 12:10:27 Can't start server
runs on any other
database.
Please let me know is it a bug in Mysql or the driver i am using. ???
Thanx and Regards,
RK
We really can't help you much unless you post your query.
Peter
^_^
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
i'm sorry - could you explain that for a
simpleton :-)
i have no idea what you mean :-/
--- Peter Grigor [EMAIL PROTECTED] wrote:
- Original Message -
From: J. A. Tovey [EMAIL PROTECTED]
To: Peter Grigor [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 9
- Original Message -
From: J. A. Tovey [EMAIL PROTECTED]
To: Peter Grigor [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 11:33 AM
Subject: Re: socket error
ok :)
all killed now,
(not quite there yet though :))
I am now getting the error:
030211 16:26
- Original Message -
From: J. A. Tovey [EMAIL PROTECTED]
To: Peter Grigor [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, February 11, 2003 11:52 AM
Subject: Re: socket error
yes, i ran everything again
Well, the host.frm file is a mysql database table def...your permissions
:)
-
Peter Grigor
Hoobly Classified Ads
http://www.hoobly.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
24 matches
Mail list logo