MySQL slowness in SMP
Hello, I have dual xeon server with 2 GB of ram. FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386 Which runs heavily MySQL with MyISAM, the problem I have it maxes out one cpu, and doesn't use the other one. Could someone tell me what shall I do to make MySQL runs faster? it already uses libthr, cache beside MySQL optimized, I would like to use the power of both cpus. last pid: 79040; load averages: 1.00, 1.01, 1.00 up 16+16:54:20 08:04:55 39 processes: 2 running, 37 sleeping CPU states: 26.9% user, 0.0% nice, 23.3% system, 0.0% interrupt, 49.8% idle Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K Free Swap: 5120M Total, 16K Used, 5120M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld Is upgrading to FreeBSD 7.0 current and using ULE would make MySQL runs in this dual xeon box? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
On 5/11/07, Martin Blapp [EMAIL PROTECTED] wrote: Hi, It depends on the threading library you use. Can you please show us the output of ldd /usr/local/libexec/mysqld ? You should use libthr instead of libpthread or libc_r in /etc/libmap.conf for mysqld. -- Martin Martin Blapp, [EMAIL PROTECTED] [EMAIL PROTECTED] -- ImproWare AG, UNIXSP ISP, Zurlindenstrasse 29, 4133 Pratteln, CH Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 PGP: finger -l [EMAIL PROTECTED] PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E -- Here we go. ldd /usr/local/libexec/mysqld /usr/local/libexec/mysqld: libz.so.3 = /lib/libz.so.3 (0x28498000) libwrap.so.4 = /usr/lib/libwrap.so.4 (0x284a9000) libcrypt.so.3 = /lib/libcrypt.so.3 (0x284b) libstdc++.so.5 = /usr/lib/libstdc++.so.5 (0x284c9000) libm.so.4 = /lib/libm.so.4 (0x28598000) libpthread.so.2 = /usr/lib/libthr.so.2 (0x285ae000) libc.so.6 = /lib/libc.so.6 (0x285c1000) and here is the libmap.conf [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Hi, So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster or it's not optimized for dual cpu yet? Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because some bottlenecks (unix domain sockets etc, old malloc) have been removed. -- Martin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Hi, Ohh, I overread that you already use libthr. But ... 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld It looks like you did not turn on 'showing threads' in top, else you would have seen that many mysqld's are running on cpu 0, other on cpu 1. -- Martin /usr/local/libexec/mysqld: libz.so.3 = /lib/libz.so.3 (0x28498000) libwrap.so.4 = /usr/lib/libwrap.so.4 (0x284a9000) libcrypt.so.3 = /lib/libcrypt.so.3 (0x284b) libstdc++.so.5 = /usr/lib/libstdc++.so.5 (0x284c9000) libm.so.4 = /lib/libm.so.4 (0x28598000) libpthread.so.2 = /usr/lib/libthr.so.2 (0x285ae000) libc.so.6 = /lib/libc.so.6 (0x285c1000) and here is the libmap.conf [/usr/local/libexec/mysqld] libpthread.so.2 libthr.so.2 libpthread.so libthr.so -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
On 5/11/07, Martin Blapp [EMAIL PROTECTED] wrote: Hi, Ohh, I overread that you already use libthr. But ... 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld It looks like you did not turn on 'showing threads' in top, else you would have seen that many mysqld's are running on cpu 0, other on cpu 1. -- Martin So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster or it's not optimized for dual cpu yet? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Hi, It depends on the threading library you use. Can you please show us the output of ldd /usr/local/libexec/mysqld ? You should use libthr instead of libpthread or libc_r in /etc/libmap.conf for mysqld. -- Martin Martin Blapp, [EMAIL PROTECTED] [EMAIL PROTECTED] -- ImproWare AG, UNIXSP ISP, Zurlindenstrasse 29, 4133 Pratteln, CH Phone: +41 61 826 93 00 Fax: +41 61 826 93 01 PGP: finger -l [EMAIL PROTECTED] PGP Fingerprint: B434 53FC C87C FE7B 0A18 B84C 8686 EF22 D300 551E -- On Fri, 11 May 2007, Abdullah Ibn Hamad Al-Marri wrote: Hello, I have dual xeon server with 2 GB of ram. FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386 Which runs heavily MySQL with MyISAM, the problem I have it maxes out one cpu, and doesn't use the other one. Could someone tell me what shall I do to make MySQL runs faster? it already uses libthr, cache beside MySQL optimized, I would like to use the power of both cpus. last pid: 79040; load averages: 1.00, 1.01, 1.00 up 16+16:54:20 08:04:55 39 processes: 2 running, 37 sleeping CPU states: 26.9% user, 0.0% nice, 23.3% system, 0.0% interrupt, 49.8% idle Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K Free Swap: 5120M Total, 16K Used, 5120M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld Is upgrading to FreeBSD 7.0 current and using ULE would make MySQL runs in this dual xeon box? -- Regards, -Abdullah Ibn Hamad Al-Marri Arab Portal http://www.WeArab.Net/ ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-current To unsubscribe, send any mail to [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: MySQL slowness in SMP
Martin Blapp wrote: So would upgrading to FreeBSD 7.0-CURRENT would make MySQL runs faster or it's not optimized for dual cpu yet? Of course would upgrading to FreeBSD 7.0-CURRENT make it faster because some bottlenecks (unix domain sockets etc, old malloc) have been removed. On the other hand, if it's an important database in production, you probably don't want to run -CURRENT on the machine. signature.asc Description: OpenPGP digital signature
Re: MySQL slowness in SMP
On Fri, 2007-05-11 at 11:07 +0300, Abdullah Ibn Hamad Al-Marri wrote: Hello, Hi! I had the same problem, but i found this blog entry from Jeremy Zawodny: http://jeremy.zawodny.com/blog/archives/000173.html After i adjusted the wait_timeout and thread_cache_size, the problem is gone. CPU utilization dropped significantly. HTH I have dual xeon server with 2 GB of ram. FreeBSD 6.2-STABLE #0: Tue Apr 24 11:32:50 GMT 2007 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/NOC i386 Which runs heavily MySQL with MyISAM, the problem I have it maxes out one cpu, and doesn't use the other one. Could someone tell me what shall I do to make MySQL runs faster? it already uses libthr, cache beside MySQL optimized, I would like to use the power of both cpus. last pid: 79040; load averages: 1.00, 1.01, 1.00 up 16+16:54:20 08:04:55 39 processes: 2 running, 37 sleeping CPU states: 26.9% user, 0.0% nice, 23.3% system, 0.0% interrupt, 49.8% idle Mem: 556M Active, 1154M Inact, 198M Wired, 93M Cache, 112M Buf, 3072K Free Swap: 5120M Total, 16K Used, 5120M Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 90293 mysql19 1000 434M 187M ucond 1 176.6H 95.95% mysqld -- Micskó Gábor HP APS, AIS, ASE Szintézis Zrt. H-9023 Győr, Tihanyi Á. u. 2. Tel: +36 96 502 216 Fax: +36 96 318 658 E-mail: [EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]