|
|||||||
| Forums | Search Forums | Register | Forum Rules | Man Pages | Albums | FAQ | Members | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
06-21-2012
|
|||
|
|||
|
Self tuning database servers
I have been looking into Percona (Percona Server with XtraDB - Percona Software), potentially for use as a surrogate for MySQL. Percona claims to be self tuning. What does it really mean to be self tuning for a database server, in the general sense? Apart from configuration parameters, such as the cache query size, there could also be some more complex tuning measures such as indexes and storage engines (use memory based storage engine for small but often used data).
How much awareness can be given to a database server for it to be self tuning? Surely there must be limits? |
| Sponsored Links | ||
|
|
#2
06-23-2012
|
|||
|
|||
|
The need for self-tuning systems software arises from the increasing complexity of today's systems combined with the decreasing fraction of users willing or able to tune such systems themselves. and even personal computers purchased solely for word processing come with systems software that provides paging, mainframe modernization scheduling, window management, device management, and filesystem caching, all of which can be tuned for better performance
Last edited by timitiwinkle; 06-24-2012 at 11:07 AM.. |
| Sponsored Links | ||
|
|
#3
06-24-2012
|
|||
|
|||
|
Thank you for your response and seems plagiarised from Self-Tuning Systems Software
The question regards database servers though. |
| Sponsored Links | ||
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can't create database after Oracle Database installation | solaris_user | Solaris | 0 | 09-19-2011 04:46 AM |
| redirect solaris database from linux database.. | senkerth | Solaris | 7 | 03-25-2011 03:37 PM |
| MySQL Tuning Tools with mysqltuner.pl and tuning-primer.sh | Neo | Web Programming | 3 | 12-06-2008 12:14 AM |
| SAS Tuning | alex blanco | UNIX for Advanced & Expert Users | 1 | 07-10-2007 12:08 PM |
|
|
Linear Mode
