Differences

This shows you the differences between two versions of the page.

Link to this comparison view

ressources:mysql:index [2009/01/29 12:00]
gaspard adding link
ressources:mysql:index [2013/06/16 22:51] (current)
Line 1: Line 1:
-====== Changing MySQL data directory ====== 
  
-===== Why changing mySQL data dir ? ===== +Here is list of tips that have been useful ​for me 
- +  * [[changing_directory|Changing MySQL data directory]] 
- +  ​* [[Faster random]]
-Under Ubuntu server, MySQL data are located under /​var/​lib/​mysql which coud cause problem whether I have a huge database to cope with : on default debian installation,​ much of the disk space is left for the /home/ directory. +
- +
-As there already is a mysql user , it is a better solution to storeits ​data to /home/mysql +
- +
-<​code>​ +
- ​Filesystem ​           Size  Used Avail Use% Mounted on +
- /​dev/​sda1 ​            ​2.9G ​ 1.4G  1.4G  51% / +
- ​varrun ​               493M   ​60K ​ 493M   1% /var/run +
- ​varlock ​              ​493M ​  ​12K ​ 493M   1% /var/lock +
- ​udev ​                 493M   ​20K ​ 493M   1% /dev +
- ​devshm ​               493M     ​0 ​ 493M   0% /dev/shm +
- /​dev/​sda3 ​            ​226G ​  ​94G ​ 122G  44% /home +
-</​code>​ +
- +
- +
-check this link : http://​ubuntuforums.org/​archive/​index.php/​t-765568.html+
ressources/mysql/index.txt · Last modified: 2013/06/16 22:51 (external edit)
 
 
Creative Commons License Powered by PHP Valid XHTML 1.0 April