Changes between Version 14 and Version 15 of MySql


Ignore:
Timestamp:
10/13/11 16:50:21 (6 years ago)
Author:
joshuadf
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • MySql

    v14 v15  
    9999Create a place for the query log: 
    100100{{{ 
     101mkdir /var/log/mysql/ 
    101102touch /var/log/mysql/query.log 
    102103chmod 600 /var/log/mysql/query.log 
    103104chown mysql.mysql /var/log/mysql/query.log 
    104 /etc/init.d/mysql restart 
     105/etc/init.d/mysqld restart 
    105106}}} 
    106107 
     
    125126 
    126127You may also be interested in the [http://www.mysqlperformanceblog.com/2006/07/27/mysql-query-cache/ MySql Query Cache].  
     128 
     129== Separate InnoDB tables == 
     130 
     131The MyISAM engine keeps data in separate files for each database table, while by default the InnoDB engine uses a single `ibdata1` file. You can get separate files with InnoDB like this: 
     132{{{ 
     133[mysqld] 
     134innodb_file_per_table=1 
     135}}} 
     136 
     137 
     138