GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

MySQL and 2 heavy tables

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL and 2 heavy tables

    Hello everyone

    I have a MySQL DB and I work with as language: PHP

    In this database, two tables are too heavy, because the insertion is made every second.

    I want to make sure that I have, in these two tables, the data from the last 2 months. If I do with normal queries and everything, it will crash the server. If I create a new table and I copy the data from the last 2 months, it could crash the server too.

    Have you any idea how to deal with this kind of problem?

    Thank you very much

  • #2
    >> because the insertion is made every second.

    are you kidding me?

    Comment


    • #3
      I am not kidding. I am very serious about this.
      Have you any idea to help me?

      Comment


      • #4
        A server should not crash from 1 insert per second.

        What's your table lay-out and what is your query?

        Comment

        Working...
        X