Re: Prevent execution of queries without a WHERE clause
Hi, You can check this feature out on section 2.9 on the mysql 5.0 certification guide (page 44). this feature has some side effects other than requesting a where with deletes and updates i.e. Quoting for whoever doesn't have the MySQL certification study guide 1.UPDATE and DELETE statments are allowed only if then include a WHERE clause that spedifically identifies which records to update or delete by means of a key,value or if they include a LIMIT clause. 2. Output from single-table SELECT statments is restricted to no more than 1,000 rows unless the statment include a LIMIT clause 3. Multiple-table SELECT statments are allowed only if MySQL will examine no more than 1,000,000 rows to process the query. The --i-am-a-dummy option is a synonym for --safe-updates. :) Gluck Darren On Tue, Sep 8, 2009 at 10:25 AM, Ian Simpson i...@it.myjobgroup.co.ukwrote: Thanks John, that's done the trick On Mon, 2009-09-07 at 18:24 +0100, John Daisley wrote: Add the option 'safe-updates' to the mysql section of your 'my.cnf' / 'my.ini' file and restart the mysqld service. [mysql] Safe-updates Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile device. -Original Message- From: Ian Simpson i...@it.myjobgroup.co.uk Sent: Monday, September 07, 2009 5:14 PM To: mysql@lists.mysql.com Subject: Prevent execution of queries without a WHERE clause Hi all, I vaguely recall finding mention a MySQL command or start-up option that blocked any update or delete query that didn't have a WHERE component, to prevent statements accidentally affecting too many rows (like those of a certain absent-minded web developer who might work for the same company as me...). I now can't find any reference to it, other than a vague mention of using safe mode in the comments in the mysql docs; it doesn't explain if that is starting with --safe-mode, or using the mysqld_safe script. Both of these modes seem remarkably poorly documented, making me unwilling to experiment with them without advice, in case one of them disables networking or something similar. Hoping someone can help with this. Thanks -- Ian Simpson System Administrator MyJobGroup -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=i...@mysqlpreacher.com
Re: optimize my.cnf
Hi Christos, Performance optimization is very subjective, and if you are experiencing low performance it can be a million different things. The description you provided didn't mention any of your current my.cnf settings, nor did it mention what kind of tables your database contains, size of data, types of indexes, engines used by your tables etc. You mention you have a quad core machine running 8G ram how much of that ram is being used by MySQL and how much by other applications? how much of it is free? What kind of CPU usage are you experiencing, what is the size of your db, are you logging slow queries and checking for missing indexes? My.cnf is not a magic box which improves performance by setting a couple of variables and normally the performance improvements are minimal as compared to other things like: 1: faster disks 2: normalized and correctly designed db (not in your power I guess) 3: good code in your application (not in your power either) I'd suggest you read High Performance MySQL 2nd ed which will definitely be of help. Sorry for bombarding you with questions but performance tuning is not something you do by setting a couple of params on my.cnf! Gluck Darren www.mysqlpreacher.com - yet another blog from a mysql dba www.securich.com - a mysql security plugin On Thu, Sep 3, 2009 at 10:06 AM, Christos Pelekis chris...@blueice.orgwrote: Hi, can you please send me some optimization examples for my.cnf ? I use mysql 5.1.37 The server run just 2 very busy forums. It is quad core cpu and 8 giga ram so we have lot of run (run debian) Can you please give me some examples? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=i...@mysqlpreacher.com
Re: reverting to passwd-less root w/out --skip-grant-tables
Log in as root and run: set password = ''; OR update mysql.user set Password='' where User='root'; this is TOTALLY INSECURE but if that's what you want, then it should do the trick. Regards, Darren Cassar www.mysqlpreacher.com www.securich.com On Wed, Aug 26, 2009 at 2:33 AM, Joe mysql@bluepolka.net wrote: I'm trying to get back to an earlier state where we started mysqld withOUT --skip-grant-tables but the root user had no password. Yes, insecure, but we're in restoration mode here. How do I reset/revert the root password to no password without running with --skip-grant-tables? Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=i...@mysqlpreacher.com
Re: Unicode (utf8) and MySQL (with Perl)
On Wed, 1 Dec 2004, Rhino wrote: I'm using mysql 4.1.7 and perl 5.8.1 on OS X 10.3 It also wouldn't hurt you to upgrade past all the minor updates of your other components. That means 4.1.7 (check), 5.8.6, and 10.3.6. I'm sure Perl had a lot of bug fixes or improvements after 5.8.1, especially since Unicode support is used a lot less than ascii historically. Also, make sure you have DBI 1.46 and DBD::mysql the newest. -- Darren Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[OT] HP DL760G2 vs Opteron for large DB on Linux
Hi all, I am looking to purchase hardware for a large database running MySQL or Oracle on Linux. Was thinking of the Opteron for its good scalability and memory bandwidth until my friend told me that the DL760 from HP that uses the F8 (from Intel Profusion) chipset allowing up to 8 CPUs and memeory up to 32GB. I have always though that the Xeons cannot go beyond 4 CPUs and 4GB but this changes the equation. Has anyone got experience with this server or similar ones? How is the performance for running databases, esp in terms of large RAM usage? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: moving records between tables?
Hi all, Thanks for the help. So I can Insert into archive_table select * from active_table where condition='true', followed by a delete from active_table... If my archive_tabler is nearly exactly the same but has two more fields (housekeep_id, and now()), how do I modify the above statement to move the record to archive_table and add in two more fields? -Original Message- From: darren [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 11:44 PM To: [EMAIL PROTECTED] Subject: moving records between tables? Hi all, I have 2 tables...one for keeping active items while the other is for older records. A housekeep program will come in every night to move some records (matching several criteria from the active table to the history one. I am currently doing SELECT, INSERT and then DELETE. i.e. a select * from active where key=key_value limit 1 and then a insert into history... and then a delete * from active where pri_key='pri_key_value'... I am sure there's a better way right?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
moving records between tables?
Hi all, I have 2 tables...one for keeping active items while the other is for older records. A housekeep program will come in every night to move some records (matching several criteria from the active table to the history one. I am currently doing SELECT, INSERT and then DELETE. i.e. a select * from active where key=key_value limit 1 and then a insert into history... and then a delete * from active where pri_key='pri_key_value'... I am sure there's a better way right?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Re: threading problems in linux C client
Hi, Thanx for responding. Only one worker thread was accesing MYSQL* myHdl. Nevertherless i have placed mutexes around all calls involing MYSQL*. main-thread: Defined MYSQL* myHdl as global variable and called mysql_init(), and mysql_connect(); worker: Defined MYSQL_RES* res and used myHdl to query with no problems. Crashes upon mysql_num_res or mysql_fetch_rows. gdb gives: Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 3076 (LWP 23491)] 0x400519e3 in mysql_fetch_row () from /usr/lib/libmysqlclient_r.so.10 (gdb) bt #0 0x400519e3 in mysql_fetch_row () from /usr/lib/libmysqlclient_r.so.10 #1 0x08054d40 in th_connection () #2 0x40036fef in pthread_start_thread () from /lib/i686/libpthread.so.0 #3 0x400370df in pthread_start_thread_event () from /lib/i686/libpthread.so.0 -Original Message- From: Eric Bergen [EMAIL PROTECTED] To: darren [EMAIL PROTECTED] Date: Wed, 30 Jun 2004 20:06:40 -0500 Subject: Re: threading problems in linux C client If you have multiple threads accessing the same connection remember to make sure that only one thread enters mysql_query() mysql_connect() or mysql_store_result() after you store the result another thread will be able to use that connection without problems. -Eric On Wed, 30 Jun 2004 11:01:35 +, darren [EMAIL PROTECTED] wrote: Hi all, I am writing a multi-threaded client that requires shared access to a single MySQL connection. The environment is Redhat 7.3 with the patched mysql-3.23.58-2.71.i386.rpm installed and compiled with -l libmysqlclient_r. The connection is made from the main thread and a MYSQL_RES* myres declared from the child thread is used to fetch results back to the thread. I get a Segmentation fault the first instance my child thread (only one) accesses MYSQL_RES through mysql_num_rows(myres). (gdb informed me that this is due to mysql_num_rows from libmysqlclient_r.so.10) I have read a few docs about writing MySQL multi-threaded clients and have called my_init() in my main prog and my_thread_init() at the first line of my thread handler. Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
threading problems in linux C client
Hi all, I am writing a multi-threaded client that requires shared access to a single MySQL connection. The environment is Redhat 7.3 with the patched mysql-3.23.58-2.71.i386.rpm installed and compiled with -l libmysqlclient_r. The connection is made from the main thread and a MYSQL_RES* myres declared from the child thread is used to fetch results back to the thread. I get a Segmentation fault the first instance my child thread (only one) accesses MYSQL_RES through mysql_num_rows(myres). (gdb informed me that this is due to mysql_num_rows from libmysqlclient_r.so.10) I have read a few docs about writing MySQL multi-threaded clients and have called my_init() in my main prog and my_thread_init() at the first line of my thread handler. Any ideas? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select and update field in one query
Hi all, I need to select the top 1000 records based on the usage field and update the checked field to '1'. I am currently doing it in 2 statements; i.e. select first then update from a MYSQL_ROW array. How do I do it in just a single statement? Please advice on a better way. Also...will doing this in one statement be more efficient from the server perspective? Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Encrypt().
I am running Discus Message Board on MYSQL server version 3.23.55 all on Windows 2K platform. Discus appears to be encrypting the user password with, I think, Encrypt(password, saltcode) (calling the function in MYSQL). When I run select encrypt(1); \g it just returns NULL. Any ideas why and what I can do to make it work? Thanks, I appreciate your attention, Darren. Darren Green Strategic ICT Research and Development Cheshire County Council 5th Floor, Commerce House, Hunter Street, Chester CH1 1SR * 01244 602104 fax 01244 603939 * mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ** Note : This E-Mail is sent in confidence for the addressee only. Unauthorised recipients must preserve this confidentiality and should please advise the sender immediately by telephone and then delete the message without copying or storing it or disclosing its contents to any other person. We have taken all reasonable precautions to ensure that no viruses are transmitted from Cheshire County Council to any third party. Copyright in this e mail and attachments created by us unless stated to the contrary belongs to Cheshire County Council. Any liability (in negligence or otherwise) arising from any party acting, or refraining from acting on any information contained in this e mail is hereby excluded. Should you communicate with anyone at Cheshire County Council by e-mail, you consent to us monitoring and reading any such correspondence. Printing this email? Please think environmentally and only print when essential! **
Random Selects
I have a table called testimonials: +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | tinyint(3) | | PRI | NULL| auto_increment | | can_use | tinyint(1) | | | 0 || | name | varchar(64) | | | 0 || | location | varchar(64) | | | 0 || | quote| text| | | || +--+-+--+-+-++ That contains 20 or so customer testimonial comments. I want to randomly display 3-4 of them every time a page loads (using PHP). Is there some type of random selction available within MySQL, as in: SELECT RANDOM(id),name,location,quote FROM testimonials WHERE can_use=1 LIMIT 3; Or something to that effect or am I better served finding some way in PHP to do this? Thanks. - 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: Random Selects
3.23.54 on Linux. And it worked. Thx. Seems to be not so random, but then with more records to sample from the randomness would increase. True? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Saturday, March 08, 2003 2:33 PM To: Darren Young; [EMAIL PROTECTED] Subject: Re: Random Selects At 12:33 -0600 3/8/03, Darren Young wrote: I have a table called testimonials: +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | id | tinyint(3) | | PRI | NULL| auto_increment | | can_use | tinyint(1) | | | 0 || | name | varchar(64) | | | 0 || | location | varchar(64) | | | 0 || | quote| text| | | || +--+-+--+-+-++ That contains 20 or so customer testimonial comments. I want to randomly display 3-4 of them every time a page loads (using PHP). Is there some type of random selction available within MySQL, as in: SELECT RANDOM(id),name,location,quote FROM testimonials WHERE can_use=1 LIMIT 3; Or something to that effect or am I better served finding some way in PHP to do this? ORDER BY RAND() LIMIT 3 ought to do it, unless your version of MySQL is older than 3.23.2. Thanks. - 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
Regular Expressions
I've looked through the mysql manual for information on regualar expressions, and all that it seems to have are references such as: SELECT fo\nfo REGEXP ^fo$; How can the REGEXP be applied to a 'SELECT field FROM table' kind of statement? Thanks, Darren Young mysql,query - 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
Windows InnoDB
Is the InnoDB table type available on Windows? Darren Young [EMAIL PROTECTED] mysql, query - 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
Client History
Where does the mysql client store the query history information? I'm referring to the information that it pulls up when you hit the up or down arrow keys. There was a rather complex query that I came up with a while ago and don't feel like 'up arrowing' all night... Thanks, Darren Young mysql, query - 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: SQL Question
I have 2 tables in our MySQL database like this: TABLE: customers +--+---+--+-+-+- ---+ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-+- ---+ | custid | mediumint(8) unsigned | | PRI | NULL| auto_increment | | name | tinytext | YES | | NULL| | | email| tinytext | YES | | NULL| | | company | tinytext | YES | | NULL| | +--+---+--+-+-+- ---+ TABLE: shipment +-+---+--+-+-+-- --+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+-- --+ | shipmentid | mediumint(10) | | PRI | NULL| auto_increment | | origin | mediumint(10) | YES | | NULL| | | destination | mediumint(10) | YES | | NULL| | | quoteid | mediumint(10) | YES | | NULL| | | customerid | mediumint(10) | YES | | NULL| | | carrierid | mediumint(10) | YES | | NULL| | +-+---+--+-+-+-- --+ I need to construct a query to find out what customers in the database have not booked shipments with us. That means there would be no records in the shipment table for a given customer id. I can easily get a count of how many shipments are there for customers that have booked (via count() and group), but this one is eluding me.. Any help or suggestions on where to get more info would be appreciated. Thanks, Darren Young The Freight Depot - 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
mysql 3.23.53 compile issue
Hi there I've an Sun Ultra Enterprise 2 desktop that is running a new (Patched) build of Solaris 9 with GCC3.2, GNU Binutils (latest) and a few packages like GNU Make, GNU sed, GNU tar from sunfreeware PATH is /usr/sbin:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/ucb LD_LIBRARY_PATH is /usr/local/ssl/lib:/usr/local/lib CFLAGS=-O3 CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti When I try to compile mysql 3.23.53 with the line: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldfla gs=-all-static I get: =8= gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/m ysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHA VE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I. -O3 -DDBUG_OFF -O3 -felide-constructors -fno-ex ceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_ MYSYS_NEW -DDEFINE_CXA_PURE_VIRTUAL -DHAVE_RWLOCK_T -c mysqld.cc mysqld.cc: In function `void* handle_connections_sockets(void*)': mysqld.cc:2410: invalid conversion from `size_socket*' to `socklen_t*' mysqld.cc:2476: invalid conversion from `size_socket*' to `socklen_t*' make[3]: *** [mysqld.o] Error 1 make[3]: Leaving directory `/usr/local/build/mysql-3.23.53/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr/local/build/mysql-3.23.53/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/build/mysql-3.23.53' make: *** [all-recursive-am] Error 2 =8= any ideas? I've also tried with no extra ./configure options and get the same results. thanks -- Darren Beale - Acksys Ltd Office: 020 8530 1454 Fax: 07092 394822 Mobile: 07711 716197 http://www.acksys.co.uk - 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
mysql-3.23.53 compile issue
Hi there I've an Sun Ultra Enterprise 2 desktop that is running a new (Patched) build of Solaris 9 with GCC3.2, GNU Binutils (latest) and a few packages like GNU Make, GNU sed, GNU tar from sunfreeware PATH is /usr/sbin:/usr/bin:/usr/local/bin:/usr/ccs/bin:/usr/ucb LD_LIBRARY_PATH is /usr/local/ssl/lib:/usr/local/lib CFLAGS=-O3 CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti When I try to compile mysql 3.23.53 with the line: ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldfla gs=-all-static I get: =8= gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/m ysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHA VE_CONFIG_H -I./../include -I./../regex -I. -I../include -I.. -I. -O3 -DDBUG_OFF -O3 -felide-constructors -fno-ex ceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_ MYSYS_NEW -DDEFINE_CXA_PURE_VIRTUAL -DHAVE_RWLOCK_T -c mysqld.cc mysqld.cc: In function `void* handle_connections_sockets(void*)': mysqld.cc:2410: invalid conversion from `size_socket*' to `socklen_t*' mysqld.cc:2476: invalid conversion from `size_socket*' to `socklen_t*' make[3]: *** [mysqld.o] Error 1 make[3]: Leaving directory `/usr/local/build/mysql-3.23.53/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr/local/build/mysql-3.23.53/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/build/mysql-3.23.53' make: *** [all-recursive-am] Error 2 =8= any ideas? I've also tried with no extra ./configure options and get the same results. thanks -- Darren Beale - Acksys Ltd Office: 020 8530 1454 Fax: 07092 394822 Mobile: 07711 716197 http://www.acksys.co.uk - 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
error: 'Host 'myhostname' is not allowed to connect to this MySQL server'
Hi After installing MySQL-3.23.52-1.i386.rpm the following is displayed: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h myhostname password 'new-password' See the manual for more instructions. . . However, when I attempt to run the second of these I get the following error: [root@myhostname root]# mysqladmin -u root -h myhostname mypassword mysqladmin: connect to server at 'myhostname' failed error: 'Host 'myhostname' is not allowed to connect to this MySQL server' Any help appreciated. Regards Darren Hills Systems Tester/Test Analyst Technology South Australia Pracom Ltd 288 Glen Osmond Road Fullarton South Australia 5063 Voice: +61 8 8202 9963 Fax: +61 8 8202 9001 Mobile: 0402 358 988 Mailto:[EMAIL PROTECTED] http://www.pracom.com.au PRIVILEGED - PRIVATE AND CONFIDENTIAL This electronic mail is solely for the use of the addressee and may contain information which is confidential or privileged. If you receive this electronic mail in error, please delete it from your system immediately and notify the sender by electronic mail or using any of the above contact details. - 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
Perl API
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Where are places to obtain information about the Perl API for MySQL? Is there possibly a list specific to that topic? Thanks. -BEGIN PGP SIGNATURE- Version: PGP Personal Security 7.0.3 iQA/AwUBPViONutdIID34ZgYEQLPQACfTkcpF5O7nklg3vkeNPtJPsNFknUAoOhK cnyCLOFutPVmkDe7BP6Sgko7 =0vjK -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
4.0.2 libmysqlclient.so.10 not found
I am in the process of testing out the 4.0 series of MySQL and am having some problems when I try to install the php-mysql RPM. The machine is a RedHat 7.2 i386 box with all current patches. I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug enabled then installed all the necessary RPM's. Everything seems to be working ok on the MySQL side except that php is asking for libmysqlclient.so.10 and the only library installed with MySQL-shared is libmysqlclient.so.11. I tried a manual symlink from libmysqlclient.so.10 to libmysqlclient.so.11 and the php-mysql still complains that the library isn't present. I installed the php-mysql RPM with --nodeps just to test it out and sure enough I get 'Call to undefined function: mysql_pconnect' which is the same message you receive if you don't install the MySQL-shared RPM in the 3.0 series. I tried adding /usr/lib /usr/lib/mysql /etc/ld.so.conf and ran ldconfig which yielded the same results. Any thoughts on how I could get this library in place with 4.0.2? Thanks, Darren Young [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
4.0.2 libmysqlclient.so.10 not found
I am in the process of testing out the 4.0 series of MySQL and am having some problems when I try to install the php-mysql RPM. The machine is a RedHat 7.2 i386 box with all current patches. I pulled down the source RPM for 4.0.2-2 and rebuilt the RPM's with debug enabled then installed all the necessary RPM's. Everything seems to be working ok on the MySQL side except that php is asking for libmysqlclient.so.10 and the only library installed with MySQL-shared is libmysqlclient.so.11. I tried a manual symlink from libmysqlclient.so.10 to libmysqlclient.so.11 and the php-mysql still complains that the library isn't present. I installed the php-mysql RPM with --nodeps just to test it out and sure enough I get 'Call to undefined function: mysql_pconnect' which is the same message you receive if you don't install the MySQL-shared RPM in the 3.0 series. I tried adding /usr/lib /usr/lib/mysql /etc/ld.so.conf and ran ldconfig which yielded the same results. Any thoughts on how I could get this library in place with 4.0.2? Thanks, Darren Young [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
Error segfault
I have a small c program that is supposed to run a select query against a MySQL database. It keeps bombing with a segfault during what I think is the db connect. I recompiled everything with debug and ran mysql_debug in the code and am getting the following: [youngd@fett]:~/src/logit $ ./searchlog -d Debug set Parsed config file and got: DB Host: fett DB Name: CHANGELOG DB User: youngd DB Pass: xx 1: dbug: libmysql.c: 1176:1: mysql_real_connect 2: dbug: libmysql.c: 1178:1: | enter: host: fett db: CHANGELOG user: youngd 3: dbug: libmysql.c: 1294:1: | info: Server name: 'fett'. TCP sock: 1073830556 4: dbug: violite.c: 103:2: | vio_new 5: dbug: violite.c: 104:2: | | enter: sd=3 6: dbug:my_malloc.c:31:3: | | my_malloc 7: dbug:my_malloc.c:32:3: | | | my: Size: 84 MyFlags: 16 8: dbug:my_malloc.c:48:3: | | | exit: ptr: 8072d68 9: dbug:my_malloc.c:49:3: | | my_malloc 10: dbug: violite.c: 126:2: | vio_new 11: dbug: libmysql.c: 1346:1: | error: Got error 111 on connect to 'fett' 12: dbug: libmysql.c: 1568:1: | error: message: 2003 (Can't connect to MySQL server on 'fett' (111)) 13: dbug: libmysql.c: 622:2: | end_server 14: dbug: libmysql.c: 626:2: | | info: Net: TCP/IP (3) 15: dbug: violite.c: 341:3: | | vio_close 16: dbug: violite.c: 362:3: | | | vio_error: close() failed, error: 107 17: dbug: violite.c: 367:3: | | vio_close 18: dbug:my_malloc.c:58:3: | | my_free 19: dbug:my_malloc.c:59:3: | | | my: ptr: 8072d68 20: dbug:my_malloc.c:62:3: | | my_free 21: dbug:my_malloc.c:58:3: | | my_free 22: dbug:my_malloc.c:59:3: | | | my: ptr: 333a3630 Segmentation fault If I run a strace on the same binary I get: connect(3, {sin_family=AF_INET, sin_port=htons(23196), sin_addr=inet_addr(192.168.5.3)}}, 16) = -1 ECONNREFUSED (Connection refused) shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected) close(3)= 0 --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ It picks up the connection info from a config file. I have other utils that use the same config file and parsing code which work ok. The host, db, username and password are used by other scripts and programs. The only thing this program does is runs a single select query against the db. Any ideas what error 111 and/or 2003 is? Other thoughts? The actual debug used in the code is: mysql_debug(d:t:F:L:n:N:P:o:, /tmp/client.trace); Thanks, Darren Young [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
MySQL List
I've sent a couple of messages to the MySQL list today that didn't seem to get through. Have there been any problems with the list and/or the manager today? One of them was returned as being too large to be posted and it really wasn't all that long. One of them never made it through and was never returned. This one was originally returned as spam since it didn't contain any words related to sql, mysql or query. Are the list filters or posting rules available somewhere to read? Here's the question I had earlier from the first message that was returned. I have a small c program that is supposed to run a select query against a MySQL database. It keeps bombing with a segfault during what I think is the db connect. I recompiled everything with debug and ran mysql_debug in the code and am getting the following: 1: dbug: libmysql.c: 1176:1: mysql_real_connect 2: dbug: libmysql.c: 1178:1: | enter: host: fett db: CHANGELOG user: youngd 3: dbug: libmysql.c: 1294:1: | info: Server name: 'fett'. TCP sock: 1073830556 4: dbug: violite.c: 103:2: | vio_new 5: dbug: violite.c: 104:2: | | enter: sd=3 6: dbug:my_malloc.c:31:3: | | my_malloc 7: dbug:my_malloc.c:32:3: | | | my: Size: 84 MyFlags: 16 8: dbug:my_malloc.c:48:3: | | | exit: ptr: 8072d68 9: dbug:my_malloc.c:49:3: | | my_malloc 10: dbug: violite.c: 126:2: | vio_new 11: dbug: libmysql.c: 1346:1: | error: Got error 111 on connect to 'fett' 12: dbug: libmysql.c: 1568:1: | error: message: 2003 (Can't connect to MySQL server on 'fett' (111)) 13: dbug: libmysql.c: 622:2: | end_server 14: dbug: libmysql.c: 626:2: | | info: Net: TCP/IP (3) 15: dbug: violite.c: 341:3: | | vio_close 16: dbug: violite.c: 362:3: | | | vio_error: close() failed, error: 107 17: dbug: violite.c: 367:3: | | vio_close 18: dbug:my_malloc.c:58:3: | | my_free 19: dbug:my_malloc.c:59:3: | | | my: ptr: 8072d68 20: dbug:my_malloc.c:62:3: | | my_free 21: dbug:my_malloc.c:58:3: | | my_free 22: dbug:my_malloc.c:59:3: | | | my: ptr: 333a3630 Segmentation fault It doesn't generate a core dump by the way. If I run a strace on the same binary I get: connect(3, {sin_family=AF_INET, sin_port=htons(23196), sin_addr=inet_addr(192.168.5.3)}}, 16) = -1 ECONNREFUSED (Connection refused) shutdown(3, 2 /* send and receive */) = -1 ENOTCONN (Transport endpoint is not connected) close(3)= 0 --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ Any ideas what error 111 and/or 2003 is? Other thoughts? The actual debug used in the code is: mysql_debug(d:t:F:L:n:N:P:o:, /tmp/client.trace); The username/password/host/database all work fine from the mysql client as well as from other programs that use similar shared code as the one that's broken. Thanks, Darren Young [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: problem with load data local infile
The file does exist. The file and its directory are 0777 permission. Darren - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, April 20, 2002 4:32 AM Subject: Re: problem with load data local infile Darren, Friday, April 19, 2002, 3:33:50 PM, you wrote: DV I am having problems with load data local infile. DV The mysql host server is running 3.23.23 DV I was able to successfully use load data local infile before to import data DV off of a client machine onto the mysql host but now all i get is a DV can't stat file errcode2 message. DV I know that the pathname I am using is correct. DV What would keep the mysql server from being able to see the file? 1. Does the file exist there? 2. Does MySQL have permissions on the file and dirs? DV Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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: Re: problem with load data local infile
Both files are world readable. How do you know this? Because FTP tells me they are. Also, when you say client machine, what do you mean? In particular, are the web server and the MySQL servers running on the same machine? Client machine is the machine running the webserver and MySQL client. The host machine runs the actual MySQL server. - 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
problem with load data local infile
I am having problems with load data local infile. The mysql host server is running 3.23.23 I was able to successfully use load data local infile before to import data off of a client machine onto the mysql host but now all i get is a can't stat file errcode2 message. I know that the pathname I am using is correct. What would keep the mysql server from being able to see the file? Thanks - 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
Fw: problem with load data local infile (repeat)
I never saw this message make this list so I'm reposting it. - Original Message - From: Darren Vollmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 19, 2002 7:33 AM Subject: problem with load data local infile I am having problems with load data local infile. The mysql host server is running 3.23.23 I was able to successfully use load data local infile before to import data off of a client machine onto the mysql host but now all i get is a can't stat file errcode2 message. I know that the pathname I am using is correct. What would keep the mysql server from being able to see the file? Thanks - 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
PERL DBB::MYSQL MAKE TEST PROBLEM....
I've been having some troubles install dbd::mysql on Solaris 2.4 - make test is failing and I can't figure out what is going wrong. The following shows the results coming back from make test If anybody can help me out here, I would appreciate it. Thanks. make[1]: Entering directory `/home/dsball/Msql-Mysql-modules-1.2219/mysql' make[1]: Leaving directory `/home/dsball/Msql-Mysql-modules-1.2219/mysql' make[1]: Entering directory `/home/dsball/Msql-Mysql-modules-1.2219/mysql' PERL_DL_NONLAZY=1 /usr/local/bin/perl -I.././blib/arch -I.././blib/lib -I/usr/local/lib/perl5/sun4-solaris/5.00401 -I/usr/local/lib/perl5 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/00base.t line 38 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10dsnlist.install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/10dsnlist.t line 45 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-3 Failed 3/3 tests, 0.00% okay t/20createdrop..install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/20createdrop.t line 47 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-5 Failed 5/5 tests, 0.00% okay t/30insertfetch.install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/30insertfetch.t line 48 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/40bindparam...install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 3) line 2 at t/40bindparam.t line 64 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-28 Failed 28/28 tests, 0.00% okay t/40blobs...install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/40blobs.t line 68 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/40listfields..install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/40listfields.t line 57 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-16 Failed 16/16 tests, 0.00% okay t/40nulls...install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/40nulls.t line 50 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/40numrows.install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at
Re: PERL DBB::MYSQL MAKE TEST PROBLEM....
Yes, this problem is happening at the 'make test' step while installing these modules... I have performed the perl Makefile.PL, and the make, they seem to go ok, just when I perform the make test, it seems to fail with this relocation and symbol errors --- Ken Menzel [EMAIL PROTECTED] wrote: Hi Darren, The tests rely on the perl BDB and mysql-modules packages for perl. Have you installed and tested these? Ken - Original Message - From: Darren Ball [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 21, 2002 10:27 AM Subject: PERL DBB::MYSQL MAKE TEST PROBLEM I've been having some troubles install dbd::mysql on Solaris 2.4 - make test is failing and I can't figure out what is going wrong. The following shows the results coming back from make test If anybody can help me out here, I would appreciate it. Thanks. make[1]: Entering directory `/home/dsball/Msql-Mysql-modules-1.2219/mysql' make[1]: Leaving directory `/home/dsball/Msql-Mysql-modules-1.2219/mysql' make[1]: Entering directory `/home/dsball/Msql-Mysql-modules-1.2219/mysql' PERL_DL_NONLAZY=1 /usr/local/bin/perl -I.././blib/arch -I.././blib/lib -I/usr/local/lib/perl5/sun4-solaris/5.00401 -I/usr/local/lib/perl5 -e 'use Test::Harness qw(runtests $verbose); $verbose=0; runtests @ARGV;' t/*.t t/00baseinstall_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/00base.t line 38 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10dsnlist.install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/10dsnlist.t line 45 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-3 Failed 3/3 tests, 0.00% okay t/20createdrop..install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/20createdrop.t line 47 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-5 Failed 5/5 tests, 0.00% okay t/30insertfetch.install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/30insertfetch.t line 48 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/40bindparam...install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 3) line 2 at t/40bindparam.t line 64 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-28 Failed 28/28 tests, 0.00% okay t/40blobs...install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/40blobs.t line 68 dubious Test returned status 2 (wstat 512) DIED. FAILED tests 1-11 Failed 11/11 tests, 0.00% okay t/40listfields..install_driver(mysql) failed: Can't load '.././blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: relocation error: file .././blib/arch/auto/DBD/mysql/mysql.so: symbol newSVpvn: referenced symbol not found at /usr/local/lib/perl5/sun4-solaris/5.00401/DynaLoader.pm line 155. at (eval 1) line 2 at t/40listfields.t line 57 dubious
Queries entering Sleep state.
Hello again all. Thanks for the help on the query time issue, I have begun a transition. I have another question. I have some queries which are apparently going into a Sleep mode in my database. Can anyone point me in the right direction on this for more information? Thanks, Darren ++-+++-+---+---+ --+ | Id | User | Host | db | Command | Time | State | Info | ++-+++-+---+---+ --+ | 15 | web | localhost | mailer | Sleep | 47743 | NULL | NULL | | 20 | adssurvey | 66.6.196.2 | mailer | Sleep | 370 | NULL | NULL | | 22 | root | localhost | mailer | Query | 0 | NULL | show processlist | ++-+++-+---+---+ --+ 3 rows in set (0.00 sec) - 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: Queries entering Sleep state.
If say, that client closes the connection at some point in the future...that will clean up then? Or has the connection been severed? -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 1:59 PM To: Greer, Darren (MED) Cc: '[EMAIL PROTECTED]' Subject: Re: Queries entering Sleep state. This is caused by a connection that's still held open by a client, or (more commonly) by a connection that wasn't closed gracefully by the client. One of the oddities of TCP is that one end of the connection won't know that the other end has dropped the connection until it tries to write something to the connection. Since MySQL doesn't write except in reply to a query, it's sitting there with one end of a dead connection patiently waiting for a new query to arrive. james montebello On Tue, 15 Jan 2002, Greer, Darren (MED) wrote: Hello again all. Thanks for the help on the query time issue, I have begun a transition. I have another question. I have some queries which are apparently going into a Sleep mode in my database. Can anyone point me in the right direction on this for more information? Thanks, Darren ++-+++-+---+---+ --+ | Id | User | Host | db | Command | Time | State | Info | ++-+++-+---+---+ --+ | 15 | web | localhost | mailer | Sleep | 47743 | NULL | NULL | 20 | | adssurvey | 66.6.196.2 | mailer | Sleep | 370 | NULL | NULL | 22 | | root | localhost | mailer | Query | 0 | NULL | show processlist | ++-+++-+---+---+ --+ 3 rows in set (0.00 sec) - 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
General Query time question
Hello all. I have a database which is around 10million rows. The structure is as follows: id int(11) NOT NULL- Auto Increment address char(90) NOT NULL status char(2) NOT NULL country char(2) state char(2) areacode char(3) ...about 40 char(1) fields. I have an unique index on address, and a non-unique index on address. I also have a non-unique index on status. My questions is this. The following query takes about 7 minutes to run: SELECT count(*) as count from userdata; This is on a PIII 700, with 512MB Ram, running Linux. Is that amount of time normal on a 10million record DB? Or, are the 40 char(1) fields just slowing it down? Thanks for any help, Darren - 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: General Query time question
Correction on the query: SELECT count(*) as count FROM userdata WHERE status = 'A'; Sorry. -Original Message- From: Greer, Darren (MED) Sent: Tuesday, January 08, 2002 10:20 AM To: '[EMAIL PROTECTED]' Subject: General Query time question Hello all. I have a database which is around 10million rows. The structure is as follows: id int(11) NOT NULL- Auto Increment address char(90) NOT NULL status char(2) NOT NULL country char(2) state char(2) areacode char(3) ...about 40 char(1) fields. I have an unique index on address, and a non-unique index on address. I also have a non-unique index on status. My questions is this. The following query takes about 7 minutes to run: SELECT count(*) as count from userdata; This is on a PIII 700, with 512MB Ram, running Linux. Is that amount of time normal on a 10million record DB? Or, are the 40 char(1) fields just slowing it down? Thanks for any help, Darren - 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: General Query time question
You are correct, they are simple Y/N fields. I am not familiar with the process you mentioned, but will do some digging. If you have any information you could give me that doesn't require too much of your time, I would appreciate it. Thanks, Darren -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:37 AM To: Greer, Darren (MED) Cc: '[EMAIL PROTECTED]' Subject: Re: General Query time question I'm just guessing here, but I suppose most of the char(1) fields are y/n fields. If that's the case you should consider using a single BIGINT and flag those bits instead. That would considerably reduce the size of the table on one hand and I guess it should improve things speed-wise as well. Obviously, my whole theory stands on a supposition, so I might be wrong in suggesting this. Bogdan Greer, Darren (MED) wrote: id int(11) NOT NULL- Auto Increment address char(90) NOT NULL status char(2) NOT NULL country char(2) state char(2) areacode char(3) ...about 40 char(1) fields. - 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: General Query time question
If I move the status to another table, and then wanted to get a count of everyone who is of status 'A', how would that be any quicker? Would I join the tables? -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:34 AM To: [EMAIL PROTECTED] Subject: Re: General Query time question I didn't think/read far enough. One more attempt is due. Correction on the query: SELECT count(*) as count FR OM userdata WHERE status = 'A'; I didn't see that it was on that column you had an index, so forget I said 'of course'. Have you used EXPLAIN to figure out if the index is actually used in the query? If you haven't already, consider running an ANALYZE TABLE just so MySQL can get some idea of the distribution for the indexed columns. It might help the optimizer make a better decision if it's not already doing what's best. If the status column only has a few different values, an index will not be used because the overhead of using the index will be greater than the benefit. If this is the case, you'll be better off without the index, and you could consider one of the two options I rambled about in my previous mail. //C - sorry 'bout that. -- Carl Troein - CĂrdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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: making a dsn-LESS connection
I believe your provider must be a valid db drivermake sure it exists on your machine. you may want to check out www.4guysfromrolla.com they have a great section on asp dsn/dsn-less connections. Hope it helps. Darren S. Ball Software QA Engineer Lucent Technologies - InterNetworking Systems 1 Robbins Road Westford, MA U.S.A 01886 Nothing fancy and nothing Microsoft -Original Message- From: GRC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 2:44 PM To: [EMAIL PROTECTED] Subject: making a dsn-LESS connection I wish to have my asp pages (on an NT 4.0 iis 4.0 machine) connect to a mysql database. I want to have the DSN-LESS type of a connection. This DSN version works: ConnectionString = DSN=myDSNname;User Id=myuserid;Password=aword; However this DSN-less version does not: ConnectionString = Provider=MySQL;datasource=localhost;Initial Catalog=acatalog;User Id=myuserid;Password=aword; The error number and description is this: 3706 : ADO could not find the specified provider Is this error saying that I dont have the NAME right? or is it that I don't actually have the provider (the ole db or whatever dll etc) on my machine ? More to the point, does anyone know what the correct connection string value should be? thanks Harry - 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
mysqld daemon ended on first connection
Hi, My server just crashed yesterday nite. After I got it up and running again, I couldn't get connection to MySQL database. Mysqld processes are checked and verified running upon booting up. But it just went dead after I tried to get a connection thru mysqladmin!! It just says error connecting to server at localhost. /etc/hosts has been checked and the entry for localhost is found in it MySQL version is 3.22.32 and is currently running on Redhat 6.2. What could be the possible reason? Could it be permission problems? I have already carried out a repairing and reindexing of the database tables but to no avail! Please help... Thanks, Darren
Build problems.
apologies if this is documented somewhere, but i have found much of the material confusing. I am attempting to build mysql-3.23.39 on a sun Solaris 2.6 box, with the languages / utilities installed. 1. perl5.6.1 2. GNUmake 3. GNUm4 4. GNUtar 5. apache1.3.19 6. autoconf-2.13 7. automake-1.4 8. gawk-3.0.4 9. bison-1.28 through documentation i can see there are a number of ways to install the mysql 1. compile the source (currently i am using this), but i have hit problems that suggest i don't have the relevant C++ libraries for my gcc complier. a. Installing the libstdc++-2.8.1.1 should rectify this? compiling the source for this is a problem , producing unhelpful errors after a lengthy configure process. if somebody can provide docs on how to install these libraries successfully i would be keen to hear about, either as the precompiled binaries or the source code. b. mysql documentation recommends that In this case, you can remove the code in `configure' that tests for the C++ compiler and then run `./configure' with the `--without-server' option - can anybody throw light on what the without server option is about? 2. use binaries (not used yet). [EMAIL PROTECTED] TEL 020 7710 2800 www.netpoll.net Netpoll Ltd 9-12 Long Lane London EC1A 9HA This message contains confidential information and is intended only for the individual or entity named. If you are not the named addressee you should not disseminate, distrribute or copy this email. Please notify the sender or [EMAIL PROTECTED] immediatly by email if you have received this email by mistake and delete this email from your system. Email transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupt, lost, destroyed, arrive late or incomplete and may contain viruses. The sender therefor does not accept liability for any errors or omissions in the contents of this message which arrise as a result of email transmission. If verification is required please request a hard copy version. This message has been scanned for viruses with Trend Micro's Virus Wall - 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
AIX recommendations
This note is primarily meant to stuff something into the archives in case other people have problems compiling mysql under AIX. There are a number of changes that need to be made that aren't detailed in the documentation, (some alteration to those docs could save someone a lot of effort in the future). I don't know how universal this is so I will say that this works under AIX 4.2.1 for mysql 3.23.37 using gcc 2.95.3 To begin with, you may need to use the following config as opposed to the one given in the docs... CC=gcc -pipe -mcpu=power -Wa,-many \ CXX=gcc -pipe -mcpu=power -Wa,-many \ CXXFLAGS=-felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr/local/mysql --with-low-memory The key change here is the -mcpu, the docs specify power2, but that causes compiles on older equipment to toss out bad assembly code. Determine what your cpu is if you are experiencing errors that indicate that problem. Typically power2, power, or powerpc may need to be used, alternatively you might need to use 604 or 604e. I'm not positive but I would think using power would likely be safe most of the time, even on a power2 machine. If you don't know what your cpu is then do a uname -m, this will give you back a string that looks like 000514676700, with a format of xxyymmss where xx and ss are always 0's, yy is a unique system id and mm is the id of the CPU Planar. A chart of these values can be found at http://www.rs6000.ibm.com/doc_link/en_US/a_doc_lib/cmds/aixcmds5/uname.htm This will give you a machine type and a machine model you can use to determine what type of cpu you have. Next, after configuring, edit config.h and change the line that says #define HAVE_SNPRINTF 1 to #undef HAVE_SNPRINTF Do the same for include/my_config.h There is probably a better way to handle that that would address the issue for the entire source but I didn't take the time to find it nor did I stumble across it. And finally, in mysqld.cc you need to add a prototype for initgoups. #ifdef _AIX41 extern C int initgroups(const char *,int); #endif After doing this, I had a version of mysql that I could compile and install. Hopefully there aren't any bugs waiting for me as a result of these changes. I'm seeing test failures for tests rpl15 and rpl16 that I haven't dug into yet but everything else looks ok. Darren Henderson [EMAIL PROTECTED] [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
MySQL Failing in Runlevel 5 on SuSE Linux 7.1 Pro
Hi I've recently installed MySQL onto suse linux 7.1 pro using the YaST2 installation program. When my system restarts a mesage saying that mysql has failed in runlevel 5 appears, however the database does appear to be running as I can connect to it via the mysql client and view databases etc. I would be very grateful if anyone has advice that would enable me to track down the cause of the message and the problem (if there is a problem). Many Thanks Darren Watson Web Developer e-mail: [EMAIL PROTECTED] www.e-skylark.com Evans House Monckton Rd Wakefield WF2 7AS