Member Avatar for vaskar

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?

  • 2 Contributors
  • 1 Reply
  • 52 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for mwasif

Many full scan because of updation.

Don't you have proper indexes?

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);

Instead of
Use

INSERT INTO table (col1, col2) VALUES(val1, val2);
INSERT INTO table (col1, col2) VALUES(val3, val4);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.