Hi Gasper,
MySql allows to package the index - to get its size smaller and to gain
performance.
Some information about that can be found here:
http://www.mysqlperformanceblog.com/2006/05/13/to-pack-or-not-to-pack-myisam-key-compression/
Gaspar Bakos schrieb:
> Hi,
>
>
> RE:
>
>> Have you tri
Hi,
RE:
> Have you tried
> analyze table x;
This was quick:
mysql> analyze table TEST;
Table Op Msg_typeMsg_text
CAT.TEST analyze status Table is already up to date
--
mysql> show index from TEST;
+---+++
Hi, Philip,
RE:
> What is the EXPLAIN output of each?
OK, first I naively typed:
explain create table test2 select * from TEST where MMi < 9000;
but of course, this does not work.
The simple select that uses MMi_m as index (and takes up to an hour):
mysql> explain select * from TEST where MMi_m
Questions;
1. Is there a way to decrease random seeks? E.g. mysqld config
parameters, increase some buffer/cache sizes?
2. Optimize table: is there a way to rearrange data so that random
seeks are minimized?
3. If we have to live with large number of random seeks does anyone
know how the underl
At 04:41 PM 6/11/2006, Ian Barnes wrote:
Hi,
Then after that it the following happened for 60 seconds and then it timed
out:
I have put more RAM in (I now have 768Mb's, as well as 3Gig of SWAP).
Thanks for the suggestions!
Cheers
Ian
Ian,
Timed out? Wasn't there an error? Have yo
I'm replacing 14 million rows of data using "Load data infile replace" and
it is taking forever to complete. I killed it after 6.2 hours on an AMD
3500 machine. I then deleted all the data from the table and used "Load
data infile ignore" and it completed quite quickly in about 30 minutes. Is
I'm trying to do a MySQL Query but it doesn't work. MySQL version: 4.0.26
When I put only one argument in MATCH, it shows no error but doesn't return
anything
[quote]
SELECT * FROM item WHERE MATCH (nom) against ('Huile');[/quote]
or
[quote]SELECT * FROM item WHERE MATCH (nom_en) against ('Huile
Hi,
we have a table with many (~0.5 billion) records and a geometry field
which was defined as a simple "point". The `show table status` shows that
the row format is dynamic, however, a simple point in the GIS
representation has a fixed format (see: WKB: 21 bytes: 1 for MSB/LSB, 4
for type and 2x8
Hi,
Yes, I don't actually know if I have very large blogs, but the possibility
exists, and is quite large.
I am running FreeBSD so I don't have the ulimit program, the only program I
have is called limits and these are what I get when running it:
[EMAIL PROTECTED] /home # limits
Resource limits
Hi,
This is all I could see just before it happened:
mysql> show processlist;
++--+---+-+-+--++---
---+
| Id | User | Host | db | Command
Hello,
There is a table (TEST) with ~100 million records, 70 columns (mostly
integers, some doubles, and a few short fixed char()), and has a ~100Gb
size.
The table has a single (not unique) index on one integer column: MMi.
If I invoke a simple select based on MMi, then the selection is VERY sl
Hi, Keith,
RE:
> This seems to be the way things are with mysql nowdays.
> Is it not time for the developers to take a serious look
> into culling all the outdated and multiple ways of
> accomplishing the same thing from mysql and the
> documentation?
This is a somewhat different subject.
But you
This seems to be the way things are with mysql nowdays.
Is it not time for the developers to take a serious look
into culling all the outdated and multiple ways of
accomplishing the same thing from mysql and the
documentation?
All the excess documentation for different ways of
accomplishing t
Hi,
I have the following table:
CREATE TABLE `z` (
`hash` varchar(16) NOT NULL default '',
`title` varchar(255) NOT NULL default '',
`body` text NOT NULL,
FULLTEXT KEY `title` (`title`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
I have tried the following query:
select sql_calc_found
14 matches
Mail list logo