Mysql 4.1.18 is out with huge performance bug fix
-
- Forum User
- Posts: 11
- Joined: Fri Mar 10, 2006 4:50 pm
-
- Forum User
- Posts: 11
- Joined: Fri Mar 10, 2006 4:50 pm
-
- Forum Regular
- Posts: 119
- Joined: Mon Nov 28, 2005 4:44 pm
I could install it to my production box, it would give it 2.5 million queries a day testing.... I just hate doing that.
4.1.18 changes: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-18.html
4.1.19 upcoming changes: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-19.html
4.1.18 changes: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-18.html
4.1.19 upcoming changes: http://dev.mysql.com/doc/refman/4.1/en/news-4-1-19.html
-
- Forum User
- Posts: 13
- Joined: Sat Mar 11, 2006 2:25 pm
I would be willing to test if somebody helps me
I have a Fedora Core 3 server with Plesk 7.5.4 running on it.
I need a version >= 4.16 MySQL installation, so I am very willing to try out the new RPM from the testing channel.
Can somebody please help me and explain what I need to add to "/etc/yum.conf" to make sure that when I run "yum update mysql" I get the correct packages?
I need a version >= 4.16 MySQL installation, so I am very willing to try out the new RPM from the testing channel.
Can somebody please help me and explain what I need to add to "/etc/yum.conf" to make sure that when I run "yum update mysql" I get the correct packages?
-
- Forum User
- Posts: 13
- Joined: Sat Mar 11, 2006 2:25 pm
I am affraid you overestimated me...
I am affraid this info is not quite enough for my inexperienced soul...
Can somebody please just put the actual lines that I add to yum.conf?
And the command that I run afterwards.
Can somebody please just put the actual lines that I add to yum.conf?
And the command that I run afterwards.
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: I am affraid you overestimated me...
The same as for the normal atomic channel, just replace atomic with atomic-testing as you can see in the url I posted above. And then just run yum update mysql (or yum update if you want all testing updates). You might want to disable the testing channel afterwards if you just want to test this mysql release (add enabled=0 to your yum entry).hansdezwart wrote:I am affraid this info is not quite enough for my inexperienced soul...
Can somebody please just put the actual lines that I add to yum.conf?
If you haven't used art's mysql packages before and are installing it on a machine that already has mysql databases you will need to add 'old_passwords=1' to your [mysqld] section of /etc/my.cnf and restart mysqld.
-
- Long Time Forum Regular
- Posts: 2813
- Joined: Sat Aug 20, 2005 9:30 am
- Location: The Netherlands
Re: I would be willing to test if somebody helps me
Why do you need >= 4.16 by the way?hansdezwart wrote:I need a version >= 4.16 MySQL installation, so I am very willing to try out the new RPM from the testing channel.
-
- Forum User
- Posts: 11
- Joined: Fri Mar 10, 2006 4:50 pm
Reason I needed it is because of the following bug:
Character set conversion was not being done for FIND_IN_SET(). (Bug #13751)
http://bugs.mysql.com/bug.php?id=13751
I have a work around within my table / fields, but the other ppl using this version will know about it.
4.1.15 has this bug, while 4.1.16 fixes the bug.
Character set conversion was not being done for FIND_IN_SET(). (Bug #13751)
http://bugs.mysql.com/bug.php?id=13751
I have a work around within my table / fields, but the other ppl using this version will know about it.
4.1.15 has this bug, while 4.1.16 fixes the bug.
-
- Forum User
- Posts: 13
- Joined: Sat Mar 11, 2006 2:25 pm
Why I need a newer version of MySQL
I use my server to run Moodle (http://moodle.org). The requirement for the latest version is >= 4.16. I am not sure why, but I think it has to with the character encoding...
Thanks for the help. I will try it around 14:00 (NL time) today and will let you all know how it goes.
Thanks for the help. I will try it around 14:00 (NL time) today and will let you all know how it goes.
-
- Forum User
- Posts: 13
- Joined: Sat Mar 11, 2006 2:25 pm
It is working!!
Well I have just managed to it working on my Plesk 7.5.4 server. I do not see any immediate problems. I will let you all know when I do...