On Sat, 2006-04-29 at 08:18 +0100, Qian Qiao wrote: > That's exactly the reason we still use mysql 4.0 in our production > environment. > > The mysql charset thingy is basically a whole load of mess. > > A brief search on mysql's bug database shows some of the encoding bugs > and unicode key length not correctly calculated are still not properly > fixed yet they pushed their production version to 5.0. > > We might be switching to postgres, at least it supports views, > triggers and handles encoding properly. The only thing preventing us > from doing so is that we use Mantisbt, which only works with mysql.
Are you sure it is not an Gentoo thing? I noticed this as well. Gentoo has utf8 in /etc/mysql/my.cnf. I personally don't need/want utf8. Some things I noticed with the Gentoo mysql install. MySQL sucks up a bunch of memory just sitting there. Looking in my.cnf the Gentoo defaults are pretty big. Lowering all the values got mysql down from 100+ MB to about 30MB. Why is it using utf8? Does mysql 5.x require that? Couldn't the Gentoo ebuild make it an option? When I tried to replace the Gentoo my.cnf with the example my-small.cnf, things wouldn't work. Maybe have the ebuild configure the three example files so that they all work and then a user can just symlink to the one they want? I am not running a production MySQL at home, just a development MySQL so I want it to have the smallest memory footprint possible. I would like to stay with MySQL 5.x for the new features. Switching to PostgreSQL doesn't really seem like an option (yet). A lot of the open source apps out there only target MySQL. This is especially true with PHP 4.x apps since PHP Data Objects (PDO) was not available and PHP 4.x required a slow DB wrapper class/script to target multiple databases and a lot of code duplications with mysql_*(), PGSQL_*(), etc. Once/If all those great PHP-based apps get ported to PHP 5.x and PDO, then PostgreSQL would be a true option. Have you tried to just download the MySQL binary and install it in /opt and see how that works? I might give that a go. Jim =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= There's no place like 127.0.0.1 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JimD Central FL, USA, Earth, Sol -- [email protected] mailing list
