New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Looking for MySQL Expert to Help with Server Optimization
Hello,
I'm looking for experienced mysql expert who can help me to fine tune dedi server with Mysql (mariadb). It was many concurrent inserts/selects and I don't know how to optimize it myself.
Can you guys recommend me some individual or company, but I prefer individual as I hope to get lower price.
Many thanks!
Comments
Email [email protected] or add Servaman on Skype.
@rmlhhd
Is that your site? Or have you used them?
Their site does't show me that they are experts for mysql…as they are also offering article writing service…just look like another indian company…
Try Percona consulting services
Yes this is my site and no it's not Indian. We don't publicly offer MySQL services on our site as not that many people are interested.
We are not experts so to speak but we certainly can optimise MariaDB. We have large clusters setup and they are working very well and fast!
Try mysqltuner (or equivalent for MariaDB)
Try mysqltuner first and fix the most obvious things before paying someone to look at your mysql.
I did write an article about mysqltuner, how to install it and run it. You get pretty far by running mysqltuner
Yes, there are some general rules you can follow that help get the most out of your hardware. Usually it tends to be whether you have the best table structure and indexes for what you're achieving and also trying to best fit regularly accessed data into memory.
percona would be a great place to get assistance, but I imagine they charge a fair bit as they're very well known. Guess it depends on your budget.
Yes, percona is expensive for me…maybe if I'm some bank or paypal I would hire them
mysqltuner will not help much as I need general advices like what fields to set for indexes, or do I need index at all in my system, MyISAM vs InnoDB, maybe filed types can be changed for better performance, etc…
So, all that can be analyzed only by human who has experience in mysql management.
I hope I would find some single person who is experienced...
Giving suggestions for indexes requires knowledge on the sql statements you will be using. You need to sit down and analyse, make changes and then diagnose the effect. Will take some time to get it rolling.
I think I have a few links that you could check out.
Hi.
I can help you with it. I have 7 years of experience with web technologies and server administer. Extensively use MySQL for over 3 years. I personally also use MariaDB for most of production websites, so it's a plus I am working hardly to optimize (web)infrastructure. I have a few hundred of servers under monitoring. Some of servers is for highloaded websites (more than 1 million views per day).
You should choose InnoDB (XtraDB) for most of tables. Indexes is a must if you have many selects.
And, as we are at LowEndTalk, the price is rather moderate.
Feel free to pm me if you want.
@Profforg I have sent you PM.
@MikHo Can you please post those links here.
If you still need help send me a pm. I will be able to help you once I am done with work for the day
https://dev.mysql.com/doc/refman/5.0/en/using-explain.html
http://www.openlogic.com/wazi/bid/195905/Tips-and-Tricks-to-Optimize-MySQL
http://20bits.com/article/10-tips-for-optimizing-mysql-queries-that-dont-suck
Quick google
Contact PSM. They know what they are doing