List:General Discussion« Previous MessageNext Message »
From:philip Date:January 28 2008 2:16pm
Subject:Embedded versus 'normal' MySQL
View as plain text  
Hello,

I am using MySQL in a booking system I am working on. I decided to use an
embedded server so downloaded 5.0.45 from source and compiled it with the
embedded library enabled. 

It works fine except that disconnecting seems to take an exceptionally
long time. Relevant lines from the log file are,

	connect_to_server()
	User    50mS, System    50mS, Real   100mS
	...
	process_statement()
	User     0mS, System     0mS, Real    20mS
	...
	disconnect_from_server()
	User    40mS, System     0mS, Real  2290mS

The disconnect_from_server() function calls mysql_close_connection() and
mysql_library_end().

Using the mysql command with a server daemon the 'quit;' command seems to
execute immediately. 

(The platform is a SUN Ultra 45 running Solaris 10 and gcc version 3.4.6)

So a couple of questions,

Is a long disconnect time from an embedded server to be expected or am I 
doing something wrong ?

I decided not to use a server daemon since I didn't want to risk it not
being available when my program ran. Is this too pessimistic a view of
server availability, under what circumstances would a running server
become unavailable (ie. crash or refuse connections) ? 

TTFN,

   Philip Riebold, p.riebold@stripped
Thread
left join in version 5.0.45Malki.Cymbalista28 Jan
  • Re: left join in version 5.0.45Baron Schwartz28 Jan
  • Embedded versus 'normal' MySQLphilip28 Jan
  • Re: left join in version 5.0.45Peter Brawley28 Jan