MySQL

MySQL and MariaDB innodb_file_per_table

Read more about MySQL and MariaDB innodb_file_per_table
Log in to post comments

For those of you pushing your MySQL instances to higher levels, you'll have realized at some point that all InnoDB tables share their indexing space into a single file (ibdata1, usually). This has several very bad outcomes:

the ibdata1 file becomes huge after some time (we've seen it pass the 8GB bar)
starting the MySQL server takes longer
deleting an InnoDB table *doesn't* reduce the space used by ibdata1
you have to shutdown your server, remove ibdata1 completely, then restart the server in order to reinitialize the ibdata1 file to a 0-size file (but th

Vim regexp: transforming multiple SQL inserts into a big one

Read more about Vim regexp: transforming multiple SQL inserts into a big one
Log in to post comments

If you ever face a very slow MySQL process based on a very long insert file and you want to optimize it by unifying a lot of queries, you can do something like the following.

Imagine you have a lot of these:

Profiling MySQL/MariaDB queries

Read more about Profiling MySQL/MariaDB queries
Log in to post comments

Important meetings

Read more about Important meetings
Log in to post comments

Sometimes I like to treat this blog as a personal one and write down things that might affect in fundamental ways our future... or at least my own future, potentially. Anyway, I'm currently living in Peru and had a series of meeting over the last two months with the new Electronical Government Office (ONGEI).

Import MySQL tables from .myd

Read more about Import MySQL tables from .myd
Log in to post comments

This is an easy procedure to import any MyISAM table that you would have in .myd, .myi and .frm format, into a local database. I assume you have MySQL server and a MySQL client on your local machine.

First, identify the name of the table (that's the name before the ".myd" extension).
Connect to your local database and create a dummy database (let's call it "import")
Create a table inside that database with the exact same name as the one you need to import.

Reset MySQL root password

Read more about Reset MySQL root password
1 comment
Log in to post comments

Reference: http://www.cyberciti.biz/tips/recover-mysql-root-password.html (partly copied to avoid loosing source)

# /etc/init.d/mysql stop

Stopping MySQL database server: mysqld.
# mysqld_safe --skip-grant-tables &
[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[6025]: started
# mysql -u root
Welcome to the MySQL monitor.

Dokeos and MySQL strict SQL mode

Read more about Dokeos and MySQL strict SQL mode
2 comments
Log in to post comments

We've had reports about Dokeos creating problems when used with MySQL in strict mode. There's a large topic development on the forum about that. The idea is that MySQL can be set to be more strict about the SQL syntax used in queries.

Subscribe to MySQL