Go Back   Singapore Web Hosting Talk > LEARNING CENTER > Server Administration

Server Administration General dedicated servers administration topics.

Reply
 
Thread Tools
Old 11-02-2010, 00:56   #1
john.cheng78
SGWHT Newbie
 
Join Date: 03-02-2010
Posts: 93
john.cheng78 is on a distinguished road
Optimise mySQL

anyone knows how we can optimise SQL?
john.cheng78 is offline   Reply With Quote

Old 11-02-2010, 12:18   #2
admin0
SGWHT Newbie
 
Join Date: 26-07-2004
Location: Singapore
Posts: 11
admin0 is on a distinguished road
Hey,

Optimize the server or optimize the sql queries ?
If for the server, there is one application called mysql tuner.
More info here: http://www.zdnetasia.com/techguide/o...2048294,00.htm

That will do for the server. For queries, there are many things. You need to check if you are doing the correct indexing or using the right columns etc.
__________________
███ Tech Support/Solutions => www.admin0.com
███ VoIP Setup/Customizations => www.voipbro.com
███
███ fulltime senior level 3 isp/system/network/voip/database admin since 1997!
admin0 is offline   Reply With Quote
Old 15-05-2010, 20:26   #3
vheeds
SGWHT Newbie
 
Join Date: 28-01-2010
Posts: 19
vheeds is on a distinguished road
Hello John,

>>we can optimise SQL?

Msql or Mysql?

Let me know so that i can advice you accordingly.
__________________
Stephan V
VHeeds.com
►A Quality WebHosting and Datacenter support.
►Email: sales@vheeds.com
►Read the latest technology news @ http://blog.vheeds.com
►Exclusive Introductory Offer! Server Hardening - $ 20 only | Dedicated Server Support - $500 only | Contact us today and avail these offers.
vheeds is offline   Reply With Quote
Old 06-03-2011, 06:59   #4
Natcoweb
SGWHT Newbie
 
Join Date: 02-02-2010
Posts: 7
Natcoweb is on a distinguished road
Hello,

You could use https://launchpad.net/mysql-tuning-primer to optimize SQL.

Hope this has helped.
__________________
Natcoweb Dedicated and Colocation Hosting
KVM-based VPS Solutions from $9.99
50% Off Bandwidth Pricing
Get a Colocation Quote
Natcoweb is offline   Reply With Quote
Old 17-04-2011, 00:10   #5
bennykusman
SGWHT Newbie
 
Join Date: 21-06-2010
Location: Singapore
Posts: 174
bennykusman is on a distinguished road
have you tried mysqltuner.pl ?
__________________
-----------
Get SG/US/ID server web hosting (cpanel) from @SGD 60 per year! + domain name included!
VPS at 3 locations at great price!
visit: http://bennykusman.com
bennykusman is offline   Reply With Quote
Old 14-11-2011, 07:19   #6
WebhostingCS
SGWHT Newbie
 
Join Date: 28-01-2010
Posts: 46
WebhostingCS is on a distinguished road
Hello,

Maybe this can help you in optimizing your mysql.

10 TIPS FOR OPTIMIZING QUERIES:
http://20bits.com/articles/10-tips-f...hat-dont-suck/

OPTIMIZING MYSQL DATABASE:
http://www.eukhost.com/web-hosting/k...ysql-database/

Thanks!
WebhostingCS is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT +8. The time now is 06:42.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
Copyright (C) 2002-2012 Brought to you by Singapore Web Hosting Talk (SGWHT). All Rights Reserved.