MySQL database limits?

Problems with the Linux version of XAMPP, questions, comments, and anything related.

MySQL database limits?

Postby trendless » 17. February 2009 20:47

I'm having some trouble with a program I'm running on XAMPP. It seems that when I start to approach 200 unique items saved to the database it stops allowing me to create new unique items. Is there something in the implementation of MySQL in XAMPP that could be causing this (php hardening etc)?

The only customization that I've done is add ZendOptimizer which is required for the program (encrypted scripts). Suffice it to say, I'm a lamp noob and wouldn't know where to begin customizing, so I certainly haven't been messing around :|
Last edited by trendless on 17. February 2009 21:15, edited 1 time in total.
trendless
 
Posts: 5
Joined: 27. January 2009 20:16

Re: MySQL database limits?

Postby Wiedmann » 17. February 2009 21:00

It seems that when I start to approach 200 unique items saved to the database it stops allowing me to create new unique items.

Well, MyISAM is using table locking:
While you insert/update many rows, the table is locked for other inserts.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL database limits?

Postby trendless » 17. February 2009 21:28

Wouldn't that affect the first new unique item I try and add to the database if it were going to affect any; ie I would have issues right from the start, not after some data has already been added?
trendless
 
Posts: 5
Joined: 27. January 2009 20:16


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 10 guests