I ran

apt-get upgrade

today for the first time in a while to get the newest version of Apache and it said that there was an update to MySQL which I decided to install.

Now I am getting this prompt:


I originally created the server with the Linode LAMP StackScript which evidently optimizes MySQL is some way. What do I need to look for in my.ini?

I should note that I am very good with Apache and PHP configuration, but the extent of my MySQL configuration knowledge is how to change the

lower_case_table_names

flag (on Windows it really should default to 2, otherwise it breaks compatibility with Pear MDB2).

Typing "D" at the prompt will show you the differences. If there is any configuration that you don't understand, it's usually safe to keep your existing configuration file when performing a routine apt-get upgrade. You can always track down any errors later.

By the way, do you really want MariaDB, or are you just doing a routine upgrade? It seems that you enabled a third-party repository for MariaDB, because Ubuntu Lucid (10.04) most certainly does not come with MariaDB 5.2.8. If you do not have any particular reason for wanting to use MariaDB, just disable the third-party repository, or use "apt pinning" to go back to standard MySQL 5.1.x. If you're not sure, just stick with MySQL.

I was actually planning to switch to MariaDB at some point since it performs much better on one of my other servers.
I will save a copy of the diff so I can revert manually if needed.

I found which admin added the MariaDB to the sources (he put it in /etc/apt/sources.list.d/mariadb.list with a name included)

If you know what you're doing, then fine, go ahead

I was just trying to caution you because it sounded like you were doing a routine apt-get upgrade and MariaDB popped out of nowhere.

Tell us how it goes!