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: 111
Registered: March 2008
Senior 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: 111
Registered: March 2008
Senior 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: 111
Registered: March 2008
Senior 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: 111
Registered: March 2008
Senior 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: 111
Registered: March 2008
Senior 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: 111
Registered: March 2008
Senior 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: 111
Registered: March 2008
Senior 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 messageGo to next 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.
Re: microslow patch for mysql-5.0.54 [message #3502 is a reply to message #2595 ] Fri, 05 September 2008 04:24 Go to previous message
zImage  is currently offline zImage
Messages: 1
Registered: September 2008
Junior Member
It needs just some minor tweaking. Here you are:

http://blog.lifepattern.org/wp-content/uploads/2008/09/micro slow_innodb_and_userstats-5.0.67.patch


We have nothing to fear but fear itself.
http://blog.lifepattern.org/
Previous Topic:Benchmark tool for MySQL
Next Topic:xfering data from table to table within a single databse
Goto Forum:
  



Current Time: Tue Oct 7 07:20:01 EDT 2008

Total time taken to generate the page: 0.08963 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