Gelu, ----- Original Message ----- From: "Gelu Gogancea" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Puiu Hrenciuc" <[EMAIL PROTECTED]>; "Philip Molter" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 03, 2002 7:48 PM Subject: Re: MySQL/InnoDB-4.0.4 is released
> Hi Heikki and all friends, > You quite right.If OS_THREAD_MAX_N is 100 or 1000 all it's ok and svr_init() > works well. thank you! Next week Lenz will start building 3.23.53 where I have reduced the number to 1000. With good luck 3.23.53 will be released around October 17, 2002. > Regards, > > Gelu Regards, Heikki Innobase Oy _____________________________________________________ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL PROTECTED] > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: "Gelu Gogancea" <[EMAIL PROTECTED]>; "Puiu Hrenciuc" <[EMAIL PROTECTED]>; > "Philip Molter" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, October 03, 2002 5:07 PM > Subject: Re: MySQL/InnoDB-4.0.4 is released > > > > Gelu, > > > > ----- Original Message ----- > > From: "Gelu Gogancea" <[EMAIL PROTECTED]> > > To: "Puiu Hrenciuc" <[EMAIL PROTECTED]>; "Heikki Tuuri" > > <[EMAIL PROTECTED]>; "Philip Molter" <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Thursday, October 03, 2002 2:40 PM > > Subject: Re: MySQL/InnoDB-4.0.4 is released > > > > > > > Hi, > > > You have right, in the new version (4.0.4) on Windows 9x are the same > > > symptom. > > > I research a little in this morning and i found where is the problem > when > > > the innodb is initialised. > > > The problems is in the function: > > > sync_array_create() > > > ...when it must initialise a lot of "cells"(n_cells=aprox. 6.000.000). > > > > that number is strange. It should be 10 000. Maybe you have compiled with > > optimizations so that the debugger shows a wrong number. > > > > But this reveals a possible reason for the slowness and other problems in > > Win 95/98/ME. > > > > Can you try the following: in > > > > \mysql\innobase\include\os0thread.h > > > > change > > > > #define OS_THREAD_MAX_N 10000 > > > > to a smaller value, for example, 100. > > > > It may be that Win 95/98/ME has problems in creating a large number of > event > > semaphores. > > > > You have to recompile the 'innobase' project because the change is in a > > header. > > > > Please report if this helps. > > > > Regards, > > > > Heikki > > Innobase Oy > > > > sql query > > > > > > > > > The routine is next : > > > > > > for (i = 0; i < n_cells; i++) { > > > cell = sync_array_get_nth_cell(arr, i); > > > cell->wait_object = NULL; > > > > > > /* Create an operating system event semaphore with no > name > > > */ > > > cell->event = os_event_create(NULL); > > > cell->event_set = FALSE; /* it is created in reset state */ > > > } > > > > > > The configuration of my computer for testing is: > > > CPU : INTEL P IV/1,7 Ghz > > > RAM: 512 MB DDRAM > > > HDD: 2x40 GB(IDE) > > > OS:Windows 98 OSR2 > > > > > > Maybe this help on Heikki to see what happend. > > > > > > Regards, > > > > > > Gelu > > > _____________________________________________________ > > > G.NET SOFTWARE COMPANY > > > > > > Permanent e-mail address : [EMAIL PROTECTED] > > > [EMAIL PROTECTED] > > > ----- Original Message ----- > > > From: "Puiu Hrenciuc" <[EMAIL PROTECTED]> > > > To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Philip Molter" > > > <[EMAIL PROTECTED]> > > > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > Sent: Thursday, October 03, 2002 12:46 AM > > > Subject: Re: MySQL/InnoDB-4.0.4 is released > > > > > > > > > > I hoped that you will solve the MySQL consuming all computer's > > > > resources in 4.0.4, but nope, the problem is still there. I'm trying > > > > to run MySQL on Win ME and when started normally it consumes > > > > all resources of my computer. When I start it with --skip-innodb > > > > it works just fine. Why ? > > > > At least I saw you fixed WinMySQLAdmin. > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > > > > To: "Philip Molter" <[EMAIL PROTECTED]> > > > > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > > > Sent: Wednesday, October 02, 2002 5:48 PM > > > > Subject: Re: MySQL/InnoDB-4.0.4 is released > > > > > > > > > > > > > Philip, > > > > > > > > > > ----- Original Message ----- > > > > > From: "Philip Molter" <[EMAIL PROTECTED]> > > > > > To: "Heikki Tuuri" <[EMAIL PROTECTED]> > > > > > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > > > > > Sent: Wednesday, October 02, 2002 4:16 PM > > > > > Subject: Re: MySQL/InnoDB-4.0.4 is released > > > > > > > > > > > > > > > > On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote: > > > > > > : Hi! > > > > > > : > > > > > > : InnoDB is a table type which provides transactions, row level > > > locking, > > > > > > : foreign key constraints, and a non-free hot backup tool to > MySQL. > > > > > > : > > > > > > : InnoDB is included in both downloadable versions of MySQL-4.0: > > > > MySQL-Pro > > > > > and > > > > > > : MySQL-Max. > > > > > > : > > > > > > : Release 4.0.4-beta is mainly a bug fix release. > > > > > > > > > > > > Will the bugfixes for this release (not necessarily the > new/updated > > > > > > features) be backported to the 3.23.x series? Given that MySQL 4 > > > > > > isn't marked as stable yet, many of us using InnoDB no doubt still > > > > > > use 3.23.x. > > > > > > > > > > of course, the fix will be backported if the bug also existed in > 3.23. > > > > > > > > > > The DESC bugs in 4.0.x are not present in 3.23. > > > > > > > > > > Since 4.0.x releases will come in more rapid succession than 3.23 > > > > releases, > > > > > it may soon be that the most bug-free InnoDB is actually in the > latest > > > > > 4.0.x. > > > > > > > > > > > * Philip Molter > > > > > > * Texas.net Internet > > > > > > * http://www.texas.net/ > > > > > > * [EMAIL PROTECTED] > > > > > > > > > > Regards, > > > > > > > > > > Heikki > > > > > Innobase Oy > > > > > > > > > > sql query > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" > > > before > > > > > posting. To request this thread, e-mail > > [EMAIL PROTECTED] > > > > > > > > > > To unsubscribe, send a message to the address shown in the > > > > > List-Unsubscribe header of this message. If you cannot see it, > > > > > e-mail [EMAIL PROTECTED] instead. > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > 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 > > > > > --------------------------------------------------------------------- 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