I can't find file mysqld.sym.gz!
hello~ When I try to Using a stack trace there's no mysqld.sym.gz on our server . Can we always find mysqld.sym.gz on any operating system? Our operating system is Linux 7.0 . I would like to mail you our error log to see if you can tell us what's wrong with our MySQL which always crash unexpectedly . Thanks ! Sincerely yours . Tracy Lu Following is error log: 020213 21:50:23?mysqld started /home/ap1/libexec/mysqld: ready for connections 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. Attempting backtrace. You can use the following information to find out where mysqld died.?If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x4007d00e 0x815f4f8 0x815f1c1 0x8143b08 0x81503ff 0x81506b9 0x81505ae 0x810e625 0x81050f7 0x8104de8 0x8105f73 0x8102107 0x80e3cc1 0x80e20ac 0x80c7605 0x80cb4ec 0x80c6a4d 0x80c5f66 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x823a7c0 = select count(invno) as tlrecs from srvmst where invno='k0036381' and strno ='2053' thd-thread_id = 9861 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 9861 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 020218 15:01:50?mysqld restarted /home/ap1/libexec/mysqld: ready for connections 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. Attempting backtrace. You can use the following information to find out where mysqld died.?If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x4007d00e 0x4011bf48 0x80d82fa 0x80cb4d7 0x80c6a4d 0x80c5f66 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8223268 = insert into tmptree1 (unid,parent,child,title,att,filename,sysfilename,owner,beginday,begintime ,endday,endtime,sequence,groupname) values ('3d850d56f8784f4f64427363cfe07f6e','309082909d9419a6201c622129c8357e','1e fe2c23f8f57e71df959033b1344a83','°w¹ïAcer²£«~¤§·s«~¬G»Ù»Pºû׫~³B²z¤è¦¡',' D','4.txt','2587a47633a7f3c62bb96f1587bd2ccf.txt','90113','2000.12.13','12 :00','2002.12.10','24:00',8,'Àç·~¸s²Õ') thd-thread_id = 79 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 79 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 1 mysqld process hanging, pid 29649 - killed 020218 15:19:42?mysqld restarted /home/ap1/libexec/mysqld: ready for connections 020218 15:37:01?mysqld started /home/ap1/libexec/mysqld: ready for connections 020218 16:02:10?/home/ap1/libexec/mysqld: Normal shutdown - 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: The table 'SQLb73d_0' is full
On Tue, Feb 19, 2002 at 09:50:57AM +0200, Mohamed Abd El-Samei Mohamed wrote: mysql insert into table1 select distinct field1 , MIN(field2) from table2 where field2 =2001-12-01 00:00:00 group by field2 ; ERROR 1114: The table 'SQLb73d_0' is full mysql I've seen this when MySQL uses an internal table for temporary data. There is a limit on the size of these tables. You can force MySQL to use a file in its temporary directory to store the results: set SQL_BIG_TABLES = 1; An alternative is to do a SELECT SQL_BIG_RESULT ... instead of SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x, though it is accepted by the parser. You don't mention which version you use. 'set SQL_BIG_TABLES' works fine in 3.22.x. Note that if I'm correct, you're using a very old version of MySQL. You might consider an upgrade. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - 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
While executing a query, Got error 22275 from table handler
Description: When i execute the following query on my database: SELECT retaillastdone_.* FROM retaillastdone_ WHERE (retaillastdone_.source_=mercury AND retaillastdone_.timestamp_ BETWEEN 97864920 AND 978735599099) ORDER BY retaillastdone_.owner_,retaillastdone_.timestamp_ ASC ; I get the error ERROR 1030: Got error 22275 from table handler however, I am sure my tables arent corrupted as I ran myisamchk on it. The interesting thing is that the following query executes without any problems SELECT retaillastdone_.* FROM retaillastdone_ WHERE (retaillastdone_.source_=mercury AND retaillastdone_.timestamp_ BETWEEN 97864920 AND 978735599099) ORDER BY retaillastdone_.owner_,retaillastdone_.timestamp_ ASC limit 10; I used the email-support and got a reply from Sergei that its bug. Thus, Iam sending this testcase. How-To-Repeat: I am attaching the table retaillastdone with the bug. If you run the same query, that gives problems to me, the bug can be reproduced. Fix: Appened limit 10 at the end of the query as I did above, it will work fine. Submitter-Id: maarten4688 Originator:maarten4688 Organization: IMC. B.V MySQL support: email support Synopsis: The problem is mentioned above . Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.39 (Official MySQL binary) Server: /usr/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for redhat-linux-gnu on i386 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.39 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 20 hours 53 min 2 sec Threads: 11 Questions: 12871549 Slow queries: 0 Opens: 887 Flush tables: 1 Open tables: 64 Queries per second avg: 171.205 Environment: System: Linux goofy2 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 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.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Jan 17 16:22 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1282588 Sep 4 21:49 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 21:34 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 21:34 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Jan 17 16:38 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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
I cannot start my server.
guo, Tuesday, February 19, 2002, 1:49:50 AM, you wrote: gl Dear Sir/Madam, gl I install mysql on my computer but it did not work. after installing the gl rpms, I use gnorpm to verify the installtion, and it's OK. but I couldn't gl start my server, after I ran mysql_install_db and safe_mysqld gl commands. I list the relevant information and I use the mysqlbug script to gl collect the relevant information . gl mysql's version : gl mysql-3.23.22-6.i386.rpm gl mysql-server-3.23.22-6.i386.rpm gl mysql-devel-3.23.22-6.i386.rpm gl my computer: AMD Athlon Processor gl cpu: 1.2GHz gl mem:256M gl operating system: red hat linux 7.0 gl kernel : 2.2.16-22 [skip] gl while I find some information from /var/lib/mysql/localhost.localdomain.err, gl the file localhost.localdomain.err's contents: gl 020215 17:31:02 mysqld started gl 020215 17:31:02 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' gl (errno: 13) $ perror 13 Error code 13: Permission denied Please, check your permissions on mysql data dir. gl 020215 17:31:02 mysqld ended gl but I find the 'host.frm' file is in the directory: gl /var/lib/mysql/mysql gl in my /etc directory, there is only a configure file named: my.conf and the gl file's length is zero. there is no file named : my.cnf or mf.cnf. gl I tried to copy one of the config file my-medium.cnf to the /etc directory gl and renamed to both my.cnf and mf.cnf, it still did not work. gl Best regards; gl Leon -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
consistency of NOW() function, and summary caching
I'm curious about what guarantees MySQL (and the SQL standard) provide with regard to multiple calls to NOW() within the same statement. If the statement takes a long time to execute, will NOW() be consistent across all invocations? The trivial example of this is if you're updating a large set of rows to an expression involving NOW(), but I'm more interested in INSERT and SELECT semantics. A simplified version of a more subtle example is: INSERT INTO order_sums (start_date, end_date, total) SELECT [literal date], NOW(), SUM(order_amount) FROM orders WHERE date_of_order = [literal date] and date_of_order NOW() The idea is that you've got an 'orders' table that gets a large amount of traffic- presumably thousands of delayed INSERT statements per hour- and users sometimes want to view a summary of the table. Instead of summarizing a huge number of rows every time, you keep caches of the summary info in another table. You'd lock the order_sums table, find the largest end_date, perform the above statement with the end_date substituted for [literal date], unlock the table, and then summarize the order_sums table. There are a couple of places that inconsistent NOW() values could cause erroneous results and an inconsistent database. First, the final 'date_of_order NOW()' is explicitly coded as a less-than and not a less-than-or-equal-to because there will very likely be additional insertions run before the end of the current second, so we leave the interval open at the top to ignore the current (partial) second. Does this in fact do what I want in the presence of many statements of the form INSERT DELAYED INTO orders (date_of_order, order_amount) values(NOW(),'123') or must I offset the NOW() by something safe like a minute to ignore inserts that haven't quite made it in yet? Second, it is obviously quite important that the NOW() in the select list exactly match the NOW() in the WHERE clause, since the next summary cache entry will be computed using its value. Is this guaranteed? Is it possible (and efficient) to alias the NOW() column in the SELECT list for use in the WHERE clause? How would that work? I'd also love any suggestions/criticisms of the above architecture. I'm trying to address what is a potentially significant performance issue for us (we hope to allow the main table to grow to tens to hundreds of millions of rows before pruning it down), but there might be a much simpler way to approach the problem. Experiences implementing solutions to similar problems 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: consistency of NOW() function, and summary caching
I'd also love any suggestions/criticisms of the above architecture. I'm trying to address what is a potentially significant performance issue for us (we hope to allow the main table to grow to tens to hundreds of millions of rows before pruning it down), but there might be a much simpler way to approach the problem. Experiences implementing solutions to similar problems would be much appreciated. Isn't this a case for user variables? Set a user variable to now() at the start if the insert, then use that rather than now() in the insert? - 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
Table overhead --
Mark, Tuesday, February 19, 2002, 5:34:34 AM, you wrote: MS Anyone know what causes overhead on a MySQL table? MS I wrote a JSP application using MySQL that uses updates and Inserts and have MS found that a lot of overhead exists. MS Of course if the table is optimized - the overhead is cleared. MS Anyone had similar issues? If you change tables with dynamic size rows (varchar, text or blob columns), you may want to defragment/reclaim space from the table. Look at in the manual, it will be useful for you: http://www.mysql.com/doc/O/P/OPTIMIZE_TABLE.html http://www.mysql.com/doc/U/p/Update_speed.html http://www.mysql.com/doc/I/n/Insert_speed.html http://www.mysql.com/doc/T/i/Tips.html MS Thanks MS Mark -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How can i acheive 'Triggers' in MySQL
sreedhar, Saturday, February 16, 2002, 7:03:31 AM, you wrote: s Hi all, s How can i acheive 'Triggers' in MySQL. or equivalent to 'Triggers'. MySQL doesn't currently support triggers, look at: http://www.mysql.com/doc/T/O/TODO_sometime.html http://www.mysql.com/doc/A/N/ANSI_diff_Triggers.html s Regards, s sreedhar -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The table 'SQLb73d_0' is full
Mohamed, Tuesday, February 19, 2002, 9:50:57 AM, you wrote: MAESM mysql insert into table1 select distinct field1 , MIN(field2) from table2 MAESM where field2 =2001-12-01 00:00:00 group by field2 ; MAESM mysql ERROR 1114: The table 'SQLb73d_0' is full MAESM please help to fix this error You can find your answers at: http://www.mysql.com/doc/F/u/Full_table.html http://www.mysql.com/doc/S/E/SET_OPTION.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Am I asking the wrong question?
Søren Neigaard wrote: HS To see if there are correct permissions check the db table ind Database HS MySQL - there you find Database specififc persmissions for each user. Yes in db the homebrew user did not have any permissions, so I change them manually, and now it all works. But why? Should I not be able to set those permissions with GRANT? Normally it should work like that, i can't see now why this didn't work... HS Another thing that could be (but i am not sure if that applies) that you HS need to relaod the database sometimes after granting something to a user HS or adding a new user, i am not sure, but you can give it a try. Yes I needed that too, I stopped and started it. Can I reload it with some command? IIRC You can issue a reload by using mysqladmin, and on the mysql shell if you have the right permission ( as root you should have them), if you use phpmyadmin there is a way too to do it. Stopping and restrting shouldn't be a problem either with small databases, but i can imagine this would take more time with a database with lots of tables under heavy load. cheers, 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
Re: Fulltext problems 4.0.1 part two
Hi! On Feb 02, Alexander Belyaev wrote: Hello, I have found a bug( or bad feature? :) ) in 4.0.1 boolean fulltext search Please help... -- select id,txt from test.logo_text where match(txt) against ('+desig* +service' in boolean mode) -- 2 rows in set (0.03 sec) -- select id,txt from test.logo_text where match(txt) against ('+design +service' in boolean mode) -- -+ 4 rows in set (0.03 sec) Sorry for delay :-( Anyway, the bug is fixed now, thank you. Bugfix will be present in MySQL 4.0.2 Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - 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
Any limit of the Query Buffer ???
Anyone here know if there is a limit of the number of query I can do in a Do While of a VB program ? --- Pascal Richer [EMAIL PROTECTED] Étudiant en Informatique et Génie Logiciel Université du Québec à Montréal - 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 performance question
Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about 100, yet under the top load it seems to be not enough. Here are the config options: set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=8M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=16 set-variable= max_write_lock_count=10 set-variable= thread_concurrency=8 The server itself is 2x PIII Intel Xeon 700 MHz, Intel KOA4 platform, with 4G RAM. Mysql 3.23.47 (binary distribution), FreeBSD 4.5 system. All mysql queries are rewritten so the INSERT/UPDATE's has been reduced or replaced by DELAYED as much as possible, to ease mysql locking. The mysql tables are indexed, all documentation from the main mysql site having been studied. And under the top load the mysql starts locking anyways. So what can be the best ways of helping it: - Changing mysql options, may be increasing key_buffer some more or what else? - Adding 2 more CPU's to the server (it can bear up to 4 CPU); - May be there can be some other ways? Thanks in advance! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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 performance question
What disk drive have you got? We have found that this can help. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 13:14 To: [EMAIL PROTECTED] Subject: Mysql performance question Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about 100, yet under the top load it seems to be not enough. Here are the config options: set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=8M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=16 set-variable= max_write_lock_count=10 set-variable= thread_concurrency=8 The server itself is 2x PIII Intel Xeon 700 MHz, Intel KOA4 platform, with 4G RAM. Mysql 3.23.47 (binary distribution), FreeBSD 4.5 system. All mysql queries are rewritten so the INSERT/UPDATE's has been reduced or replaced by DELAYED as much as possible, to ease mysql locking. The mysql tables are indexed, all documentation from the main mysql site having been studied. And under the top load the mysql starts locking anyways. So what can be the best ways of helping it: - Changing mysql options, may be increasing key_buffer some more or what else? - Adding 2 more CPU's to the server (it can bear up to 4 CPU); - May be there can be some other ways? Thanks in advance! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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 performance question
Here is the hardware: 8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 1 rpm 18.2GB, Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI, FreeBSD says when booting: ADAPTEC RAID-50 370F Fixed Direct Access SCSI-2 device Tell me please if any other info is needed. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Simon Green wrote: Date: Tue, 19 Feb 2002 13:22:04 - From: Simon Green [EMAIL PROTECTED] To: 'Varshavchick Alexander' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Mysql performance question What disk drive have you got? We have found that this can help. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 13:14 To: [EMAIL PROTECTED] Subject: Mysql performance question Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about 100, yet under the top load it seems to be not enough. Here are the config options: set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=8M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=16 set-variable= max_write_lock_count=10 set-variable= thread_concurrency=8 The server itself is 2x PIII Intel Xeon 700 MHz, Intel KOA4 platform, with 4G RAM. Mysql 3.23.47 (binary distribution), FreeBSD 4.5 system. All mysql queries are rewritten so the INSERT/UPDATE's has been reduced or replaced by DELAYED as much as possible, to ease mysql locking. The mysql tables are indexed, all documentation from the main mysql site having been studied. And under the top load the mysql starts locking anyways. So what can be the best ways of helping it: - Changing mysql options, may be increasing key_buffer some more or what else? - Adding 2 more CPU's to the server (it can bear up to 4 CPU); - May be there can be some other ways? Thanks in advance! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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
Error 1058 Win2K Server with MySQL
We are trying to install MySQL on a Windows 2000 Server, but are getting 'error 1058' when we try to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - 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
Boolean Fulltext problems part III
Hello, Sergey, thanks for the patch, I applied it for 4.0.1 and seems like mentioned bug closed. But I found new bug :) Strange, but the query WORKS AS EXPECTED without fulltext index! The results for 4.0.1 with latest fulltext patch applied: If you need full testcase, please conteact me. Thanks, Alexander -- show variables like 'ft%' -- +--++ | Variable_name| Value | +--++ | ft_min_word_len | 2 | | ft_max_word_len | 254| | ft_max_word_len_for_sort | 20 | | ft_boolean_syntax| + -()~*:| | +--++ 4 rows in set (0.00 sec) -- show index from logo_text -- +---++--+--+-+-- -+-+--++--+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++--+--+-+-- -+-+--++--+ | logo_text | 0 | PRIMARY |1 | id | A | 38347 | NULL | NULL | | | logo_text | 1 | fff |1 | txt | A | 38347 |1 | NULL | FULLTEXT | +---++--+--+-+-- -+-+--++--+ 2 rows in set (0.00 sec) -- select * from logo_text where match(txt) against ('+sony -play*' in boolean mode) -- +---+--- ---+ | id| txt | +---+--- ---+ | 3198 | sony | | 3199 | sony | | 5947 | cd changer 6 sony | | 5948 | wega fd trinitron sony | | 7539 | playstation sony | | 11814 | my first sony | | 11815 | my first sony | | 11835 | sony music | | 11836 | sony versity | | 11869 | it's a sony sony | | 19720 | playstation 2 sony | | 19721 | playstation sony | | 20417 | sony music 550 | | 21186 | sony mobile | | 21187 | xplod sony | | 21188 | memory stick sony | | 27096 | sdds sony dynamic digital sound digital movie sound system | | 29512 | playstation sony | | 30292 | vaio sony | | 37280 | sony ericsson mobile communications http://www.sonyericssonmobile.com/ | | 37281 | sony ericsson mobile communications http://www.sonyericssonmobile.com/ | | 39170 | sony computer entertainment | | 39548 | ali the movie will smith sony pictures entertainment | | 40117 | digital cinematography sony | | 40133 | cinealta sony | | 40134 | cinealta sony | | 40310 | superslim sony monitors | | 40506 | sony walkman | +---+--- ---+ 28 rows in set (0.00 sec) -- ALTER TABLE logo_text DROP INDEX fff -- Query OK, 38347 rows affected (1.44 sec) Records: 38347 Duplicates: 0 Warnings: 0 -- select * from logo_text where match(txt) against ('+sony -play*' in boolean mode) -- +---+--- ---+ | id| txt | +---+--- ---+ | 3198 | sony | | 3199 | sony | | 5947 | cd changer 6 sony | | 5948 | wega fd trinitron sony | | 11814 | my first sony | | 11815 | my first sony | | 11835 | sony music | | 11836 | sony versity | | 11869 | it's a sony sony | | 20417 | sony music 550 | | 21186 | sony mobile | | 21187 | xplod sony | | 21188 | memory stick sony | | 27096 | sdds sony dynamic digital sound digital movie sound system | | 30292 | vaio sony | | 37280 | sony ericsson mobile communications http://www.sonyericssonmobile.com/ | | 37281 | sony ericsson mobile communications http://www.sonyericssonmobile.com/ | | 39170 | sony computer entertainment | | 39548 | ali the movie will smith sony pictures entertainment | | 40117 | digital cinematography sony | | 40133 | cinealta sony | | 40134 | cinealta sony | | 40310 | superslim sony monitors | | 40506 | sony walkman | +---+--- ---+ 24 rows in set (0.43 sec) Bye Server version: 4.0.1-alpha Uptime: 23 min 52 sec Threads: 2 Questions: 164 Slow queries: 4 Opens: 94 Flush tables: 1 Open tables: 4 Queries per second avg: 0.115 -- - 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: About Regular Backup on MySQL
Dear Sir/Madam: I'd like to know how I can have regular backup in mysql database that is carried out by the system itself, instead of typing in the backup command in the DOS mode everytime. Thanks for your attention looking forwards to your reply. Regards, Polly __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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
help on installation
Hello, I am trying to install MySQL in Solaris 7. I download this version of Mysql (mysql-3.23.48-sun-solaris2.7-sparc.tar.gz). After I ran the gunzip and these instruction shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell ln -s mysql-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db shell chown -R root /usr/local/mysql shell chown -R mysql /usr/local/mysql/data shell chgrp -R mysql /usr/local/mysql shell chown -R root /usr/local/mysql/bin shell bin/safe_mysqld --user=mysql I got # bin/safe_mysqld --user=mysql [1] 4902 # Starting mysqld daemon with databases from /usr/local/mysql/data 020219 08:19:03 mysqld ended And then I open the ultra.err, and I got this message below. 020219 08:19:03 mysqld started /usr/local/mysql/bin/mysqld: File './ultra-bin.1' not found (Errcode: 13) 020219 8:19:03 Could not use ultra-bin for logging (error 13) 020219 8:19:03 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/local/mysql/data/ultra.pid' (Errcode: 13) 020219 8:19:03 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020219 8:19:03 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mysql/data/ultra.pid' (Errcode: 13) 020219 08:19:03 mysqld ended DOes anybody can help me to direct me to a correct path? Thank you. Victor - 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 TEXT datatypes and multiple tables
At 04:08 2/19/02 +0100, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I have a table that has a field with a TEXT datatype. Because of this all my CHAR fields had to become VARCHAR. Is it common practice to move the TEXT field to a separate table in order to preserve the CHAR fields in the original table. Bear in mind I am primarily concerned with speed. Are there any other tips someone can offer for using the TEXT datatype? Craig - 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: About Regular Backup on MySQL
If you are on a Windows box, you can create a batch job for it. If you are on Linux/Unix run a cron job -Original Message- From: Che WaiSam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 8:19 AM To: [EMAIL PROTECTED] Subject: Re: About Regular Backup on MySQL Dear Sir/Madam: I'd like to know how I can have regular backup in mysql database that is carried out by the system itself, instead of typing in the backup command in the DOS mode everytime. Thanks for your attention looking forwards to your reply. Regards, Polly __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.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
Please have a look on this group by
Hi Folks, now sitting here for 5 hours trying to get these stupid sql-request running, I decide to ask the list. structual information of the database: database.preis = decimal(12,2), database.lfd=int(11), database.typ=varchar(30), database.marke=varchar(50) The following requests works select min(preis) from database also select min(preis) from database where marke='marke' and typ not like 'R%' and typ not like 'X%' but I have to get another value from the db so i choose select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesn´t bring the expected pair preis / lfd but all available preis/lfd grouped ascending. Any idea, even if I´m shure that the select worked tonight. TIA Oliver - 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 performance question
Hi Simon, A couple of things, unless you have compiled WITH_LINUX_THREADS from the /usr/ports/databases then adding more processors will be unlikely to help. The native threads lib on FreeBSD runs a threaded app on 1 processor currently, use the LINUX_THREADS option in the ports to get around this if you would like to add more processors. Do you have softupdates on also? Have you read 'man tuning'? Are you accessing alot of tables/DBs? If yes what is your table_cache value? What is in 'SHOW STATUS' and 'SHOW VARIABLES'? Also MySQL 4.0.1 has a query cache that is incredible! It works great. 6000 queries per minute is pretty good performance. Have you looked at using heap tables where possible? Another suggestion if everything is hitting the same table/database have you tried innodb tables? They work very well under high loads. I would study all the 'SHOW STATUS' output and see if you can spot anything in the manual page for each of the variables. Best of Luck, Ken - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: Simon Green [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 8:30 AM Subject: RE: Mysql performance question Here is the hardware: 8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 1 rpm 18.2GB, Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI, FreeBSD says when booting: ADAPTEC RAID-50 370F Fixed Direct Access SCSI-2 device Tell me please if any other info is needed. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Simon Green wrote: Date: Tue, 19 Feb 2002 13:22:04 - From: Simon Green [EMAIL PROTECTED] To: 'Varshavchick Alexander' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Mysql performance question What disk drive have you got? We have found that this can help. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 13:14 To: [EMAIL PROTECTED] Subject: Mysql performance question Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about 100, yet under the top load it seems to be not enough. Here are the config options: set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=8M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=16 set-variable= max_write_lock_count=10 set-variable= thread_concurrency=8 The server itself is 2x PIII Intel Xeon 700 MHz, Intel KOA4 platform, with 4G RAM. Mysql 3.23.47 (binary distribution), FreeBSD 4.5 system. All mysql queries are rewritten so the INSERT/UPDATE's has been reduced or replaced by DELAYED as much as possible, to ease mysql locking. The mysql tables are indexed, all documentation from the main mysql site having been studied. And under the top load the mysql starts locking anyways. So what can be the best ways of helping it: - Changing mysql options, may be increasing key_buffer some more or what else? - Adding 2 more CPU's to the server (it can bear up to 4 CPU); - May be there can be some other ways? Thanks in advance! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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: Please have a look on this group by
On Tuesday 19 February 2002 10:07, Oliver Heinisch wrote: What would you expect the database to return You asked it to GROUP all the records with the same preis, that means it has to choose a value for each column of the record that is the result of each grouping, correct? So which of the (for example eleven (elf for you deutche;o)) different values of database.lfd did you want to have returned in your one resulting record? Obviously the database cannot stuff 11 values into one field You need something like select min(preis), max(lfd) or some other summary function, OR you need to GROUP BY preis,lfd. You simply cannot have it both ways. In fact (Monty are you listening!!!) MySQL needs to throw an error on this sort of query because it is relationally incorrect and the database engine cannot fullfill it correctly. For some odd reason though, human brains have a really hard time understanding this concept. If you want to really understand it, pretend to be a database and process a GROUP BY of the form he's having problems with, then you'll understand. ;o). Hi Folks, now sitting here for 5 hours trying to get these stupid sql-request running, I decide to ask the list. structual information of the database: database.preis = decimal(12,2), database.lfd=int(11), database.typ=varchar(30), database.marke=varchar(50) The following requests works select min(preis) from database also select min(preis) from database where marke='marke' and typ not like 'R%' and typ not like 'X%' but I have to get another value from the db so i choose select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesn´t bring the expected pair preis / lfd but all available preis/lfd grouped ascending. Any idea, even if I´m shure that the select worked tonight. TIA Oliver - 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: Please have a look on this group by
Oliver, select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesnt bring the expected pair preis / lfd but all available preis/lfd grouped ascending. you're grouping by the same column you're trying to aggregate with MIN(), so it's normal that you're getting all of the values of 'preis' in the result. You might want to GROUP BY a different column, e.g. 'typ' or 'marke' in your example. HTH, Peter sql, query -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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
[SECURITY] How do these blank passwords get into mysql.user?
One thing's been bothering me for a while: When I create a user and database in MySQL, the user always ends up with an extra entry with host='%' and password=''. How is this happening? This is how I create a new database and user: mysql create database xxx; Query OK, 1 row affected (0.01 sec) mysql insert into user set host='localhost', user='xxx', password=password('yyy'); Query OK, 1 row affected (0.03 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql grant all privileges on xxx to xxx; Query OK, 0 rows affected (0.03 sec) mysql grant all privileges on xxx.* to xxx; Query OK, 0 rows affected (0.00 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql select host,user,password from user where user='xxx'; +---+--+--+ | host | user | password | +---+--+--+ | % | xxx | | | localhost | xxx | 66debff13dff1053 | +---+--+--+ 2 rows in set (0.00 sec) What did I do wrong to cause these users with blank passwords to be created (essentially opening me wide to the outside)? My MySQL version is 3.23.47. It's worked fine after I delete the extra row in the user table manually, but this could be dangerous to someone who doesn't notice it! - 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: double outer joins in mysql?
On Tuesday 19 February 2002 00:48, Todd Goldenbaum wrote: hi, I'm wondering if anyone knows if it's possible to do a double-outer join in mysql. by that I mean outer-joining on two tables instead of one (both from the same original table). in other words, whereas a normal outer join might go something like this: select b.date, u.name from billing b outer join users u on b.user_id=u.user_id ...I'm trying to do something more like this: select b.date, u.name, l.city from billing b outer join users u on b.user_id = u.user_id, locations l on b.location_id = l.location_id (that syntax is bogus) but does anyone know if this is even possible? thanks, todd As I recall you should be able to do SELECT * FROM a LEFT JOIN b ON a.x=b.x LEFT JOIN c ON c.z=b.z WHERE ... and if I understand you correctly you get what you want (which is ALL records in A even if they have no corresponding b's or c's. NOTE that the second ON might want to be a comparison between columns in a and c, not b and c depending on exactly what you need (IE in my example a missing b value would result in no returned c for that a, even if one existed). You might even need something like ON c.z=b.z OR a.y=c.y depending on your needs. - 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: [SECURITY] How do these blank passwords get into mysql.user?
Philip, you should explicitly specify host/password in the GRANT statement, like this: GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; This way the user will only granted access from the specified host, you don't need to manually INSERT into the user table. (You'll also get rid of the empty passwords.) Peter On Tue, 19 Feb 2002, Philip Mak wrote: One thing's been bothering me for a while: When I create a user and database in MySQL, the user always ends up with an extra entry with host='%' and password=''. How is this happening? This is how I create a new database and user: mysql create database xxx; Query OK, 1 row affected (0.01 sec) mysql insert into user set host='localhost', user='xxx', password=password('yyy'); Query OK, 1 row affected (0.03 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql grant all privileges on xxx to xxx; Query OK, 0 rows affected (0.03 sec) mysql grant all privileges on xxx.* to xxx; Query OK, 0 rows affected (0.00 sec) mysql flush privileges; Query OK, 0 rows affected (0.00 sec) mysql select host,user,password from user where user='xxx'; +---+--+--+ | host | user | password | +---+--+--+ | % | xxx | | | localhost | xxx | 66debff13dff1053 | +---+--+--+ 2 rows in set (0.00 sec) What did I do wrong to cause these users with blank passwords to be created (essentially opening me wide to the outside)? My MySQL version is 3.23.47. It's worked fine after I delete the extra row in the user table manually, but this could be dangerous to someone who doesn't notice it! -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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: [SECURITY] How do these blank passwords get into mysql.user?
On Tue, Feb 19, 2002 at 04:39:10PM +0100, Peter Banik wrote: you should explicitly specify host/password in the GRANT statement, like this: GRANT ALL ON xxx.* TO user@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; This way the user will only granted access from the specified host, you don't need to manually INSERT into the user table. (You'll also get rid of the empty passwords.) Hmm, I just ran another experiment: mysql create database xxx; Query OK, 1 row affected (0.00 sec) mysql grant all on xxx to xxx; Query OK, 0 rows affected (0.00 sec) mysql select host,user,password from user where user='xxx'; +--+--+--+ | host | user | password | +--+--+--+ | %| xxx | | +--+--+--+ 1 row in set (0.00 sec) So if I execute a GRANT statement without specifying a password, and MySQL decides that it needs to create a new user for this (host,user) pair, then it will create it with blank password! This seems to be insecure default behavior to me. I wonder if it would be better to change MySQL such that it will not create a user with blank password like this unless IDENTIFIED BY '' is explicitly specified? - 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: another xml thread
On Monday, February 18, 2002, at 11:26 PM, Benjamin Pflugmann wrote: So, if you want to use data from a MySQL database and transfer it via XML and the other way around (i.e. XML as an transport layer for relational data), I see no particular problem for you to write a client that accomplishes that. But that doesn't touch major possibilities of XML. If you want to take data from XML documents and store them within MySQL, I see no way how that can be done reasonably. I see. I had not considered how more complex (and more tree-like) XML documents would be handled by the RDBMS. I was thinking about my particular application, which is actually very simple, and would rely only on a single table (each column of the table would contain the content of a separate element in the XML file). But now that I think about it, this is much more simple than some XML files will end up being, given their hierarchical structure. So perhaps it's fine for my basic purposes, but not the best solution for complex XML documents. IIRC, the thread you cite was so long, because some (one?) of the people partiating did not know what they were talking, but kept insisting on their point. But I did not have a second look, so I am not sure if I am mis-remembering. Yes, there was a lot of back-and-forthing. Thanks, Erik Erik Price Web Developer Temp Media Lab, H.H. Brown [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
Running MySQL on Dos System?
Is it possible to port MySql on a Dos Computer ? Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin - 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
Running MySQL on DOS?
Is it possible to port MySql on a Dos Computer ? Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin - 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: get instance variable
Hi Robert - The only way I have found to get this sort of stuff (as well as security info) out is to use mysql_query (or mysql_real_query) and issue the query just like you would at the mysql client. Then you can interpret the results that are returned. I am having to do that with column level grants by user ID to implement views of the data in a C++ environment and it's the only way that I could find to do it. There are not a lot of C API things that are specific to getting data column metadata and other configuration data. IT is mostly for obtaining connections, results sets, and manipulating result sets. It appears that the way they want you to get stuff out using the C API is not with lots of specific calls, but by just issuing the command yourself and interpreting the result set. I found the best way is to write a simple program to issue a call and the cout the result set information. Be sure and do that because sometimes the returned data will surprise you a little bit I have some working C++ connection and result set classes if you would like them, plus a test program you can use. Ken Hylton -Original Message- From: Li, Robert [mailto:[EMAIL PROTECTED]] Sent: Monday, February 18, 2002 9:07 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject:get instance variable Hi, all MySQL team Here is another question. I want to get individual MySQL instance's variable(like datadir, tmpdir etc) using C API. Is there any function can do this? I know that use mysqladmin and use query show variables can do this. Thanks and regards Robert Li Computer Associates RD Centre Beijing , China Tel:+86 10 6561 1136 ext 852 (O) Fax:+86 10 8529 8979 E-mail: [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 - 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 have a look on this group by
At 19.02.2002 10:20, you wrote: What would you expect the database to return Thanks to all so far, The query should give the smallest price MIN(preis) and the according lfd number of this record. so the answer should only be one pair f.e.: 15200,00 | 41 . I think this should work, as this is the same row ??? Maybe a bug? MySQL 3.22.32 is running. Oliver You asked it to GROUP all the records with the same preis, that means it has to choose a value for each column of the record that is the result of each grouping, correct? So which of the (for example eleven (elf for you deutche;o)) different values of database.lfd did you want to have returned in your one resulting record? Obviously the database cannot stuff 11 values into one field You need something like select min(preis), max(lfd) or some other summary function, OR you need to GROUP BY preis,lfd. You simply cannot have it both ways. In fact (Monty are you listening!!!) MySQL needs to throw an error on this sort of query because it is relationally incorrect and the database engine cannot fullfill it correctly. I made some grouping errors, and wondered about the noise the linux-box made, until i made a ps ax to see a lot of mysql-instances running mad ;-) For some odd reason though, human brains have a really hard time understanding this concept. If you want to really understand it, pretend to be a database and process a GROUP BY of the form he's having problems with, then you'll understand. ;o). I do not understand why select MIN(), something needs a GROUP BY in my case, as the result is in the same row as mentioned above. structual information of the database: database.preis = decimal(12,2), database.lfd=int(11), database.typ=varchar(30), database.marke=varchar(50) The following requests works select min(preis) from database also select min(preis) from database where marke='marke' and typ not like 'R%' and typ not like 'X%' but I have to get another value from the db so i choose select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis this doesn´t bring the expected pair preis / lfd but all available preis/lfd grouped ascending. - 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
Editing system vars
I am relatively new to MySQL I need to edit my db variables. How is this done ? From the command line or by editing a file? My OS is Windows. 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
appropriate datatype - blob/text?
Hi, I wonder if someone could offer me some advice. One of the requirements for my database is that it must store (in one field) the contents of a text file (never exceeding 1MB). The data is obviously plain text format, and is in the following format: .010 .1083649E+03 .2186916E+02 .0013470 .1993729E+03 .2738670E+02 .0026940 .5308654E+03 .7280664E+02 . . .0040410 .2063586E+04 .2057984E+03 I would like to know what the most suitable and/or efficient method of storage would be. I am assuming BLOB or TEXT. Any advice would be greatly appreciated. - Best regards, Lee bypass_filter sql,query /bypass_filter - 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 have a look on this group by
In this case you have to omit GROUP BY from your query. Peter On Tue, 19 Feb 2002, CreaCtion wrote: At 19.02.2002 10:20, you wrote: What would you expect the database to return Thanks to all so far, The query should give the smallest price MIN(preis) and the according lfd number of this record. so the answer should only be one pair f.e.: 15200,00 | 41 . I think this should work, as this is the same row ??? Maybe a bug? MySQL 3.22.32 is running. Oliver -- GPG ID D40940EC FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC - 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 performance question
Thanks a lot for the advices. The value for table_cache is 8572, and I'm indeed accessing a lot of tables. So as I gather it the main effect should be expected from transfering to MySQL 4.0.1 compiled with LINUX_THREADS and using innodb tables, true? Now what can you say about reliability issue, aren't these products currently in the development stage and can they be used for the production server? Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Ken Menzel wrote: Date: Tue, 19 Feb 2002 10:07:22 -0500 From: Ken Menzel [EMAIL PROTECTED] To: Varshavchick Alexander [EMAIL PROTECTED], Simon Green [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Mysql performance question Hi Simon, A couple of things, unless you have compiled WITH_LINUX_THREADS from the /usr/ports/databases then adding more processors will be unlikely to help. The native threads lib on FreeBSD runs a threaded app on 1 processor currently, use the LINUX_THREADS option in the ports to get around this if you would like to add more processors. Do you have softupdates on also? Have you read 'man tuning'? Are you accessing alot of tables/DBs? If yes what is your table_cache value? What is in 'SHOW STATUS' and 'SHOW VARIABLES'? Also MySQL 4.0.1 has a query cache that is incredible! It works great. 6000 queries per minute is pretty good performance. Have you looked at using heap tables where possible? Another suggestion if everything is hitting the same table/database have you tried innodb tables? They work very well under high loads. I would study all the 'SHOW STATUS' output and see if you can spot anything in the manual page for each of the variables. Best of Luck, Ken - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: Simon Green [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 8:30 AM Subject: RE: Mysql performance question Here is the hardware: 8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 1 rpm 18.2GB, Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI, FreeBSD says when booting: ADAPTEC RAID-50 370F Fixed Direct Access SCSI-2 device Tell me please if any other info is needed. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Simon Green wrote: Date: Tue, 19 Feb 2002 13:22:04 - From: Simon Green [EMAIL PROTECTED] To: 'Varshavchick Alexander' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Mysql performance question What disk drive have you got? We have found that this can help. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 13:14 To: [EMAIL PROTECTED] Subject: Mysql performance question Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about 100, yet under the top load it seems to be not enough. Here are the config options: set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=8M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=16 set-variable= max_write_lock_count=10 set-variable= thread_concurrency=8 The server itself is 2x PIII Intel Xeon 700 MHz, Intel KOA4 platform, with 4G RAM. Mysql 3.23.47 (binary distribution), FreeBSD 4.5 system. All mysql queries are rewritten so the INSERT/UPDATE's has been reduced or replaced by DELAYED as much as possible, to ease mysql locking. The mysql tables are indexed, all documentation from the main mysql site having been studied. And under the top load the mysql starts locking anyways. So what can be the best ways of helping it: - Changing mysql options, may be increasing key_buffer some more or what else? - Adding 2 more CPU's to the server (it can bear up to 4 CPU); - May be there can be some other ways? Thanks in advance! Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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
HTML dumping into browser...
I am having trouble convincing my SQL admin at the hosting company that something is wrong with the server / speed. It is really odd, but in myPhpAdmin for example, on the left hand side the list of databases comes out properly for about 95% of the list, then it starts dumping HTML into the frame. I thought this was just poor coding and a burp / hiccup, however, when the tech tried to perform the same functions in Vancouver, and also via a server in Florida, he did not have the problem. However, when tried from home on a DSL line, and from a phone line in rural Ontario(canada) not only the PHPadmin is farting, but some of my code as well Has anyone experienced this problem? (HTML code just being dumped to the page) losing buttons / hyperlinks and having them replace with text... (sporadically) Patrick Egan Egan Consulting 15 Elvina Gardens Toronto, Ontario M4P 1X7 T] 416 630 4982 F] 416 488 7187 C] 416 726 4832 Pager] 416 377 9031 E] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] W] www.eganconsulting.com http://www.eganconsulting.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
Generating SQL code?
I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything extra on my server. Thanks. Sterling J. Anderson 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
Re: Generating SQL code?
See mysqldump utility, it does exactly what you ask. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Sterling J. Anderson wrote: Date: Tue, 19 Feb 2002 11:14:11 -0600 From: Sterling J. Anderson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Generating SQL code? I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything extra on my server. Thanks. Sterling J. Anderson 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 - 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
basic query question
I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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
SOLVED ..Please have a look on this group by..,not really
Again, thanks to all, who helped. None of your advices gave the desired pair combination single row preis/ lfd, but just looking at the first row, gave the correct answer as I grouped by preis, lfd. I was irritated by the results, the command-line gave me. Even as I wanted the quantity of returned rows (numrows) to be a flag. So now I use the sql-query : select min(preis),lfd from database where marke='marke' and typ not like 'R%' and typ not like 'X%' and typ not like 'C%' group by preis, lfd; (this gives me several lines ordered, so the min(preis),lfd is the first row) Oliver - 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 C API ----------!
I have a written a Windows client that accesses a MySQL server (Linux) via the MySQL C API. Stored in the MySQL database are large files (larger than a Mbyte). The C API makes it very easy for the client to query and alter the database. However, I have some special needs that don't appear to be addressed by the C API. The windows client needs the ability to download files from the database. But, before the files can be downloaded to the client, the server needs to insert (into the file) some custom information and then encrypt the entire file. Here are my questions: 1. Is there any way I can get MySQL (by means of the C API) to execute a custom process on certain entries in the database? 2. Once the custom processing has been accomplished, how can I transfer the customized file from the server to the client? 3. Apache is not part of the equation, but I would love to use PHP to solve the above problems. Is there any way that this could be accomplished? Thanks in advance for any advice that you might have. Ron - 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: [SECURITY] How do these blank passwords get into mysql.user?
»Philip Mak« sagte am 2002-02-19 um 10:25:38 -0500 : One thing's been bothering me for a while: When I create a user and database in MySQL, the user always ends up with an extra entry with host='%' and password=''. How is this happening? This is how I create a new database and user: mysql create database xxx; Query OK, 1 row affected (0.01 sec) mysql insert into user set host='localhost', user='xxx', password=password('yyy'); Here you set that the user xxx has the password yyy. mysql grant all privileges on xxx.* to xxx; Here you insert another user but don't set a password! BTW: You don't have to insert the user manually. If you try to GRANT access to a non existing user, the user will be silently created. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 days 9 hours 56 minutes - 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: Generating SQL code?
Take a look at mysqldump John On Tuesday 19 February 2002 12:14, Sterling J. Anderson wrote: I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything extra on my server. Thanks. Sterling J. Anderson 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 - 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: Running MySQL on Dos System?
At 10:51 19/02/2002 -0500, Martin Filteau wrote: Hi, Is it possible to port MySql on a Dos Computer ? Sorry no. You need at least a 32 bit OS. Regards, Miguel Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Editing system vars
Mark, Tuesday, February 19, 2002, 6:31:26 PM, you wrote: MS I am relatively new to MySQL I need to edit my db variables. MS How is this done ? From the command line or by editing a file? MS My OS is Windows. If you mean mysql options you can set variables by editing my.cnf(my.ini) file or by using SET statement or by setting mysqld command-line options. Look in the manual: http://www.mysql.com/doc/S/E/SET_OPTION.html http://www.mysql.com/doc/O/p/Option_files.html http://www.mysql.com/doc/C/o/Command-line_options.html MS Thanks MS Mark -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gross database lockup
I've upgraded a database server from: 2 x pIII 700MHZ 784Mb to 2 x pIII 1ghz 2gig ecc reg and have been having some sick database lockups since. 9:10pm up 6:11, 3 users, load average: 167.29, 108.42, 49.33 - unbelieveable load average. top shows 137 mysql 'threads?' CPU0 states: 99.26% user, 0.15% system, 0.0% nice, 0.0% idle CPU1 states: 99.4% user, 0.37% system, 0.0% nice, 0.0% idle both cpu's are pegged Mem: 2061960K av, 1427272K used, 634688K free, 0K shrd,5952K buff Swap: 522104K av, 0K used, 522104K free 1311104K cached Memory looks..ok. The disk is a raid 5 scsi array off of a adaptec(dpt) 2100S..the old raid controller was a 3200S (dual channel version) The array was swapable..so its the exact same data. I just moved the array to the new machine...and i dont see any pattern as to when it locks...seems a query just gets hung...and then stuff just keep stacking up till its completely locked. The previous machine/setup ran perfect...never anything like this at all. I'm using the same version of slackware on both machines...Started with 2.4.16, tried 2.4.17 and am using 2.4.12 kernel now (2.4.12 is the same kernel as the old machine) Same version of mysql as well I need to exhaust all my options before moving it back to the old machine... Anyone with some ideas? possible bad ram?? maybe corrupt datasomewhere? What is the best check practice for me..I did a myisamck -r on all tables..and sometimes some say is usable but needs fixing... Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 1058 Win2K Server with MySQL
At 07:49 19/02/2002 -0600, Gerald Jensen wrote: Hi! Did you tried to put the datadir variable too in the my.cnf file ? Anyway, when the service is failing try to start it as console: mysqld-nt --standalone --console In this way you should see the messages errors, also you can see them in the \data\mysql.err file. Regards, Miguel We are trying to install MySQL on a Windows 2000 Server, but are getting 'error 1058' when we try to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
v3.22.32 and temp tables
Hi, I want to build a temp table which I can query to sum values. If I try create temporary table tbl_name select some_query_here, then I get an error that tells me that I have an error with my sql syntax near 'temporary table tbl_name select some_query_here'. Am I correct in thinking that this is due to the version of mysql I'm using? (No, I can't upgrade it at this point). I wasn't successful in finding the answer to my dilemma at www.mysql.com/doc/manual.php. Thanks, Brian - 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: basic query question
At 19.02.2002 10:22, you wrote: I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic Try this, even if I´m careful due to my bad day, see todays threads ;-) select id, lname, fname, pic from database where engagedto=id; The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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: Generating SQL code?
At 11:14 -0600 2/19/02, Sterling J. Anderson wrote: I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything extra on my server. Thanks. Others have rightly pointed out mysqldump. Within SQL itself, you can use SHOW CREATE TABLE, at least if you have MySQL 3.23.19 or later. - 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: basic query question
assuming that engaedto refers to an id, your query might be: SELECT a.lname,a.fname,b.engagedto FROM mydata a LEFT JOIN mydata b ON(a.id=b.engagedto); -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: basic query question I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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: appropriate datatype - blob/text?
do you need to search on it? If not, perhaps storing these files separately with a pointer storedd in the database. This will improve searching speed I understand. -Original Message- From: Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 10:29 AM To: MySQL Subject: appropriate datatype - blob/text? Hi, I wonder if someone could offer me some advice. One of the requirements for my database is that it must store (in one field) the contents of a text file (never exceeding 1MB). The data is obviously plain text format, and is in the following format: .010 .1083649E+03 .2186916E+02 .0013470 .1993729E+03 .2738670E+02 .0026940 .5308654E+03 .7280664E+02 . . .0040410 .2063586E+04 .2057984E+03 I would like to know what the most suitable and/or efficient method of storage would be. I am assuming BLOB or TEXT. Any advice would be greatly appreciated. - Best regards, Lee bypass_filter sql,query /bypass_filter - 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: Error 1058 Win2K Server with MySQL
Problem is solved ... customer had his server configured so any new services being installed were automatically disabled! That is why the service would not start. We have installed MySQL on about a dozen Win2K Advanced servers ... this is the first time we have encountered this issue. Thank you to those who responded! - Original Message - From: Miguel Angel Solorzano [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 12:05 PM Subject: Re: Error 1058 Win2K Server with MySQL At 07:49 19/02/2002 -0600, Gerald Jensen wrote: Hi! Did you tried to put the datadir variable too in the my.cnf file ? Anyway, when the service is failing try to start it as console: mysqld-nt --standalone --console In this way you should see the messages errors, also you can see them in the \data\mysql.err file. Regards, Miguel We are trying to install MySQL on a Windows 2000 Server, but are getting 'error 1058' when we try to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MOD_AUTH_MYSQL and apache
HAS anyone every used this Module to access mysql before , i have it working with clear text passwords just fine but when i took the encrypted ones from my old .htpasswd file and put them in my mysql table apache cant read them John Lord([EMAIL PROTECTED]) Network Administrator Studio for Publications Inc 410-723-7089 Office [EMAIL PROTECTED] Pager www.4jon.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: basic query question
select id, lname, fname, pic from database where engagedto=id; Sorry, mate, that won't work. That will find folks who are engaged to themselves, i.e., narcissists -Original Message- From: Oliver Heinisch [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 11:30 AM To: [EMAIL PROTECTED] Subject: Re: basic query question At 19.02.2002 10:22, you wrote: I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic Try this, even if I´m careful due to my bad day, see todays threads ;-) select id, lname, fname, pic from database where engagedto=id; The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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: v3.22.32 and temp tables
From the manual: In MySQL Version 3.23, you can use the TEMPORARY keyword... Sorry, mate, you are SOL until you upgrade -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:09 PM To: 'MySQL List' Subject: v3.22.32 and temp tables Hi, I want to build a temp table which I can query to sum values. If I try create temporary table tbl_name select some_query_here, then I get an error that tells me that I have an error with my sql syntax near 'temporary table tbl_name select some_query_here'. Am I correct in thinking that this is due to the version of mysql I'm using? (No, I can't upgrade it at this point). I wasn't successful in finding the answer to my dilemma at www.mysql.com/doc/manual.php. Thanks, Brian - 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
MySQL-3.23.49-1.src.rpm does not build on RedHat 6.2
I'm running MySQL on a RedHat 6.2 linux box (kernel 2.2.20). The MySQL-shared-3.23.49-1.i386.rpm package does not install since it's compiled using GLIBC 2.2. I've tried to build binary packages from MySQL-3.23.49-1.src.rpm as suggested. The compilation fails: creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I.. /include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3 -felide-const ructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exception s -fno-rtti -fpermissive -I/usr/local/mysql-glibc/include -c mysql.cc In file included from mysql.cc:48: /usr/include/curses.h:195: warning: `ERR' redefined /usr/include/sys/ucontext.h:74: warning: this is the location of the previous definition cc1plus: Invalid option `-fpermissive' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49' make: *** [all-recursive-am] Error 2 error: Bad exit status from /var/tmp/rpm-tmp.61911 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.61911 (%build) Is there anything missing or wrong in my system. What can I do? Thanks a lot - 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: MOD_AUTH_MYSQL and apache
On Tue, 19 Feb 2002 13:10:01 -0500, John Lord [EMAIL PROTECTED] wrote: HAS anyone every used this Module to access mysql before , i have it working with clear text passwords just fine but when i took the encrypted ones from my old .htpasswd file and put them in my mysql table apache cant read them You need to add to your .htaccess file: Auth_MySQL_Encryption_Types Crypt_DES MySQL this tells apache to use either the UNIX crypt or MySQL Password encryption Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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
innodb table status : Why is Max_data_length NULL?
I have two InnoDB tables using a pool of space (the combined size of the data files may change). I want to limit each to using half the amount of space (or split it in some manner .. 60%/40%, etc). So far I've done this with a daemon that runs all the time deleting appropriate rows when the table nears capacity (I have it looking at the Data_length and Index_length columns of Show table status like 'tablename' and compairing the sum to the max that I've hardcoded).. But of course this requires that magic number in there. I'd like to be able to pull the max out of the database somehow, which brings me to my question.. Why is max_data_length null? And is there a way I can get to this value? Is there a better/different way to do this? Thanks, Eric Mayers Software Engineer I Captus Networks query. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: basic query question
you will have to join the table with itself and reference it as if it is two tables. this might be slow however so you might want to make some specific indexes to speed it up. This Query will return all the people who are engaged and a picture of their fiancé: select p1.lname, p1.fname, p1.pic, p2.pic from people p1, people p2 where p1.id = p2.engagedto; this query will return people whether they are engaged or not: select p1.lname, p1.fname, p1.pic, p2.pic from people p1 left join people p2 on (p1.id = p2.engagedto); -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: basic query question I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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: basic query question
Okay, so I do this and all I end up with is +-+---+-+---+ | id | lname | fname | engagedto | +-+---+-+---+ | 131 | Hallows | Samuel | 131 | | 273 | Simmons | Maria | 273 | | 221 | Papa | Sharla | 221 | | 18 | Biehl | Ruth| 18| | 302 | Vance | Alicia | 302 | | 123 | Goettl| Christopher | 123 | | 78 | Ellsworth | Morgan | 78| | 204 | Millet| David | 204 | +-+---+-+---+ 8 rows in set (0.00 sec) The returning query doesn't seem very helpful. I guess what I want is mysql to return the results with each person they are engaged to in order. I added the p1.id and p1.engagedto fields. mysql select p1.id, p1.lname, p1.fname, p1.engagedto, p2.engagedto from members p1, members p2 where p1.id = p2.engagedto; +-+---+-+---+---+ | id | lname | fname | engagedto | engagedto | +-+---+-+---+---+ | 131 | Hallows | Samuel | 18| 131 | | 273 | Simmons | Maria | 78| 273 | | 221 | Papa | Sharla | 123 | 221 | | 18 | Biehl | Ruth| 131 | 18| | 302 | Vance | Alicia | 204 | 302 | | 123 | Goettl| Christopher | 221 | 123 | | 78 | Ellsworth | Morgan | 273 | 78| | 204 | Millet| David | 302 | 204 | +-+---+-+---+---+ 8 rows in set (0.01 sec) This at least shows me the info I had in my original table. If I looked at it I could see that id# 131 should match up with id# 18 and such. I guess I'm looking for a query that will match these to up either in the same row or one after another. Any help is SOOO appreciated! Dean - Original Message - From: Roger Karnouk [EMAIL PROTECTED] To: Dean Householder [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 12:17 PM Subject: RE: basic query question you will have to join the table with itself and reference it as if it is two tables. this might be slow however so you might want to make some specific indexes to speed it up. This Query will return all the people who are engaged and a picture of their fiancé: select p1.lname, p1.fname, p1.pic, p2.pic from people p1, people p2 where p1.id = p2.engagedto; this query will return people whether they are engaged or not: select p1.lname, p1.fname, p1.pic, p2.pic from people p1 left join people p2 on (p1.id = p2.engagedto); -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: basic query question I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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
Error 2013: Lost connection to MySQL server during query
Hopefully someone out there can help me as I haven't been able to find any documentation on this that applies. I am running MySQL version 3.22.32 on a FreeBSD v4.4 machine. I am getting Error 2013: Lost connection to MySQL server during query when I run the following query: select distinct Product.MFG_ID, MFG.Name fromProduct, Cat_link, MFG where MFG.ID=Product.MFG_ID and Product.ID=Cat_link.PROD_ID and Cat_link.CAT_ID=3 and Product.Status=A order by MFG.Name; Does anyone have any ideas? Thanks! TW - 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: basic query question
You're very close: mysql select p1.lname, p1.fname, p2.lname as engaged_lname, p2.fname as engaged_fname from members p1, members p2 where p1.id = p2.engagedto; but the REAL question is What do you want out of the query? -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 1:53 PM To: Roger Karnouk; [EMAIL PROTECTED] Subject: Re: basic query question Okay, so I do this and all I end up with is +-+---+-+---+ | id | lname | fname | engagedto | +-+---+-+---+ | 131 | Hallows | Samuel | 131 | | 273 | Simmons | Maria | 273 | | 221 | Papa | Sharla | 221 | | 18 | Biehl | Ruth| 18| | 302 | Vance | Alicia | 302 | | 123 | Goettl| Christopher | 123 | | 78 | Ellsworth | Morgan | 78| | 204 | Millet| David | 204 | +-+---+-+---+ 8 rows in set (0.00 sec) The returning query doesn't seem very helpful. I guess what I want is mysql to return the results with each person they are engaged to in order. I added the p1.id and p1.engagedto fields. mysql select p1.id, p1.lname, p1.fname, p1.engagedto, p2.engagedto from members p1, members p2 where p1.id = p2.engagedto; +-+---+-+---+---+ | id | lname | fname | engagedto | engagedto | +-+---+-+---+---+ | 131 | Hallows | Samuel | 18| 131 | | 273 | Simmons | Maria | 78| 273 | | 221 | Papa | Sharla | 123 | 221 | | 18 | Biehl | Ruth| 131 | 18| | 302 | Vance | Alicia | 204 | 302 | | 123 | Goettl| Christopher | 221 | 123 | | 78 | Ellsworth | Morgan | 273 | 78| | 204 | Millet| David | 302 | 204 | +-+---+-+---+---+ 8 rows in set (0.01 sec) This at least shows me the info I had in my original table. If I looked at it I could see that id# 131 should match up with id# 18 and such. I guess I'm looking for a query that will match these to up either in the same row or one after another. Any help is SOOO appreciated! Dean - Original Message - From: Roger Karnouk [EMAIL PROTECTED] To: Dean Householder [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 12:17 PM Subject: RE: basic query question you will have to join the table with itself and reference it as if it is two tables. this might be slow however so you might want to make some specific indexes to speed it up. This Query will return all the people who are engaged and a picture of their fiancé: select p1.lname, p1.fname, p1.pic, p2.pic from people p1, people p2 where p1.id = p2.engagedto; this query will return people whether they are engaged or not: select p1.lname, p1.fname, p1.pic, p2.pic from people p1 left join people p2 on (p1.id = p2.engagedto); -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: basic query question I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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
RE: MOD_AUTH_MYSQL and apache
i compiled it right into apache , it is working but using clear text passwords. Its 2.20, i found a 3.20 also but it wont compile at all, ive looked all over the web and noone else seems to have a problem , im at a loss here is my .htaccess that works AuthName Your Login is Required AuthType Basic Limit GET POST Auth_MySQL_DB members Auth_MySQL_Encrypted_Passwords off require valid-user /Limit John Lord([EMAIL PROTECTED]) Network Administrator Studio for Publications Inc 410-723-7089 Office [EMAIL PROTECTED] Pager www.4jon.com -Original Message- From: Mike(mickalo)Blezien [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 2:56 PM To: John Lord Subject: Re: MOD_AUTH_MYSQL and apache On Tue, 19 Feb 2002 14:34:16 -0500, John Lord [EMAIL PROTECTED] wrote: yeah tried that also , i get this error in my apache error log Invalid command 'Auth_MySQL_Encrypted_Types', perhaps mis-spelled or defined by a module not included in the server configuration do you have these lines somewhere in your httpd.conf: LoadModule auth_mysql_module libexec/mod_auth_mysql.so AddModule mod_auth_mysql.c and are you sure you have the the most recent version of the mod_auth_mysql installed, 2.20 Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 performance question
Your welcome Alexander! OK the value for table_cache is 8572 * 3 = 25716 file descriptors, how big is kern.maxfiles and kern.maxfilesproc? These need to be set above 26000 to allow all those tables to be opened! I know I have missed this sometime, or not reset them after a kernel compile. Also you don't need 4.0.1 for innodb tables, they work fine on 3.23.49 and LINUX_THREADS option from the ports package I think is only available for 3.23.xx versions. The only problems I have had with 4.0.1 have been self inflicted. There are some bugs in some of the newer features, 4.0.2 should be out soon. I have been kicking around the idea of using 4.0.1 in production as none of the bugs so far really affect my application. You can see the online change log for a list of changes and fixes since 4.0.1 at http://www.mysql.com/doc/N/e/News-4.0.2.html Good Luck, Ken - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED] Cc: Simon Green [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 11:31 AM Subject: Re: Mysql performance question Thanks a lot for the advices. The value for table_cache is 8572, and I'm indeed accessing a lot of tables. So as I gather it the main effect should be expected from transfering to MySQL 4.0.1 compiled with LINUX_THREADS and using innodb tables, true? Now what can you say about reliability issue, aren't these products currently in the development stage and can they be used for the production server? Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Ken Menzel wrote: Date: Tue, 19 Feb 2002 10:07:22 -0500 From: Ken Menzel [EMAIL PROTECTED] To: Varshavchick Alexander [EMAIL PROTECTED], Simon Green [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Mysql performance question Hi Simon, A couple of things, unless you have compiled WITH_LINUX_THREADS from the /usr/ports/databases then adding more processors will be unlikely to help. The native threads lib on FreeBSD runs a threaded app on 1 processor currently, use the LINUX_THREADS option in the ports to get around this if you would like to add more processors. Do you have softupdates on also? Have you read 'man tuning'? Are you accessing alot of tables/DBs? If yes what is your table_cache value? What is in 'SHOW STATUS' and 'SHOW VARIABLES'? Also MySQL 4.0.1 has a query cache that is incredible! It works great. 6000 queries per minute is pretty good performance. Have you looked at using heap tables where possible? Another suggestion if everything is hitting the same table/database have you tried innodb tables? They work very well under high loads. I would study all the 'SHOW STATUS' output and see if you can spot anything in the manual page for each of the variables. Best of Luck, Ken - Original Message - From: Varshavchick Alexander [EMAIL PROTECTED] To: Simon Green [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 8:30 AM Subject: RE: Mysql performance question Here is the hardware: 8x U160 SCA IBM UltraStar 36LZX Discovery 4MB cache 1 rpm 18.2GB, Adaptec 3200S 64MB Cache 32/64 bit PCI RAID U160 SCSI, FreeBSD says when booting: ADAPTEC RAID-50 370F Fixed Direct Access SCSI-2 device Tell me please if any other info is needed. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 19 Feb 2002, Simon Green wrote: Date: Tue, 19 Feb 2002 13:22:04 - From: Simon Green [EMAIL PROTECTED] To: 'Varshavchick Alexander' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: Mysql performance question What disk drive have you got? We have found that this can help. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 19 February 2002 13:14 To: [EMAIL PROTECTED] Subject: Mysql performance question Hi people, May be anybody can advice from the personal experience tweeking which options both in the mysql configuration and server hardware can help in increasing mysql performance speed? As it is now, mysql is configured to occupy about 600M RAM, and queries per second avg goes up to about 100, yet under the top load it seems to be not enough. Here are the config options: set-variable= key_buffer=512M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=8M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=16 set-variable= max_write_lock_count=10 set-variable= thread_concurrency=8 The server itself is 2x PIII Intel Xeon 700 MHz, Intel KOA4 platform, with 4G
Time bug with MySQL 3.23.49
After MySQL 3.23.49 was release the other day, I upgraded my server as usual. After a while I noticed something odd. All datetimes that were entered into the database after I upgraded the server to 3.23.49 were 5 hours ahead. I am located in Upstate NY, which I think is -5 hours from GMT. When I downgraded back to 3.23.48, the problem was fixed. Is this a bug or am I missing something? Some info about my server after the 3.23.49 upgrade: OS: RedHat Linux 7.1 Kernel: 2.4.10-ac2 Apache 1.3.22 with PHP 4.1.1 MySQL Client: 3.23.48 built into PHP/Apache (static) MySQL Server: 3.23.49 Richard Gabriel, CTO CoreSense Inc. (518) 276-2673 - 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: basic query question
Thank you all so much for helping me with this query. It works! Best of all, now I understand how to join tables and such! Thanks again! - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Dean Householder' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 1:04 PM Subject: RE: basic query question You're very close: mysql select p1.lname, p1.fname, p2.lname as engaged_lname, p2.fname as engaged_fname from members p1, members p2 where p1.id = p2.engagedto; but the REAL question is What do you want out of the query? -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 1:53 PM To: Roger Karnouk; [EMAIL PROTECTED] Subject: Re: basic query question Okay, so I do this and all I end up with is +-+---+-+---+ | id | lname | fname | engagedto | +-+---+-+---+ | 131 | Hallows | Samuel | 131 | | 273 | Simmons | Maria | 273 | | 221 | Papa | Sharla | 221 | | 18 | Biehl | Ruth| 18| | 302 | Vance | Alicia | 302 | | 123 | Goettl| Christopher | 123 | | 78 | Ellsworth | Morgan | 78| | 204 | Millet| David | 204 | +-+---+-+---+ 8 rows in set (0.00 sec) The returning query doesn't seem very helpful. I guess what I want is mysql to return the results with each person they are engaged to in order. I added the p1.id and p1.engagedto fields. mysql select p1.id, p1.lname, p1.fname, p1.engagedto, p2.engagedto from members p1, members p2 where p1.id = p2.engagedto; +-+---+-+---+---+ | id | lname | fname | engagedto | engagedto | +-+---+-+---+---+ | 131 | Hallows | Samuel | 18| 131 | | 273 | Simmons | Maria | 78| 273 | | 221 | Papa | Sharla | 123 | 221 | | 18 | Biehl | Ruth| 131 | 18| | 302 | Vance | Alicia | 204 | 302 | | 123 | Goettl| Christopher | 221 | 123 | | 78 | Ellsworth | Morgan | 273 | 78| | 204 | Millet| David | 302 | 204 | +-+---+-+---+---+ 8 rows in set (0.01 sec) This at least shows me the info I had in my original table. If I looked at it I could see that id# 131 should match up with id# 18 and such. I guess I'm looking for a query that will match these to up either in the same row or one after another. Any help is SOOO appreciated! Dean - Original Message - From: Roger Karnouk [EMAIL PROTECTED] To: Dean Householder [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 12:17 PM Subject: RE: basic query question you will have to join the table with itself and reference it as if it is two tables. this might be slow however so you might want to make some specific indexes to speed it up. This Query will return all the people who are engaged and a picture of their fiancé: select p1.lname, p1.fname, p1.pic, p2.pic from people p1, people p2 where p1.id = p2.engagedto; this query will return people whether they are engaged or not: select p1.lname, p1.fname, p1.pic, p2.pic from people p1 left join people p2 on (p1.id = p2.engagedto); -Original Message- From: Dean Householder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 12:22 PM To: [EMAIL PROTECTED] Subject: basic query question I'm fairly new to MySQL, so if anyone could help me I'd really appreciate it! What I'm trying to do is join two pictures in a database to each other. My database holds info about people with variables: id, lname, fname, engagedto, pic The engagedto field contains the id of the person they are engaged to. I'm trying to print the people that are engaged to each other next to each other. I've played with the join command and a little with group but don't really understand how these work... If anyone could point me in the right direction regarding how to query the database to return these records connected to each other, I would really appreciate it! Thanks so much Dean - 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:
Fatal error: Can't change to run as user 'mysql' ; Please check that the user exists!
Description: Followed steps to install binary distribution, including adding mysql user to group mysql. The user exists. When you run bin/safe_mysqld --user=mysql or if you run bin/mysqld --user=mysql or if you run bin/mysqld --user=#UID then it gives this error. No error if you su mysql first then run the command. How-To-Repeat: install the binary distribution, follow documented setup steps Fix: you can su mysql then run safe_mysqld. Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: safe_mysqld won't start with user mysql Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.49 (Official MySQL Binary) Environment: System: Linux francis 2.4.17 #1 SMP Tue Feb 19 14:10:05 EST 2002 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-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Feb 19 04:38 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 4783716 May 25 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 May 25 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 May 25 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpr! o -O3 -fno-omit-frame-pointer' CXX=gcc - 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
Flushing via JDBC
I am having problems flushing via jdbc. I have already granted the administrator reload permissions, but maybe I need to do something else. I am using MySQL version 3.23.47 and I am using JDBC 3.0. Has anyone ever had this type of problem? - 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
Flushing via JDBC
I am having problems flushing via jdbc. I have already granted the administrator reload permissions, and I am passing the query flush tables;, which seems to work in the command line. I am using MySQL version 3.23.47, mm.mysql-2.0.9, and JDBC 3.0. Has anyone ever had this type of problem? - 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: row level privilages - thoughts on how to do
Hi Noel, On Tue, 2002-02-19 at 13:40, [EMAIL PROTECTED] wrote: I'm wondering about row level privilages - being able to restrict what people see and can update etc on a row level as well as a column/table level. As others mentioned, having VIEWs wouldn't necessarily be of any help, since VIEWs are quite restrictive about INSERT/UPDATE type operations on the view. Anyway, after a little pondering, I think I've come up with a fairly nice solution for this problem. It is MySQL specific though: Use MyISAM MERGE tables (http://www.mysql.com/doc/M/E/MERGE.html). You can define a MERGE table, merging multiple *identical* MyISAM type tables. It is a bit like a view, in a way. You can do a query on the merge table, which will internally gather data from all the tables. How does this help you? You set up your permissions so that admin tools have full access to the merge table and all its parts. For individual users, you only grant access to their own table, to the extent that you want. Some shuffling between tables might be required when a row is for instance 'transfered' to another user, but I would figure that that is fairly easy to handle. Anyway, this way the plain end-user application can be bound by the user permissions, there's nothing specific the application needs to do, and no way for the user to circumvent that system. This may not be suitable for every situation, but it might be useful here Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and ASP.Net
Has anyone connected to a mysql database using ASP.NET If so can you point me in the right direction. I can't find anything on that query, Table, SQL Roger Karnouk - 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 off-the-shelf product
Hello everyone, Would someone know of off-the-self MySQL product that will contain latest MySQL server in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled with, PHP or perl. I just need to use the features of MySQL only. The reason I need it, is for FDA (Food and Drug Administration) standards approval. Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 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
Question about locking reads
Hi Guys According to documentation from MYSQL the query Select * from test where test=5 FOR UPDATE Should lock the row which satisfies the above condition. But this is not working for me. I tried this query with InnoDB table. Does anybody knows what could be a possible cause for this. Rajneesh - 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
-fno-implicit-templates, -fno-exceptions,-fno-rtti problems
Can somebody tell me why these 3 flags must be added when I compile mysql from source code? I am trying to use another compiler instead gcc to compile mysql. But it doesnot accept these three flags. From the readme, it seems to me that these flags (especially -fno-exceptions must be used). I want to find a workaround for this issue, but first I need to know why these flags are needed. Can you explain me this? Can I eliminate these options and make mysql still runs well? thanks. Peng - 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: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems
On Tuesday 19 February 2002 4:31 pm, Peng Zhao wrote: Can somebody tell me why these 3 flags must be added when I compile mysql from source code? I am trying to use another compiler I see no reason that these should be required. -fno-implicit-templates simply requires all templates to be explicit. -fno-exceptions tells the compiler that the code does not use exceptions (throw, catch, etc.) and results in a speed increase. -fno-rtti is for runtime type information, often used along with dynamic_cast and the like. Again, a speed increase and/or compiled code decrease if that is selected. instead gcc to compile mysql. But it doesnot accept these three flags. I'm curious... what are you using? Anyway, in summary and unless someone else speaks up, I see no reason why you'd actually need these flags. With gcc, these flags will improve performance a little but that is about all. - 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: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems
Thanks for your reply. But You can find something from http://www.mysql.com/doc/I/B/IBM-AIX.html : If you are using gcc or egcs to compile MySQL, you must use the -fno-exceptions flag, as the exception handling in gcc/egcs is not thread safe! (This is tested with egcs 1.1.) And it also says the mysqld will crash radmonly without -fno-exceptions flag. I wonder recent gcc maybe can go on without the flags? I am using orcc to compile mysql. Can you tell me how gcc improve speed via avoiding exceptions? I mean if the source code contains throw-catch stuff, how gcc avoid that? And why throw-catch stuff is not performance friendly (just because the exception handling mechanism? but usually exceptions are very rare, there is no need to avoid exception, from this point of view)? thanks. Peng - 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: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems
On Tuesday 19 February 2002 4:56 pm, Peng Zhao wrote: Thanks for your reply. But You can find something from http://www.mysql.com/doc/I/B/IBM-AIX.html : Thanks, I hadn't noticed that. If you are using gcc or egcs to compile MySQL, you must use the -fno-exceptions flag, as the exception handling in gcc/egcs is not thread safe! (This is tested with egcs 1.1.) And it also says the mysqld will crash radmonly without -fno-exceptions flag. I wonder recent gcc maybe can go on without the flags? To be honest, I am not sure about the later versions of gcc. It surprises me somewhat that exceptions aren't thread-safe in egcs. Still, it would be worth trying out with gcc 2.95.x or gcc 3.x. I am using orcc to compile mysql. Can you tell me how gcc improve speed via avoiding exceptions? I mean if the source code contains throw-catch stuff, how gcc avoid that? And why throw-catch stuff is not performance If the source code contains throw-catch, you are stuck. You _must_ turn on exception handling in order to use them. However, many people write code without any exceptions at all and in this case, the compiler can save some effort by not supporting them. Note, though, that most modern implementations of iostream, etc. etc. probably use exceptions. You may want to try out Intel's C++ compiler for Linux if you are using an ix86 CPU. We used it here at work and it resulted in code that ran more than twice as fast, though we have never tried it with MySQL. And greetings to a fellow UofA student (though I've now graduated). - 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: **Backing Up A Database**
Hi Felix (or anyone), I'm giving this a go but as a Linux newbie running Red hat 7.2 I have a question to ask Do I need to alter anything in Cron for it to run the logrotate script? What would I need to put into the hourly cron folder to make things happen more often to check they are working correctly? Alex -Original Message- From: Felix Richter [mailto:[EMAIL PROTECTED]] Sent: 18 February 2002 15:26 To: David yahoo; mySQL List Subject: Re: **Backing Up A Database** - create a file in /etc/logrotate.d, filename does not matter, take this as a template, fill in connection parameters in mysqldump call (): /home/backup/sqlback/mybackup.sql { daily nomissingok nocreate compress rotate 14 errors [EMAIL PROTECTED] prerotate mysqldump --opt --full /home/backup/sqlback/mybackup.sql endscript } - check syntax and options of this file: man logrotate - you're set: cron will call logrotate each night. logrotate processes each file in the dir, executes the prerotate script and then compresses the logfile (i.e. SQL-Dump), renames older ones and keeps at max 14 of them (rotate 14). nomissingok will let you know if the mysqldump failed Felix - 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.324 / Virus Database: 181 - Release Date: 14/02/2002 - 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: -fno-implicit-templates, -fno-exceptions,-fno-rtti problems
somewhat that exceptions aren't thread-safe in egcs. Still, it would be worth trying out with gcc 2.95.x or gcc 3.x. I used 2.95.3 to compile mysql, it is fine, just because it accepts those flags. I didnot try to switch those flags off and compile. I am using orcc to compile mysql. Can you tell me how gcc improve speed via avoiding exceptions? I mean if the source code contains throw-catch stuff, how gcc avoid that? And why throw-catch stuff is not performance If the source code contains throw-catch, you are stuck. You _must_ turn on exception handling in order to use them. However, many people write code without any exceptions at all and in this case, the compiler can save some effort by not supporting them. Will this improve the performance? I mean just by not supporting them, no optimization to the code? You may want to try out Intel's C++ compiler for Linux if you are using an ix86 CPU. We used it here at work and it resulted in code that ran more than twice as fast, though we have never tried it with MySQL. I wonder whether Intel's C++ compiler accept those flags. Are those flags included in some standards? My problem is that I don't want the mysqld crashed randomly when I do benchmarking on it. And greetings to a fellow UofA student (though I've now graduated). thank you. I am honored. -- Regards Peng -- Peng Zhao [EMAIL PROTECTED] http://www.cs.ualberta.ca/~pengzhao TEL (Lab): (780)492-3725 Lab: CSC251 - 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
Installation Problem mysql-3.23.49
Description: When I run a ./configure --prefix=/usr/local/mysql --with-libwrap the configure completes but the make fails. Making all in sql make[2]: Entering directory `/usr/local/src/mysql-3.23.49/sql' Making all in share make[3]: Entering directory `/usr/local/src/mysql-3.23.49/sql/share' make[3]: Nothing to be done for `all'. make[3]: Leaving directory `/usr/local/src/mysql-3.23.49/sql/share' make[3]: Entering directory `/usr/local/src/mysql-3.23.49/sql' c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\-DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc mysqld.cc: In function `void *handle_connections_sockets (void *)': /usr/include/tcpd.h:131: too many arguments to function `void sock_host ()' mysqld.cc:2395: at this point in file /usr/include/tcpd.h:69: too many arguments to function `int hosts_access ()' mysqld.cc:2396: at this point in file /usr/include/tcpd.h:124: too many arguments to function `char *eval_client ()' mysqld.cc:2401: at this point in file make[3]: *** [mysqld.o] Error 1 make[3]: Leaving directory `/usr/local/src/mysql-3.23.49/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.49/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.49' make: *** [all-recursive-am] Error 2 If I run the configure without --with-libwrap mysql compiles and installs fine. Any help offered would be appreciated. How-To-Repeat: See above Fix: Submitter-Id: submitter ID Originator:Clinton Dilks Organization: HortResearch New Zealand MySQL support: [none] Synopsis: Mysql-3.23.49 wont compile from source on redhat 7.1 when you specify the --with-libwrap option Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Source distribution) Environment: Compaq Deskpro EN, 256MB Ram, Redhat 7.1 System: Linux silver.marc.hort.cri.nz 2.4.2-2 #1 Sun Apr 8 20:41:30 EDT 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.1 2.96-85) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 15 12:18 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5724399 Oct 4 05:55 /lib/libc-2.2.4.so -rw-r--r--1 root root 27314604 Oct 4 05:52 /usr/lib/libc.a -rw-r--r--1 root root 178 Oct 4 05:52 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler - 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
security concerns and 1044 access denied problem
Hi gurus, Here's my problem: After installing binary version of mysql on sun, I try to add a new user and a new database, namely `dbuser' and `mydb', such that dbuser can access mydb but nothing else. However I found that if I do not grant dbuser 'select' privilege in mysql.user, dbuser cannot connect even if dbuser is granted select privilege for mydb in mysql.db. (1044 error) After granting dbuser 'select' privilege in mysql.user, dbuser can connect to mydb but then dbuser can connect to the database called 'mysql' as well, and thus read mysql.user. Now dbuser knows more than he needs, which is a security concern for me. So is there a way to both be secure and still allow a user to connect? Thanks - Ran Pang SE 99 e-mail: [EMAIL PROTECTED] http://www.cas.mcmaster.ca/~pangr tel: (905)529-5619 - 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
using MySQL
I seem to have forgotten how to get into MySQL and work. (It's been a while but I'm starting up again. I get these errors: bob@sfpetard:~ mysqladmin create library mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'library'' and: bob@sfpetard:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 to server version: 3.23.44-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases - ; +---+ | Database | +---+ | addresses | | inventory | | libes | | mysql | | sample| | test | +---+ 6 rows in set (0.01 sec) mysql use libes ERROR 1044: Access denied for user: '@localhost' to database 'libes' I am doing this on SuSE 7.3. I know there is a user mysql already set up but I don't knwo the password. -- Bob Rea ** On the side of the box, under 'System Requirements', it said 'Requires Windows 95 or better'. So I installed Linux. ** [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: would you send me the mysql distribution which can support big5
- Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: Tony Wu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 8:38 PM Subject: Re: would you send me the mysql distribution which can support big5 On Tue, 19 Feb 2002 12:43:04 +0800 Tony Wu [EMAIL PROTECTED] wrote: Dear Sir, Would you send me the mysql distribution which can support big5, because our databases has too many big5 character! Please help! Your Sincerely, Tony Wu EDP Department Tel : 852-29435587 Sanyo Energy (HK) Co., Ltd. Hi! This list is dedicated to the discussions on the internal functioning of mysql server. For the questions, like the above, please write to [EMAIL PROTECTED] -- Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL with SSL support
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, Need: Communicate securely using PKI from a DBI perl script to MySQL where dozens of clients connect from multiple sites around the country (stunnel is not an option :( If I issue a grant command like such GRANT ALL PRIVILEGES ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY goodsecret REQUIRE SUBJECT C=EE, ST=Some-State, L=Tallinn, O=MySQL demo client certificate, CN=Tonu [EMAIL PROTECTED] AND ISSUER C=FI, ST=Some-State, L=Helsinki, O=MySQL Finland AB, CN=Tonu [EMAIL PROTECTED] AND CIPHER EDH-RSA-DES-CBC3-SHA I am assuming that in order to make something like this work that you would also need to present your client certificate then the mysqld would check the issuer and the cn for the client, but reading through the documentation, and the change log for DBD:MYSQL I don't see anything that would allow me to specify the client certificate. Searching through google I did find http:[EMAIL PROTECTED]/msg00050.html which specs that you are supposed to use mysql_ssl=1 in the DSN but that only gets me half way there. I was wondering if any of you guys out there have found a way around this tid bit of a problem. Background: I have version 4.01 running on a Linux 7.1 machine the environment variables for SSL show up. Thanks in Advance, JC -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBPHMOqnX+hJvt5DtWEQIFFgCfQDNuz4buG7JQp1iDVkGIzZIfAM0AnivJ t1do+xjkRMJiJVzoQl8PeBxC =P9HK -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: using MySQL
You did not setting privilege for yourself to use MySQL access. See something about Security issue in MySQL manual (online or donwload). If you need the tools to setup MySQL instead of MySQL command prompt try PHPMyAdmin (web based) or MySQLFront (windows based). SF At 16:01 19/2/2002 -0800, Bob Rea wrote: I seem to have forgotten how to get into MySQL and work. (It's been a while but I'm starting up again. I get these errors: bob@sfpetard:~ mysqladmin create library mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'library'' and: bob@sfpetard:~ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 to server version: 3.23.44-Max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases - ; +---+ | Database | +---+ | addresses | | inventory | | libes | | mysql | | sample| | test | +---+ 6 rows in set (0.01 sec) mysql use libes ERROR 1044: Access denied for user: '@localhost' to database 'libes' I am doing this on SuSE 7.3. I know there is a user mysql already set up but I don't knwo the password. -- Bob Rea ** On the side of the box, under 'System Requirements', it said 'Requires Windows 95 or better'. So I installed Linux. ** [EMAIL PROTECTED] http://home.earthlink.net/~sfpetard/ - 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 be informed that all e-mail which are addressing to thaithanakit.co.th will need to be changed to BTsecurities.com by March 1, 2002 Thank you. :-) -- - 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 with SSL support
Hi JC I know you said stunnel is not an option but how about SSLwrap? http://www.quiltaholic.com/rickk/sslwrap/ james At 18:49 19/02/2002 -0800, JC wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, Need: Communicate securely using PKI from a DBI perl script to MySQL where dozens of clients connect from multiple sites around the country (stunnel is not an option :( If I issue a grant command like such GRANT ALL PRIVILEGES ON test.* TO [EMAIL PROTECTED] IDENTIFIED BY goodsecret REQUIRE SUBJECT C=EE, ST=Some-State, L=Tallinn, O=MySQL demo client certificate, CN=Tonu [EMAIL PROTECTED] AND ISSUER C=FI, ST=Some-State, L=Helsinki, O=MySQL Finland AB, CN=Tonu [EMAIL PROTECTED] AND CIPHER EDH-RSA-DES-CBC3-SHA I am assuming that in order to make something like this work that you would also need to present your client certificate then the mysqld would check the issuer and the cn for the client, but reading through the documentation, and the change log for DBD:MYSQL I don't see anything that would allow me to specify the client certificate. Searching through google I did find http:[EMAIL PROTECTED]/msg00050.html which specs that you are supposed to use mysql_ssl=1 in the DSN but that only gets me half way there. I was wondering if any of you guys out there have found a way around this tid bit of a problem. Background: I have version 4.01 running on a Linux 7.1 machine the environment variables for SSL show up. Thanks in Advance, JC -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBPHMOqnX+hJvt5DtWEQIFFgCfQDNuz4buG7JQp1iDVkGIzZIfAM0AnivJ t1do+xjkRMJiJVzoQl8PeBxC =P9HK -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php James Carrier Bullet Online :: Aim Higher [http://www.bulletonline.com] 41b Beavor Lane, London W6 9BL Tel +44 (0) 20 8834 3442 Fax +44 (0) 20 8741 2790 - 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
Question on maximum record input frequency and table lengths.
Hello, We are considering using MySQL in an application involving recording and processing analog signal inputs from various electric powerplant instrumentation. Some (but not a majority) of these signals will take and need to record and discrete measurements at a frequency from 360 to 1000 or so times per second. These measurements will be subject to relatively simple queries (greater than or less than comparisons and conditional statements) As each instrument monitored will be providing a distinct piece of data on a separate analog channel, and will not by precisely synchronous with output from other analog channels, our initial idea is to have each analog channel output to a separate table in the database. On the largest plants we would expect to monitor, we would have about 42 separate analog channels (tables) taking data at the 360 or more times per second. Each of these tables would have two fields - a record number (index) autoincrementing, and a numeric (probably a smallint in most cases) which are change, and a couple of static identifier fields, so each record would be on the order of 100 bytes or less. Assuming there are no hardware constraints (everything would be on dedicated servers, with whatever hardware is necessary) are there any known limits on how many tables/records the MySQL database engine can handle? Most of this data would be disposed of (reduced to one record per second) after 24 hours, if no plant alarm conditions have occurred in that 24 hour period, so permanent storage of huge tables isn't an issue - but at 360 x 86400 seconds per day, there would still be several million records in these tables - is there any means of estimating the impact this would have on the number of records and tables which could be successfully written in this scenario? Thank you for any help you are able to give, or any resources you can point us to. Michael Mitchell, Principal, DGRI Systems - 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
I can't find file mysqld.sym.gz!
hello~ When I try to Using a stack trace there's no mysqld.sym.gz on our server . Can we always find mysqld.sym.gz on any operating system? Our operating system is Linux 7.0 . I would like to mail you our error log to see if you can tell us what's wrong with our MySQL which always crash unexpectedly . Thanks ! Sincerely yours . Tracy Lu Following is error log: 020213 21:50:23 mysqld started /home/ap1/libexec/mysqld: ready for connections 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. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x4007d00e 0x815f4f8 0x815f1c1 0x8143b08 0x81503ff 0x81506b9 0x81505ae 0x810e625 0x81050f7 0x8104de8 0x8105f73 0x8102107 0x80e3cc1 0x80e20ac 0x80c7605 0x80cb4ec 0x80c6a4d 0x80c5f66 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x823a7c0 = select count(invno) as tlrecs from srvmst where invno='k0036381' and strno ='2053' thd-thread_id = 9861 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 9861 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 020218 15:01:50 mysqld restarted /home/ap1/libexec/mysqld: ready for connections 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. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x4007d00e 0x4011bf48 0x80d82fa 0x80cb4d7 0x80c6a4d 0x80c5f66 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8223268 = insert into tmptree1 (unid,parent,child,title,att,filename,sysfilename,owner,beginday,begintime,e ndday,endtime,sequence,groupname) values ('3d850d56f8784f4f64427363cfe07f6e','309082909d9419a6201c622129c8357e','1efe 2c23f8f57e71df959033b1344a83','°w¹ïAcer²£«~¤§·s«~¬G»Ù»Pºû׫~³B²z¤è¦¡ ','D','4.txt','2587a47633a7f3c62bb96f1587bd2ccf.txt','90113','2000.12.13','1 2:00','2002.12.10','24:00',8,'Àç·~¸s²Õ') thd-thread_id = 79 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 79 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 1 mysqld process hanging, pid 29649 - killed 020218 15:19:42 mysqld restarted /home/ap1/libexec/mysqld: ready for connections 020218 15:37:01 mysqld started /home/ap1/libexec/mysqld: ready for connections 020218 16:02:10 /home/ap1/libexec/mysqld: Normal shutdown - 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: Question on maximum record input frequency and table lengths.
Hi Michael, On Wed, 2002-02-20 at 13:29, Michael Mitchell wrote: We are considering using MySQL in an application involving recording and processing analog signal inputs from various electric powerplant instrumentation. Interesting application! It is always nice to hear where MySQL is being used Assuming there are no hardware constraints (everything would be on dedicated servers, with whatever hardware is necessary) are there any known limits on how many tables/records the MySQL database engine can handle? The limits are known, see http://www.mysql.com/doc/T/a/Table_size.html As you will see, provided you are using a recent version of MySQL Server, the only possible issues stem from operating system limitations. So that is something to keep an eye on when building your servers and choosing an operating system. Linux and Solaris are the most used and generally give the best performance, but FreeBSD (latest version) is also popular. Most of this data would be disposed of (reduced to one record per second) after 24 hours, if no plant alarm conditions have occurred in that 24 hour period, so permanent storage of huge tables isn't an issue - but at 360 x 86400 seconds per day, there would still be several million records in these tables - is there any means of estimating the impact this would have on the number of records and tables which could be successfully written in this scenario? This type of application and size should not be a problem, MySQL is used quite often in high volume logging. MySQL also offers specific features such as MERGE tables that allow you to operate on large sets of (historical) data. Older tables may even be compressed (and archived on CD) while still being read-only accessible, and be fully combined (by the server) with the latest online data. Optionally, the system collecting the latest data could be separated from the system that deals with the older aggregate information. Thank you for any help you are able to give, or any resources you can point us to. I hope the above will give you some basic idea of what is possible. For more detailed questions, you may wish to contact [EMAIL PROTECTED] Another option could be MySQL training (http://ww.mysql.com/training/); the courses spend considerable time on optimisation of the operating system and MySQL Server configuration, database design and queries. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please, need help urgently
I need some help, this is a mission critical server and it has CRASHED! Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port) The server had to be rebooted, and when it came back up, my MySQL server died. It's been working flawlessly for months (5 or 6), but all the sudden mysqld will not start. Here's whats in my log... __ 020219 22:52:00 mysqld restarted 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. 020219 22:52:00 mysqld restarted 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. 020219 22:52:01 mysqld restarted 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. 020219 22:52:01 mysqld restarted 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. _--_ This keeps repeating and repeating. Since it's a port I don't have debugging compiled into MySQL, so I can't stack trace. I've used isamchk, myisamchk, and mysqld --flush to try to clean everything up, but no luck. Please help, I need to get this thing back up tonight! If you need anymore info, I'll be on this group all night until I get this thing back up. Thanks in advance! NR - 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
I can't find file mysqld.sym.gz!
hello~ When I try to Using a stack trace there's no mysqld.sym.gz on our server . Can we always find mysqld.sym.gz on any operating system? Our operating system is Linux 7.0 . I would like to mail you our error log to see if you can tell us what's wrong with our MySQL which always crash unexpectedly . Thanks ! Sincerely yours . Tracy Lu Following is error log: 020213 21:50:23 mysqld started /home/ap1/libexec/mysqld: ready for connections 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. Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Stack range sanity check OK, backtrace follows: 0x4007d00e 0x815f4f8 0x815f1c1 0x8143b08 0x81503ff 0x81506b9 0x81505ae 0x810e625 0x81050f7 0x8104de8 0x8105f73 0x8102107 0x80e3cc1 0x80e20ac 0x80c7605 0x80cb4ec 0x80c6a4d 0x80c5f66 Stack trace successful, trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x823a7c0 = select count(invno) as tlrecs from srvmst where invno='k0036381' and strno ='2053' thd-thread_id = 9861 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 9861 did to cause the crash. In some cases of really bad corruption, this value may be invalid Please use the information above to create a repeatable test case for the crash, and send it to [EMAIL PROTECTED] Number of processes running now: 0 - 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, need help urgently
Hi, It would be time consuming to understand why the server crashed and then repair the server, as u say it is a mission crtical one , the quickest way to get it up and running would be to back up the database (copy the ur database directory completely under the data directory) reinstall MySQL cleanly and get the DB back in action again.Also make sure u've got a 'release' build of MySQL, I got the following info from a site hope that helps.. Signal 11 Description : Signal 11, or officially know as segmentation fault, means that the program accessed a memory location that was not assigned. That's usually a bug in the program. So if you're writing your own program, that's the most likely cause. However, this FAQ will concentrate on the possibilities besides that. The cause can be software or (most likely) hardware for a Signal 11 crash. Read on to find out more. (*) Of course nothing is Linux specific. If your hardware is flaky, Linux, Windows 3.1, FreeBSD, Windows NT and NextStep will all crash. If you are not reading this at http://www.BitWizard.nl/sig11/, that's where you can find the most recent version. cheers, Sundara Pandian, Megasoft Ltd, India. - Original Message - From: SplitSlim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 20, 2002 10:14 AM Subject: Please, need help urgently I need some help, this is a mission critical server and it has CRASHED! Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port) The server had to be rebooted, and when it came back up, my MySQL server died. It's been working flawlessly for months (5 or 6), but all the sudden mysqld will not start. Here's whats in my log... __ 020219 22:52:00 mysqld restarted 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. 020219 22:52:00 mysqld restarted 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. 020219 22:52:01 mysqld restarted 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. 020219 22:52:01 mysqld restarted 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. _--_ This keeps repeating and repeating. Since it's a port I don't have debugging compiled into MySQL, so I can't stack trace. I've used isamchk, myisamchk, and mysqld --flush to try to clean everything up, but no luck. Please help, I need to get this thing back up tonight! If you need anymore info, I'll be on this group all night until I get this thing back up. Thanks in advance! NR - 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 off-the-shelf product
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Demirchyan Oganes-AOD098 declared Would someone know of off-the-self MySQL product that will contain latest MySQL server in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled with, PHP or perl. I just need to use the features of MySQL only. The reason I need it, is for FDA (Food and Drug Administration) standards approval. Try nusphere.com, I believe they might have what you're after. - -- - --- www.explodingnet.com |Projects, Forums and +Articles for website owners - -- Nick Wilson -- |and designers. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8c029HpvrrTa6L5oRAv0KAKCHcho4UkbYNGUEYEwz7A+4WGrDEwCffSRe Xe8bDDQbSkUwyJn5a6m7RHs= =m5b9 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL off-the-shelf product
Hi! I believe NuSphere does not distribute MySQL-Max-3.23. Tergat MySQL Studio contains MySQL-Max-3.23.47. Do you literally need an 'off-the-shelf' product? Tergat is available as a downloadable version for $66. The physical boxset version is not available yet, I think. ... http://www.mysqlstudio.com/ Tergat MySQL Studio contents: - Navicat (Version 4.1) - Tergat MySQL launcher (Version 3.1) - Tergat MySQL installer - MySQL database server (MySQL Max 3.23.47) - Apache web server (Apache 1.3.20) - PHP scripting languages (PHP 4.0.6) - Comprehensive documentation Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com -Original Message- From: Nick Wilson [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Wednesday, February 20, 2002 9:17 AM Subject: Re: MySQL off-the-shelf product -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Demirchyan Oganes-AOD098 declared Would someone know of off-the-self MySQL product that will contain latest MySQL server in it? Something like 3.23.46a max-nt and above. I don't care what it's bundled with, PHP or perl. I just need to use the features of MySQL only. The reason I need it, is for FDA (Food and Drug Administration) standards approval. Try nusphere.com, I believe they might have what you're after. - -- - --- www.explodingnet.com |Projects, Forums and +Articles for website owners - -- Nick Wilson -- |and designers. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8c029HpvrrTa6L5oRAv0KAKCHcho4UkbYNGUEYEwz7A+4WGrDEwCffSRe Xe8bDDQbSkUwyJn5a6m7RHs= =m5b9 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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