Concurrent insert/select with BDB
Hi I'm using MySQL 3.23.32 on Linux. I try to run concurrent insert/select requests on BDB tables, but it doesn't work. I started mysqld with --bdb-shared-data option. I run mysql on 2 clients (on the same computer). The first one runs a select request and the second one runs an insert request. If I use autocommit, the insert waits for the end of the select. If I don't use autocommit, the insert waits for the commit of my first client. Did someone ever use concurrent insert/select with BDB databases ? Are there some special parameters to initialize, to allow insert and select at the same time (it doens't matter for me if my first client reads duplicated records). Thanks a lot ! __ Philippe Morin - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.com ___
INSERT...SELECT
Hallo to all! I have troubles with one particular INSERT...SELECT. I have found no example in the manual and other -general- advices on the net do not work with MySQL. Could anyone help me with this: I have four tables. I would like to insert specific records from table1 to table 2 in column1, specific records from table3 to table2 into colum2, moreover, columns in the table3 are defined with respect to table4 (based on id). This means that I have to fidle with 4 tables to insert records into one table and need to use quite long select statements. Could any of you advise me advanced SQL language manual specifically for MySQL?? This would be of GREAT help (General books do not help, I have several of them already...;-( Thank you a lot, Jan - 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
SV: HOW DO I CAN DO THIS... you CANT!
Hiya Tonu You seem to have big problem - not of how a database works, but of what a database and webpage can actually do. I'm not trying to sound like a smart-ass, but I suggest you go and take a look at this URL : http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html It helped me getting started with PHP and MySQL. And you just might get an idea of WHAT a database can do. PS : Please fix that annoying CapsLock-key! Yours sincerly Jacob "Techek" Kamp Hansen - webmonkey at Portaltjenesten A/S - developer at Amante.dk -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]P; vegne af Tnu Samuel Sendt: 9. februar 2001 08:28 Til: MAN ...; [EMAIL PROTECTED] Emne: Re: HOW DO I CAN DO THIS... "MAN ..." wrote: HI THERE, I HAVE A PROBLEM WITH THE ETTIQUETES OF THE DATABASE, I MEAN HOW DO I CAN MAKE A SITE WHERE I CAN UPLOAD INFORMATION WITH A DATABASE, FOR EXAMPLE: IF I WANT A PAE WHERE SAYS "PUT YOUR NAME HERE" AND YOU HAVE TO PUT IT IN AN TEXTAREA HOW DO I MAKE THAT THAT NAME CAN GO TO MY DATABASE I TRIED PUTIN' THIS FORM NAME="AND HERE I PUT THE DATABASE'S NAME" METHOD="GET" ACTION="URL OF THE DATABASE" INPUT TYPE="" NAME="CAMP NAME"BRINPUT TYPE="SUBMIT" VALUE="UPLOAD" BUT I DIDNT GET THAT IT ONLY OFFERS ME TO DOWNLOAD THE DATABASE. HELP MEE Read the manual please. And also please buy new keyboard with working CapsLock key. Current keyboard annoys users. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - 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
SV: Simple datatype question
Hiya Joel You're right, but have a look at ENUM (and SET later on!). The ENUM-type can be defined as being either 'yes'/'no', '1'/'0' or even 'Techek'/'Joel' *hehe* Happy coding! Yours sincerly Jacob "Techek" Kamp Hansen - webmonkey at Portaltjenesten A/S - developer at Amante.dk -Oprindelig meddelelse- Fra: Joel Holtzman [mailto:[EMAIL PROTECTED]] Sendt: 9. februar 2001 08:21 Til: [EMAIL PROTECTED] Emne: Simple datatype question Hello, I'm looking at the manual, and I cannot find the answer to this simple question. What is the datatype in mysql for boolean? In Access it's yes/no. What about mysql? Thanks Joel - 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
BACKUP command external script.
I am wondering, if it is possible to use MySQL and create a shell script to backup tables from a database on a cron? If anyone has an idea if this is possible, and how I might go about it, it would be much appreciated! Thank You - Tim -- Tim Dachtera - [EMAIL PROTECTED] http://www.siliconco.com Web Designs - Consulting - IT Solutions 612-282-1328 / ICQ:8751060 - 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 error 2002
I am getting this error ERROR 2002: Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock' (111) I am running redhat 7, apache, and PHP on this machine. It is preventing me from starting the sql server, however, I'm able to bypass this with safe_mysqld --skip-grant-tables Any idea how to fix this problem? Also, I'm a mySQL newbie. How does one add a database to mySQL? Where do I put it, is there something like the Windows DSN to set up? - 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
How I can delete date from tables concerned with indexes?
Hello! How I can delete date from tables concerned with indexes? For example: DELETE FROM table1,table2 WHERE table1.table1_id = table2.table1_id and table2.status = 'example'; or DELETE FROM table1 WHERE table1.table1_id = table2.table1_id and table2.status = 'example'; Best regards, WebDesign Cityline Andre Gorben [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
Threads
Hi, our problem is that we are having more and more threads of mysqld (on Linux), so that we get a "too many connections" error. Are the threads terminated automatically? How are the threads generated? Ghaleb - 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: How many tables in a database?
I have 6500 tables under one database there is no problem i hope that helps :) -- Kissandrakis S. George [[EMAIL PROTECTED]] Network and System Administrator [http://www.phaistosnetworks.gr/] Tel/Fax: (+30 892) 24450/23206 Phaistos Networks S.A. - A DOL Digital Company - 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: Client library - Exception handling?
Chris Hundley writes:
Are you suggesting that I look at the mysql++ code as an example, or actually use the
mysql++ code instead of the "mysql.h" included libraries?
Chris
HI!
You can not look at mysql++ code and code like that with C API.
You should either use C API (therefore no try {} catch{}) or use C++
API instead of C API.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: how do I contribute a binary distribution?
Eric Sven Ristad writes:
How do I post a new binary distribution for inclusion in the page
http://www.mysql.com/downloads/mysql-3.23.html
?
I would like to contribute a standard binary distribution for DEC OSF
4.0D (Alpha) [mysql-3.23.32-dec-osf4.0d-alphaev56]. Compiling mysql
on this platform is a major pain, requiring operating system patches,
painful gcc/gmake upgrades, as well as makefile editing. So I would
like to save someone else the trouble if possible.
Please reply directly to me.
Thanks,
Eric
-
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
Please send your contribution to
ftp://support.mysql.com/pub/mysql/Incoming and let me know it's full
path name.
Please try to build all binaries static, if possible.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: Please help with mysql++...I'm very frustrated.
Mike W. Baranski writes:
All of the examples from teh mysql++ docs show hte connection as:
Connection con("mysql_cpp_data");
whenever I run this statement, I get a seg fault. What is the problem?
My permissions are okay, I don't need any for mysql. Someone please
help, I'm stuck here and this is not good. I'm using RedHat 7 and gcc
2.96.
MWB.
--
*
Mike W. Baranski
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Web : http://www.secmgmt.com
Phone: 919-788-9200
Fax : 919-510-0037
P.O. box 30099
Raleigh, N.C. USA 27622
*
Ha,
2.96 !!!
It will NEVER work.
You MUST use 2.95 , or nothing in mysql will ever work for you !!
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: Crashing in win2000
Jamie writes:
I'm finding that msql 32-bit is somehow crashing when ever I play audio -
either from a CD in my CDrom or m3ps via Creative player II and winamp
respectivly. Does anyone else know of this or experienced this?
Jamie
Hi!
This is a list for MySQL, not MSQL.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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: BDB
When using the BDB tables and RedHat 6.2 or 7.0, should --skip-locking be used or not? I know it was recommended for earlier versions of RedHat, like version 5.x. Thanks in advance, Rick - / Rick Mehalick Senior Consultant / Shell Services International SSI-GPAX / Phone: 281-544-5092(WCK) / Fax:281-544-2646(WCK) / email: [EMAIL PROTECTED] - -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 08, 2001 6:49 PM To: Peter Zaitsev Cc: [EMAIL PROTECTED] Subject: BDB Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello mysql, Peter 1) Today I tried to reload my tables with backuing up and recovering Peter whole database by mysqldump - it seems like it does not work - Peter mysqld crashed during loading data back even after I've removed all Peter bad tables and bdb logs to have a clean system. Peter This looks like the same problem as I reported with insert test - Peter BDB hanges/crashes during huge multiple insert queries. Peter I've uploaded the mysqldump output wich crashes mysqld during load Peter to the secret directory as layers_la00.sql.gz. Peter The thing is after I've dumped the same data without the extended Peter insert I could load it back without any problems. I will look at this as after the weekend. Peter 2) Then I was loading the data from .sql file I saw the followings: Peter onyx:/spylog/db # mysqladmin processlist | grep -v Sleep Peter +-+---++-++--+-- -+-- + Peter | Id | User | Host | db | Command| Time | State | Info | Peter +-+---++-++--+-- -+-- + Peter | 34 | root | localhost | la00| Field List | 494 | Repair by sorting | | Peter | 36 | root | localhost | lacontrol | Query | 64 | System lock | insert into layers_la00.g00keywords (counter_id,keyword) values (106339,'RSBAC') | Peter | 38 | root | localhost | la00| Field List | 468 | Waiting for table | | Peter | 39 | root | localhost | layers_la00 | Query | 0| update | INSERT INTO g03dirs VALUES (110912,8288,'pictures/company/itartass/calendar')| Peter | 81 | root | localhost | la00| Field List | 296 | Waiting for table | | Peter | 121 | titan | php.local | counter | Query | 5| System lock | SELECT lsh.begin AS period, sh.hosts7d,sh.visitors7d Peter FROM layers_la00.g00layers_stat_hits AS ls | Peter | 125 | root | localhost | | Query | 0| | show processlist | Peter +-+---++-++--+-- -+-- + Peter as you see here one thread is doing repear as this happened after Peter mysqld crash, but note first insert query in system lock state (I've Peter saw several queries at this place, but all of them spent in system Peter lock time several tenths of seconds) this can nothing to do with Peter recovery (this table was just created by mysqldump couple of minutes Peter before) - I habe the only explanation which looks ok the system lock Peter takes place while many inserts are going to othe table (g03dirs) - as Peter soon as the table changed all other queries which was in system lock Peter state got a chance to run. The other thing is mysqldump does not uses Peter lock tables to insert data so this looks like real perfomance Peter (concurency) problem Some Peter more examples: The "System Lock" means that you got some problem with fnctl() on your system. The fix is to restart mysqld with --skip-locking and without --enable-locking to ensure that fcntl() lock is not used. If you are using 'mysqldump --opt', it should generate locks for the tables. What command did you use ? Peter onyx:/spylog/db # mysqladmin processlist | grep -v Sleep Peter +-+---++-+-+--++ --+ Peter | Id | User | Host | db | Command | Time | State | Info | Peter +-+---++-+-+--++ --+ Peter | 36 | root | localhost | lacontrol | Query | 384 | update | replace into layers_la00.g00stat_404refs (layer_id,id,visitors,loads,hits) values Peter (2,2,0,4,0), Peter (2,9, | Peter |
Need help with Install of MySQL
I am new to MySQL and have just installed the MySQL rpm files to my Linux box. I have run "mysql_install_db" with no problems and I have then run "safe_mysqld " this comes up with the messsage "starting mysql daemon with databses from /var/lib/mysql mysqld daemon ended" I assumed that this was corrected and then ran "mysqladmin version" to which i recieved the following error message "can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) check that mysql is running and that the socket /var/lib/mysql/mysql.sock exists" I can not find any mysql processes running when I type "ps" and I cannot find any sock files anywhere. What am i doing wrong can somebody please please help. Thanks Matt Davis. - 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: How to create table in this case
Hi, Thanks for your comments. In this table the entries would look like this: student_id hour_of_day day_of_week week_of_course 1 1 1 1 6 1 1 1 14 1 1 1 Thus the table will have as many identical rows except in one column as there are absentees in particular session. My doubt is isnt it reduntant and is there any other ways of doing things without this redundancy? I am newbie to databases (just a few weeks) Suresh On Fri, Feb 09, 2001 at 09:26:49AM -, Russell King wrote: From: Suresh Kumar R [EMAIL PROTECTED] I want to have the absentee list of students per hour_of_day per day for a week, done for the entire course. One possibility I thought was to create a table with date and each hour of the day as columns, then each cell would have to have variable number of student roll nos who are absent for that particular hour and I dont know how I can enter an array of numnbers. I think the best method to deal with this is just have a single table containing : student_idint hour_of_dayint day_of_weekint week_of_courseint One assumes a student is present for all classes. If a student is absent, an entry is made in the table, recording the student's number, and the time/day/week they are absent. It is more elegant to record the date using a date field, but it will complicate your subsequent select queries, so I would use the above design in your case. This has the added advantage of only storing data by exception. Russ. -- Suresh Kumar.R, Dept of Electronics Communication College of Engineering, Trivandrum - 695 016, INDIA Phone: (O) 91 471 595634 - 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: BACKUP command external script.
My script backuping up alla databases which is in my datadir. It's works for me. #!/bin/sh USER=root PASSWORD=somepassword BACKUPTYPE=daily if [ -x $BACKUPTYPE ] then echo "$0 Backup typ" exit 0 fi for i in `ls /var/mysql|grep -E -v ".pid|.err"` ; do DB=$i ; DATE=$BACKUPTYPE ; rm -rf/home/backup/mysql/$DB\_$DATE.sql.gz ; /usr/local/mysql/bin/mysqldump -u $USER -p$PASSWORD --opt $DB /home/backup/mysql/$DB\_$DATE.sql ; /bin/gzip /home/backup/mysql/$DB\_$DATE.sql if [ ! -x $2 ] then echo "Backing up: $i" fi done On Fri, 9 Feb 2001, T. Stephen Dachtera wrote: I am wondering, if it is possible to use MySQL and create a shell script to backup tables from a database on a cron? If anyone has an idea if this is possible, and how I might go about it, it would be much appreciated! - 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: Help with SQL statement please.
I hope somebody may of come across this sort of problem before dealing with counting total records in subcategories. I have two tables sslinks which contains links (URL) information and sslinkcats which contains category information. The category table "sslinkcats" has a field called "lcat_id" (which is an autonumber) and also "lcat_cat" which is the "lcat_id" value of the parent category. For example cricket would be under sport and the "lcat_cat" of cricket would be "lcat_id" of sport. The problem is that the below statement will only count the number of links in each particular category. $sql = "SELECT sslinkcats.lcat_id, COUNT(*) AS NumLinks FROM sslinks, sslinkcats WHERE link_cat = sslinkcats.lcat_id AND link_validated = 'yes' GROUP BY link_cat"; I want to display the total amount of links under the category sport to include all subcategories like football,cricket,cricket rugby. Also if cricket had subcategories, then I would these counted too. I am sure the answer is looking at me but I just can't see it. Therefore any pointers or assistance would be very welcome. (ps. If you have read this message before, apologies but I was informed that this is the correct category for this type of question. Sorry) Sir, since you have chosen the tree structure approach rather than the relational database approach, I'd recommend reading 'SQL for Smarties' by Joe Celko. There are two chapters on dealing with tree structures in SQL. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - 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
libz.so.1 error
Greetings, I get this error msg:: Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! however /usr/local/lib/lib.z.so.1 does exists...and I did NOT create the mysql:mysql user... Any suggestions..? donnie - 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: Need help with Install of MySQL
Matt, I'm fairly new to MySQL myself, but it sounds like your mysqld is not starting up when you issue safe_mysqld. Instead of invoking safe_mysqld directly, find the "mysql.server" file that got installed with mysql, and start mysqld with that by doing something like: cd /dir/to/mysql.server ./mysql.server start There's quite a bit more to consider, like what user you want to start the server as, but try that first and see if that will start the server for you. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Matt Davis [[EMAIL PROTECTED]] wrote: I am new to MySQL and have just installed the MySQL rpm files to my Linux box. I have run "mysql_install_db" with no problems and I have then run "safe_mysqld " this comes up with the messsage "starting mysql daemon with databses from /var/lib/mysql mysqld daemon ended" I assumed that this was corrected and then ran "mysqladmin version" to which i recieved the following error message "can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) check that mysql is running and that the socket /var/lib/mysql/mysql.sock exists" I can not find any mysql processes running when I type "ps" and I cannot find any sock files anywhere. What am i doing wrong can somebody please please help. Thanks Matt Davis. - 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
Antwort: Re: How many tables in a database?
On 09.02.2001 12:01:01 Kissandrakis S. George wrote: I have 6500 tables under one database there is no problem Pardon me, but how do you keep track of that many tables? I mean, I've a hard time with 10 or 20 tables - but 6500??? - 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: Space problem?
Wyatt James wrote: I am getting a misleading error message saying "duplicate key 127 at key 1" when trying to add an item to a table. There is no duplicate (I downloaded then uploaded to a new table and get the same error). The unique key is a smallint(4) with auto-increment. Is there some limit in MySQL on a Linux server on how many entries a table can contain? Each row is only about 1K in size and I read somewhere that you can go up to 2gig on a table size. Are you sure key is not a tinyint? 127 is the largest value for a tinyint. - 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: libz.so.1 error
On Fri, 9 Feb 2001, del wrote: Installing all prepared tables ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or directory Killed Installation of grant tables failed! however /usr/local/lib/lib.z.so.1 does exists...and I did NOT create the mysql:mysql user... Any suggestions..? This depends on your OS. On SCO OpenServer or UnixWare this is needed. LD_LIBRARY_PATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib:/usr/local/mysql/lib/mysql:/usr/local/BerkeleyDB.3.2/lib LIBPATH=/usr/lib:/lib:/usr/local/lib:/usr/ccs/lib: export LD_LIBRARY_PATH LIBPATH Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - 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: How to create table in this case
Hi, On Fri, Feb 09, 2001 at 05:51:08PM +0530, Suresh Kumar R wrote: In this table the entries would look like this: student_idhour_of_day day_of_week week_of_course 1 1 1 1 6 1 1 1 141 1 1 Thus the table will have as many identical rows except in one column as there are absentees in particular session. My doubt is isnt it reduntant and is there any other ways of doing things without this redundancy? You are right in general. And you can move last 3 fields to another table, add id column and insert student_id and chunk_id into the absence table. But I would not go this way unless you want to use those chunks somewhere else. If you don't want to use 3 fields you can replace them by calculated numeric value. For example: time_chunk = hour_of_day + day_of_week * 100 + week_of_course * 1 In my opinion, it will give you another advantage. Instead of select * from absence where hour_of_day = 1 and day_of_week = 1 you will write select * from absence where time_chunk = 101 I am calling it an advanantage because as far as I understood MySQL is not efficient in where clauses at least sometimes. On Fri, Feb 09, 2001 at 09:26:49AM -, Russell King wrote: From: Suresh Kumar R [EMAIL PROTECTED] I want to have the absentee list of students per hour_of_day per day for a week, done for the entire course. One possibility I thought was to create a table with date and each hour of the day as columns, then each cell would have to have variable number of student roll nos who are absent for that particular hour and I dont know how I can enter an array of numnbers. Never go this way (excuse me please for so strong phrase). What if you want to detail your absence to half an hour, quarter of hour, minutes. Ok, if you are not convinced yet... to seconds :-) In my personal experience, you never know :-) So, please, don't tell me: "I will never go this way!" I think the best method to deal with this is just have a single table containing : student_idint hour_of_dayint day_of_weekint week_of_courseint One assumes a student is present for all classes. If a student is absent, an entry is made in the table, recording the student's number, and the time/day/week they are absent. The bottom line from my point of view is the solution is quite good, but I would consider a formula instead of last 3 fields. Hope it helps. -- Lumberer. - 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
Persistant Connection
Good Morning: We have a system of databases (in the plural) which number in the hundreds on individual servers. I want to open a persistant connection on the server and switch databases without closing the handle in DBI and reopening it. Is this possible without getting a rollback warning using DBI? Ruben -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - 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
[Fwd: Re: Rotating the BINLogs]
I'm not the only one confused. Any ideas? Original Message Subject: Re: Rotating the BINLogs Date: 9 Feb 2001 12:37:03 -0300 From: "Rodolfo Sikora" [EMAIL PROTECTED] To: Leonardo Dias [EMAIL PROTECTED] I'm really confused like you. I've been using flush logs on master... I don't know exactly how to use PURGE MASTER LOGS TO, RESET SLAVE and RESET MASTER. If you learn how to use them, please send me an email. Tkz. = Hi there, we have two databases replicating perfectly now, though we have a big doubt now: How should we rotate the binary logs without a problem? I was checking out the PURGE MASTER LOGS command in the Manual. The text below was taken from there: "Available starting in Version 3.23.28. Deletes all the replication logs that are listed in the log index as being prior to the specified log, and removed them from the log index, so that the given log now becomes first. Example: PURGE MASTER LOGS TO 'mysql-bin.010' This command will do nothing and fail with an error if you have an active slave that is currently reading one ofthe logs you are trying to delete. However, if you have a dormant slave, and happen to purge one of the logs it wants to read, the slave will be unable to replicate once it comes up. The command is safe to run while slavesare replicating - you do not need to stop them. You must first check all the slaves with SHOW SLAVE STATUS to see which log they are on, then do a listing of the logs on the master with SHOW MASTER LOGS, find the earliest log among all the slaves (if all the slaves are up to date, this will be the last log on the list), backup all the logs you are about to delete (optional) and purge up to the target log." So that, from what I've understood, when I do a PURGE MASTER LOGS TO 'mysql-bin.010', it will delete all the prior logs and start a new log called mysql-bin.010 as being the one to index. And then? What should I do? Should I run CHANGE MASTER TO in the SLAVE, so that it would now read from mysql-bin.010? The current bin log is getting too large and I'm not really sure about what should I do specifically. I've read somewhere in the manual that what could be done is: one locks all the tables and do a reset master and a reset slave. I don't think that would do it either. Has anyone come up with another idea to fix this problem? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - 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
What is involved in running ASP scripts, MySQL SERVER on Cobalt Raq3
Just what the subject said. What is this going to take to get ASP talking to a mysql database on a Cobalt Raq 3 Server(A flavor of Linux). Is it costly? What is it going to take? Thanks BK - 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
FULLTEXT
I have a query that works :
$sql = "SELECT questions.qid, questions.title, MATCH questions.title,
questions.question AGAINST ('support') as relavance FROM questions ORDER BY
relavance DESC LIMIT 0, 50";
I would like this query to also match results from the field respons in the
table respons.
I tried this without help :
$sql = "SELECT questions.qid, questions.title, MATCH questions.title,
questions.question, respons.respons AGAINST ('support') as relavance FROM
questions, respons WHERE questions.qid = respons.qid ORDER BY relavance DESC
LIMIT 0, 50";
Can you help ?
-
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
rpm files and source distribution
Hi, I am trying to install the MySql rpms or source distribution to my RedHat 6.2, when I install the rpms, I always get an error "Query of MySQL-3.22.32-1.i386.rpm failed.", if I download the source packages, I can not unzip it because it is not complete. Have you met this error before? Thanks, Wanggui *** Wangui Li [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
How do tables break?
I'm had the exact same problem. I believe it happened becuase my the drive was full when I tried to make an insert. But now I can't seem to access that table at all. I've been able to get in the actual file, mine is call Elemenets.MYD but I can't do anything with it. ANy help would be great. I don't have a backup of the db. thanks, michael - 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
RedHat 6.2 (re) installation failure
Hi I am running RedHat 6.2 and notice that there are serious problems running MySQL on it. There are lots of posts on the email lists about the the installation hanging at 'Installing all prepared tables'. Users normally manage to do one install, the db runs for a while, then it's impossible to connect, and reinstall fails. Exactly my case. (Tried everything except reinstalling the OS, but i guess MySQL would stop working after a while even if i did that.) I have tried installing 3.23.32 from RPMs and from the binary and it's always the same problem. This has not been resolved yet, has it? It is a very serious issue for us. I have a machine still serving MySQL db's on RH 6.2 and if it quietly stops working and refuses reinstall then we have pretty big problems. Perhaps people should be warned not to run MySQL on RH 6.2? Should the user manual admit this problem? It has been reported for more than 8 months without any progress evident in the mailing lists. I have spent days on the email archives, documentation, my system, all to no avail. Thanks in advance for any help/hints David p.s. for examples of systems reporting this, do a quick search on the mysql.com site. - 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
Load question
We are currently running Blackboard 5 level 1 (an online course management package) which utilizes MySQL v3.22.32. Our previous semesters saw a course load of approximately 85 courses under which, MySQL performed extremely well. This semester, we have skyrocketed to 768 courses. Now, our server (a Sun Enterprise 450 with 2 400MHz Sparc's, 1 GB of RAM, and 30GB of storage in a RAID 5 configuration) is performing extremely slow. Using top to monitor system performance, we are regularly seeing our load factor rise to double digits and MySQL run away with up to 98% (peak) of the CPU time. Blackboard's response to this is that MySQL does not scale upwards very well and, to fix our problem, we will have to switch to an Oracle database (at an increased price). My question is, is Blackboard pulling our leg or does MySQL truly have a problem scaling upwards? Jesse - 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
SQL_SLAVE_SKIP_COUNTER not working
I've been trying a lot and the SET SQL_SLAVE_SKIP_COUNTER didn't work... what should I do then? -- Leonardo Dias Catho Online WebDeveloper http://www.catho.com.br/ - 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
load data infile question
I have a one time load of an extremely large file. It's a tab delimited file, the problem I'm getting is importing the following field. C:\Borland\server\bin\gbak.exe- The field how it looks on the import file (it's delimited by tabs) C:Borlandserver ingbak.exe - How it looks once it is imported into MySql Between the "ver ing" there is a tab character that I can't get to show on this e-mail I think it's interpreting the \b (from server\bin) as a tab character or something. Without editing the entire file how can I get around this problem? I would also like to see the '\' in the database if possible. Following is the load statement that I am using for loading the data. load data local infile "e:/data_in/keyaudit.kau" into table tbl_KeyAudit; MySql version is 3.23.28-gamma-debug Debra Samsom Bristol Aerospace Ltd. (204) 775-8331 3402 [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: Load question
Saying your up to 768 courses doesn't give us much information. How many queries/second is the server handling right now? My machine, which is considerably slower than yours handles 10 queries/second without blinking an eye. When we were experiences an extreme slow down before, we found three issues. One was that we didn't have enough RAM (1 Gig of RAM should be fine). The second thing was that our configuration was not optimized for our system in the least (you HAVE tweaked /etc/my.cnf right?). And the last was that we had 1 bad query. To give you a feel for what 1 single badly written query can do to your performance. When we had this problem, we were doing on average 2 queries/second. 1 out of every 200 or so queries would be the one single bad one. But it turned our load average from the 0.00 - 0.06 range to the 20 - 50 range. Just proof that you really need to see if a single query is to blame. Use a util like MyTop to watch the queries as they happen. If you see one appearing more often than others, take a look at that query. There might be a better way to write it (or use keys more effeciently). - Original Message - From: "Jesse Santana" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 09, 2001 9:08 AM Subject: Load question We are currently running Blackboard 5 level 1 (an online course management package) which utilizes MySQL v3.22.32. Our previous semesters saw a course load of approximately 85 courses under which, MySQL performed extremely well. This semester, we have skyrocketed to 768 courses. Now, our server (a Sun Enterprise 450 with 2 400MHz Sparc's, 1 GB of RAM, and 30GB of storage in a RAID 5 configuration) is performing extremely slow. Using top to monitor system performance, we are regularly seeing our load factor rise to double digits and MySQL run away with up to 98% (peak) of the CPU time. Blackboard's response to this is that MySQL does not scale upwards very well and, to fix our problem, we will have to switch to an Oracle database (at an increased price). My question is, is Blackboard pulling our leg or does MySQL truly have a problem scaling upwards? Jesse - 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: RedHat 6.2 (re) installation failure
David Vender wrote: Hi I am running RedHat 6.2 and notice that there are serious problems running MySQL on it. There are lots of posts on the email lists about the the installation hanging at 'Installing all prepared tables'. Users normally manage to do one install, the db runs for a while, then it's impossible to connect, and reinstall fails. Exactly my case. (Tried everything except reinstalling the OS, but i guess MySQL would stop working after a while even if i did that.) I have tried installing 3.23.32 from RPMs and from the binary and it's always the same problem. This has not been resolved yet, has it? It is a very serious issue for us. I have a machine still serving MySQL db's on RH 6.2 and if it quietly stops working and refuses reinstall then we have pretty big problems. Perhaps people should be warned not to run MySQL on RH 6.2? Should the user manual admit this problem? It has been reported for more than 8 months without any progress evident in the mailing lists. I have spent days on the email archives, documentation, my system, all to no avail. Thanks in advance for any help/hints David p.s. for examples of systems reporting this, do a quick search on the mysql.com site. I have posted replies to dozens of these "Problems" and usually receive a "thanks, that was the problem!" email back. Create a mysql user. Put user=mysql in the /etc/my.cnf file in the [mysqld] section. Make sure when you run mysql_install_db you include the "--user=mysql" option. chown -R mysql "The var directory" Make sure the directory containing the mysql.sock is world readable and searchable. Systems that "Suddenly stop running mysql" have a permissions problem somewhere. - 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: lockup in test suite on SGI
On Friday 09 February 2001 09:19, Robert Marchand wrote: Hi, this is a follow up to my problem with the test suite on an SGI O2 with Irix 6.5.8f I manage to pass through all the tests without problems but a very long 'select' test: select 0,209 0,336 239,115 [pass] but thats another problem. The previous problem I had (hanging in 'delayed' test) seems Select test is supposed to take a while - on PIII 500 with 256 MB RAM running Linux it takes 26 seconds. If your CPU is not that beefy you do not have very much RAM and the disks are slow, 239 seconds is to be expected. du to the CAP_SCHED_MGT privilege as required by the doc. Let me explain: IF I run the tests with root OR with the CAP privilege attached to the mysqld process, the bug appears as said earlier. IF I run the tests with a user without this privilege, the tests are fine. When doing this, threads appears to be OK. I'll now try if this privilege is really required on an Apache-mysql context. That looks like some thread library bug. I would expect it to be the other way around, though. The privilege is required to create global scope threads - you should get errors if you do not have it. However, to be able to see what is up with this, we need to be able to log in to your machine. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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 Codes for MySQL
Hi all. I have a problem with one of my tables. I can get a count of records, or simple selects, but if I go any more complex, I get an error "ERROR 1030: Got error 127 from table handler". I can't seem to find any documentation that further explains these types of errors. Is there anywhere I can go to find out exactly what these errors mean? Thanks, Ben Bass XO Communications - 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
VBScript and mySQL
Hello,
I am having trouble connecting to a mySQL server through VB Script via myODBC...
When I used to use Access I used this script to connect:
Qt = Chr(34)
Set caldb = Server.CreateObject("ADODB.Connection")
caldb.Open "caldb"
Which returned an error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Access denied for user: 'jarntz@MORPHEUS' (Using password: YES)
I tried:
Qt = Chr(34)
Set caldb = Server.CreateObject("ADODB.Connection")
caldb.Open "Driver=MySQL;Server=;DB=cal;UID=jarntz;PWD=thematrix;OPTION=16386;"
which works, but I don't know if it is an acceptable way of doing things...
Any Suggestions... I apologize I am new to mySQL... hence my issue.
Jeremy
Re: Error Codes for MySQL
"Bass, Benjamin" wrote: Hi all. I have a problem with one of my tables. I can get a count of records, or simple selects, but if I go any more complex, I get an error "ERROR 1030: Got error 127 from table handler". I can't seem to find any documentation that further explains these types of errors. Is there anywhere I can go to find out exactly what these errors mean? Thanks, Ben Bass XO Communications You have a crashed index. See the manual on isamchk and myisamchk. - 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
Switching SQL Databases
Hello, I'm delurking to ask if any of you are willing to share your SQL database expertise with me. I'm a features writer working on a story about the issues and problems encountered while switching SQL databases. If anyone would like to share your experience, or find out more about the article, please email me at [EMAIL PROTECTED] Thank you for considering this, Lisa Nadile __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! 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
Queries
Hello, When you create a query, how do you save it? Is there a special command to save a query? Thanks Mark - 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: lockup in test suite on SGI
Hi, the thing is if I start mysql as root with '--user mysql' I get the 'cannot create new thread' thing which is why you put the CAP_SCHED_MGT thing in the manual I suppose. But if I do an 'su' it works just alright without any need of this privilege, and it is only in this context that all the tests pass. I have tested this on three SGI servers and it is always the same: lock (wait on cond) at some point or another when root and no problems when non-root. I'm now testing our IMP (webmail) installation with mysql as non-root (started with su) to see if the locking problem we have is gone (see my other posts in november and december). I'll post confirmation if it works. As for the select test, my machine has only 128 Mb so it could be in the range. The bizarre thing is I've tried it on bigger ones and it took more time (like 400 or 500 s) :-)! Thanks. At 11:39 01-02-09 -0700, Sasha Pachev wrote: On Friday 09 February 2001 09:19, Robert Marchand wrote: Hi, this is a follow up to my problem with the test suite on an SGI O2 with Irix 6.5.8f I manage to pass through all the tests without problems but a very long 'select' test: select 0,209 0,336 239,115 [pass] but thats another problem. The previous problem I had (hanging in 'delayed' test) seems Select test is supposed to take a while - on PIII 500 with 256 MB RAM running Linux it takes 26 seconds. If your CPU is not that beefy you do not have very much RAM and the disks are slow, 239 seconds is to be expected. du to the CAP_SCHED_MGT privilege as required by the doc. Let me explain: IF I run the tests with root OR with the CAP privilege attached to the mysqld process, the bug appears as said earlier. IF I run the tests with a user without this privilege, the tests are fine. When doing this, threads appears to be OK. I'll now try if this privilege is really required on an Apache-mysql context. That looks like some thread library bug. I would expect it to be the other way around, though. The privilege is required to create global scope threads - you should get errors if you do not have it. However, to be able to see what is up with this, we need to be able to log in to your machine. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ --- Robert Marchand tl: 343-6111 poste 5210 DGTIC-SIT e-mail: [EMAIL PROTECTED] Universit de Montral Montral, Canada - 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
[EMAIL PROTECTED] wrote: Hello, When you create a query, how do you save it? Is there a special command to save a query? Thanks Mark Query is just text... if you are in unix under mysql monitor you can do \e on any line after you run the query (and before you type a new one) and it will open the editor you have configured, you can then save it from the editor to wherever you want. - 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
Testing my Eudora Filtering
Sorry to clutter up the list, whici is quiet right now, but i want to test my Eudora filter. Thank you. Dave Anderson Software Engineer Library Management Systems Northwestern University Library Voice:(847)491-8305 Fax:(847)491-8306 Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie Questions
Just got mysql running (Ithink) on Redhat Linux 7. The version is mysqladmin Ver 8.8 Distrib 3.23.22-beta, for redhat-linux-gnu on i386 TCX Datakonsult AB, by Monty Server version 3.23.22-beta-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock So how do I change/add passwords for the users and how do I add users? I tried 'mysqladmin password newpassword' (where newpassword is my password) The response I get is: 'mysqladmin: unable to change password; error: 'You are using MySQL as an anonym' ' So then I switch to superuser and try again. The response I get is: 'mysqladmin: unable to change password; error: 'Table 'user' is read only' ' I try : 'mysqladmin -password newpassword' The response is: 'mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' So how the heck do I do this?? Thanks Lad. Gaal - 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
Please HELP easy ANSWER
Hi Everyone, I have a big problem, that I bet could be solved pretty simply but I am new to mysql so its killing me and my database. Ok heres the problem, suddenly out of no where when my php script tries to (or manually) do a insert it says: ERROR 1062: Duplicate entry '127' for key 1 Now why all of a sudden is this doing this at id 127? This is what my create table statement looks like if this is of any help to you: CREATE TABLE custinfo ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, date date, name varchar(50), card varchar(22), exp_date varchar(7), authcode varchar(8), amount double(4,2), tax double(3,2), pnref varchar(16), address text, city tinytext, state varchar( 3), zip varchar(15), country varchar(2), contact_first varchar(20), contact_last varchar(20), contact_phone varchar(20), contact_ema il tinytext, tickets tinyint(3), description varchar(50), PRIMARY KEY (id), UNIQUE id (id)); Now after I got this message these are some of the things I have tried to solve the problem but of course had no success: I tried isamchk -r and -R, i have even tried it with -rkis and then just plain -kis i pretty much have tried them all and it still gives the same error when i try to insert anything into the list ? What do i do to fix it and what did i do to cause it? Please help me I need this database up and running (loosing money every hour its down!) :( please please please help thank you very much for your time and help. -Steven Steven Fruchter Chief Technology Officer SMR Studios, Inc. [EMAIL PROTECTED] http://www.smrstudios.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
Re: amazingly slow
Hi. You may want to try a combined index (RecordNumber, WordNumber) on wordindex, because the indexes you have can only restrict on field (RecordNumber in the EXPLAIN below) e.g. ALTER TABLE wordindex ADD UNIQUE(RecordNumber, WordNumber); I presume that the RecordNumber/WordNumber pairs are unique (seems so from what your tables look like). If not, you have to replace UNQIUE by KEY. Bye, Benjamin. On Tue, Feb 06, 2001 at 01:49:41PM +0100, [EMAIL PROTECTED] wrote: [...] I did the EXPLAIN as you suggested. Here is the output: mysql EXPLAIN SELECT B.* FROM maintable AS B , - wordindex AS YL1 , - wordindex AS YL2 , - wordindex AS YL3 WHERE - YL1.WordNumber = 123 AND - YL1.RecordNumber = B.RecordNumber AND - YL2.WordNumber = 345 AND - YL2.RecordNumber = B.RecordNumber AND - YL3.WordNumber = 678 AND - YL3.RecordNumber = B.RecordNumber AND - B.Price = 1000 - LIMIT 0,51; +-+--+---++---++ +--+ |table|type |possible_keys |key |key_len|ref |rows|Extra | +-+--+---++---++ +--+ |YL3 |ref |WordNumber,RecordNumber|WordNumber | 4 |??? | 1 | | |B|eq_ref|PRIMARY|PRIMARY | 4 |YL3.RecordNumber| 1 |where used| |YL2 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| |YL1 |ref |WordNumber,RecordNumber|RecordNumber| 4 |B.RecordNumber | 23 |where used| +-+--+---++---++ +--+ 4 rows in set (0.01 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: Performance issues.
Hi. On Wed, Feb 07, 2001 at 03:01:28PM -0500, [EMAIL PROTECTED] wrote: [...] We have one table with all the defintions on it's own row. Then we have built off of that table another table that is only the distinct words, no definitions. This is because if a word has 10 definitions, it makes it hard to limit the number of results returned from the first table to 5 words, because we don't know how many definitions each word has. We have two coloumns that we check the search on. keyWord and vKeyWord. keyWord is basically the non-display keyword. without spaces and junk. We could remove that from the searching, if it'd help. Would that make much of a difference? In your case, yes (see below). So first we do a: "SELECT COUNT(*) AS totalWords FROM keywords WHERE keyword LIKE '$keyword%' OR vkeyword LIKE '$keyword%'" to get the number of entries they can page through. The problem is that MySQL cannot (yet) use indexes well for OR clauses. You can see this with EXPLAIN SELECT COUNT(*) AS totalWords FROM keywords WHERE keyword LIKE '$keyword%' OR vkeyword LIKE '$keyword%'; If you can afford it (as you said above), just let keyword away and test for vkeyword: SELECT COUNT(*) AS totalWords FROM keywords WHERE vkeyword LIKE '$keyword%'; This should be quite fast (provided that there exists an index on vkeyword). Then we do a: "SELECT vkeyWord FROM keywords WHERE keyword LIKE '$keyword%' OR vkeyword LIKE '$keyword%' LIMIT $startWordCount, 5" ($startWordCount depends on which page they are on) And build a list of the words we received. You would have to rewrite this, too. Then we do a: "SELECT * FROM Random WHERE vKeyWord IN ($word1, $word2, $word3, $word4, $word5) ORDER BY ID" And *poof* we have all the definitions for 5 words, and the maximum number of words that there could be. Are we doing anything obviouslly wrong in this? Not really. It's just that MySQL cannot handle the OR well. If you really would need the two conditions, there are work-arounds for that (e.g. creating a temporary table, ...), which I won't elaborate on now. Is there a way to log all the sql calls? Yes, there are two logs: an update log (contains only queries which change the database content) and a general log (all queries). You probably have to enable logging first. Have a look at the section about server options in the manual. Bye, Benjamin. - 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
Weird - Was: Problems compiling MySQL
Problem: see below. For some reason mysql doesn't like db to be outside of the directory. It compiled fine when I moved the db directory in to the mysql source directory and reconfiged so that it saw the berkeley db library. Has anyone else had this problem? Jamie -Original Message- From: Jamie Krasnoo [mailto:[EMAIL PROTECTED]] Sent: Friday, February 09, 2001 9:12 AM To: MySQL Subject: Problems compiling MySQL I've run in to a bit of a problem with compiling MySQL. It compiles fine without the patched berkeley db. However when I add it in to the config, either by --with-berkeley-db= or the other two. I get this error. Can someone please tell me what's going on here and let me know how to get past this point. error: Making all in share make[3]: Entering directory `/usr/src/mysql-3.23.32/sql/share' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/usr/src/mysql-3.23.32/sql/share' make[3]: Entering directory `/usr/src/mysql-3.23.32/sql' c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr\"" -DDATADIR="\"/usr/var\"" -DSHAREDIR="\"/usr/share/mysql\ "" -DHAVE_CONFIG_H -I/usr/include -I./../include -I./../regex-I. -I../include -I.. -I. -O3 -DDBUG_OFF -fno-implicit-templates -c mysqlbinlog.cc In file included from mysqlbinlog.cc:23: ../include/my_sys.h:170: declaration of `int *__errno_location ()' throws different exceptions /usr/include/bits/errno.h:39: than previous declaration `int *__errno_location () throw ()' make[3]: *** [mysqlbinlog.o] Error 1 make[3]: Leaving directory `/usr/src/mysql-3.23.32/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr/src/mysql-3.23.32/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/mysql-3.23.32' make: *** [all-recursive-am] Error 2 config used: ./configure --prefix=/usr --with-raid --with-berkeley-db=/usr On a RedHat 7.0 system, patched db already installed. Do I need to include other CFLAGS or CXXFLAGS? Much appreciated, Jamie Krasnoo [EMAIL PROTECTED] -BEGIN PGP PUBLIC KEY BLOCK- Version: GnuPG v1.0.4 (GNU/Linux) Comment: Jamie Krasnoo (BMaximus) [EMAIL PROTECTED] mQGiBDpiu/gRBACJ+U9ti3GHIr2oF9emUGPIKiRrpg0MwC+9kyzWm+aGpoNpuRZ6 VH/nLgjAFBr7vsVHkPehoIEYxdTDnq5UE4/HOfWeHeTlm8/Oz8zx4TOAcMrEfYV2 4Ny8g4PyJaeutUcn+nqckDsUQ7mWFcn/3XdA7TrQrm1baRrepubA2uqt+wCgnK0Q jucnmH5xafdmqNDdAH+7rhED/02ze3B3o8xtcYK+0XYEN0v+XihtuWip6J0zdqMr P0QTzgGV1BVjpXLnry/po/q9Hs6YiGnVmixIAH1KMZpJD4MG/77WYfwqDpUaaSZn tCwQkjVHU1BJum9TYuo1Q3auvJaQ5Pg3dE2J3YG2FVaU5veygGfsxltt8WEWEJ3i f8pLA/9P75/hy51sESmlCzmc5mNL8rBWUisMF9WMosCZkGKz0A1yCC9lZM09dxCw hTkQvRBkrFwRx2eaFgy7eD40vbkI1Rlaelvx5atvHXOJenpSfShPut6JmND+cehW 6BfqT2ROLBRrSJD3cO1FAHt7dyTgceshgW2g6WtWeP5zzRhRB7QxSmFtaWUgS3Jh c25vbyAoQk1heGltdXMpIDx3ZWJtYXN0ZXJAbXllYm9hcmQuY29tPohXBBMRAgAX BQI6Yrv4BQsHCgMEAxUDAgMWAgECF4AACgkQgSA4ibDuKIsstwCgic5D6/qsWsgT 2vfkpSTUF4HL750AoIwGn+pvt6Hms2lAogM/nOSDDNxDuQENBDpivAgQBAC4BNtD hsawho/Bb8OGw1zq+B8KCEnaWxjEamIlOU/diU9cuuNmoiQkRpHajzcNjQ3O5sxA GxpAsthOhFeHnDRejDLN8Om7kydB4XdaPW5hqOZFlzNF97cbg2Y+fbscQWtPfRkl 3t/qEemwQZpGtCi7L+yqiXaJoXVEBqtBtlD1twAFEwP+Oz3e0H1eVWh7p5hGp6cN AJaGYaLHNMsbYw5l1+kUdJ0yxDPkLiTgdcGsbmgBLpnpJUujHOQF6/gWVPhzSzY2 VKqNshhJua+tt94Oo5AMlKCOQDje95Ks7ZdJUAjYKerhfvabDqASREgFhcPD5oXe UN4Lw7bNy1fI6PMGv1SACDyIRgQYEQIABgUCOmK8CAAKCRCBIDiJsO4oi3RuAJwJ kiuCZBveRLOFL+7iwlv9FhLNtgCZAYi6NAa98h82BLFi2kpVkm4YCFs= =1BAm -END PGP PUBLIC KEY BLOCK- - 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
HELP!!!
Help! I just installed the most recent release and the only thing I'm getting is... mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | +--+ 6 rows in set (0.00 sec) (The output should be mysql and test.) ... after initial installation and setup. Select queries and stuff seem to work alright, although I can't work like this. Help! JMR - 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: Please HELP easy ANSWER
Try this instead: CREATE TABLE custinfo ( id int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT, date date, name varchar(50), card varchar(22), exp_date varchar(7), authcode varchar(8), amount double(4,2), tax double(3,2), pnref varchar(16), address text, city tinytext, state varchar( 3), zip varchar(15), country varchar(2), contact_first varchar(20), contact_last varchar(20), contact_phone varchar(20), contact_ema il tinytext, tickets tinyint(3), description varchar(50), PRIMARY KEY (id)); Your id field is too small ... it's wrapping at 127 back to 0, and thus you're getting a collision -- here I've chosen an int instead. Also, primary keys are by definition unique, so you don't need to declare a second key on id. "Steven Fruchter" [EMAIL PROTECTED] wrote: Hi Everyone, I have a big problem, that I bet could be solved pretty simply but I am new to mysql so its killing me and my database. Ok heres the problem, suddenly out of no where when my php script tries to (or manually) do a insert it says: ERROR 1062: Duplicate entry '127' for key 1 Now why all of a sudden is this doing this at id 127? This is what my create table statement looks like if this is of any help to you: CREATE TABLE custinfo ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, date date, name varchar(50), card varchar(22), exp_date varchar(7), authcode varchar(8), amount double(4,2), tax double(3,2), pnref varchar(16), address text, city tinytext, state varchar( 3), zip varchar(15), country varchar(2), contact_first varchar(20), contact_last varchar(20), contact_phone varchar(20), contact_ema il tinytext, tickets tinyint(3), description varchar(50), PRIMARY KEY (id), UNIQUE id (id)); Now after I got this message these are some of the things I have tried to solve the problem but of course had no success: I tried isamchk -r and -R, i have even tried it with -rkis and then just plain -kis i pretty much have tried them all and it still gives the same error when i try to insert anything into the list ? What do i do to fix it and what did i do to cause it? Please help me I need this database up and running (loosing money every hour its down!) :( please please please help thank you very much for your time and help. -Steven Steven Fruchter Chief Technology Officer SMR Studios, Inc. [EMAIL PROTECTED] http://www.smrstudios.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
HELP!!!
Hello, I updated to 3.23.32 and now this happens: mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | +--+ 20 rows in set (0.00 sec) Select queries and stuff seem to work alright... Downgrade to 3.22.32 had no effect!? I also installed PHP4.0.4pl1 at the same time. It seemed this strange behavior occured just after it was all brought up to date. Any insights are very welcome! Regards J.M. Roth
help on mysql and cold fusion setup (urgent)
hi i have setup a mysql database foo_db and when i goto admininstrator of coldfusion to setup the odbc, the databsourse is foo_db and i select merant mysql drive, then click add. the verify is fail can anyone tell me what am i does wrong ? i using linux 6.2, coldfusion pro 4.5 thanks Wong - 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
ISAM and MYISAM
Hi, I've read some people talking about ISAM and MYISAM table. I dont understand what are those tables and can anyone explain to me and the difference of each table. and also which one has better performance? thanks Teddy - 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 dies, fails to restart (address already in use)
Description: After running for a variable amount of time, our server will just die. We have run myisamchk several times, with -r and with -o. We even checked the actual file system for corruption. This is a real problem when the server doesn't automatically restart. This is what the log looks like when it doesn't come back up: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died Attemping backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong Bogus stack limit or frame pointer, aborting backtrace Number of processes running now: 0 010209 18:37:25 mysqld restarted 010209 18:37:25 Can't start server: Bind on TCP/IP port: Address already in use 010209 18:37:25 Do you already have another mysqld server running on port: 1433 ? 010209 18:37:25 Aborting 010209 18:37:25 mysqld ended Severity: serious Priority: high Category: mysql Class: Release: mysql-3.23.32 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.32 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 4 min 19 sec Threads: 101 Questions: 255072 Slow queries: 0 Opens: 139 Flush tables: 1 Open tables: 133 Queries per second avg: 984.834 Environment: System: Linux db1.audiogalaxy.com 2.4.2-pre3 #1 SMP Fri Feb 9 18:01:57 CST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Dec 18 04:16 /lib/libc.so.6 - libc-2.1.94.so -rwxr-xr-x1 root root 4796386 Oct 5 16:46 /lib/libc-2.1.94.so -rw-r--r--1 root root 22737326 Oct 5 16:09 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 5 16:09 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db '--with-comment=Official MySQL RPM' - 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: Nuevo! Postales reales por la web
tengo una caja roja de lapices! Jay [EMAIL PROTECTED] wrote: Lanzamiento para San Valentn! Hola! http://www.postalesreales.com Te imprimimos, franqueamos y enviamos tu postal fsica personalizada desde Espaa a cualquier parte del mundo, incluyendo dentro de la peninsula Ibrica. Si estas en Latin America, aproveche las tarifas de envo local para enviar una postal de las de verdad a tus amigos y seres queridos! NO SON POSTALES VIRTUALES - ESTAS SON DE VERDAD! Envo en 48 horas! Un saludo de Elena Daz, [EMAIL PROTECTED] Otro servicio de Global Communications Services Spain S.L http://www.globalcomspain.com/html/team.htm You are receiving this message because you asked to be notified of new products from Global Comms when you visited one of our sites. If you feel this is in error, return this mail with "remove" in the subject line to be taken off our lists. Ha recibido este mail porque solicito ser notificado de nuevos productos cuando visito uno de nuestros webs. Si considero su inclusin en nuestra lista un error, devuelva este mail con "remove" en el subject para ser eliminado de nuestra lista. - 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: a bug during tar .........
go and get gtar (GNU tar) donnie At 10:28 AM 2/10/2001 +0800, 163 wrote: Dear sir: I downed mysql-3.23.32.tar.gz, first i extrat mysql-3.23.32.tar from gz file,then I use command "tar -xvf mysql-3.23.32.tar ", an error occured, I copy the last 3 line to you! My OS platform is UnixWare 7.11. . . x mysql-3.23.32/sql-bench/Results-linux/ATIS-mysql_dbug-Linux_2.2.14_my_SMP_i686, 972 bytes, 2 tape blocks x mysql-3.23.32/sql-bench/Results-linux/big-tables-mysql-Linux_2.0.33_i586-cmp-ms-sql,mysql,sybase, 684 bytes, 2 tape blocks UX:tar: ERROR: Cannot set time on ././@LongLink: No such file or directory UX:tar: ERROR: Directory checksum error what's the wrong and how to fix this bug? Thanks ! xiejiangbo - 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: BDB
Hello Michael, Friday, February 09, 2001, 3:48:53 AM, you wrote: Peter as you see here one thread is doing repear as this happened after Peter mysqld crash, but note first insert query in system lock state (I've Peter saw several queries at this place, but all of them spent in system Peter lock time several tenths of seconds) this can nothing to do with Peter recovery (this table was just created by mysqldump couple of minutes Peter before) - I habe the only explanation which looks ok the system lock Peter takes place while many inserts are going to othe table (g03dirs) - as Peter soon as the table changed all other queries which was in system lock Peter state got a chance to run. The other thing is mysqldump does not uses Peter lock tables to insert data so this looks like real perfomance Peter (concurency) problem Some Peter more examples: MW The "System Lock" means that you got some problem with fnctl() on your MW system. MW The fix is to restart mysqld with --skip-locking and without MW --enable-locking to ensure that fcntl() lock is not used. Mysql is started with --skip-locking as it's recomended on linux, so this should not be the problem. MW If you are using 'mysqldump --opt', it should generate locks for the MW tables. What command did you use ? At first I used mysqldump --all --opt but then mysqld crashed on multiple inserts. The next time I just started it with --all --add-drop-tables options and this is the cases for this usage. Peter onyx:/spylog/db # mysqladmin processlist | grep -v Sleep Peter +-+---++-+-+--++--+ Peter | Id | User | Host | db | Command | Time | State | Info | Peter +-+---++-+-+--++--+ Peter | 36 | root | localhost | lacontrol | Query | 384 | update | replace into layers_la00.g00stat_404refs (layer_id,id,visitors,loads,hits) values Peter (2,2,0,4,0), Peter (2,9, | Peter | 39 | root | localhost | layers_la00 | Query | 0| update | INSERT INTO g03stat_404pages VALUES (149,1563,0,1,0) | Peter | 272 | root | localhost | | Query | 0|| show processlist | Peter +-+---++-+-+--++--+ Peter as you see here replace is "hanged" - it's simple query wich should Peter not take so long. But just few seconds after: MW Do you know if some other thread was using the table at this point ? layers_st00.g00stat_404refs ? No. This is the only thread using it. Peter onyx:/spylog/db # mysqladmin processlist | grep -v Sleep Peter +-+---++-+-+--+-+--+Peter | Id | User | Host | db | Command | Time | State | Info | Peter +-+---++-+-+--+-+--+ Peter | 36 | root | localhost | lacontrol | Query | 16 | update | replace into layers_la00.g00stat_enterpages (layer_id,id,hits,loads) values Peter (2,2048,2,2), Peter (2,1,60,60 | Peter | 39 | root | localhost | layers_la00 | Query | 0| update | INSERT INTO g03stat_404refs VALUES (6,76851,0,1,0) | Peter | 271 | titan | mail.local | counter | Query | 1| System lock | select Peter visitors, Peter visitors7d, Peter visitors30d, Peter | Peter | 273 | root | localhost | | Query | 0| | show processlist | Peter +-+---++-+-+--+-+--+ Peter As you see here the mysqldump moved to loading other table and the Peter replace passed, and now the other replace is waiting for insert. And Peter so on the thing continues with each table. MW Ok, I see what you mean. This looks VERY strange. MW This could be a thread concurrency problem; I don't think so. The chance one thread
