Home » Performance » MySQL » microslow patch for mysql-5.0.54
microslow patch for mysql-5.0.54 [message #2595] Wed, 06 February 2008 01:47 Go to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
Hi,

When will come new microslow patch for mysql-5.0.54?
Re: microslow patch for mysql-5.0.54 [message #2817 is a reply to message #2595 ] Mon, 31 March 2008 04:38 Go to previous messageGo to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
Please answer - when?

And why already didn't released?
Re: microslow patch for mysql-5.0.54 [message #2823 is a reply to message #2595 ] Tue, 01 April 2008 06:41 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 99
Registered: March 2008
Member

You can find it here: http://www.mysqlperformanceblog.com/files/patches/patch-mysq l-5.0.54a-msl.diff


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: microslow patch for mysql-5.0.54 [message #2824 is a reply to message #2823 ] Tue, 01 April 2008 10:19 Go to previous messageGo to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
hmm...

I'm found source distribution for mysql-5.0.56 and patching failed on his:

$ patch -p1 < /home/umask/patch-mysql-5.0.54a-msl.diff
patching file include/my_time.h
patching file scripts/mysqldumpslow.sh
patching file sql-common/my_time.c
patching file sql/filesort.cc
Hunk #1 succeeded at 173 (offset 1 line).
Hunk #2 FAILED at 240.
Hunk #3 succeeded at 1072 (offset 8 lines).
1 out of 3 hunks FAILED -- saving rejects to file sql/filesort.cc.rej
patching file sql/log.cc
Hunk #1 succeeded at 2076 (offset 42 lines).
Hunk #2 succeeded at 2091 (offset 42 lines).
Hunk #3 succeeded at 2109 (offset 42 lines).
Hunk #4 succeeded at 2122 (offset 42 lines).
patching file sql/log_event.cc
patching file sql/my_time.c
patching file sql/mysql_priv.h
patching file sql/mysqld.cc
patching file sql/set_var.cc
Hunk #1 succeeded at 215 (offset -1 lines).
Hunk #2 succeeded at 281 (offset -1 lines).
Hunk #3 succeeded at 326 (offset -1 lines).
Hunk #4 succeeded at 682 (offset -1 lines).
Hunk #5 succeeded at 708 (offset -1 lines).
Hunk #6 succeeded at 739 (offset -1 lines).
Hunk #7 succeeded at 975 (offset -1 lines).
Hunk #8 succeeded at 1005 (offset -1 lines).
Hunk #9 succeeded at 1058 (offset -1 lines).
Hunk #10 succeeded at 1655 (offset 7 lines).
Hunk #11 succeeded at 3550 (offset 13 lines).
patching file sql/set_var.h
patching file sql/slave.cc
patching file sql/sql_cache.cc
patching file sql/sql_class.cc
Hunk #2 succeeded at 2190 (offset 1 line).
Hunk #3 succeeded at 2212 (offset 1 line).
Hunk #4 succeeded at 2271 (offset 1 line).
patching file sql/sql_class.h
patching file sql/sql_parse.cc
Hunk #3 succeeded at 2279 (offset 67 lines).
Hunk #4 succeeded at 5976 (offset 60 lines).
patching file sql/sql_select.cc
Hunk #1 succeeded at 6218 (offset 1 line).
Hunk #2 succeeded at 6237 (offset 1 line).
Hunk #3 succeeded at 9285 (offset 3 lines).
Hunk #4 succeeded at 10146 (offset 3 lines).
patching file sql/sql_show.cc
patching file sql/structs.h
Re: microslow patch for mysql-5.0.54 [message #2825 is a reply to message #2824 ] Tue, 01 April 2008 21:54 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 99
Registered: March 2008
Member

Ilys,

Well, it's possible, as you are trying to patch mysql 5.0.56 using patch for 5.0.54a..


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: microslow patch for mysql-5.0.54 [message #2826 is a reply to message #2825 ] Wed, 02 April 2008 00:55 Go to previous messageGo to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
> Well, it's possible, as you are trying to patch mysql 5.0.56 using patch for 5.0.54a..

Sad yes.

Can you explain microslow patch release policy?
Re: microslow patch for mysql-5.0.54 [message #2827 is a reply to message #2826 ] Wed, 02 April 2008 01:07 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 99
Registered: March 2008
Member

Hmm, there is no special release policy, we just create patches when we need them, or when someone requests Smile
I will try to get patch for 5.0.56 tomorrow.


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: microslow patch for mysql-5.0.54 [message #2836 is a reply to message #2595 ] Thu, 03 April 2008 06:21 Go to previous messageGo to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
How your progress in writing a patch?
Re: microslow patch for mysql-5.0.54 [message #2837 is a reply to message #2595 ] Thu, 03 April 2008 10:48 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 99
Registered: March 2008
Member

http://www.mysqlperformanceblog.com/files/patches/patch-mysq l-5.0.56-msl.diff


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: microslow patch for mysql-5.0.54 [message #3059 is a reply to message #2837 ] Fri, 09 May 2008 15:17 Go to previous messageGo to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
what about 5.0.60?


$ patch -p1 < /usr/src/redhat/SOURCES/patch.slow-micro.mysql-5.0.56-msl.di ff
patching file include/my_time.h
patching file scripts/mysqldumpslow.sh
patching file sql-common/my_time.c
patching file sql/filesort.cc
Hunk #1 succeeded at 180 (offset 7 lines).
Hunk #2 succeeded at 239 (offset -1 lines).
Hunk #3 succeeded at 1079 (offset 7 lines).
patching file sql/log.cc
Hunk #1 succeeded at 2177 (offset 101 lines).
Hunk #3 succeeded at 2210 (offset 101 lines).
patching file sql/log_event.cc
Hunk #1 succeeded at 2039 (offset 1 line).
patching file sql/my_time.c
patching file sql/mysql_priv.h
Hunk #1 succeeded at 484 (offset 1 line).
Hunk #2 succeeded at 1384 (offset 8 lines).
patching file sql/mysqld.cc
Hunk #1 succeeded at 176 (offset 7 lines).
Hunk #2 succeeded at 495 with fuzz 2 (offset 269 lines).
Hunk #3 FAILED at 667.
Hunk #4 succeeded at 3381 (offset -141 lines).
Hunk #5 succeeded at 5036 (offset 264 lines).
Hunk #6 succeeded at 4722 (offset -141 lines).
Hunk #7 succeeded at 5518 (offset 264 lines).
Hunk #8 succeeded at 5782 (offset -141 lines).
Hunk #9 succeeded at 6975 (offset 264 lines).
Hunk #10 succeeded at 7033 (offset -141 lines).
Hunk #11 succeeded at 7779 (offset 264 lines).
1 out of 11 hunks FAILED -- saving rejects to file sql/mysqld.cc.rej
patching file sql/set_var.cc
patching file sql/set_var.h
patching file sql/slave.cc
Hunk #1 succeeded at 2925 (offset 17 lines).
patching file sql/sql_cache.cc
patching file sql/sql_class.cc
Hunk #2 succeeded at 2197 (offset 7 lines).
Hunk #4 succeeded at 2278 (offset 7 lines).
patching file sql/sql_class.h
patching file sql/sql_parse.cc
Hunk #2 succeeded at 1181 (offset -14 lines).
patching file sql/sql_select.cc
Hunk #1 succeeded at 6196 (offset -22 lines).
Hunk #3 succeeded at 9263 (offset -22 lines).
patching file sql/sql_show.cc
patching file sql/structs.h
Re: microslow patch for mysql-5.0.54 [message #3065 is a reply to message #3059 ] Mon, 12 May 2008 03:42 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 99
Registered: March 2008
Member

I'll let you know when 5.0.60 microslow patch will be released.


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: microslow patch for mysql-5.0.54 [message #3101 is a reply to message #3065 ] Tue, 20 May 2008 00:56 Go to previous messageGo to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
> I'll let you know when 5.0.60 microslow patch will be released.

When? Smile
Re: microslow patch for mysql-5.0.54 [message #3105 is a reply to message #3101 ] Tue, 20 May 2008 11:52 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 99
Registered: March 2008
Member

Most probably it will be done by the end of this or next week.


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: microslow patch for mysql-5.0.54 [message #3190 is a reply to message #3105 ] Tue, 17 June 2008 15:24 Go to previous messageGo to next message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
we still wait! Smile

I have yum repo for many users and i can't update mysql upto 5.0.60 without microslow patch.
Re: microslow patch for mysql-5.0.54 [message #3197 is a reply to message #3190 ] Wed, 18 June 2008 07:18 Go to previous messageGo to next message
debug  is currently offline debug
Messages: 99
Registered: March 2008
Member

It's here

[Updated on: Wed, 18 June 2008 07:21]


Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting
Re: microslow patch for mysql-5.0.54 [message #3445 is a reply to message #2595 ] Mon, 18 August 2008 02:21 Go to previous message
ilys  is currently offline ilys
Messages: 11
Registered: December 2007
Junior Member
Hi!

What about patch for mysql-5.0.67 (official community release)?

patch -p1 < /usr/src/redhat/SOURCES/patch-mysql-5.0.60-msl+innodb.diff
patching file include/my_time.h
patching file innobase/buf/buf0buf.c
patching file innobase/buf/buf0rea.c
patching file innobase/fil/fil0fil.c
patching file innobase/include/buf0rea.h
patching file innobase/include/fil0fil.h
patching file innobase/include/os0file.h
patching file innobase/include/thr0loc.h
patching file innobase/include/trx0trx.h
patching file innobase/lock/lock0lock.c
patching file innobase/os/os0file.c
patching file innobase/srv/srv0srv.c
patching file innobase/thr/thr0loc.c
patching file innobase/trx/trx0trx.c
patching file scripts/mysqldumpslow.sh
patching file sql/filesort.cc
patching file sql/ha_innodb.cc
patching file sql/log.cc
patching file sql/log_event.cc
patching file sql/mysqld.cc
Hunk #2 succeeded at 408 (offset 3 lines).
Hunk #4 succeeded at 3653 (offset 3 lines).
Hunk #6 succeeded at 4989 with fuzz 2 (offset 3 lines).
Hunk #7 succeeded at 5384 (offset 6 lines).
Hunk #8 succeeded at 6055 (offset 9 lines).
Hunk #9 succeeded at 6845 (offset 11 lines).
Hunk #10 succeeded at 7306 (offset 9 lines).
Hunk #11 succeeded at 7658 (offset 19 lines).
patching file sql/mysql_priv.h
Hunk #1 succeeded at 489 (offset 4 lines).
Hunk #2 succeeded at 1420 (offset 16 lines).
patching file sql/my_time.c
patching file sql/set_var.cc
Hunk #4 succeeded at 697 (offset 6 lines).
Hunk #6 succeeded at 993 (offset 10 lines).
Hunk #8 succeeded at 1081 (offset 15 lines).
Hunk #10 succeeded at 3573 (offset 15 lines).
patching file sql/set_var.h
patching file sql/slave.cc
patching file sql/sql_cache.cc
Hunk #1 succeeded at 1341 (offset 7 lines).
patching file sql/sql_class.cc
Hunk #1 succeeded at 188 (offset 14 lines).
Hunk #2 succeeded at 2200 (offset 3 lines).
Hunk #3 succeeded at 2233 (offset 14 lines).
Hunk #4 succeeded at 2281 (offset 3 lines).
patching file sql/sql_class.h
Hunk #4 succeeded at 550 with fuzz 2 (offset 1 line).
Hunk #6 succeeded at 1185 (offset 1 line).
Hunk #7 succeeded at 1297 (offset 3 lines).
Hunk #8 succeeded at 1704 (offset 5 lines).
patching file sql/sql_parse.cc
Hunk #3 FAILED at 2265.
Hunk #4 succeeded at 6031 (offset 55 lines).
1 out of 4 hunks FAILED -- saving rejects to file sql/sql_parse.cc.rej
patching file sql/sql_select.cc
Hunk #1 succeeded at 6210 (offset 14 lines).
Hunk #3 succeeded at 9277 (offset 14 lines).
patching file sql/sql_show.cc
patching file sql/structs.h
patching file sql-common/my_time.c
-bash-3.2$ echo $?
1


On 5.0.66a (and on 5.0.66, 5.0.64, 5.0.62) patch has applied correctly.
Previous Topic:My MySQL datafile seems to growing alarmingly
Next Topic:Disaster Recovery/Hot Site
Goto Forum:
  



Current Time: Thu Aug 21 20:04:01 EDT 2008

Total time taken to generate the page: 0.04716 seconds
.:: Contact :: Home :: MySQL Support by Percona.com ::.

Powered by: FUDforum 2.7.5.
Copyright ©2001-2006 FUD Forum Bulletin Board Software

MySQL Performance | Forum authority Badge