RE: Extending mySQL

2004-06-01 Thread Yiannis Mavroukakis
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

2004-05-29 Thread Sergei Golubchik
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

2004-05-25 Thread Yiannis Mavroukakis
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

2003-06-20 Thread Prem Soman
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

2003-06-20 Thread Dan Nelson
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

2003-06-20 Thread Prem Soman
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

2001-12-05 Thread Demirchyan Oganes-AOD098

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