RE: Perl DBI DBD Show Table Modules Best Dir Install Choices!
Bob, As soon as you compiled and installed perl itself, the Config module of perl will tell any Makefile.PL driven package where to install itself: under the directory structure of perl. I don't know for sure, but I suppose DBI DBD installs via Makefile.pl script... If not, do a perl -V to see where @INC is pointing to. somewhere in that structure your DBI should be installed, so that all programs in Perl can find it without messing with @INC. Cheers, Guus PS: database,sql,query,table for the antispam rules... -Original Message- From: bobby [mailto:bobby]On Behalf Of rjtalbo Sent: Saturday, September 15, 2001 9:08 PM [snipped] Where is the most common and preferred Location for the Install?? [omitted] - 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: load level on linux mysql server out of control
I'ld suggest you guys round back to the version of MySQL that didn't have this problem, and try to figure out, possibly by giving MySQL AB access to the server(s), or installing a debuggable executable, what the problem is... Obviously, if two people are hit, the problem must be other than their env / code. Just my $0.02, Guus -Original Message- From: Henning Schroeder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 2:07 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: load level on linux mysql server out of control At 01:46 11.09.01, you wrote: I'm having a lot of trouble tracing the origin of the problem -- sometimes it seems that accessing a particular large table is causing it, sometimes it seems that a combination of factors is causing it. Regardless, what I observe is that within 1 minute my load level climbs from between 2 and 4 to over 100, which I have never seen on any *nix system before. The RAM utilization is high, but not over 85%, and the CPU utilization fluctuates of course but stays below 40% user until whatever is causing my problems happens, and then it jumps to 100% and doesn't come down until I kill mysqld and let everything close. hi, same problem here. mysql 3.23.41, apache 1.3.20, php 4.0.6, kernel 2.2.19, debian system. 1GHz PIII 512MB. load 200. my fix for now till i have a better idea is to restrict the number of apache children to 60 which keeps the load 20. which is horrible nevertheless. and extremely slow for the users at times. the load normalizes (to something 4-ish, which is still pretty high for ~50q/s) again after ~15min. if you find out anything about that problem, PLEASE tell me. i´m searching for ~3 weeks and i´m not smarter in the least. and it sucks :-( at least i didn´t have that harddisk failures. yet. but then, it´s a colo machine so power should be fine. yes, dear mailing list, i know you told me my queries are, well, suboptimal. but i´m not quite sure about that. more tomorrow:-) greetings henning - 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: ASP MySQL
-Original Message- From: L_U_I_Z [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 9:08 PM To: [EMAIL PROTECTED] I'm developing an application and I have to choose a good database server. I guess that's not the only choice... I'm considering MS SQL Server and MySQL. I haven't heard very much about MySQL, but from I've read on the web I think MySQL is Unix/Linux orientated and works well with PHP. True, but MySQL has an exellent ODBC module as well. It's called MyODBC. I'm going to use a NT platform, with the IIS as web server, and I wanted to use ASP. Does MySQL fit good with IIS and ASP? Now, with this env, you want to check out how big your application might become and shed light on aspects like scalability, ease of backup and restore, etc. Especially Microsoft made some very good progress in this area with MS SQL 2000... OTOH, MySQL is very simple to backup / restore. MySQL is also quite scalable when it comes to seperation of readers and writers (replication). Now, back to your question. As far as my experience is concerned, the Microsoft products work very well if left in a Microsoft-Products-Only-Environment. The big problem that remains is that you need to understand how to install the products in order to guarantee long life time. I don't know about performance of IIS/MySQL vs IIS/SQLServer2000, but I guess MS has the top hand here as well. OTOH, if your choice was somewhat free, I'ld rather use Apache/PHP/MySQL combination: 1st: Cheap Solution (OS + Web Server + DB all for free...) 2nd: Proven Record of Quality (PHP is the most widely used language in Server Side Scripting...; Apache has a proven record of being the most used web server...) 3rd: Yahoo uses MySQL for certain (if not all) areas, and they seem quite happy. 4th: (From my own experience) MySQL virtually never crashes... last but not least: Monty and Team, and this list are very actively participating in helping people out with their problems. Just my 0.02$, Guus - 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: slow querys
What about SELECT id FROM table WHERE ok=1 AND type=1 and field like '%text'. MySQL would have chance to create a temp table, reduce its contents via ok=1 AND type=1 and then do the expensive like '%text%' matches... Just my $0.02, Guus -Original Message- From: Osus [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 4:17 PM To: [EMAIL PROTECTED] Subject: Re: slow querys Hi, The slow queries are those like... SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1 where table have about 20.000 records and field is a text field. I need to find ALL the records that have text, even if text is a i have to find all the records that have one a. Many of that querys take 16 or 20 seconds. what do you think? - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Jesus [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 22, 2001 12:08 AM Subject: Re: slow querys On Tue, Aug 21, 2001 at 10:04:58PM +0200, Jesus wrote: Threads: 12 Questions: 107446 Slow queries: 485 Opens: 88 Flush tables: 1 Open tables: 82 Queries per second avg: 42.722 -- Why have I so many slow querys??? I can't understand, but the performance get down. I have Mysql/apache/php it's a web aplication what can i do? Enable the slow_query_log as described in the manual. Use the information there to determine which queries are slow. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 4 days, processed 56,743,183 queries (142/sec. avg) - 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 - 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: regarding mysql software
Dear Chetan, which version did you download (and from which site :)? What OS are you running on? Can you give an exact transscript of the command you used and the output it generated? (Eventually parts of config.log might help as well.) (Checked the archive at www.mysql.com, but could not find any useful note on this particular problem quickly...) Guus -Original Message- From: chetan merai [mailto:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 6:20 AM To: [EMAIL PROTECTED] Subject: regarding mysql software database ,sql,query,table Dear sir, I , chetan merai ,want to know about the installation problem that i am having with mysql. After downloading from net , and then using other commands when i use the command ./configure , I get the following error: error:can't find sources in . and .. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.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: mysql.org
-Original Message- From: Marten Mickos [mailto:[EMAIL PROTECTED]] cut /cut serious Our interpretation is that even under the interim agreement, the operation by NuSphere of mysql.org would have been a trademark violation. Then, Marten, tell us what the status is of the trademark application? Under way, finished, or in the mail as suggested by the other post from Sander Pilon? (I don't know about US legal aspects here, but I'ld assume in the mail is rather different from finished...) morecuts /morecuts /serious halfwayserious And yes, if Britt would agree, you might post documents like the interim agreement and the termination thereof. Of course, this would involve posting the journal of the faxed termination, and a statement from Britt that NuSphere actually received it. Fax communication sometimes don't work... (An aspect sofar not discussed...) The track of needed documents will grow quite rapidly here. You might want a 3rd party, not-for-profit web site to publish it all. (Something like www.mysql-open-source-legal-resolution.org hosted by NuSphere *evilgrin*. This would be an application of broad name related usage rights...) /halfwayserious serious In any case, 1) Money always is the reason why a company is in business to do business. 2) As Tom DeMarco writes in one of his latest books, lawyers don't add much, since they cost money, take you out of your business, which is making money, and tend to destroy all good faith one would have for another. ... Not to disrespect either party, but I'm not to take a stand as I don't know any of the NuSphere products around MySQL. Take care of yourself, and eachother, Guus Short-time Mysql user. /serious PS: table, query, sql, database - 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: I am facing this error [ Urgent ]
Hi, What kind of Platform, MySQL Version, etc.? is the mysql daemon running? Guus -Original Message- From: Syed Sumair [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:12 AM To: [EMAIL PROTECTED] Subject: I am facing this error [ Urgent ] cut Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /web/sites/188/pisps/www.pisps.f2s.com/signup/index.php on line 372 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - 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: conflicts with new version
-Original Message- From: Richard Kurth [mailto:[EMAIL PROTECTED]] I am trying to reinstall mysql on a cobalt server I removed the first version but when I go to install the new version I get this message below saying it conflicts with another version could you tell me how I can correct this. I have looked through the entire directory structure and can not find any other files that relate to mysql file /etc/logrotate.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /etc/rc.d/init.d/mysql from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamchk from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/isamlog from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_install_db from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 file /usr/bin/mysql_zap from install of MySQL-3.23.39-1 conflicts with file from package MySQL-3.22.32-1 [ snipped for brevity ] Richard, obviously, you used rpm (or similar) to install 3.22.32-1. you also treid to re-install 3.23.39-1 with rpm (or similar). If so, please do a rpm -f mysql.rpm. This will freshen your current installation, and removes the 3.22.32-1 references from the rpmdb. For more information, please visit man rpm. Cheers, Guus - 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