5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Any MySQl DBA's lurking?

by lisag
4 replies
I am thinking about hiring a DBA to tune a MySQL server for high transaction volume. 100,000 transactions per hour +-. Anyone have DBA credentials for MySQL?
#dba #lurking #mysql
  • Profile picture of the author Spencer Westwood
    Lisa it depends on more than just the db. What server is it running on (its own or shared), are the tables indexed, are the queries optimised???

    All these factors come into play before you start optimizing MYSQL...

    Kind regards, Spencer
    {{ DiscussionBoard.errors[1151405].message }}
  • Profile picture of the author patfl
    Lisa,

    PM me with some info about the config of the server and what kind of transaction it is, read or write. Also, I would need some info about the application that is connected to the server and that generate those transactions.

    Reaching 100k transaction per hour shouldn't be a problem if you have a decent hardware and if the program connected to the database has been developed correctly.

    Patrice
    {{ DiscussionBoard.errors[1151565].message }}
  • Profile picture of the author fifthnormal
    I would have to say tuning the your application is likely to net you better results.

    Typically what I see is not so much a problem with the MySQL database schema, but just poorly written applications that access the database. That's kind of a universal problem, not just with the MySQL platform.

    There are exceptions though, like if the developer just didn't add any indexing... Sometimes over indexing is a problem as well.
    {{ DiscussionBoard.errors[1190842].message }}
  • Profile picture of the author warrich
    try mysql performance blog for more detail or pm me i will optmize your mysql setting on server
    Signature
    {{ DiscussionBoard.errors[1207525].message }}

Trending Topics