:::: Site with High-Volume Writing & Auto-Increment Fields

CodeCharge Studio

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> PHP

:::: Site with High-Volume Writing & Auto-Increment Fields

Author

Message

klwillis

Posts: 428

Posted: 12/28/2004, 2:29 PM

Has anyone experienced problems within a high-volume website using MySQL where the rows are uniquely
identified by auto_increment primary key fields?

Have you started seeing significant delays when performing
record inserts into MySQL as the number of users inserting
records into the database increases?

_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"

Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006

RonB

Posts: 228

Posted: 01/09/2005, 7:35 AM

If you experience problems you should probably look at what table types you are using. Try different ones to suit your needs. Like innodb tables instead of myisam and vice versa.

klwillis

Posts: 428

Posted: 01/09/2005, 8:58 AM

INNODB is the only choice for us in this application.

MYISAM is fine for retrievals, but updates to a table using this
engine require the entire table to be locked prior to performing
updates.

I think we'll just have to see what happens overtime.

Quote RonB:
If you experience problems you should probably look at what table types you are using. Try different ones to suit your needs. Like innodb tables instead of myisam and vice versa.

_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"

Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006

mamboBROWN

Posts: 1713

Posted: 01/09/2005, 10:20 AM

You may want to use tools to analyze if you have database bottle necks. Check the MySQL site for their or 3rd party tools that can help you determine where bottle necks are. It could be slow queries that need to be rewritten or other database issues that could be quickly addressed. Good Luck.

klwillis

Posts: 428

Posted: 01/09/2005, 10:37 AM

No problems yet - we're just trying to be proactive.

I appreciate your sugestions.

Quote mamboBROWN:
You may want to use tools to analyze if you have database bottle necks. Check the MySQL site for their or 3rd party tools that can help you determine where bottle necks are. It could be slow queries that need to be rewritten or other database issues that could be quickly addressed. Good Luck.

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home | Search | Members | Register | Login