MariaDB: Difference between revisions
>Samthecrazyman InnoDB separate tables added |
>Samthecrazyman m Corrected number formatting under InnoDB section using HTML tags, removed left in line breaks |
||
| Line 38: | Line 38: | ||
<li>You then need to goto 'File' on the menu bar and click 'Open'.</li> | <li>You then need to goto 'File' on the menu bar and click 'Open'.</li> | ||
<li>You now need to open the MySQL configuration file. This is located at <code>/etc/my.cnf</code>.</li> | <li>You now need to open the MySQL configuration file. This is located at <code>/etc/my.cnf</code>.</li> | ||
<li>Scroll down and find the block (values edited out for security):< | <li>Scroll down and find the block (values edited out for security):<pre> | ||
# The MySQL server | # The MySQL server | ||
[mysqld] | [mysqld] | ||
port = 3306 | port = 3306 | ||
socket = /<dir>/mysql.sock | socket = /<dir>/mysql.sock | ||
# Change following line if you want to store your database elsewhere | # Change following line if you want to store your database elsewhere | ||
# datadir = /<dir> | # datadir = /<dir> | ||
skip-external-locking | skip-external-locking | ||
| Line 53: | Line 53: | ||
read_buffer_size = <num>K | read_buffer_size = <num>K | ||
read_rnd_buffer_size = <num>K | read_rnd_buffer_size = <num>K | ||
myisam_sort_buffer_size = <num>M | myisam_sort_buffer_size = <num>M</pre></li> | ||
<li>At the end of the block, you will need to add the following:< | <li>At the end of the block, you will need to add the following: | ||
<pre>innodb_file_per_table=1</pre></li> | |||
<li>Now save this change and close the file.</li> | <li>Now save this change and close the file.</li> | ||
<li>For the change to take effect, you will need to restart the MySQL server.</li> | <li>For the change to take effect, you will need to restart the MySQL server.</li> | ||
<li> | <li><ul><li> Goto the Lanuch menu and open Konsole</li> | ||
<li> | <li> At the prompt type <code>rcmysql restart</code>. This can take a few seconds.</li> | ||
<li> | <li> Now type <code>rcmysql status</code>. You should see that the sever is now running. If it isn't and it says 'failed', there is a problem with what you have typed. You will need to go back through from the beggining, ensuring you have typed the directive correctly and have placed it in the correct block.</li> | ||
</ol> | </ul></ol> | ||
== External == | == External == | ||
[http://www.mysql.com MySQL website] | [http://www.mysql.com MySQL website] | ||