•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 430,107 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,160 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 544 | Replies: 1
 |
•
•
Join Date: Feb 2008
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I used both Myisam and InnoDB.
We have something like 500k update, 500k and 500k insert/delete/replace per hour. Many full scan because of updation.Both give me some problem either dead lock occurs or too many connection rise. Also insert/delete/replace operation takes long time.
If i used innodb then dead lock occurs. And When i used Myisam then comes "Too many Connection".
How can i solve these problem?
We have something like 500k update, 500k and 500k insert/delete/replace per hour. Many full scan because of updation.Both give me some problem either dead lock occurs or too many connection rise. Also insert/delete/replace operation takes long time.
If i used innodb then dead lock occurs. And When i used Myisam then comes "Too many Connection".
How can i solve these problem?
•
•
Join Date: Dec 2007
Posts: 116
Reputation:
Rep Power: 1
Solved Threads: 14
Junior Poster
•
•
•
•
Many full scan because of updation.
What is the value of max_connections in my.cnf?
Can't you perform queries in bulk? e.g. Use a single query to insert 2 rows instead of 2 quereis
Use
INSERT INTO table (col1, col2) VALUES(val1, val2), (val3,val4);
Use
INSERT INTO table (col1, col2) VALUES(val1, val2); INSERT INTO table (col1, col2) VALUES(val3, val4);
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- MyISAM vs InnoDB (MySQL)
Other Threads in the MySQL Forum
- Previous Thread: store HTML is a text field in a table on a MySQL Database
- Next Thread: MySql Autoincrement
