MySQL ODBC Connector - Best Idea On InnoDB Table for Pooling System

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Best Idea On InnoDB Table for Pooling System

Ady Wicaksono

2006-01-30, 9:25 am

Imagine American Idol where users vote on their Idols

Imagine that the system is using an innodb table... where

INSERTING is very fast might be concurrent .... BUT inserting is done
over HTTP and PHP (not enable multiple insert :(( )
Updating status for each data inserted is also very fast .... i mean
everytime for each incoming vote we must reply the vote, so we need to
update the state
On the other side, we also need to count for each data real time

What is the best configuration i mean from InnoDB engine it self for this

High Concurrent Insert
High Concurrent Update
High Frequency on Select count(*) on table

Thx

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Sponsored Links