[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] MySQL tabel og index'



Jeg ved ikke lige hvad grundlaget for de index' er, men det virker stadig som overkill.

Backup bliver kørt midt på natten med "mysqldump --add-locks --lock-tables --skip-comments -u BRUGERNAVN -pPASSWORD DATABASENAVN > DATABASENAVN.sql"

Det er en dedikeret MySQL server, som er trimmet rimligt godt til opgaven, så det er ikke ressourcer der mangler.

Den pågældende tabel er sjældent ude for ændringer og der bliver kun kørt queries i dagtimerne, så det spiller hellere ikke nogen rolle.

Der er andre database med langt større data mængder, som ikke så længe om at køre backup, men der er index'erne også rimligt begrænset.

I slow-query loggen skriver MySQL "SELECT /*!40001 SQL_NO_CACHE */ * FROM `TABLENAME`", efter backup'en, hvilket må siges at være rigtig nok ved backup.

/Nis



 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 22:43 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *