Results 1 to 6 of 6

Thread: MySQL Tuning

  1. #1
    Join Date
    Mar 2003
    Location
    Manchester
    Posts
    76

    MySQL Tuning

    We're writing a script that captures a large number of data packets, processes them, and then places them in a MySQL Database.
    There are going to be twice as many writes to the database than reads and there could be up to 1000 concurrent write in extreme circumstances.

    So, what's the best way to tune the MySQL configuration for this kind of use?
    We've purposely setup MySQL to use INNODB.

    We'll increase the number of maximum available connections and per users connections but what about buffers and cache values - are the defaults ok, or is there something we should set that would greatly enhance write performance?

    Thanks,
    Tom

  2. #2
    Join Date
    Jan 2011
    Posts
    451
    Hello Tom,

    Are you using cPanel?

    I hopes this video help you to know more about mysql optimization :

    http://www.cpanel.net/videos/mysql-optimization/
    " Your work is to discover your work and then with all your heart to give yourself to it. "

    That's the mark of a true professional !

  3. #3
    Join Date
    Mar 2003
    Location
    Manchester
    Posts
    76
    Thanks, I'll take a look.

  4. #4
    Join Date
    Jan 2011
    Posts
    451
    Welcome ! Good Luck !
    " Your work is to discover your work and then with all your heart to give yourself to it. "

    That's the mark of a true professional !

  5. #5
    Join Date
    Mar 2003
    Location
    Manchester
    Posts
    76
    Excellent video, ta.

  6. #6
    Join Date
    Jan 2011
    Posts
    451
    Hello,

    Ya, it is. Great to know that you liked it.
    " Your work is to discover your work and then with all your heart to give yourself to it. "

    That's the mark of a true professional !

Similar Threads

  1. MySQL tuning
    By Neko Negde in forum Hosting Security and Technology
    Replies: 4
    Last Post: 05-27-2011, 11:21 AM
  2. MySQL Tuning
    By M Nour in forum Dedicated Server
    Replies: 5
    Last Post: 10-02-2010, 12:57 PM
  3. Help Tuning MySQL
    By pgowder in forum Hosting Security and Technology
    Replies: 3
    Last Post: 04-09-2007, 11:17 AM
  4. MySQL tuning - HW or SW
    By MongoHosting in forum Hosting Security and Technology
    Replies: 3
    Last Post: 05-20-2004, 12:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •