I have a fairly large database on my (2 million records)
WIN32 mySQL 4.0.20
The question is:
I am adding large amounts of data to it (300,000 to 500,000 at a time) with
the standard (INSERT INTO) command.
Question is, do I have to reindex, and when and how often?
Does mySQL automatically build indexes on the fly as I add data?
If I do have to reindex, is there a command that will rebuild all the
indexes for that table (I have 4) ???
Thanks for ANY clarification.
Craig cs********@hotm ail.com 2 2069
Craig Stadler wrote: Question is, do I have to reindex, and when and how often? Does mySQL automatically build indexes on the fly as I add data?
It should merge the new state of the table into the index as you add
data, but this is not the speediest process, and it might not result in
a well-balanced index.
If I do have to reindex, is there a command that will rebuild all the indexes for that table (I have 4) ???
Yes, myisamchk can be used to do this. I think this page will help you: http://dev.mysql.com/doc/mysql/en/Insert_speed.html
Regards,
Bill K.
"Craig Stadler" wrote: I have a fairly large database on my (2 million records) WIN32 mySQL 4.0.20
The question is:
I am adding large amounts of data to it (300,000 to 500,000 at a
time) with the standard (INSERT INTO) command.
Question is, do I have to reindex, and when and how often? Does mySQL automatically build indexes on the fly as I add data?
If I do have to reindex, is there a command that will rebuild all
the indexes for that table (I have 4) ???
Thanks for ANY clarification. Craig cs********@hotm ail.com
From the functionality standpoint, everything will work, and you don’t
have to do anything special for the indexes to be populated.
From the performance standpoint, if it is an issue, use delay key
write to defer writing the indecis to disk (a huge perfor. drain).
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Basic-...ict140718.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=472904 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Bacci |
last post by:
I have two tables. The first is "Locations" which has 52,000 zip codes
w/cooresponding latitudes and longitudes. The second "Suppliers" has 2,000
company names and addresses.
The user enters a zip code and the cooresponding latitude and longitude is
return.
$sql = "SELECT l.latitude, l.longitude ";
$sql .= "FROM Locations l";
$sql .=...
|
by: Phil Powell |
last post by:
The table already has a fulltext index and from there I can use the
MySQL fulltext search query to get results as well as the relevancy
score.
The problem I have is that MySQL has a default setting whereby the
minimum amount of characters is 4 for a search. Being that we're
government and full of TLA (three-letter acronyms), that is not...
|
by: stan k. |
last post by:
First of all i'm on a win32 platform using java. I also have mysql
installed. My question isabout benchmarks and multiple inserts &
selects
SQLITE: http://www.sqlite.org/
HSQL: http://hsqldb.sourceforge.net
I current have a mysql database of approx. 80mb.
Each day I Insert approx .5mb of new records into this table,
and I might also run...
|
by: Nino Skilj |
last post by:
I'm a bit confused about indexing using MySQL. I have something like
this:
Table:
PEOPLE
Values:
user_id
first_name
last_name
|
by: Craig Stadler |
last post by:
I have a fairly large database on my (2 million records)
WIN32 mySQL 4.0.20
The question is:
I am adding large amounts of data to it (300,000 to 500,000 at a time) with
the standard (INSERT INTO) command.
Question is, do I have to reindex, and when and how often?
Does mySQL automatically build indexes on the fly as I add data?
| |
by: nick |
last post by:
Hi,
I'm pretty much a database beginner and have what I think is a basic
question:
If I have a table which has a 'status' column and I can have say three
statuses: "active", "pending", "inactive". Is it better to break these
out into a different "Statuses" table?
On the one hand it seems to me it would be better to be in a different
|
by: Vic Cekvenich |
last post by:
What would be performance of pgSQL text search vs MySQL vs Lucene (flat
file) for a 2 terabyte db?
thanks for any comments.
..V
--
Please post on Rich Internet Applications User Interface (RiA/SoA)
<http://www.portalvu.com>
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet,...
|
by: jrs_14618 |
last post by:
Hello All,
This post is essentially a reply a previous post/thread
here on this mailing.database.myodbc group titled:
MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode
I was wondering if anybody has experienced the same issues
|
by: Amar |
last post by:
Hi All,
I need to select data from a database table containing huge amount of
data. Now I am storing data using one primary key and I am just using
simple select statement, and this process gives me the output but it is
taking long to execute the query. As much I had heared I want to use
some indexing or cluster indexing which might help me...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |