Helpon Mysql Table Type

Forums: Web Development
Email this Topic • Print this Page

I am writing a web-based application for outputting MIS monthly data of our organisation using PHP & Mysql.
There are three tables, Monthly_data, Cumulative_Data & Targets_Data. Every day around 50 clients will enter data in 2 tables Monthly_Data & Cumulative_Data. Since some the data entered is tentative, in the month end there will be lot of updating in the tables.

All the tables are MyIsam with 60 columns. Most of them are either Decimals (Max 10,2) and few are of varchar type. There is one auto numbered column for primary key and a varchar column with and index length of 25 to speedup the searches.

I'm not using transaction or any temporary tables. Even though chances for concurrent writing is minimal, since all the 3 tables are being read or written multiple times during every single process, and the data entered is vital, the tables are Write locked and Unlocked during each process .
My questions are listed below. Since I am not a professional programmer please try to be a bit descriptive while answering.
Regards
Thomas

1. Is Mysql suitable and reliable for the above kind of application?

2. What type of Table should I use? MyIsam or InnoDB?

3. Can the Locking of Tables can cause any corruption or any other problems? One of my tables crashed during the trials(The platform was Mysql on Windows 98), hence the query.

4. What should be the frequency of optimising the tables?

5. Can a Windows NT server with Mysql & PHP give a performance par with the Linux?

Topic Stats
Top Replies
Link to this Topic

Type: Discussion • Score: 1 • Views: 583 • Replies: 1

No top replies

Re: Helpon Mysql Table Type

chasun wrote:

1. Is Mysql suitable and reliable for the above kind of application?

Yes

Quote:

2. What type of Table should I use? MyIsam or InnoDB?

Depends on how hard this db will be used. For this kind of thing to have a significant effect I am talking about thousands and thousands of queries a day.

Changing the type later is not too hard, but the basics ar that MyIsam is faster but does not have row locking, only table locking.

Quote:

3. Can the Locking of Tables can cause any corruption or any other problems? One of my tables crashed during the trials(The platform was Mysql on Windows 98), hence the query.

I don't think so

Quote:

4. What should be the frequency of optimising the tables?

Depends on usage. It can cause the db to be sluggish. But even on large dbs, you rarely have problems and you likely don't even need to do it once a month.

Quote:

5. Can a Windows NT server with Mysql & PHP give a performance par with the Linux?

What is the criteria for performance? Windows has a lot of unecessary overhead that I don't like in a server. For example, a GUI. I have no need for "windows" at all in a server, I just need command line.

So any server like Windows' servers or Apple's servers that has a fancy GUI is running a lot of wholly unecessary stuff as far as the web app is concerned.

0 Replies

Helpon Mysql Table Type

Related Topics

Quick Links

My Account

able2know