Results 1 to 14 of 14
Thread: Fastest MySQL server
-
02-06-2011, 07:10 AM #1Newbie
- Join Date
- Feb 2011
- Posts
- 20
Fastest MySQL server
Hi,
I am looking for a very fast mysql solution.
My app has a lot of write querries.
I read about memchached, clustering, geography partitioning... and frankly my knowledge is limited.
Tell me your experience.
-
02-06-2011, 07:34 AM #2Web Hosting Master
- Join Date
- Apr 2007
- Posts
- 3,531
MySQL speed can be improved in a few area's.
Firstly before you look at the servers hardware, check the application. The reason for slowness is normally not the hardware but coding that is very MySQL intensive. Sure hardware isn't always that expensive but improving the coding is free plus a bit of time.
Speeding up MySQL is a fairly easy concept, you generally want to improve the performance of where it's stored. So this is looking at changing your hard drives from something like SATA 7.2k disks, to 15k SAS drive or SSD drives etc...
So whats the fastest hard drive? well RAM, not technically but it can be for the purpose. So RAM is always going to be faster than a hard drive, if you have enough of it then it makes scene just to store all your database there, once the server has booted up of course.
What if you don't have enough RAM, well then their is caching. Basically this just stores the most common queries in RAM, so if their run again the database can just hand over what's in RAM without having to query the disk.
Cache can also be used in your application, using something like PHP memcache you can stop the query even hitting the MySQL server and wasting precious processing power and resources.
What server do you have at the moment? what application is using the server?BotWars.io - Code the AI of your Battle Bot!
-
02-06-2011, 08:12 AM #3Eternal Member
- Join Date
- Dec 2004
- Location
- New York, NY
- Posts
- 10,710
If your goal is purely MySQL performance you may want to look at a dedicated server based solution, and not a cloud server.
-
02-06-2011, 11:20 AM #4Temporarily Suspended
- Join Date
- Jan 2011
- Posts
- 127
SSDs do good work for improving overall database performance.
-
02-06-2011, 11:24 AM #5Lord of live chats
- Join Date
- Jul 2009
- Location
- UK
- Posts
- 1,312
As your doing a lot of writes... Maybe change the storage engine?
Live Chat Support Software for your Business website - IMsupporting.com
-
02-06-2011, 02:24 PM #6Web Hosting Master
- Join Date
- Apr 2009
- Posts
- 1,143
I would look into a dedicated server aswell if you are purely looking for sql performance.. A server with either a hookup to a fast SAN or a set of ssd discs is a good option for pure performance.
-
02-06-2011, 02:33 PM #7Web Hosting Master
- Join Date
- Apr 2009
- Location
- inside wht
- Posts
- 746
You may better replace mysql with percona server . Also use Debian OS for your mysql server. We had big issues in a VB forum which was badly performing in Centos kernel. So we changes OS to debian and replaced with percona. It works great now . Also try to put temp tables in memory too .
24x7 PROACTIVE SERVER MANAGEMENT | OUTSOURCED WEB HOSTING SUPPORT
Sales : sales @ syslint.com | Call us : (+91)9447607799 | Are you looking for DevOps Admins ?
-
02-06-2011, 04:02 PM #8Newbie
- Join Date
- Feb 2011
- Posts
- 20
So to sum it up :
Percona server on dedicated running Debian with SSD and use temp in RAM
thanks !Last edited by mcdroid; 02-06-2011 at 04:07 PM.
-
02-06-2011, 04:11 PM #9Web Hosting Master
- Join Date
- Apr 2009
- Location
- inside wht
- Posts
- 746
24x7 PROACTIVE SERVER MANAGEMENT | OUTSOURCED WEB HOSTING SUPPORT
Sales : sales @ syslint.com | Call us : (+91)9447607799 | Are you looking for DevOps Admins ?
-
02-06-2011, 04:11 PM #10Newbie
- Join Date
- Feb 2011
- Posts
- 20
what is a good mysql config ?
-
02-06-2011, 04:15 PM #11Newbie
- Join Date
- Feb 2011
- Posts
- 20
Is there a tool to deploy instances of mysql and dispatch queries across multiple servers?
-
02-06-2011, 06:21 PM #12Web Hosting Master
- Join Date
- Mar 2009
- Location
- Austin, TX
- Posts
- 935
SysAdmin.xyz
Having severs with customer data on it without proper monitoring is like having one night stand without using protections - eventually, there will be an 'oh s**t!' moment.
-
02-07-2011, 02:16 AM #13Web Hosting Evangelist
- Join Date
- Sep 2008
- Posts
- 545
I suggest you 3 ways.
1) Check your application queries. Make sure you have using correct database engine. I think innodb would be better for you. Also, make sure you have added correct index to your database.
2) Use mysqltuner. Check whether you have correct amount of RAM.
3) Using SSD drives will improve your performance.
Once you have done the above three you will have a good database server.
-
02-07-2011, 05:36 AM #14Web Hosting Guru
- Join Date
- Oct 2005
- Posts
- 292
Given that you want something write heavy and clustered, have you considered MySQL Cluster? MySQL Cluster seem to fit the bill.
Can you cite more usage details like:
1. Desired performance in terms of requests per second?
2. Size of data inserted/updated?
3. Type of writes?
4. Sample schema perhaps?
Similar Threads
-
FASTEST MySQL and PHP Hosting, [Seeing is Believing] 75% OFF On Any Plan
By Ivan23 in forum Shared Hosting OffersReplies: 0Last Post: 07-17-2005, 12:32 PM -
Experience the FASTEST MySQL and PHP Hosting, ($6.99 per 3 months)
By Ivan23 in forum Shared Hosting OffersReplies: 3Last Post: 04-09-2005, 11:22 PM -
Fastest Query - MySQL/PHP
By mattschinkel in forum Programming DiscussionReplies: 16Last Post: 05-17-2003, 03:34 AM -
Biggest, Fastest, Most stable MySQL Host?
By ElliotH in forum Web HostingReplies: 4Last Post: 03-12-2003, 06:49 PM