tatiana.azundris.com

mysqldump.azundris.com

I18N - MySQL-dump

http://mysqldump.azundris.com/categories/25-I18N

MySQL is destroying my Umlauts. This is the english translation of an article. In my german blog. This article, like the german original, is licensed CC-BY-SA. The english translation has been kindly provided by Tobias Klausmann. Recently, I had to explain this to several people, hence a writeup for the blog for easier reference. The question:. I have content in my database that can be sucessfully read and written by my application, but if I do a. Thus (hopefully) is the character sequence. And this is t...

mysqldump.azundris.com

Security - MySQL-dump

http://mysqldump.azundris.com/categories/21-Security

Mylogin.cnf password recovery. As Todd Farmer points out in Understanding mysql config editor s security aspects. The new .mylogin.cnf file generated by mysql config editor. Does not securely store the password used to login to the database. It just obfuscates it. The format of the file is as follows (as of MySQL 5.6.7-RC):. 4 Bytes Zero (Version Information). 20 Bytes Key Generation Matter. 4 Bytes Length information. Length bytes crypted matter. The crypt is done using the AES ENCRYPT. I suppose the Pe...

mysqldump.azundris.com

Dude, where is my memory? - MySQL-dump

http://mysqldump.azundris.com/archives/106-Dude,-where-is-my-memory.html

Dude, where is my memory? Dude, where is my memory? Kris, please have a look at our database. We are running a materialized dataset processor, and on a database with about 40 GB of buffer pool and a database size of 6 GB, we are observing swapping.". Now, that is interesting. The box in question has 48 GB of memory, and indeed, hardly 6 GB of data. Mysql> select . 160;-> sum(data length index length)/1024/1024/1024 as gb . 160;-> from tables . 1 row in set (0.00 sec). That's going to be interesting!

mysqldump.azundris.com

MySQL 5.6-RC: GTID vs. MyISAM - MySQL-dump

http://mysqldump.azundris.com/archives/103-MySQL-5.6-RC-GTID-vs.-MyISAM.html

MySQL 5.6-RC: GTID vs. MyISAM. MySQL 5.6-RC: GTID vs. MyISAM. So we tested the 5.6.7-RC. And ran into a strange problem:. Because of a test, a preexisting configuration with GTID enabled existed, and suddenly we did not have properly initialized grants in mysql.* created for a new installation. Turns out: GTID and non-transactional tables are no friends, and that is even documented. Server: # less /usr/share/mysql/mysql system tables data.sql. INSERT INTO tmp user VALUES ('localhost','root',' ,.);. This ...

mysqldump.azundris.com

Entries by Azundris - MySQL-dump

http://mysqldump.azundris.com/authors/1-Azundris

Waiting for a full mysqldump. As a service to the busy, here are SuSE 10.0 RPMs of 5.0.19 a/o 2005-12-27. Mdash; use the spec-file to roll your own from the sources. This is a QND build, no warranty given, no responsibility taken. As a service to the busy, here are SuSE 9.3 RPMs of 5.0.13 a/o 2005-09-09. Mdash; use the spec-file to roll your own from the sources. This is a QND build, no warranty given, no responsibility taken. A day in the docs. The most recent MySQL server I used in a. Just out of curio...

mysqldump.azundris.com

Miscellaneous - MySQL-dump

http://mysqldump.azundris.com/categories/6-Miscellaneous

Waiting for a full mysqldump. Pending acts of god, I will be. At the MariaDB Dev Meeting. In Lisbon, PT, arriving 2011-03-11 (Thu) late, and leaving 2011-03-14 (Mon) around noon. At O'Reilly MySQL Conference and Expo. In Santa Clara between 2011-04-12 and 2011-04-15. I will arrive in SFO late 2011-04-08. Salmiakki - the official MySQL Drink. The official MySQL Drink. How to make it:. Continue reading "Salmiakki - the official MySQL Drink". LDAP is not relational. Let me explain why. If you write blog ent...

mysqldump.azundris.com

Scaleout and Tuning - MySQL-dump

http://mysqldump.azundris.com/categories/24-Scaleout-and-Tuning

How large can a MySQL database become? In Maximum MySQL Database Size? Nick Duncan wants to find out what the maximum size of his MySQL database can possibly be. He answers that with a list of maximum file sizes per file system type. That is not a useful answer. While every file system does have a maximum file size, this limitation is usually not relevant when it comes to MySQL maximum database size. But let's start with file systems, anyway. Second: You also never. In Scaleout and Tuning. The immediate ...

mysqldump.azundris.com

Replication - MySQL-dump

http://mysqldump.azundris.com/categories/27-Replication

MySQL 5.6-RC: GTID vs. MyISAM. So we tested the 5.6.7-RC. And ran into a strange problem:. Because of a test, a preexisting configuration with GTID enabled existed, and suddenly we did not have properly initialized grants in mysql.* created for a new installation. Turns out: GTID and non-transactional tables are no friends, and that is even documented. Also, this is supposed to work with GRANT and REVOKE, but not with INSERT and DELETE. Now guess what mysql-install-db and friends are using? This is now s...

mysqldump.azundris.com

MySQL-dump

http://mysqldump.azundris.com/archives/P2.html

Fighting the mysqld init script. Today we discovered a particularly subtle way of fucking up a server restart. After a routine configuration change and RPM upgrade, a colleague tried to restart an important master. That failed. The message:. Root@master  ]# /etc/init.d/mysql start. Starting MySQLCouldn't find MySQL manager (/ bin/mysqlmanag[FAILED]erver (/ bin/mysqld safe). The colleague tried multiple times, and finally resorted to manually typing a. Nohup mysqld safe . An ORM wrapper around DBI, which ...