MySQL Performance: MySQL => Large table

Members

Help

Home

Home » Performance » MySQL » Large table

Show: Today's Messages :: Show Polls :: Message Navigator

Large table [message #3053]

Thu, 08 May 2008 04:49

mrl22
Messages: 2
Registered: May 2008

Junior Member

Hi,

I have a script that creates between 60 and 2000 records a minute in a table with only 4 columns, over time this table will get very large....

Is there any way I can build the database for this to run fast even with large ammounts of data?

Richrad

Report message to a moderator

Re: Large table [message #3056 is a reply to message #3053 ]

Fri, 09 May 2008 02:41

mwallace
Messages: 14
Registered: April 2008
Location: CA

Junior Member

Partitioning and indexes. What's the read load expected to be vs. the write load?

Report message to a moderator

Re: Large table [message #3058 is a reply to message #3056 ]

Fri, 09 May 2008 08:02

mrl22
Messages: 2
Registered: May 2008

Junior Member

I can imagine the read to be alot more...

As there will be only one script that will write a load of data once every minute... but multiple clients will generate graphs and stats from that data throughout the day...

Report message to a moderator

Previous Topic:	Database Server Hardware
Next Topic:	counting in my sql XxY

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Mon Oct 13 20:13:24 EDT 2008

Total time taken to generate the page: 0.03353 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.