RE: Extending mySQL
Thank you :) -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: 29 May 2004 15:08 To: Yiannis Mavroukakis Cc: [EMAIL PROTECTED] Subject: Re: Extending mySQL Hi! On May 25, Yiannis Mavroukakis wrote: > Hello, > > I'm hoping this is the correct list to post my question ( I was also > considering mysql internals), if not accept my apologies. Yes, internals@ would be better for these kind of questions. > I wish to write a mySQL extension, that will do some filtering on all > data before it is send out to the requesting clients. Is there an API > that will allow me to do this for all outgoing data from the DB? PROCEDURE. See "Adding New Procedures to MySQL" in the manual. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. Note:__ This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Jaguar Freight Services and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Extending mySQL
Hi! On May 25, Yiannis Mavroukakis wrote: > Hello, > > I'm hoping this is the correct list to post my question ( I was also > considering mysql internals), if not accept my apologies. Yes, internals@ would be better for these kind of questions. > I wish to write a mySQL extension, that will do some filtering on all > data before it is send out to the requesting clients. Is there an API > that will allow me to do this for all outgoing data from the DB? PROCEDURE. See "Adding New Procedures to MySQL" in the manual. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Extending mySQL
Hello, I'm hoping this is the correct list to post my question ( I was also considering mysql internals), if not accept my apologies. I wish to write a mySQL extension, that will do some filtering on all data before it is send out to the requesting clients. Is there an API that will allow me to do this for all outgoing data from the DB? Thank you, Yiannis. Note:__ This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Jaguar Freight Services and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: extending MySql
thanx alan! is there any C API available to detect MySql restarts! which file(s) do i have to monitor so that i can track server restarts. > The server does not know how many times it has been > restarted. You can > easily enough write a wrapper script that keeps > count, though. As for > the date, just call gettimeofday() or time() from C, > or SELECT NOW() > from MySQL. > > -- > Dan Nelson > [EMAIL PROTECTED] Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: extending MySql
In the last episode (Jun 20), Prem Soman said: > that was very useful for me. can these UDF's provide a better way to > access the sever specific information such as the date and number of > times the server was restarted The server does not know how many times it has been restarted. You can easily enough write a wrapper script that keeps count, though. As for the date, just call gettimeofday() or time() from C, or SELECT NOW() from MySQL. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
extending MySql
thank u nelson! that was very useful for me. can these UDF's provide a better way to access the sever specific information such as the date and number of times the server was restarted Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Auto-extending MySQL tablespace
Hello everyone, I've rewrote our existing our existing software to be compatible both for Oracle 8i and MySQL databases. I wanted to know, does MySQL support auto-extending of it's tablespace? I know how to manually do it, by adding data files, and restarting the server. Also, how could I check to see how much of pre-allocated space has been used. Is it the actual size? I'm using MySQL 3.23.44 max with InnoDB tables. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [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