In short, during an optimization or a MySQL query involving a lot of replace(replace(replace…))) I decided to compile PREG as lib_mysqludf_preg from UDF Repository for MySQL in a view to use PCRE functions directly in MySQL.
Too bad MySQL still cant not use functions for index creation, but this is not the theme of this post.
So, fist install MariaDB 10.0.6:
set the MariaDB 10.0.6 repo, I used the ftp mirror at ftp.ulak.net.tr
root@seik-centos-01:[Wed Dec 18 23:55:12][/tmp]$ cat …[Read more...]