[EN] MySQL database server

Where is the PHPMyAdmin?

PHPMyAdmin is a common application for accessing and managing MySQL databases.

There are often security issues regarding PHPMyAdmin, so we don't recommend installing it on our managed servers. Instead please use PIL's PHPMyAdmin installation - you can find it at https://mysql.pil.dk

If you are having trouble with logging in, please check the following:

  1. Ensure you have typed in the all of the servername including '.pil.dk' eg. 'myserver.pil.dk' in the Server field.
  2. Check twice that you typed the exact username and password provided by us.
  3. Send us a message providing hostname, database name, username and your ip ( check www.myip.dk ) - Do not send us your password!

Should I choose MyISAM or InnoDB for my tables?

MyISAM has been the default MySQL engine for many years, but since MySQL 5.5.5 the default has been switched to InnoDB. And with good reason, allthough MyISAM historically has been the fastest for simple queries, that is usually no longer the case.

MyISAM especially suffers from table based locking and lack of scalability on multicore servers:

Source: mysql-innodb-myisam.pdf

How to convert tables from MyISAM to InnoDB

The simplest way to convert a table is with the ALTER TABLE tablename ENGINE=InnoDB; syntax ( mysql documentation ). But remember that the table is locked while doing so, and that it can take some time on large tables.

You can also mysqldump into a file, substitute the engine and restore the table again (this can can faster than alter table):
mysqldump $db $table | sed 's/ENGINE=MyISAM/ENGINE=InnoDB/' > table_dump.sql. The table can be restored again with mysql $db < table_dump.sql

Har du flere spørgsmål? Indsend en anmodning

0 Kommentarer

Artiklen er lukket for kommentarer.
Drevet af Zendesk