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