473,398 Members | 2,404 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,398 software developers and data experts.

Are mysql indexes automatically maintained?

I've just applied an index to my mysql 4.0.21 database/tables and it
really helped with speed. I was wondering if this index I added is
automatically adjusted by mysql over time or do I have to go back say
every week and remake the index?

Mysql 4.0.21
Linux 2.4.30

Thanks.

Jul 23 '05 #1
1 1647
sc****@particle.net wrote:
I've just applied an index to my mysql 4.0.21 database/tables and it
really helped with speed. I was wondering if this index I added is
automatically adjusted by mysql over time or do I have to go back say
every week and remake the index?


Making it once is enough. Having an index in a table makes inserts a
little bit slower because MySQL has to sort it when it's inserted. But
you won't notice it unless you insert sereral rows simultaneously and
the speed decrease is usually much less than the gain in speed with
select queries.
Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Asher Golan | last post by:
Which '.exe' file should I run in order to start the MySql Server ? How do I creat a new data base ? I learnt how to access MySql using php commands, but dont know how to create the database. Is...
4
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
6
by: David Brown | last post by:
With MySQL is it possible to have indexes or tables held in RAM? If so how do I ensure that updates are copied to disk? Regards, Dave.
3
by: Roger | last post by:
Hi I got the advice to rebuild the indexes on the databases once a year. Espesially if the database have grown much. The question is: How do I do that? If I try to run the indexscript wich was...
1
by: Gregory.Spencer | last post by:
Hi there, Using PHPMyAdmin and it is very usefully reporting problems with my MySQL DB. "PRIMARY and INDEX keys should not both be set for column `column_name`" and
9
by: Derrick Shields | last post by:
I'm working with a database that has over 11 million rows. The .SQL drop file is about 2.5gigs. Doing a simple query: select * from people where last_name like '%smith%' A query like this can...
6
Atli
by: Atli | last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users. Anyone should be able to get...
1
by: Manoj Dubey | last post by:
I would like to execute the mysql Setup.exe through program without inputting any clicks on the button given, Like "next", "Install" and so on. The program should install the MYSQL 5...
0
by: idealfellow | last post by:
Hi Guys, I have multiple Mysql DB instances containing same schema but different data in the tables, running in my unix server. I always have the issue of not upgrading...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
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,...
0
jinu1996
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...
0
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...
0
tracyyun
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...
0
isladogs
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.