Are the other servers all using the same kernel version (2.4.4)? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > m] On Behalf Of Arndt Jenssen > Sent: Wednesday, December 12, 2001 2:27 PM > To: [EMAIL PROTECTED] > Subject: High load problem with 3.23.45 > > > Maybe some coding/mysql master out there knows an answer to > this tricky > problem... > > We've recently migrated all our mysql servers from 3.23.42 to > 3.23.45 without > any problems except for one server. > That linux server shows after startup of mysql after 1 or 2 > minutes an > exceptionally high load and the load will rise until the > server ends up in > nirvana (I've seen a load of 80 and more) > > Some infos on the server: > Distribution: Suse 7.2 > kernel: 2.4.4 > glibc: 2.2.2 > gcc: 2.9.53 > > We've profiled mysqld with following results (grpof): > > *********************************** > Flat profile: > > Each sample counts as 0.01 seconds. > % cumulative self self total > time seconds seconds calls us/call us/call name > 48.10 4.69 4.69 3682 1273.76 1273.76 > _nl_get_alt_digit > 23.90 7.02 2.33 getpid > 20.92 9.06 2.04 regex_compile > 4.10 9.46 0.40 708096 0.56 0.56 > __array_type_info > type_info function > 1.44 9.60 0.14 > lock_update_insert > 0.31 9.63 0.03 12 2500.00 2500.09 chk_del > 0.21 9.65 0.02 288 69.44 69.44 > find_best(JOIN *, > unsigned long, unsigned int, double, double) > 0.21 9.67 0.02 > __mktime_internal > 0.10 9.68 0.01 285302 0.04 0.04 > sort_get_next_record > 0.10 9.69 0.01 21066 0.47 0.47 _IO_vfscanf > 0.10 9.70 0.01 4106 2.44 9.73 > mysql_execute_command(void) > ******************* > As you can see most of the time is spend in the functions > _nl_get_alt_digit, > getpid and regex_compile. > > The profile log of another server running mysql 3.23.45 looks > completely > different. Most of the time on this server is spend in the > select method what > seems to be just perfect. > > Here is the profile log of the functioning server: > *********************************** > Flat profile: > > Each sample counts as 0.01 seconds. > % cumulative self self total > time seconds seconds calls us/call us/call name > 13.92 0.11 0.11 select > 11.39 0.20 0.09 1 90000.00 93333.33 buf_pool_create > 7.59 0.26 0.06 memset > 6.33 0.31 0.05 __libc_accept > 6.33 0.36 0.05 > __mcount_internal > 6.33 0.41 0.05 chunk_alloc > 6.33 0.46 0.05 vfprintf > 5.06 0.50 0.04 3363 11.89 11.89 init_io_cache > 5.06 0.54 0.04 > pthread_handle_sigrestart > 2.53 0.56 0.02 2721 7.35 7.35 > create_new_thread(THD *) > 2.53 0.58 0.02 12 1666.67 1666.67 hash_create > 2.53 0.60 0.02 1 20000.00 21666.67 > recv_apply_hashed_log_recs > 2.53 0.62 0.02 > __pthread_alt_unlock > ****************************************************** > > We've compiled mysql on both servers with following configure options: > > CFLAGS="-O3 -p -mpentiumpro" CXX=gcc CXXFLAGS="-O3 -p -mpentiumpro > -felide-constructors -fno-exceptions -fno-rtti" ./configure > --prefix=/usr/local/mysql --enable-assembler --with-debug > --with-mysqld-ldflags="-all-static -p" > --localstatedir=/usr/local/mysql/data > -with-innodb > > And both servers are running the same system and (hopefully) the same > configuration. > > Any ideas.... > > Thanks in advance for your help. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > >
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
