OPTIMIZE my.cnf
Monty Program has What is MariaDB 5.5? and MariaDB vs. MySQL whitepapers available for download.
This is the main Knowledgebase category for MariaDB.
Follow any of the links below to find information on the topics you are interested in. If you would like to know more about anything that isn't documented, ask a question at the place where the answers should be and we will do our best to provide an answer for it!
Answer
You need to change only few options. The most important thing is that you reserve enough memory for InnoDB's buffer pool.
My advice is that you read these great resources:
- http://www.tocker.ca/2013/09/17/what-to-tune-in-mysql-56-after-installation.html
- http://www.percona.com/resources/technical-presentations/optimizing-mysql-configuration-percona-mysql-university-montevideo
Of course if it's a development machine memory is less important and you can also consider disabling some features (storage engines, network capabilities).