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! 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]
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.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 Restarts . The following error was logged in the error log : Number of processes running now: 0 040712 18:26:33 mysqld restarted 040712 18:26:33 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 44378 InnoDB: Doing recovery: scanned up to log sequence number 0 44378 040712 18:26:33 InnoDB: Flushing modified pages from the buffer pool... 040712 18:26:33 InnoDB: Started /abc/MySQL4.0.15/mysql-standard-4.0.15-pc-linux-i686/bin/mysqld: ready for connections. Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 040712 20:13:51 mysqld started /advent/MySQL4.0.15/mysql-standard-4.0.15-pc-linux-i686/bin/mysqld: ready for connections. Version: '4.0.15-standard-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388600 read_buffer_size=131072 max_used_connections=2 max_connections=100 threads_connected=2 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 225791 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x84a6aa0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbff3ef48, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8070640 0x8288108 0x82c2a56 0x82e3cab 0x82c50df 0x82c460a 0x82c5362 0x8283fd6 0x82c460a 0x82842d6 0x8284005 0x80ddf44 0x807d5ad 0x807e895 0x8079e03 0x807985d 0x807904f 0x82858bc 0x82bb07a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x84af4f8 = create function getData returns integer soname sharedObject.so thd-thread_id=19 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. When the application is started for first time, mysql restarts and the database and UDF's are not created, but however when it was started for the second time, the database and the UDF's are getin created. please help me . this is found to appear only on mysql 4.0.* , while it works fine in 3.23.* ___ALL-NEW Yahoo! Messenger - so many all-new ways to express yourself 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]
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 problem, kindly help me. ___ WIN FREE WORLDWIDE FLIGHTS - nominate a cafe in the Yahoo! Mail Internet Cafe Awards www.yahoo.co.uk/internetcafes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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. i searched the manual but got no solution. - Download Yahoo! Messenger now for a chance to WIN Robbie Williams Live At Knebworth DVD
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. i searched the manual but got no solution. - Download Yahoo! Messenger now for a chance to WIN Robbie Williams Live At Knebworth DVD
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 insolving the problem. thanks and regards! Download Yahoo! Messenger now for a chance to win Live At Knebworth DVDs http://www.yahoo.co.uk/robbiewilliams -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 insolving the problem. thanks and regards! Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 insolving the problem. thanks and regards! Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 insolving the problem. thanks and regards! Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 me the link from where it could be downloaded ,.. i am using mysql 3.23.40 advance thanx! Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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, Which version are you curently using 3.23.xxx ?? Whats the XXX in your version ??? What do the change log files say at the www.mysql.com homepage ? Best regards Nils Valentin Tokyo/Japan Prem Soman wrote: Thanks neils! i have gone thru what u referred long before, i know that this set method is not fully supported in 3.23 version, thats why i posed this question, i wanted to know whether there is any other way to do it. when i make changes to my.cnf file i am able to do it but it is not immediatly reflected since mysqld reads from the my.cnf file only when it restarts i thought there must be some sort of command line utility or ... to enable and disabke log files without restarting the server. can u also tell me from what version onwards is this type of dynamic setting 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_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in v3.23.52: http://www.mysql.com/doc/en/SET_OPTION.html Best regards Nils Valenin Tokyo/Japan 2003年 8月 13日 水曜日 13:30、Prem Soman さんは書きました: Note: forwarded message attached. Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ 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: Fwd: Dynamic enabling of log files
Thanks neils! i have gone thru what u referred long before, i know that this set method is not fully supported in 3.23 version, thats why i posed this question, i wanted to know whether there is any other way to do it. when i make changes to my.cnf file i am able to do it but it is not immediatly reflected since mysqld reads from the my.cnf file only when it restarts i thought there must be some sort of command line utility or ... to enable and disabke log files without restarting the server. can u also tell me from what version onwards is this type of dynamic setting 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_LOG_BIN | SQL_LOG_UPDATE. But these commands are not supported in v3.23.52: http://www.mysql.com/doc/en/SET_OPTION.html Best regards Nils Valenin Tokyo/Japan 2003年 8月 13日 水曜日 13:30、Prem Soman さんは書きました: Note: forwarded message attached. Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils 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]
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 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]
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/---BeginMessage--- 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 instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ ---End Message--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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':my_compress.o(.text+0x97): undefined reference to `uncompress'/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_compress_alloc':my_compress.o(.text+0x12b): undefined reference to `compress'collect2: ld returned 1 exit statusplease help me in understanding the problem. - Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
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 constructor called... how should i compile my UDF source file. kindly 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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 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]
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 each client{or connection}. is there
any API available to retrieve it or where in the
source code i can get all these informations!
kindly 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 list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 *lengths;
lengths = mysql_fetch_lengths(res);
for(i=0;i{
str = strcat(str,row[i]);
}
str = strcat(str,\n);
}
but i know that the content in red would rerturn an error!!
how to convert the output of mysql_fetch_row() function to an equivalent string ?
-
Want to chat instantly with your online friends? Get the FREE Yahoo!Messenger
RE: Query excution time
thank u lovatt!
cant i create an application that runs like a
Oracle trigger using 'C' so that i can get the queries
and the time they took to execute dynamically rather
than using a synthetic model.
--- Peter Lovatt [EMAIL PROTECTED] wrote: Hi
if you are using php
http://uk.php.net/manual/en/function.microtime.php
?php
function getmicrotime(){
list($usec, $sec) = explode( ,microtime());
return ((float)$usec + (float)$sec);
}
$time_start = getmicrotime();
//query here
$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
Subject: 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 list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[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
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]
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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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! 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]
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]
