Advantages in combining DB's ?

. Each database has the size of around 100M. Thanks, Prem

Question in ORACLE

Hello All, I have a question in ORACLE indexing What is the difference between B-Tree index and Bitmap index? Thanks in Advance, Prem

URGENT: Question on table storage

for this scenario? Thanks, Prem

How to "control" the number of sql dameons?

Hi All, Could you please explain why some one needs multiple sql daemons and how to control the number of dameons. Thanks, Prem

libmysqlclient.so.12 download for solaris

PLease help me to download libmysqlclient.so.12 for MySQL 4.x for solaris 8. Kinndly provide me some site from where i can download it. ___ Win a castle for NYE with your mates and Yahoo! Messenger http://uk.messenger.ya

libmysqlclient.so.12 for solaris 8

PLease help me to download libmysqlclient.so.12 for MySQL 4.x for solaris 8. Kinndly provide me some site from where i can download it. ___ ALL-NEW Yahoo! Messenger - all new features - even more fun!

mysql restarts when creating UDF.

hi, i have a very serious problem, when i try to reinitialise the database and start my application. By reinitilisation i would remove the database i created along with the UDF functions i created. Then when i try to start my application, which creates the database tables and the UDf, MySQL Rest

Mysql UDF

HI! I wrote a mysql UDF that works well in older versions of mysql (3.23.*) but the same is not working for new versions like (4.0*) . The server restarts every time i invoke my function . I also compiled and linked with libmysqlclient.so.11, but still the problem persists. how to solve the p

mysql user

i find problem while compiling the UDF in windows. the function returns an integer and so i set the type as "long long" but this datatype is not recognised by VC++ 6.0 and i end up with a compilation error. how can i resolve this and what the prototype for functions that returns integer values

mysql UDF in windows

i find problem while compiling the UDF in windows. the function returns an integer and so i set the type as "long long" but this datatype is not recognised by VC++ 6.0 and i end up with a compilation error. how can i resolve this and what the prototype for functions that returns integer values

MySqlManager.rc file missing in mysql source for windows

hi all., i tried to compile mysql-3.23.58 source distribution for windows using VisualStudio 6 and found that MySqlManager.rc file missing and hence the compilation failed , The MySqlManeger.rc file is not available in the MySqlManager folder downloaded from mysql home site. plz help me out in

MySqlManager.rc file missing in mysql source for windows

hi all., i tried to compile mysql-3.23.58 source distribution for windows using VisualStudio 6 and found that MySqlManager.rc file missing and hence the compilation failed , The MySqlManeger.rc file is not available in the MySqlManager folder downloaded from mysql home site. plz help me out in

MySqlManager.rc file missing in mysql source for windows

hi all., i tried to compile mysql-3.23.58 source distribution for windows using VisualStudio 6 and found that MySqlManager.rc file missing and hence the compilation failed , The MySqlManeger.rc file is not available in the MySqlManager folder downloaded from mysql home site. plz help me out in

MySqlManager.rc file missing in windows source distribution.

hi all., i tried to compile mysql-3.23.58 source distribution for windows using VisualStudio 6 and found that MySqlManager.rc file missing and hence the compilation failed , The MySqlManeger.rc file is not available in the MySqlManager folder downloaded from mysql home site. plz help me out in

MySQL DLL for windows

hi ! i have a problem compiling a simple mysql client program in windows. what are the compilation options needed and also how the Linking is made . The manual says to include my_global.h in the header but i dont find that under include folder. also i searched in the net , can anyone provide

Re: Fwd: Dynamic enabling of log files

hi Nils! can u show me how to change the long_query_time using sql statement or by using mysqladmin. the set long_query_time=xyz; does not work or is this a valid command. i am using mysql 3.23.52 --- Nils Valentin <[EMAIL PROTECTED]> wrote: > Hi Prem, > >

Re: Fwd: Dynamic enabling of log files

ng for log files allowed. Regards, Prem S --- Nils Valentin <[EMAIL PROTECTED]> wrote: > > Hi Prem, > > That question was just here 2 days ago, so easy to > answer. ;-) > > > > Logs can be enabled/disabled for the session with > SET SQL_LOG_OFF | > SQL

Fwd: Dynamic enabling of log files

Note: forwarded message attached. Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/--- Begin Message --- hi all! can we enable and disable log files (update log,

Dynamic enabling of log files

hi all! can we enable and disable log files (update log, slow query log) dynamically. Please let me know. what should i do to enable it without restarting the server. I am using MySQL 2.23.52 advance thanx! Want to chat in

ERROR while compiling:

i am using Linux 6.2(Zoot) and MySql 2.23.36and found the following error while compiling the C program using mysql APIcc -o test prog1.c -L /usr/lib/mysql -I /usr/include/mysql -lmysqlclientThe following Error occured :/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress'

finding user details inside UDF

hi! i heared that its possible to get user details inside the UDf by adding the mysql_priv.h header file. But where will this file be available. i am using MySql 3.23.52 on linux8.0 when i try to compile it says :"mysql_priv" file not found. If i can include this file, i can get the thread c

mysql update

i want to update every row in the mysql table that matches a part of each row in it. ie. for example if a table contains the following rows : Pid:21577 PPid: 21174 Uid:501 Gid:501 i want to change the first row to Pid:30209 similarly for any row plz advice me

transactions and per connection details

hi all! i am very much interested in knowing the intricacies of the MySql server. i use Mysql version 3.23.52. how can we get informations regarding all Mysql transactions and regarding the tables and databases that have been dropped. Also how can we get the amount of time spent by

type casting help!!!

hi!! i wrote a simple function that returns a string in C the function fetches values from a table and stores all the value in a string variable and then returns it ...This is small part inside the function i wrote! while((row = mysql_fetch_row(res))) { unsigned long *length

RE: Query excution time

gt; > $time_end = getmicrotime(); > $time = $time_end - $time_start; > echo "Did nothing in $time seconds"; > ?> > > > > > -Original Message- > From: Prem Soman [mailto:[EMAIL PROTECTED] > Sent: 21 June 2003 08:03 > To: mysql groups > Sub

Query excution time

hi ! what is the best way to find query excution time in MySql plz help me! Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- MySQL General Mailing List For

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 > t

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

does MySql Supports shared Objects

hi! Dynamic shared objects could enable user written code to be integrated with the server at run time! . Does MySql support shared objects, since MySql is an open source database i believe it can support DSO. If its not true is there any alternative! ___

Name of the Driver file ?

(/u/premc/mysql). I checked in /u/premc/mysql/lib/mysql . But it contains only libmysqlclient.so , libmysqlclient.so .10 & libmysqlclient.so .10.0.0. Are these the correct Dirver files ? Can anybody help me out of this problem ? Thanks in