Re: Embedded MySQL
On Friday 23 June 2006 06:18 am, Asif Lodhi wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? I don't see a binary version avaliable, but I know the following configure option exists: --with-embedded-server Build the embedded server (libmysqld). -- I'm assuming this is what you want -- TIA, Asif -- Chris White PHP Programmer/DB Jaguar Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded MySQL
Hi, I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Asif Lodhi [EMAIL PROTECTED] wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- TIA, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Re: Embedded MySQL
I am sorry, this in case if your programming in java. Melvin Zamora [EMAIL PROTECTED] wrote: Hi, I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Asif Lodhi wrote: Hi All, Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- TIA, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com - Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail Beta.
Re: Embedded MySQL
Hi Chris and Melvin, Thanks a lot for the quick responses. I have found it. Actually, it comes bundled with the main distribution. The documentation is in the main reference manual and the header can be found in the include directory. -- Thanks again. Asif I don't see a binary version avaliable, but I know the following configure option exists: --with-embedded-server Build the embedded server (libmysqld). -- I'm assuming this is what you want .. I haven't tried this one, but I think this might help http://mysql-je.sourceforge.net Can some kind soul tell me from where I can download the Embedded Library version of MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded MySQL for Symbian ?
that looks like a good idea, and im hoping it will be much faster. but, how can it ran on a symbian platform? On 6/15/05, AJIT SADASIVAN [EMAIL PROTECTED] wrote: Hi, I am new to this group...Just wanted to findout whether Embedded MySQL library is available for Symbian ( Series 60 platform).Any effort going on in this direction..? Any idea about the rough memory footprint.. With Regards Ajit.S __ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Louie Miranda http://www.axishift.com -- under development
Re: Embedded MySQL for Symbian ?
I mean, much faster to other db that are currently on the symbian platform. On 6/15/05, Louie Miranda [EMAIL PROTECTED] wrote: that looks like a good idea, and im hoping it will be much faster. but, how can it ran on a symbian platform? On 6/15/05, AJIT SADASIVAN [EMAIL PROTECTED] wrote: Hi, I am new to this group...Just wanted to findout whether Embedded MySQL library is available for Symbian ( Series 60 platform).Any effort going on in this direction..? Any idea about the rough memory footprint.. With Regards Ajit.S __ Discover Yahoo! Use Yahoo! to plan a weekend, have fun online and more. Check it out! http://discover.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Louie Miranda http://www.axishift.com -- under development -- Louie Miranda http://www.axishift.com -- under development
Re: Embedded mysql for simple user programs
At 09:14 AM 11/4/2004, you wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. To use the libmysqld.dll you need to create a section in the my.ini or my.cnf file that looks like: [MyEmbeddedProgram.exe] basedir=U:\MySQL datadir=U:\MySQL_Data tmpdir=f:\mysql_tmp where MyEmbeddedProgram.exe is the name of your program. But this could be expensive. If you distribute your application to others, whether for profit or for free, you will need a license for each copy (about $500). If all you're doing is creating address books or other tables with a few hundred rows in it, then MySQL is overkill. There are plenty of other databases out there that have a zero footprint and no install is necessary. I can suggest some for Windows that work great. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
Hi. You may tell MySQL where the data files are stored in the argc, when you are calling mysql_server_init. Also you may put other server variables into this array. I think, MySQL can do most tasks, which you are looking for. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html txemi [EMAIL PROTECTED] wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
Aha, what solution would you recommend? I would like some open and free product working in linux and win, easy to interact with other products and some relation among tables capabilitie (foreign index, constraint...). I focused on sqlite because It seem to match this requirements and it is already available on most linux distros. I did not know you had to pay for mysql, I thought they made money from services. El jue, 04-11-2004 a las 09:43 -0600, mos escribió: At 09:14 AM 11/4/2004, you wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. To use the libmysqld.dll you need to create a section in the my.ini or my.cnf file that looks like: [MyEmbeddedProgram.exe] basedir=U:\MySQL datadir=U:\MySQL_Data tmpdir=f:\mysql_tmp where MyEmbeddedProgram.exe is the name of your program. But this could be expensive. If you distribute your application to others, whether for profit or for free, you will need a license for each copy (about $500). If all you're doing is creating address books or other tables with a few hundred rows in it, then MySQL is overkill. There are plenty of other databases out there that have a zero footprint and no install is necessary. I can suggest some for Windows that work great. Mike -- __ hola, soy una firma horrible -- \ ^__^ \ (oo)\___ (__)\ )\/\ ||w | || || email: [EMAIL PROTECTED] web: http://txemi.webhop.org web2: http://txemi2.webhop.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded mysql for simple user programs
Thanks, I did have a look at it and it seems that I could use embedded mysql with no conffiles at all. :-) I like it becouse I would prefer application configuring mysql based on its own config or status and not having spread conffiles for each used library. Besides, various applications using this library and editing some mysql conffile at user home (/home/user/.my.cnf) could finish in a mess. El jue, 04-11-2004 a las 17:51 +0200, Gleb Paharenko escribió: Hi. You may tell MySQL where the data files are stored in the argc, when you are calling mysql_server_init. Also you may put other server variables into this array. I think, MySQL can do most tasks, which you are looking for. See: http://dev.mysql.com/doc/mysql/en/Server_system_variables.html txemi [EMAIL PROTECTED] wrote: I cannot see in mysql online manual Embedded example (http://dev.mysql.com/doc/mysql/en/libmysqld_example.html) any pathname telling where de database will be saved in disk. So I suppose it must be some existing database especified on some configuration file. Could be embebbed mysql be a replacement to sqlite for programs that just want to create some database in some specified file with no configuration if possible? I was thinking of embebbed mysql as a way for user unprivileged desktop programs creating databases at user's home. The apps I was thinking of were personal databases, addressbooks and so. For being embebbed and created on a personal file or dir they would be easy to create, update and remove. Besides, for using mysql backend it would be powerful (lot of features as foreing indexes and constraints and complex sql commands) and I suppose easy to export data for latter use in other mysql databases and so if neccesary. So I could thank any opinion on this to help me know if embedded mysql could fit my needs or I would better use a simpler solution as sqlite. The things I would try to avoid: - An unprivileged desktop user needing to edit system config. - Needing to edit config files. Better to set up everything inside the application. - Being able to create, edit and remove database from application. No need for extra config. thanks, txemi. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- __ hola, soy una firma horrible -- \ ^__^ \ (oo)\___ (__)\ )\/\ ||w | || || email: [EMAIL PROTECTED] web: http://txemi.webhop.org web2: http://txemi2.webhop.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Embedded MySQL?
Hi. On Thu 2003-03-20 at 08:25:08 +0200, [EMAIL PROTECTED] wrote: Hi, I have a question I hope you can help me with. I try to develop a database in Borlands Delphi or with C++ and Visual Studio 6 (Windows 2000). Probably I choose Delphi. Now I want to use MySQL as a platform for my program. According to http://www.mysql.com/doc/en/libmysqld_overview.html I can run a standalone server in my program. Now I wonder how this works in practise? Ideally I want to call an API in a dll-file to create and maintain the database. http://www.mysql.com/doc/en/libmysqld.html should answer most of your concern. Basically it boils down to an additional call to mysql_server_init() and mysql_server_end() and compiling with libmysqld instead of libmysqlclient. The rest is the same with the client library. HTH, Benjamin. -- [EMAIL PROTECTED] - 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
Re: embedded mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 mahesh rai wrote: Hi, we are developing an application in java that needs to have an embedded database so that we needn't install the database on the client machine. Is it possible to achieve this using mysql. I read that mysql 4.0 supports embedded database, but I find that embedded MySQL server library is only for C developers. please help thanks rai It is not currently planned to support 'libmysqld' from Java via the JDBC driver, as it is not technically feasible at this point in time due to threading and data conversion issues. This doesn't mean that you can't 'embed' MySQL through Java, though. There are plenty of users who do this by controlling the regular 'mysqld' through Runtime.exec() calls. 'mysqld' has enough command-line options that make it fully configurable, and controllable using plain command-line calls through Runtime.exec(). Connector/J 3.1.x will ship with utility classes to help with this (they are already included in the nightly snapshots from http://mmmysql.sourceforge.net/snapshots/dev/) -Mark - -- MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/ For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+Yr8ktvXNTca6JD8RAhD9AJ9YTFw19RTXwZa2xnvku4RvpQj5hgCdHT/W /fZrYX1vcn8z/ONCkaU6qv0= =URTk -END PGP SIGNATURE- - 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
Re: Embedded MySQL
On Fri, Sep 27, 2002 at 01:37:24PM +0930, David Lloyd wrote: What's the advantages of using Embedded MySQL instead of, say, Berkely's DB? Well, the SQL interface is probably the biggest advantage. There is no query language for Berkely DB, so ad-hoc queries are time-consuming to code. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 51 days, processed 1,092,381,257 queries (243/sec. avg) - 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
Re: Embedded MySQL server crashing
Sorry for the ambiguity. My application is a gui application written in Borland C++ Builder 6. It features one form with 4 buttons consisting of Create, Connect, Disconnect, Destroy. Only the relevant buttons are availible at certain times. (For instance, you cannot destroy a server when one is not created, therefore you have to click create in order to hit destroy). The purpose of the Create button is to call mysql_server_init, which creates the mysqld embedded server. After which you hit connect to connect to the created server, and then you can disconnect and destroy the server with their respective buttons. I can click the following button and have it crash: o Create button o Destroy button o Create button again o Destroy button --(Crashes here) I hope this clears things up. The destroy button simply calls the mysql_server_end(), and nothing else, just to kill the server. The speed issues I had before (with it waiting 30 seconds to kill the server) were resolved with adding the skip-innodb option to my configuration file. This also fixed the previous crash after creating the server the second time, but now has moved the crash one step ahead, the destruction of the server. Ted -- Ted Morse CIHOLAS Enterprises [EMAIL PROTECTED] On Tue, 18 Jun 2002, miguel solorzano wrote: At 08:35 17/6/2002 -0500, Theodore Morse wrote: Hi, I tried the skip-innodb in my configuration file, it helps to a point, now I can create the server twice, but can only destroy it once, the procedure goes like this: Please clarify: o Create server o Destroy server Your application is closed ? or you did the below server instance immediately the above destroy action without to know if the server clean up was finished ? o Create server o CRASH!! - 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
Re: Embedded MySQL terminate abnormally.
At 23:46 30/12/2001 +0900, Heo, Jungsu Mr. wrote:
Hi!
Below the patch made by Monty:
(/my/mysql) bk diffs sql/net_serv.cc
= sql/net_serv.cc 1.32 vs edited =
170c170
#ifndef EXTRA_DEBUG
---
#if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY)
(/my/mysql) bk diffs -c sql/net_serv.cc
= sql/net_serv.cc 1.32 vs edited =
*** /tmp/net_serv.cc-1.32-4839 Sat Dec 22 15:13:31 2001
--- edited/sql/net_serv.cc Sun Dec 30 12:43:17 2001
***
*** 167,173
void net_clear(NET *net)
{
! #ifndef EXTRA_DEBUG
int count; /* One may get 'unused' warn */
bool is_blocking=vio_is_blocking(net-vio);
if (is_blocking)
--- 167,173
void net_clear(NET *net)
{
! #if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY)
int count; /* One may get 'unused' warn */
bool is_blocking=vio_is_blocking(net-vio);
if (is_blocking)
Regards,
Miguel
I installed Embedded MySQL( compiled --with-embedded-server)
And I compiled source code from Manual.
(I did not modify the source)
compiled nicly, but I run the Embedded MySQL,
Segmentation fault occured
[wertyu@inos prog]$ ls
Makefile mysqld* mysqld.c mysqld.c~
[wertyu@inos prog]$ ./mysqld
Segmentation fault
[wertyu@inos prog]$
here is output from GDB
Program received signal SIGSEGV, Segmentation fault.
0x8051984 in vio_read ()
(gdb) bt
#0 0x8051984 in vio_read ()
#1 0x807357d in net_clear ()
#2 0x804857f in simple_command ()
#3 0x80494f0 in mysql_close ()
#4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54
#5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1,
argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini,
rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78
(gdb)
gcc version = 2.91.66
OS version = Redhat 6.0
Thank you for advanced answer!
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
-
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
--
For technical support contracts, goto https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil
___/ www.mysql.com
-
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
Re: Embedded MySQL server the outside world
Marek Kustka writes: Hi folks, does embedded server tcp-listen to the outside world i.e. it could be used by another app or perhaps been accessed by the same app using ODBC? Nope. OR is MySQL C API the only way to control it? Yes, so far. But other API's could be built on top of it ... Thanks, Marek -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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
Re: Embedded MySQL: Opinion Please
http://www.qnx.com/ Tey actually have a headline right now about BerkleyDB being ported. While I take nothing away from the Mysql/Linux combo as a stable OS. I would stay that a specifically designed RTOS for embeded devices might be better in this situation. Gregg - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 15, 2001 1:00 PM Subject: Embedded MySQL: Opinion Please Hi! I've been monitoring this list for a while now (re: lurking), I've seen only passing comments about embedding MySQL, so I thought I would come out and directly ask the MySQL community for your opinions, or better yet, actual facts - based on experience. I am evaluating MySQL / Linux for use in a line of deeply embedded, multi-node, real-time SCADA products. Where: deeply embedded = headless platform, no user interaction (not even via telnet), no administration interaction, required to operate for years without restart. multi-node = 1 to N processor boards, sharing a common bus (VME, CPCI), not SMP. And, * Database size: between 10K - 250K records - where once the records have been created, they are only updated, typically between several 100 to several 1,000 UPDATES / second. * No moving parts (no fan, no hard disk, no CD, no floppy, no noth'n). * Memory size is not an issue (can add more as required); CPU power is not an issue (re: Moore's Law) (The actual requirements are not as extreme as depicted here, but I want to push the envelope.) I am convinced that MySQL / Linux will work in such as environment. But, the real question(s) is: Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? For this environment, is the MySQL / Linux combo a good idea? Or, should I stick with Linux, but seek out an alternate DBMS? Or, should I drop Linux and go with Windows CE, or some other RTOS? Or, should I stop being a software developing and become a sheepherder? David Vance Senior Software Developer GE Harris Energy Control Systems Canada, Inc. 2728 Hopewell Place NE Calgary, Alberta,Canada T1Y 7J7 +1 (403) 214-4543 +1 (403) 287-7946 [EMAIL PROTECTED] - 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
Re: Embedded MySQL: Opinion Please
Hi. On Thu, Feb 15, 2001 at 02:00:04PM -0500, [EMAIL PROTECTED] wrote: [...] Can they (MySQL / Linux) work in such an environment, continuously, without error or failure, or requiring operator intervention, for years on end? Well, I see no principle problem here. The servers I administer run about 200-400 days without interruption (then the counters get interrupted by hardware/software upgrades ;-) Exceptions are massive internet accesses (so called slashdot effect), but with enough memory and some reasonable limits set, one gets even this stuff stable (not responsive, but stable). What you have to have a look at is anything which is incremental, mainly log files and such stuff. Either disable or rotate those. What I would do is make a test install, then leave it alone for some time and then compare all file sizes and assure that the growing files will be no problem or handle them with cronjobs. For case of emergency (i.e. if some program crashes anyhow), there are several solutions for watchers available, which can restart them (although, as I said, I did not need that stuff until now on x86 boxes). For this environment, is the MySQL / Linux combo a good idea? The question is whether the support for your hardware is stable. If so, I would dare to say that I get the software part stable, too. Or, should I stick with Linux, but seek out an alternate DBMS? MySQL is rock solid if you avoid newly added features and have tested your queries once to be supported. I won't say anything about other DBMSes, because I use none intensively enough to justify a opinion on it. Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? No comment. ;-) Bye, Benjamin. - 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
Re: Embedded MySQL: Opinion Please
Benjamin Pflugmann wrote: Or, should I drop Linux and go with Windows CE, or some other RTOS? Well, I am biased there, but I would really avoid Windows. ;-) Other RTOS are probably a good idea, as someone else already said. Or, should I stop being a software developing and become a sheepherder? A RTOS? I would go for QNX, better yet: Neutrino (this is a really weird RTOS) No comment. ;-) Bye, Benjamin. - 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
