RE: Frequent Table Corruption - Please Help
hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 22:35 To: Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Frequent Table Corruption - Please Help Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:08 PM Subject: Re: Frequent Table Corruption - Please Help Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again! it may be worthwhile to test a new kernel in one of those problematic computers. We believe corruption problems in RH 2.4.18/drivers are random. Then any small change can provoke them. But we will probably never know what exactly was wrong in some 2.4.18 computers. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 9:52 PM Subject: Frequent Table Corruption - Please Help Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is that once the table is corrupted, it seems to be locked. Well, no clients can read from it. Once repaired, just one record is usually lost for each time the corruption occurs. I am not sure if this is a MySQL bug or even how to reproduce it, but I was hoping that someone here could help. I have included all the information that I have about this below. Any insight is greatly appreciated! Here is the mysqlbug information: Release: mysql-4.0.13 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux *.com 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/ccGCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Nov 1 2002 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 5 2002 /lib/libc-2.2.93.so -rw-r--r--1 root root 2233342 Sep 5 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 5 2002 /usr/lib/libc.so Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' '--with-client-ldflags=-all-static' '--without-berkeley-db' '--with-innodb' '--without-vio' '--without-openssl' '--enable-assembler' '--enable-local-infile' '--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock'
Connection problem!!! Windows to Linux
Hi there: I need URGENT help about this .. I wrote a program application for windows which can add and delete data from this application, it working fine with my own MySQL install on the same windows OS.. Now I try to change the connection this dayabase to the server whihc runnign under linux, and create the same database, same user and password. But when I connect the error message said: [MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to connect to this MYSQL Server. But form the database, I added the host %, means hsould be allow any host... anyone can help me on this? the application I wrote will be using with dynamic IP everytime user dial-up to the internet connect.. wish to hear some help soon.. -- Best, Aric Cheah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
subselect question... shouldn't this work?
I am new to subselects, and what I really want is to do them in an update, but the following shows a simpler select, that also doesn't seem to work as I think it should. Advice? Do I just misunderstand how subselects are actually executed? (This is on mysql version 4.1.0-alpha-max-nt.) First, here's the tables in question: mysql describe m; +---+-+---+--+-+-+---+ | Field | Type| Collation | Null | Key | Default | Extra | +---+-+---+--+-+-+---+ | toid | int(11) | binary| YES | | NULL| | | rd| int(11) | binary| YES | | NULL| | +---+-+---+--+-+-+---+ mysql describe p; +-+-+---+--+-+-+---+ | Field | Type| Collation | Null | Key | Default | Extra | +-+-+---+--+-+-+---+ | userid | int(11) | binary| | PRI | 0 | | | pmnew | int(11) | binary| YES | | NULL| | | pmtotal | int(11) | binary| YES | | NULL| | +-+-+---+--+-+-+---+ and the data in the tables... mysql select * from p; ++---+-+ | userid | pmnew | pmtotal | ++---+-+ | 1 | 0 | 0 | | 2 | 0 | 0 | ++---+-+ 2 rows in set (0.00 sec) mysql select * from m; +--+---+ | toid | rd| +--+---+ |1 | 0 | |1 | 0 | |1 | 0 | |1 |12 | |1 |15 | |1 | 123 | |1 | 12312 | |1 | 12312 | |1 | 123 | |2 | 0 | |2 | 0 | |2 | 1 | |2 | 2 | +--+---+ 13 rows in set (0.00 sec) mysql select userid,pmtotal,pmnew, (select count(rd) from m where toid=p.userid) calc_total, (select count(rd) from m where rd=0 and toid=p.userid) calc_new from p where userid in (select distinct toid from m); ++-+---++--+ | userid | pmtotal | pmnew | calc_total | calc_new | ++-+---++--+ | 1 | 0 | 0 | 9 |3 | | 2 | 0 | 0 | NULL | NULL | ++-+---++--+ Now, the first row has what I want and expect, in calc_total and calc_new... but the second row doesn't. Why? Shouldn't the subselects in the field selector part (not the where part) be re-executed for each value in the IN()? If so, I'd expect calc_total to be '4', and calc_new to be '2' for the second row. For example, if I manually fudge the WHERE ... IN, I get: mysql select userid,pmtotal,pmnew, (select count(rd) from m where toid=p.userid) calc_total, (select count(rd) from m where rd=0 and toid=p.userid) calc_new from p where userid in (2); ++-+---++--+ | userid | pmtotal | pmnew | calc_total | calc_new | ++-+---++--+ | 2 | 0 | 0 | 4 |2 | ++-+---++--+ which is exactly what I want, but all at once :-) Ideas? Misunderstanding on my part? Bug? (By the way, what I eventually want to do is an update to set pmtotal and pmnew to be the calc_total and calc_new; in the real schema this is a simplified version of, they are essentially 'caches' of the new/total counts...) Any comments appreciated. Ben Margolin = [ Ben Margolin -- [EMAIL PROTECTED] -- [EMAIL PROTECTED] ] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: More duhh! questions
I've been having the same problem, using mysql++ with mysql 4.0.13. It works just fine entered into mysql-front or mysql.exe, but not through mysql++ Can I check the CREATE TEMPORARY TABLES privilege through the API? - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 8:43 AM Subject: Re: More duhh! questions Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I am attempting to create a temporary table to do a complex query and I get an error: error 1044: Access denied for user: '@localhost' to database 'shopsample' what can I do to keep this from happening? I am using the production version of mySQL 4.0.13 in windows 2000. Does user have CREATE TEMPORARY TABLES privilege? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: WG: wait_timeout in my.cnf
Moritz Steiner [EMAIL PROTECTED] wrote: I set a lot of variables in the my.cnf file, all variables are set (I checked it with show variables) except of wait_timeout. If I set the option in MySQL with option wait_status=xxx it works. How did you set the wait_timeout variable? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Frequent Table Corruption - Please Help
Tom, you could also try a 'stock kernel' 2.4.20, not a Red Hat one. We are running a SuSE kernel 2.4.18 and it has worked perfectly. [EMAIL PROTECTED]:~/mysql-4.1/client uname -a Linux hundin 2.4.18-64GB-SMP #1 SMP Wed Mar 27 13:58:12 UTC 2002 i686 unknown Regards, Heikki - Original Message - From: Tom Roos [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 9:59 AM Subject: RE: Frequent Table Corruption - Please Help hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 22:35 To: Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Frequent Table Corruption - Please Help Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:08 PM Subject: Re: Frequent Table Corruption - Please Help Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again! it may be worthwhile to test a new kernel in one of those problematic computers. We believe corruption problems in RH 2.4.18/drivers are random. Then any small change can provoke them. But we will probably never know what exactly was wrong in some 2.4.18 computers. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 9:52 PM Subject: Frequent Table Corruption - Please Help Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is that once the table is corrupted, it seems to be locked. Well, no clients can read from it. Once repaired, just one record is usually lost for each time the corruption occurs. I am not sure if this is a MySQL bug or even how to reproduce it, but I was hoping that someone here could help. I have included all the information that I have about this below. Any insight is greatly appreciated! Here is the mysqlbug information: Release: mysql-4.0.13 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux *.com 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/ccGCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Nov 1 2002 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 5 2002
Re: genereal query log
Moritz Steiner [EMAIL PROTECTED] wrote: I want to turn on and off the general query log from time to time. Is there a possibility to do this without changing the my.cnf file and restarting the server. I thought for example set option log=ON You can do SET SQL_LOG_OFF=1; to turn off logging for this client. Client must have SUPER privilege: http://www.mysql.com/doc/en/SET_OPTION.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Managing big tables
Maybe you could get some speed increase for you queries by setting the record_buffer to a higher value. Because with fixed row length this buffer fills up faster too. Although I doubt that you will gain a lot... /rudy -Original Message- From: Alexander Schulz [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 17:06 To: [EMAIL PROTECTED] Subject: Re:Managing big tables Thanks for your efforts, and in rudys last mail he confirms what i have feared, the io-overhead for reading the extremely longer rows most probably causes these longer query-times. I think we will have to redesign our table-structure, because we're already working on a (hardware-)raid, so the mysql-raid-option won't really be an option. Perhaps the only way to get this damned big tables smaller in appropriate time will be a solution via merge-tables (if this does not slow down our productive queries on that table too much). alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQLDump
It does not fail if some tables are not locked. But like you said, you could miss data. So the better way is first to lock, then flush and then dump the table. It does not backup the transaction log (if you mean the binary log with transaction log). Even worse, you normally have no way of telling from which point in time you have to restore the transaction log (except time of course, but which is in some situation not enough information). Best and most secure way of doing a backup of which you can guarantee to restore safely is to shutdown the server, backup the tables, reset the bin log, restart the server. But even then you can get problem during the restore, because you cannot prevent users from logging in while you do the restore (ok, there are some tricks, but these are tricks and not well thought out backup procedure). I think MySQL is thoroughly leaking in this aspect and someone should put his/her attention to this very soon. Because its hard to sell your manager a DB which does not support a well thought out backup and RESTORE procedure! Cheers /rudy -Original Message- From: Gilbert Wu [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 18:31 To: [EMAIL PROTECTED] Subject: RE: MySQLDump The connections will still write to one or two tables. Mainly stock prices from a price server. Hence, not so bother if any prices arrive after the dump starts are not captured. I would like to know if mysqldump will fail to run if the tables are not locked? Cheers. Gilbert -Original Message- From: Sent: 15 July 2003 17:11 To: Gilbert Wu Subject: Re: MySQLDump sure, just tell it to lock the tables while it does the dump. curtis On Tuesday 15 July 2003 12:02, Gilbert Wu wrote: Hi, I am new to MySQL. I wonder if someone could tell me if I can run MySQLDump on a database while a few users are still connected to it. If yes, is it clever enough to backup the transaction log and use it to restore the database to the nearest state to the before the dump? Many thanks. Gilbert Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: One Big Data Base or Many Smaller Ones
Really depends on what exactly you want to achieve. But as I read the mail below, create a lot of smaller ones. If the ISP however charges you for each DB it is also easy to only create one huge DB, just do not make the table names too long. Developers are lazy in typing... :) /rudy -Original Message- From: Charla Beaulieu [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 18:33 To: [EMAIL PROTECTED] Subject: One Big Data Base or Many Smaller Ones Hello, I am creating an on-line course and would like to know if it will make a difference in the way I set up my database(s). Option 1 : Create one large Database for the course Here I would prefix the tables with their functions, ie. reg_ quizzes_ forum_ etc. Option 2 : Create a smaller Database for each function Here I would create a registration database, a quizzes database a forum database etc. I do not have my own server, so I would have to get my ISP to create each database, which might be a hassle for them. I want to know which method would be best. Thank you Charla -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: table protection
azamka [EMAIL PROTECTED] wrote: Is there any command that we can use to view the protection on the tables??. Is there any way that we can convert read only tables to read write?. Please ehlp If you get error that table is read only, it means that: 1. table is compressed with myisampack 2. MySQL doesn't have permissions on the table files. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
compare longblob with binary data
hi all a question about checking the data of a longblob for equality. assume the `data` field is of type longblob. the following statement returns the image records with equal data. SELECT * FROM `image` WHERE `data`=? how does mysql performe the test. does it check the length of the blob before comparing the data, or makes it sense to add the length test as follows SELECT * FROM `image` WHERE LENGTH(`data`) = ? AND `data`=? any suggestions? best regard benny
RE: Best practice column type for storing decimal currency amounts?
Problem is that DECIMALs are currently stored as FLOAT or DOUBLE in the DB (at least MyISAM). MySQL AB is busy with adding a true monetary type (like MONEY) to the system. What I am doing when using monetary values is putting them into floats if I can live with rounding problems or put them into in ints and multiply them by 100 (or 1000) before putting them there (thus taking care of the decimal point myself). Cheers /rudy ps: I wish DECIMALS would be stored as char :) -Original Message- From: John Hicks [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 21:39 To: [EMAIL PROTECTED] Subject: Best practice column type for storing decimal currency amounts? Is there an accepted best practice on whether to store decimal currency amounts (e.g. dollars and cents) in MySQL decimal column types? Certainly, the most straightforward way is to use decimal columns. But it appears that such values are stored as ASCII strings, which would be inefficient for calculations (requiring conversion to a numeric type for each calculation). I guess the alternative would be to use integer columns (and multiply by 100 to store the value as total cents). My particular context is a PHP/MySQL sales system. What's the consensus? Thanks much, --John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Complex select statement
You are not allowed to use grouping functions in the WHERE clause. To restrict on grouped values, you have to put them into the HAVING clause. Cheers /rudy -Original Message- From: Roy Walker [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 23:25 To: Rudy Metzger; [EMAIL PROTECTED] Subject: RE: Complex select statement Still having a problem with this. Still have one last thing that isn't working. This is MySQL 4.0.13. UPDATE table_tmp,table2_daily SET table_tmp.period_count = table_tmp.count - table2.count WHERE table_tmp.id = table2.id AND MAX(table2.timestamp); This is giving me: ERROR : Invalid use of group function. I am trying to update the period_count field for all the records in table_tmp, by setting the equal to the count from table_tmp MINUS the count from table2 where the id's match and it is the newest record in table2. Any ideas? Please don't tell me to how to do it 4.1! Please! :) Roy -Original Message- From: Rudy Metzger [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 3:49 AM To: Roy Walker; [EMAIL PROTECTED] Subject: RE: Complex select statement I never heard before that you can use a select statement in an arithmetic expression. Only ALL, ANY, MIN, MAX, =, (and some other which do not come to my mind quickly) should work. Anyway, it is considered a subselect and therefore does not work yet. However, in 4.1 you should also be able to formulate it like this: INSERT INTO table2( id, count, period_count, date ) SELECT t1.id, t1.count, t1.count - x.count, to_days(now()-1) FROM table1 t1, (SELECT count FROM table2 WHERE id = t1.id ORDER BY timestamp desc LIMIT 1) x This would also be the way how I would do it in a different DB (e.g. ORACLE). Cheers /rudy -Original Message- From: Roy Walker [mailto:[EMAIL PROTECTED] Sent: vrijdag 11 juli 2003 18:30 To: [EMAIL PROTECTED] Subject: RE: Complex select statement Eva, Thanx for your help. Still having an issue with this. I forgot to mention I am running MySQL 4.0.13. Tried both of these statements: INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count - (SELECT count FROM table2 WHERE id=id1 order by timestamp desc limit 1)) AS period_count, (TO_DAYS(NOW() -1)) from table 1; INSERT INTO table2 (id,count,period_count,date) SELECT @id1:=id, count, (count - (SELECT count FROM table2 WHERE [EMAIL PROTECTED] order by timestamp desc limit 1)) AS period_count, (TO_DAYS(NOW() -1)) from table 1; They both give me an error for the 'SELECT count FROM table2 WHERE id=id1' section. Is this illegal syntax? Would this be considered a subselect? Thanx, Roy -Original Message- From: Paracková Eva, Ing [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 12:30 AM To: Roy Walker Subject: RE: Complex select statement try this: INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count - (SELECT count FROM table2 WHERE id=id1 order by timestamp desc limit 1)) AS period_count, (TO_DAYS(NOW() -1)) from table 1; i am not sure, the subselect is ok. if the id1 alias will not work, then try to use a variable (... SELECT @id1:=id ... WHERE [EMAIL PROTECTED] ...). i just corrected a few syntax mistakes in your query. eva -Original Message- From: Roy Walker [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 7:19 AM To: [EMAIL PROTECTED] Subject: Complex select statement If anyone could tell me what I am doing wrong here, I would greatly appreaciate it. Have the following tables: table1: id, count table2: id, count, period_count, date, timestamp Trying to do the following; get all rows from table 1 and insert them into table2 while setting period_count to count.table1 minus the most recent entry for that id in count.table2, then set the date field to the previous day. Here goes: INSERT INTO table1 (id,count,period_count,date) SELECT id,count FROM table1, (count.table1 - (SELECT count FROM table2 WHERE MAX(timestamp) AND id.table2=id)) AS period_count, date='TO_DAYS(NOW() -1)'; Sorry if this is easy, but I could not find an example of any mathematic functions while doing an INSERT ... SELECT. Thanx, Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
switch query logging while the server is running
Description: It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch on logging, perform an activity, switch off logging, and look what has happened. Otherwise, the server has to be restarted to change logging, which is a bit annoying... How-To-Repeat: mysql show variables like 'log'; +---+---+ | Variable_name | Value | +---+---+ | log | ON| +---+---+ 1 row in set (0.00 sec) mysql set log off; ERROR 1193: Unknown system variable 'log' mysql set session log off; ERROR 1193: Unknown system variable 'log' mysql Fix: ? Submitter-Id: submitter ID Originator: Organization: MySQL support: none Synopsis: switch query logging while the server is running Severity: non-critical Priority: low Category: mysql Class: change-request Release: mysql-4.0.13-standard (Official MySQL-standard binary) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux xxx 2.4.18 #1 Wed Feb 12 17:10:01 CET 2003 i686 unknown Architecture: i686 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Single Record Locking - Permanent?
I would add a flag to the record (e.g. 'user_lock'). You then have to evaluate this flag in your application. Or you can wait until 5.0 for triggers where you then can do it in the DB (or maybe not, dunno how far triggers will go). Maybe MERGE tables could help you, not sure about this though. Split the table in 2 subtables, one part with the user updateable data, the other one with the manager only data. Then grant rights specific to this tables. I do not know however which rights are used: the one you granted to the individual tables or the one you granted to the merge table. You would have to check that out yourself. Cheers /rudy -Original Message- From: Dan Ullom [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 19:04 To: [EMAIL PROTECTED] Subject: Single Record Locking - Permanent? Is it possible to lock single records for all but a certain set of users, permanently? The intention is to make old items permanently unchangeable by anyone but managers. Thanks, Dan Ullom TechCentric 314-991-2594 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Foreign Keys
InnoDB is using a totally different concept than MyISAM. Where in MyISAM all the data is in one file, InnoDB uses the principle of Tablespaces (like ORACLE). This puts the whole tables (and metadata) into one HUGE file (in theory. In practice this file can be split and extends can be defined of how it grows). In general, MyISAM is faster. So if you are developing an application which is logging low level traffic information for telephony calls, use MyISAM. If you develop a normal application, like a webshop, you won't notice the difference. Executive Summary: If you need foreign constraints, use InnoDB. Cheers /rudy -Original Message- From: Andrew Kuebler [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 4:54 To: [EMAIL PROTECTED] Subject: Foreign Keys When I type: Show keys from [tablename]; I do not see foreign keys listed there and I cannot seem to find any command that will list foreign keys. Can anyone help? Also, I notice Innodb tables only store one file unlike MyISAM which stores 3. Are Innodb tables any slower than MyISAM since they store all data in a single file? I am looking to use Innodb for an application simply because of the referential integrity. Thanks in advance... Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Simple newbie question - CURTIME()
Please check the manual, search for DATE_ADD(). /rudy -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 8:01 To: [EMAIL PROTECTED] Cc: Pieter Subject: Simple newbie question - CURTIME() Good day \-=0=-=00- I have looked in the manual and seem to be missing it or not understanding correctly, The curtime() function resturns the current server time. my problem is the clients are not in the same country as the server, thus the time of the system is 6 hours behind. We want to add 6 hours to the time on capturing of the data, but using curtime() and adding the difference gives the wrong time back, must we add the amount seconds or minutes to the function to get the correct time ? Thanks in Advance for all help Johannes Pretorius -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question: using Visual Studio.NET
Hi Everybody, 1- I am trying to upsize an access database to my MySQL server on my website. I tried to get connected within access and failed. Please advise. I am using Win XP as the operating system and MS Office XP Pro. 2- How to connect a Visual Studio.NET project to a MySQL data base located on a MySQL server on a web. I tried to establish a connection with the server from within VS.NET project using th normal procedure, but failed. I could connect to a local SQL server. however I need to use MySQL server on my website. I have the IP address, User ID and Password of the server. Please advise. I am using VS.NET 2003. Many thanks. T. Rady _ No masks required! Use MSN Messenger to chat with friends and family. http://go.msnserver.com/HK/25382.asp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple newbie question - CURTIME()
Johannes Pretorius [EMAIL PROTECTED] wrote: I have looked in the manual and seem to be missing it or not understanding correctly, The curtime() function resturns the current server time. my problem is the clients are not in the same country as the server, thus the time of the system is 6 hours behind. We want to add 6 hours to the time on capturing of the data, but using curtime() and adding the difference gives the wrong time back, must we add the amount seconds or minutes to the function to get the correct time ? If you use CURTIME() function, you can convert to the seconds with TIME_TO_SEC() and then apply arithmetic operations. Another way, use function NOW() and DATE_ADD()/DATE_SUB() functions: http://www.mysql.com/doc/en/Date_and_time_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
first time to use MySQL on MS Platform with PHP.
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
Notice: Undefined variable: productid in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: itemname in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: description in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: price in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: information in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
16
Saved successfully
Here is the code of productsave.php :
?php
include(functions.php);
$sql=
insert into product ( productid, itemname,
description, price, information )
values ('$productid', '$itemname', '$description',
'$price', '$information')
;
$conn=connection();
choosedb();
if (mysql_query($sql,$conn)){
echo Saved successfullybr;
}
else echo mysql_error();
mysql_close($conn);
?
Here is the code of the form which calls
productsave.php (it's cgi program):
form action=cgi/productsave.php method=POST
centerbuData Entry - Product
List/u/b/center
br
table align=center border=0
trtd align=left1./tdtd align=leftProduct
ID/tdtd align=left :/td
td align=left input type=text name=productid
readonly=yes/td/tr
trtd align=left2./tdtd align=leftItem
Name/tdtd align=left:/td
td align=leftinput type=text
name=itemname/td/tr
trtd align=left3./tdtd
align=leftDescription/tdtd align=left:/td
td align=leftinput type=text
name=description/td/tr
trtd align=left 4./tdtd
align=leftPrice/tdtd align=left:/td
td align=leftinput type=text
name=price/td/tr
trtd align=left5./tdtd
align=leftInformation/tdtd align=left:/td
td align=leftinput type=text
name=information/td/tr
trtd colspan=4 align=centerinput
type=submit value=Save src=img/ok.png
input type=reset value=Clear
src=img/no.png/td/tr
/table
/form
Please tell me. Thank you very much in advance.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: subselect question... shouldn't this work?
These are not real subselects. You speak of a subselect when you are define a select in the FROM clause of a kwiri. If you define them in the WHERE clause, you speak of derived tables. Putting them even into the SELECT clause is something specific to MySQL (as far as I know). Ok, now this is theory and does not help you much :) Thus you can solve this without subselects: SELECT userid, pmtotal, pmnew, count(*) calc_total, sum(if(rd=0,1,0) calc_new FROM m, p WHERE userid = toid GROUP BY userid OR ( if you insist on derived tables and subselects ) SELECT userid, pmtotal, pmnew, m2.calc_total calc_total, m1.calc_new calc_new FROM m, p, ( SELECT toid, count(*) calc_new FROM m WHERE rd = 0 GROUP BY toid ) m1, ( SELECT toid, count(*) calc_total FROM m GROUP BY toid ) m2 WHERE userid IN ( SELECT distinct toid FROM m ) AND p.userid = m2.toid AND p.userid = m1.toid But I would use the first one... /rudy -Original Message- From: Ben Margolin [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 1:36 To: [EMAIL PROTECTED] Subject: subselect question... shouldn't this work? I am new to subselects, and what I really want is to do them in an update, but the following shows a simpler select, that also doesn't seem to work as I think it should. Advice? Do I just misunderstand how subselects are actually executed? (This is on mysql version 4.1.0-alpha-max-nt.) First, here's the tables in question: mysql describe m; +---+-+---+--+-+-+---+ | Field | Type| Collation | Null | Key | Default | Extra | +---+-+---+--+-+-+---+ | toid | int(11) | binary| YES | | NULL| | | rd| int(11) | binary| YES | | NULL| | +---+-+---+--+-+-+---+ mysql describe p; +-+-+---+--+-+-+---+ | Field | Type| Collation | Null | Key | Default | Extra | +-+-+---+--+-+-+---+ | userid | int(11) | binary| | PRI | 0 | | | pmnew | int(11) | binary| YES | | NULL| | | pmtotal | int(11) | binary| YES | | NULL| | +-+-+---+--+-+-+---+ and the data in the tables... mysql select * from p; ++---+-+ | userid | pmnew | pmtotal | ++---+-+ | 1 | 0 | 0 | | 2 | 0 | 0 | ++---+-+ 2 rows in set (0.00 sec) mysql select * from m; +--+---+ | toid | rd| +--+---+ |1 | 0 | |1 | 0 | |1 | 0 | |1 |12 | |1 |15 | |1 | 123 | |1 | 12312 | |1 | 12312 | |1 | 123 | |2 | 0 | |2 | 0 | |2 | 1 | |2 | 2 | +--+---+ 13 rows in set (0.00 sec) mysql select userid,pmtotal,pmnew, (select count(rd) from m where toid=p.userid) calc_total, (select count(rd) from m where rd=0 and toid=p.userid) calc_new from p where userid in (select distinct toid from m); ++-+---++--+ | userid | pmtotal | pmnew | calc_total | calc_new | ++-+---++--+ | 1 | 0 | 0 | 9 |3 | | 2 | 0 | 0 | NULL | NULL | ++-+---++--+ Now, the first row has what I want and expect, in calc_total and calc_new... but the second row doesn't. Why? Shouldn't the subselects in the field selector part (not the where part) be re-executed for each value in the IN()? If so, I'd expect calc_total to be '4', and calc_new to be '2' for the second row. For example, if I manually fudge the WHERE ... IN, I get: mysql select userid,pmtotal,pmnew, (select count(rd) from m where toid=p.userid) calc_total, (select count(rd) from m where rd=0 and toid=p.userid) calc_new from p where userid in (2); ++-+---++--+ | userid | pmtotal | pmnew | calc_total | calc_new | ++-+---++--+ | 2 | 0 | 0 | 4 |2 | ++-+---++--+ which is exactly what I want, but all at once :-) Ideas? Misunderstanding on my part? Bug? (By the way, what I eventually want to do is an update to set pmtotal and pmnew to be the calc_total and calc_new; in the real schema this is a simplified version of, they are essentially 'caches' of the new/total counts...) Any comments appreciated. Ben Margolin = [ Ben Margolin -- [EMAIL PROTECTED] -- [EMAIL PROTECTED] ] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives:
RE: first time to use MySQL on MS Platform with PHP.
I think it is the code in functions you need to look at or the path in one of
your ini files :)
Andrew
-Original Message-
From: Prabu Subroto [mailto:[EMAIL PROTECTED]
Sent: 16 July 2003 10:14
To: [EMAIL PROTECTED]
Subject: first time to use MySQL on MS Platform with PHP.
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
Notice: Undefined variable: productid in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: itemname in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: description in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: price in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: information in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
16
Saved successfully
Here is the code of productsave.php :
?php
include(functions.php);
$sql=
insert into product ( productid, itemname,
description, price, information )
values ('$productid', '$itemname', '$description',
'$price', '$information')
;
$conn=connection();
choosedb();
if (mysql_query($sql,$conn)){
echo Saved successfullybr;
}
else echo mysql_error();
mysql_close($conn);
?
Here is the code of the form which calls
productsave.php (it's cgi program):
form action=cgi/productsave.php method=POST
centerbuData Entry - Product
List/u/b/center
br
table align=center border=0
trtd align=left1./tdtd align=leftProduct
ID/tdtd align=left :/td
td align=left input type=text name=productid
readonly=yes/td/tr
trtd align=left2./tdtd align=leftItem
Name/tdtd align=left:/td
td align=leftinput type=text
name=itemname/td/tr
trtd align=left3./tdtd
align=leftDescription/tdtd align=left:/td
td align=leftinput type=text
name=description/td/tr
trtd align=left 4./tdtd
align=leftPrice/tdtd align=left:/td
td align=leftinput type=text
name=price/td/tr
trtd align=left5./tdtd
align=leftInformation/tdtd align=left:/td
td align=leftinput type=text
name=information/td/tr
trtd colspan=4 align=centerinput
type=submit value=Save src=img/ok.png
input type=reset value=Clear
src=img/no.png/td/tr
/table
/form
Please tell me. Thank you very much in advance.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: switch query logging while the server is running
[EMAIL PROTECTED] wrote: Description: It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch on logging, perform an activity, switch off logging, and look what has happened. Otherwise, the server has to be restarted to change logging, which is a bit annoying... How-To-Repeat: mysql show variables like 'log'; +---+---+ | Variable_name | Value | +---+---+ | log | ON| +---+---+ 1 row in set (0.00 sec) mysql set log off; ERROR 1193: Unknown system variable 'log' mysql set session log off; ERROR 1193: Unknown system variable 'log' mysql This variable is called SQL_LOG_OFF. Please, read the manual: http://www.mysql.com/doc/en/SET_OPTION.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can someone help me??
I am new in mysql I wrote this query: INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione, ordine, codice) VALUES (10 ,6 ,5 ,10 - 99: ,12 ,50 ,'S12IT3' ) and server reply to me: Query was empty Can someone tell me where i do mistake? Thanks a lot.. Sbandy [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore
RE: Can someone help me??
Did you do that on the mysql command line? Or did you use a different client and/or API? Cheers /rudy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:21 To: [EMAIL PROTECTED] Subject: Can someone help me?? I am new in mysql I wrote this query: INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione, ordine, codice) VALUES (10 ,6 ,5 ,10 - 99: ,12 ,50 ,'S12IT3' ) and server reply to me: Query was empty Can someone tell me where i do mistake? Thanks a lot.. Sbandy [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connection problem!!! Windows to Linux
If you manually updated the tables, use flush privileges to inform the DB server of your changes. Cheers /rudy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:23 To: [EMAIL PROTECTED] Subject: Re: Connection problem!!! Windows to Linux Aric Cheah [EMAIL PROTECTED] wrote: I wrote a program application for windows which can add and delete data from this application, it working fine with my own MySQL install on the same windows OS.. Now I try to change the connection this dayabase to the server whihc runnign under linux, and create the same database, same user and password. But when I connect the error message said: [MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to connect to this MYSQL Server. But form the database, I added the host %, means hsould be allow any host... anyone can help me on this? the application I wrote will be using with dynamic IP everytime user dial-up to the internet connect.. How did you give permissions? Did you use GRANT statement or edit system tables manually? Show me the output of SHOW GRANTS for this user. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can someone help me??
I use phpmyadmin At 11.26 16/07/2003 +0200, Rudy Metzger wrote: Did you do that on the mysql command line? Or did you use a different client and/or API? Cheers /rudy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:21 To: [EMAIL PROTECTED] Subject: Can someone help me?? I am new in mysql I wrote this query: INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione, ordine, codice) VALUES (10 ,6 ,5 ,10 - 99: ,12 ,50 ,'S12IT3' ) and server reply to me: Query was empty Can someone tell me where i do mistake? Thanks a lot.. Sbandy [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can someone help me??
Try using only single quotes rather than a mixture of single and double quotes? Andy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 10:32 To: Rudy Metzger; [EMAIL PROTECTED] Subject: RE: Can someone help me?? I use phpmyadmin At 11.26 16/07/2003 +0200, Rudy Metzger wrote: Did you do that on the mysql command line? Or did you use a different client and/or API? Cheers /rudy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:21 To: [EMAIL PROTECTED] Subject: Can someone help me?? I am new in mysql I wrote this query: INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione, ordine, codice) VALUES (10 ,6 ,5 ,10 - 99: ,12 ,50 ,'S12IT3' ) and server reply to me: Query was empty Can someone tell me where i do mistake? Thanks a lot.. Sbandy [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Building from the develepment tree (windows)
I'm trying to build mysql from the development sources of mysql 4.1., retreived using bitkeeper under win2k using cygwin. I have made bk -r edit, and now I'm having a problem running aclocal: aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library When I make automake --version and aclocal --version it prints me 1.4-p5. Does anyone use cygwin for this, any solutions and advices ? Best regards, Marek L. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple newbie question - CURTIME()
Thanks I have figured it out, I only have to add 06 to the curtime() function as example : //== SNIP mysql select curtime() + 06 as TimePlus6, curtime() as TheCurrenTime; +---+---+ | TimePlus6 | TheCurrenTime | +---+---+ |180922 | 12:09:22 | +---+---+ 1 row in set (0.00 sec) //= END SNIP Thanks for help and response Johannes Pretorius At 12:08 16/07/2003 +0300, Egor Egorov wrote: Johannes Pretorius [EMAIL PROTECTED] wrote: I have looked in the manual and seem to be missing it or not understanding correctly, The curtime() function resturns the current server time. my problem is the clients are not in the same country as the server, thus the time of the system is 6 hours behind. We want to add 6 hours to the time on capturing of the data, but using curtime() and adding the difference gives the wrong time back, must we add the amount seconds or minutes to the function to get the correct time ? If you use CURTIME() function, you can convert to the seconds with TIME_TO_SEC() and then apply arithmetic operations. Another way, use function NOW() and DATE_ADD()/DATE_SUB() functions: http://www.mysql.com/doc/en/Date_and_time_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Resource temporarily unavailable - What does that mean?
While accessing MySQl data base by means of perl the value of variable $! sometimes equals Resource temporarily unavailable. At the mean time everything works correct. What does that mean? ___ http://chat.bigmir.net/ - ñàìûé óäîáíûé ÷àò ñ ôîòîàëüáîìàìè -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question: using Visual Studio.NET
You can access a mysql database within VS.Net through odbc. To do this you have install myodbc. You can get this from mysql website. After installing myodbc you have to create a new datasource. Then you can connect to mysql with the help of adodb object in vs.net. I have never tried to connect mysql within access. But I think so you can do this too through odbc. If you need I can send you samples codes too. [EMAIL PROTECTED] wrote: Hi Everybody, 1- I am trying to upsize an access database to my MySQL server on my website. I tried to get connected within access and failed. Please advise. I am using Win XP as the operating system and MS Office XP Pro. 2- How to connect a Visual Studio.NET project to a MySQL data base located on a MySQL server on a web. I tried to establish a connection with the server from within VS.NET project using th normal procedure, but failed. I could connect to a local SQL server. however I need to use MySQL server on my website. I have the IP address, User ID and Password of the server. Please advise. I am using VS.NET 2003. Many thanks. T. Rady _ No masks required! Use MSN Messenger to chat with friends and family. http://go.msnserver.com/HK/25382.asp -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Simple newbie question - CURTIME()
WRONG! What will happen in this case? The DB is converting/casting the DATE (curtime()) into an integer and then ads 6. So what you get does not necessarily represent a valid date/time! Just replace 06 with 24 and see what you yet. Cheers /rudy -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 12:11 To: [EMAIL PROTECTED] Subject: Re: Simple newbie question - CURTIME() Thanks I have figured it out, I only have to add 06 to the curtime() function as example : //== SNIP mysql select curtime() + 06 as TimePlus6, curtime() as TheCurrenTime; +---+---+ | TimePlus6 | TheCurrenTime | +---+---+ |180922 | 12:09:22 | +---+---+ 1 row in set (0.00 sec) //= END SNIP Thanks for help and response Johannes Pretorius At 12:08 16/07/2003 +0300, Egor Egorov wrote: Johannes Pretorius [EMAIL PROTECTED] wrote: I have looked in the manual and seem to be missing it or not understanding correctly, The curtime() function resturns the current server time. my problem is the clients are not in the same country as the server, thus the time of the system is 6 hours behind. We want to add 6 hours to the time on capturing of the data, but using curtime() and adding the difference gives the wrong time back, must we add the amount seconds or minutes to the function to get the correct time ? If you use CURTIME() function, you can convert to the seconds with TIME_TO_SEC() and then apply arithmetic operations. Another way, use function NOW() and DATE_ADD()/DATE_SUB() functions: http://www.mysql.com/doc/en/Date_and_time_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Simple newbie question - CURTIME()
SELECT EXTRACT(HOUR_SECOND FROM 1999-07-02 01:02:03); -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 13:32 To: [EMAIL PROTECTED] Cc: Pieter Subject: RE: Simple newbie question - CURTIME() Thanks \0-\-==-0-= I have seen my error and have changed it to be as follows : //== SNIP == mysql select date_add(now(),INTERVAL 6 HOUR); +-+ | date_add(now(),INTERVAL 6 HOUR) | +-+ | 2003-07-16 19:00:13 | +-+ 1 row in set (0.00 sec) // END SNIP == Is this more correct ? If I only need the time I use //= SNIP === mysql select date_format(date_add(now(),INTERVAL 6 HOUR),'%H:%i:%s'); +-+ | date_format(date_add(now(),INTERVAL 6 HOUR),'%H:%i:%s') | +-+ | 19:31:04| +-+ 1 row in set (0.03 sec) //== END SNIP == Thanks Johannes At 13:06 16/07/2003 +0200, you wrote: WRONG! What will happen in this case? The DB is converting/casting the DATE (curtime()) into an integer and then ads 6. So what you get does not necessarily represent a valid date/time! Just replace 06 with 24 and see what you yet. Cheers /rudy -Original Message- From: Johannes Pretorius [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 12:11 To: [EMAIL PROTECTED] Subject: Re: Simple newbie question - CURTIME() Thanks I have figured it out, I only have to add 06 to the curtime() function as example : //== SNIP mysql select curtime() + 06 as TimePlus6, curtime() as TheCurrenTime; +---+---+ | TimePlus6 | TheCurrenTime | +---+---+ |180922 | 12:09:22 | +---+---+ 1 row in set (0.00 sec) //= END SNIP Thanks for help and response Johannes Pretorius At 12:08 16/07/2003 +0300, Egor Egorov wrote: Johannes Pretorius [EMAIL PROTECTED] wrote: I have looked in the manual and seem to be missing it or not understanding correctly, The curtime() function resturns the current server time. my problem is the clients are not in the same country as the server, thus the time of the system is 6 hours behind. We want to add 6 hours to the time on capturing of the data, but using curtime() and adding the difference gives the wrong time back, must we add the amount seconds or minutes to the function to get the correct time ? If you use CURTIME() function, you can convert to the seconds with TIME_TO_SEC() and then apply arithmetic operations. Another way, use function NOW() and DATE_ADD()/DATE_SUB() functions: http://www.mysql.com/doc/en/Date_and_time_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: More duhh! questions
For the following I am assuming you didn't edit that output for security reasons. What I see immediately wrong is that you are not passing a username to mysql (If you were, then there would be something like '[EMAIL PROTECTED]' there). Of course you can set MySQL up so that it does not require a username to connect, but that isn't very secure. -Rob -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 3:43 AM To: [EMAIL PROTECTED] Subject: Re: More duhh! questions Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I am attempting to create a temporary table to do a complex query and I get an error: error 1044: Access denied for user: '@localhost' to database 'shopsample' what can I do to keep this from happening? I am using the production version of mySQL 4.0.13 in windows 2000. Does user have CREATE TEMPORARY TABLES privilege? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: CF MySQL
I am running the current version which is labeled ColdFusion MX. According to Macromedia, you need a Pentium Processor, 128M RAM Minimum, 256M RAM recommended, and 512M RAM preferred, and 350M id HD space. I was running MySQL, Apache standard secure, Sendmail for 25 people, ColdFusion MX, and a Firewall on a Celeron 400 with 384M Ram and slower IDE HDs. This configuration did noticeably slow down the server. After removing all large MySQL databases, leaving the server running did improve performance. Loading ColdFusion onto a Xeon 800 box w/Raid 5 SCSI, 512M RAM, running multiple HighHit Web Sites, with MySQL running some small databases, has not slowed performance at all. Personally, I am not sure which component caused the biggest slow down, CPU, Ram, or HD. My guess is RAM, then CPU, then HD. Personally, I have found, it best to have any SQL server running on the fastest box, with the most RAM, and your WebServer and CF on a 2nd box. This will give you the best performance without having to buy 2,4 or 8way processor boxes. Patrick At 03:58 PM 7/15/2003, William R. Mussatto wrote: I am currently running ColdFusion MX on my Linux Servers access both MySQL from different Linux Servers and MS SQL from a MS2000 WS. ColdFusion and MySQL are both available and run on both Win Linux machines. I also have PHP installed on Linux, but have never attempted to learn fully utilize PHP. ColdFusion is capable of access many DB programs. You simply need to tell CF how and where to access the Data. At 12:01 PM 7/15/2003, Andrew wrote: Hi All I've had a quick scoot about and could see anything about cold fusion and mysql is it possible to use this combination successfully if at all? Thanks Andrew Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or888-638-6963 Fax: 724-489-4386 If you don't mind me asking, which version of the server are you using on Linux. We have been asked to set such a system up and are looking for background. Also, does CF put much of a load on the server. We are running Debian Stable. (woody). Thanks for any info. William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 Patrick J. Shoaf, Systems Engineer mailto:[EMAIL PROTECTED][EMAIL PROTECTED] Midmon Internet Services, LLC 100 Third Street Charleroi, PA 15022 http://www.midmon.com Phone: 724-483-2400 ext. 105 or888-638-6963 Fax: 724-489-4386 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Connection problem!!! Windows to Linux
Aric, Are you running the linux version of your database on a shared web host? Some web hosts prevent you from using % as a host identifier for security reasons. I would also check to see if the permissions were defined at the proper level (in other words, have you set up access prvis for a specific database only, or did you grant access to all databases?) Globally-defined privileges will be listed in the user table of the mysql database and permissions set for a specific DB will be in the db table. You might also check that the mysql server is not protected by a firewall (ask your web host.) One last thing to check: The hostname identifier must be surrounded by either single or double quotes, NOT backticks. The following is an example that works under MySQL 4.0.13: grant all on *.* to myusername@'%' identified by 'mypassword'; I hope that helps--I don't normally connect to MySQL through ODBC. -Rob -Original Message- From: Aric Cheah [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 3:36 AM To: [EMAIL PROTECTED] Subject: Connection problem!!! Windows to Linux Hi there: I need URGENT help about this .. I wrote a program application for windows which can add and delete data from this application, it working fine with my own MySQL install on the same windows OS.. Now I try to change the connection this dayabase to the server whihc runnign under linux, and create the same database, same user and password. But when I connect the error message said: [MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to connect to this MYSQL Server. But form the database, I added the host %, means hsould be allow any host... anyone can help me on this? the application I wrote will be using with dynamic IP everytime user dial-up to the internet connect.. wish to hear some help soon.. -- Best, Aric Cheah -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
date conversion
I need to convert dates in the format below into mysql date format. If I try to change the column type to date, it wipes out the data. +-+ | 26-Jan-2001 | | 26-Jan-2001 | | 15-Apr-2001 | | 1-Nov-2001 | | 31-Oct-2001 | | 26-Jan-2001 | | 22-Jun-2001 | | 23-Jul-2000 | | 1-Nov-2001 | | 31-May-2000 | | 17-Nov-2000 | | 10-May-2001 | | 15-Apr-2001 | | 17-May-2001 | | 29-Mar-2000 | | 30-Aug-2001 | | 18-May-2000 | | 11-Apr-2000 | | 1-Nov-2001 | | 24-Feb-2000 | +-+
Re: Frequent Table Corruption - Please Help
What do you consider high volume? Also, please keep me in the loop on this. Any configuration changes that help would be appreciated. Thanks! Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Tom Roos [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED]; Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 2:59 AM Subject: RE: Frequent Table Corruption - Please Help hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 22:35 To: Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Frequent Table Corruption - Please Help Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:08 PM Subject: Re: Frequent Table Corruption - Please Help Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again! it may be worthwhile to test a new kernel in one of those problematic computers. We believe corruption problems in RH 2.4.18/drivers are random. Then any small change can provoke them. But we will probably never know what exactly was wrong in some 2.4.18 computers. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 9:52 PM Subject: Frequent Table Corruption - Please Help Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is that once the table is corrupted, it seems to be locked. Well, no clients can read from it. Once repaired, just one record is usually lost for each time the corruption occurs. I am not sure if this is a MySQL bug or even how to reproduce it, but I was hoping that someone here could help. I have included all the information that I have about this below. Any insight is greatly appreciated! Here is the mysqlbug information: Release: mysql-4.0.13 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux *.com 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/ccGCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='g++' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Nov 1 2002 /lib/libc.so.6 - libc-2.2.93.so -rwxr-xr-x1 root root 1235468 Sep 5 2002 /lib/libc-2.2.93.so -rw-r--r--1 root root
Re: Frequent Table Corruption - Please Help
I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved the problem? What 2.4 version exactly did you run and was it a RedHat kernel? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Tom Roos [EMAIL PROTECTED] Cc: Richard Gabriel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:10 AM Subject: Re: Frequent Table Corruption - Please Help Have you tried to use a non SMP kernel ? I have also experienced table corruptions 2 years ago with mysql 3.23.xx and a 2.2.14smp kernel. I had several servers with the same configuration but only the most loaded had this problem. I had no more corruptions in single CPU mode. I upgraded later to a newer smp kernel (2.4) that solved the problem. It may be a temporary fix until you schedule an upgrade. Hope this helps Joseph Bueno Tom Roos wrote: hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 22:35 To: Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Frequent Table Corruption - Please Help Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:08 PM Subject: Re: Frequent Table Corruption - Please Help Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again! it may be worthwhile to test a new kernel in one of those problematic computers. We believe corruption problems in RH 2.4.18/drivers are random. Then any small change can provoke them. But we will probably never know what exactly was wrong in some 2.4.18 computers. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 9:52 PM Subject: Frequent Table Corruption - Please Help Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is that once the table is corrupted, it seems to be locked. Well, no clients can read from it. Once repaired, just one record is usually lost for each time the corruption occurs. I am not sure if this is a MySQL bug or even how to reproduce it, but I was hoping that someone here could help. I have included all the information that I have about this below. Any insight is greatly appreciated! Here is the mysqlbug information: Release: mysql-4.0.13 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux *.com 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/ccGCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2 20020903
RE: date conversion
SELECT concat( substring_index(DATE,'-',-1), '-', lpad( field(substring_index(substring_index(DATE,'-',2),'-',-1), 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug', 'Sep','Oct','Nov','Dec'), 2,'0'), '-', lpad(substring_index(DATE,'-',1),2,0), Replace DATE by the date string you want to have converted (e.g. via a variable from an API or a column name from a select/update/insert..select Cheers /rudy -Original Message- From: Jonathan Patton [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 15:07 To: [EMAIL PROTECTED] Subject: date conversion I need to convert dates in the format below into mysql date format. If I try to change the column type to date, it wipes out the data. +-+ | 26-Jan-2001 | | 26-Jan-2001 | | 15-Apr-2001 | | 1-Nov-2001 | | 31-Oct-2001 | | 26-Jan-2001 | | 22-Jun-2001 | | 23-Jul-2000 | | 1-Nov-2001 | | 31-May-2000 | | 17-Nov-2000 | | 10-May-2001 | | 15-Apr-2001 | | 17-May-2001 | | 29-Mar-2000 | | 30-Aug-2001 | | 18-May-2000 | | 11-Apr-2000 | | 1-Nov-2001 | | 24-Feb-2000 | +-+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: switch query logging while the server is running
Ok, but this only works for the current session, if I close and restart the client the settings are reset... -Ursprüngliche Nachricht- Von: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 11:19 An: [EMAIL PROTECTED] Betreff: Re: switch query logging while the server is running [EMAIL PROTECTED] wrote: Description: It would be nice if general query logging could be switched on and off while the MySQL server is running, and not only at startup time. While debugging an application that uses foreign database access libraries, this would be very helpful. One could switch on logging, perform an activity, switch off logging, and look what has happened. Otherwise, the server has to be restarted to change logging, which is a bit annoying... How-To-Repeat: mysql show variables like 'log'; +---+---+ | Variable_name | Value | +---+---+ | log | ON| +---+---+ 1 row in set (0.00 sec) mysql set log off; ERROR 1193: Unknown system variable 'log' mysql set session log off; ERROR 1193: Unknown system variable 'log' mysql This variable is called SQL_LOG_OFF. Please, read the manual: http://www.mysql.com/doc/en/SET_OPTION.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question: using Visual Studio.NET
You can also use my native ADO.Net provider for MySql found at http://www.bytefx.com Thanks Reggie -Original Message- From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 5:15 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Question: using Visual Studio.NET You can access a mysql database within VS.Net through odbc. To do this you have install myodbc. You can get this from mysql website. After installing myodbc you have to create a new datasource. Then you can connect to mysql with the help of adodb object in vs.net. I have never tried to connect mysql within access. But I think so you can do this too through odbc. If you need I can send you samples codes too. [EMAIL PROTECTED] wrote: Hi Everybody, 1- I am trying to upsize an access database to my MySQL server on my website. I tried to get connected within access and failed. Please advise. I am using Win XP as the operating system and MS Office XP Pro. 2- How to connect a Visual Studio.NET project to a MySQL data base located on a MySQL server on a web. I tried to establish a connection with the server from within VS.NET project using th normal procedure, but failed. I could connect to a local SQL server. however I need to use MySQL server on my website. I have the IP address, User ID and Password of the server. Please advise. I am using VS.NET 2003. Many thanks. T. Rady _ No masks required! Use MSN Messenger to chat with friends and family. http://go.msnserver.com/HK/25382.asp -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlcc bug ?
I have noticed that mySQL Control Center (beta 092), will only return back 1000 rows whenever I doubleclick on a table that I know contains an amount greater than 1000 rows. I've checked all properties in mysqlcc and nothing makes a difference. When I select the table and then choose Return all Rows, same behaviour - 1000 rows outputted only. When I select Return Limit, and enter a very large number, I then get the all of the rows retrieved and displayed ... Is this a bug ? Thanks, Travis Weir Cognos Inc. Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos Business Forum. Taking place in over 25 cities around the world, its an opportunity for Business and IT leaders to learn about strategies for driving performance. Visit http://www.cognos.com/enterprise03 for more details. This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you.
Freelance Help Sought
Hi I'm hitting lots of brick walls after moving from an Access-driven website (before it grew big) to MySQL, which is all new to me. The problems I have centre around MySQL Server timeouts and various memory problems on the server. The client's getting jumpy and I don't have much time so I'm hoping to find someone who could give me a few hours of help. It would mean having a look at our server and a few pages (ASP), isolating the key bugs, making a few suggestions for improvement and giving me an idiot's guide in an e-mail to the sorts of things you'd done. There'd be some (reasonable -- the client is a charity) remuneration. If you're interested, please drop me an e-mail letting me know who you are! Many thanks if you're able to lend a hand! Best wishes (unsubscribing from list now) _ Trevor Sather Creative Director Square Eye Ltd 22-24 Monmouth Rd, London, W2 4UT, UK (t) +44 (0)870 760 6682 (f) +44 (0)20 7243 8833 (e) [EMAIL PROTECTED] (w) www.SquareEye.com
RE: first time to use MySQL on MS Platform with PHP.
Prabu,
This is kind of off-topic, as it is a PHP problem. ;) Those error
messages are telling you that the variables you are trying to use were never
initialized. This suggests to me that your PHP installation is set up with
the register_globals option turned off. This means all of your form data is
being stored in the $_POST superglobal array. Just change the query to pull
from the array, so your entries would go from $productid to
${_POST['product_id']} (Please take note of the curly braces {} and the use
of single quotes '' in my revision--they are important.)
Hope that helps.
-Rob
-Original Message-
From: Prabu Subroto [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 5:14 AM
To: [EMAIL PROTECTED]
Subject: first time to use MySQL on MS Platform with PHP.
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
Notice: Undefined variable: productid in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: itemname in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: description in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: price in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: information in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
16
Saved successfully
Here is the code of productsave.php :
?php
include(functions.php);
$sql=
insert into product ( productid, itemname,
description, price, information )
values ('$productid', '$itemname', '$description',
'$price', '$information')
;
$conn=connection();
choosedb();
if (mysql_query($sql,$conn)){
echo Saved successfullybr;
}
else echo mysql_error();
mysql_close($conn);
?
Here is the code of the form which calls
productsave.php (it's cgi program):
form action=cgi/productsave.php method=POST
centerbuData Entry - Product
List/u/b/center
br
table align=center border=0
trtd align=left1./tdtd align=leftProduct
ID/tdtd align=left :/td
td align=left input type=text name=productid
readonly=yes/td/tr
trtd align=left2./tdtd align=leftItem
Name/tdtd align=left:/td
td align=leftinput type=text
name=itemname/td/tr
trtd align=left3./tdtd
align=leftDescription/tdtd align=left:/td
td align=leftinput type=text
name=description/td/tr
trtd align=left 4./tdtd
align=leftPrice/tdtd align=left:/td
td align=leftinput type=text
name=price/td/tr
trtd align=left5./tdtd
align=leftInformation/tdtd align=left:/td
td align=leftinput type=text
name=information/td/tr
trtd colspan=4 align=centerinput
type=submit value=Save src=img/ok.png
input type=reset value=Clear
src=img/no.png/td/tr
/table
/form
Please tell me. Thank you very much in advance.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Error 28
Hi List I got an no space left on device error. Is there a way to drop an index without having MySQL create a temporary table? Can I delete the .myi file directly from the operating system? Thanks in advance Oswaldo Castro
RE: Can someone help me??
I tried but nothing At 10.52 16/07/2003 +0100, Andy Eastham wrote: Try using only single quotes rather than a mixture of single and double quotes? Andy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: 16 July 2003 10:32 To: Rudy Metzger; [EMAIL PROTECTED] Subject: RE: Can someone help me?? I use phpmyadmin At 11.26 16/07/2003 +0200, Rudy Metzger wrote: Did you do that on the mysql command line? Or did you use a different client and/or API? Cheers /rudy -Original Message- From: Sbandy [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 11:21 To: [EMAIL PROTECTED] Subject: Can someone help me?? I am new in mysql I wrote this query: INSERT INTO testo (id_lingua, id_categoria, id_campo, riga, sezione, ordine, codice) VALUES (10 ,6 ,5 ,10 - 99: ,12 ,50 ,'S12IT3' ) and server reply to me: Query was empty Can someone tell me where i do mistake? Thanks a lot.. Sbandy [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] [EMAIL PROTECTED] http://www.motormaniaci.com il portale per gli appassionati di motore -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Unable to perform Inner Join
I have 2 tables with the following fields : table : publisher field1: pub_id - Primary, int, auto table : titles field1: title_id - Primary, int, auto field1: pub_id - int Using sqlyog I noticed that the indexes had already been created for the Primary keys but according to my tutorial I also had to create an index for the foreign key. I did this and then tried to run the following query : SELECT pubishers.pub_id, titles.pub_ID FROM pubishers JOIN pubishers ON pubishers.pub_id = titles.pub_id It keeps giving me the following error : Error Code : 1066 Not unique table/alias: 'pubishers' Can someone tell me what I am doing wrong ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to terminate dead connections that are in SLEEP?
Good morning all, I have a problem with inceasing connection to my database that eventually result in connections being rejected. I know I have an application that is terminating a thread without closing the database handle. Problem is I'm waiting for the fix on some other changes. Here is my reseach. If I check the connections with 'SHOW PROCESSLIST'. I may have 30 connections showing. Some of these show a 'Time' value of 500+ and the 'Command' column reads 'Sleep'. If I check in 15 minutes this same ID will still show as connected but of course the 'Time' value will be greater. So, I checked my variables and for 'wait_timeout' I have this set to '65'. Question is how can I terminate these 'dead' connections? Paul
Unable to perform Inner Join
Try this instead: SELECT pubishers.pub_id, titles.pub_ID FROM pubishers JOIN titles ON pubishers.pub_id = titles.pub_id HTH. ** For great Emap magazine subscription gift offers visit http://www.emapmagazines.co.uk ** The information in this email is intended only for the addressee(s) named above. Access to this email by anyone else is unauthorised. If you are not the intended recipient of this message any disclosure, copying, distribution or any action taken in reliance on it is prohibited and may be unlawful. Emap plc and or its subsidiaries do not warrant that any attachments are free from viruses or other defects and accept no liability for any losses resulting from infected email transmissions. Please note that any views expressed in this email may be those of the originator and do not necessarily reflect those of this organisation. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to terminate dead connections that are in SLEEP?
Kill them :) http://www.mysql.com/doc/en/KILL.html Cheers /rudy -Original Message- From: PAUL MENARD [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 16:44 To: [EMAIL PROTECTED] Subject: How to terminate dead connections that are in SLEEP? Good morning all, I have a problem with inceasing connection to my database that eventually result in connections being rejected. I know I have an application that is terminating a thread without closing the database handle. Problem is I'm waiting for the fix on some other changes. Here is my reseach. If I check the connections with 'SHOW PROCESSLIST'. I may have 30 connections showing. Some of these show a 'Time' value of 500+ and the 'Command' column reads 'Sleep'. If I check in 15 minutes this same ID will still show as connected but of course the 'Time' value will be greater. So, I checked my variables and for 'wait_timeout' I have this set to '65'. Question is how can I terminate these 'dead' connections? Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: derived tables
I don't Mysql very well, but I would be very surprised if that was supported, based on my experience with Oracle. You need to distinguish between data and database object names. You can use derived_tables to return data, but niot names. You can't do select * from 'table', because 'table' is a string, not an object name, your subquery is returning 'table'. You need to use dynamic sql for that sort of thing. -Original Message- From: Shawn McGinn [mailto:[EMAIL PROTECTED] Sent: 13 July 2003 18:02 To: [EMAIL PROTECTED] Subject: derived tables I would like to select data from a table where the table name is located in another table, and I am using the following query: select t1.* from (select tbl_name from user_table where user=guy) t1; This should return the data from table 'tbl_name', but I only get results from the subquery (ie. the query as a whole returns 'tbl_name', not it's contents) Where am I going wrong? I am using version 4.1.0-alpha-standard. Shawn -- Shawn McGinn [EMAIL PROTECTED] UNB -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with UPDATE via CGI
I'm having some trouble updating a mysql database with a perl cgi. Here's the perl: $sql = UPDATE grants SET agency2 = \$agency2\ WHERE agency2 = \$key\; $rv = do($sql) or die Can't execute $sql: $dbh-errstr\nbr; Here's the error returned in the browser: Can't execute UPDATE grants SET agency2 = Academic Health Center WHERE agency2 = AHC: DBI::db=HASH(0x8232154)-errstr br at /var/www/cgi-bin/test/chag2.cgi line 35, AG line 1. The update command works with no problem when I use it from the command line in mysql with same user and password. SELECT and INSERTs work via cgi with 'prepare' and 'execute'. I'm wondering if 'do' is my problem. -- Peter Fleck University of Minnesota Cancer Center [EMAIL PROTECTED] www.cancer.umn.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Deleted index file (.MYI)
Hi Everybody I have acidentally deleted an index file (.MYI) from a table. Is there another way, besides its backup, to recover this table ? Thanks for any help
monitoring
How are you monitoring on your databases? Who has a good solution? Moritz
RE: monitoring
[snip] How are you monitoring on your databases? Who has a good solution? [/snip] What do you mean by monitoring? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Deleted index file (.MYI)
Accidently? You just asked if you could delete the .MYI table because of your disk full error. Oswaldo Castro wrote: Hi Everybody I have acidentally deleted an index file (.MYI) from a table. Is there another way, besides its backup, to recover this table ? Thanks for any help -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql and windows 2003
Wy can't I start the service in windows 2003 server have any one a solusion? Pleas help Ivo tompert
query
Hello: I have 2 tables t1: id age 1 7 2 6 3 7 4 8 5 9 6 4 t2: age 7 9 then I like select all in t1 without are in t2, so I need a result as follow id age 2 6 4 8 6 4 Thanks in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: monitoring [from an off-list reply]
-Original Message- From: Moritz Steiner [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 10:46 AM To: Jay Blanchard Subject: AW: monitoring I want to see: Number of queries Number of Connections Network Data In/Out Key writes Key reads Types of queries Temporary and disk tables usage Memory usage Disk usage -Ursprüngliche Nachricht- Von: Jay Blanchard [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 17:40 An: Moritz Steiner; [EMAIL PROTECTED] Betreff: RE: monitoring [snip] How are you monitoring on your databases? Who has a good solution? [/snip] What do you mean by monitoring? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How can I display images from a mySQL Database in a web page?
What I have found that works, in PHP, is using a form that allows the user to browse for a file or an image. Upon submitting the form the file is uploaded to a set location on the web server and the name of the file is added to the database. When displaying the information associated with the image, write the php page so it has the image tag and all you do is query the database for the name of the file. Let php do the rest. I realize this isn't a php list but this is what I have done in the past. You can check the www.php.net newsgroups archives for steps on accomplishing this task. Good luck, Jef -Original Message- From: Dan Anderson [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:31 PM To: Partap Davis Cc: [EMAIL PROTECTED] Subject: Re: How can I display images from a mySQL Database in a web page? I think there is a way to insert binary image data in your html, but is there any particular reason you need to do that? Yes, my client's server is running with particularly restrictive PHP safe mode settings and has informed me that dynamic images are a /must have/. :: bangs head against wall. starts to bleed :: So, it is relatively easy to store images into a BLOB, and slightly tricky to chop them up into the packet size and reassemble them. But trying to figure out how to do this has boggled my mind and I appreciate all the help of the community. :) -Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problems compiling Mysql in Alpha with Tru64Unix V5.1
julio [EMAIL PROTECTED] wrote: I try to compiling Mysql V4.0 in the Alpha/Tru64 Unix V5.1a. I have installed in the Alpha C++ and C version 6.5, and gcc 3.3 and GNU MAKE 3.8. # make No suffix list. To me it looks like you are running the wrong make, not GNU one. Can help me Julio Rocha -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL query problems
Hi,
Not sure if the problem here is PHP or MySQL, but here we go. I am
trying to do two queries on a database - one after the other, but the
second one never seems to get executed. The two queries are identical
except for two variables. I have checked my form and they are correct
and are being sent to the PHP script the way they should be.
The variables are $playerto, $playerfrom, $nameto, $namefrom. The 'TO'
query is the one that doesn't work.
Here is my code. Any help is appreciated.
if ($namefrom != $nameto) {
if ($playerfrom != $playerto) {
include(2004server.inc);
if($error) {
include(trades-input.php);
exit;
}
$query1 = select manager.idn, manager.total,
roster.idp, position, points from roster join reference
join manager where manager.idn=reference.idn and
reference.idp=roster.idp and manager.idn like '$namefrom' and
roster.idp like '$playerfrom';
$result1 = mysql_query($query1) or $mysqlerror =
mysql_error();
if ($mysqlerror) {
$error = $d_base_error$email_error;
include(trades-input.php);
exit;
}
$line = mysql_fetch_row($result1);
mysql_free_result($result1);
$query2 = select manager.idn, manager.total,
roster.idp, position, points from roster join reference
join manager where manager.idn=reference.idn and
reference.idp=roster.idp and manager.idn like '$nameto' and
roster.idp like '$playerto';
$result2 = mysql_query($query2) or $mysqlerror =
mysql_error();
if ($mysqlerror) {
$error = $d_base_error$email_error;
include(trades-inputs.php);
exit;
}
$row = mysql_fetch_array($result2);
mysql_free_result($result2);
}
}
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: query
Patricio Gigoux [EMAIL PROTECTED] wrote: Hello: I have 2 tables t1: id age 1 7 2 6 3 7 4 8 5 9 6 4 t2: age 7 9 then I like select all in t1 without are in t2, so I need a result as follow id age 2 6 4 8 6 4 SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.age=t2.age WHERE t2.age IS NULL; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: first time to use MySQL on MS Platform with PHP.
Place an echo in the productsave.php page and check the SQL query. If
the query that is getting passed is correct then the problem is on the
productsave page. Otherwise, your values aren't being passed to the
query.
Jef
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 3:25 AM
To: Prabu Subroto; [EMAIL PROTECTED]
Subject: RE: first time to use MySQL on MS Platform with PHP.
I think it is the code in functions you need to look at or the path in
one
of
your ini files :)
Andrew
-Original Message-
From: Prabu Subroto [mailto:[EMAIL PROTECTED]
Sent: 16 July 2003 10:14
To: [EMAIL PROTECTED]
Subject: first time to use MySQL on MS Platform with PHP.
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
Notice: Undefined variable: productid in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: itemname in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: description in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: price in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: information in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
16
Saved successfully
Here is the code of productsave.php :
?php
include(functions.php);
$sql=
insert into product (productid, itemname,
description, price, information )
values ('$productid', '$itemname', '$description',
'$price', '$information')
;
$conn=connection();
choosedb();
if (mysql_query($sql,$conn)){
echo Saved successfullybr;
}
else echo mysql_error();
mysql_close($conn);
?
Here is the code of the form which calls
productsave.php (it's cgi program):
form action=cgi/productsave.php method=POST
centerbuData Entry - Product
List/u/b/center
br
table align=center border=0
trtd align=left1./tdtd align=leftProduct
ID/tdtd align=left :/td
td align=left input type=text name=productid
readonly=yes/td/tr
trtd align=left2./tdtd align=leftItem
Name/tdtd align=left:/td
td align=leftinput type=text
name=itemname/td/tr
trtd align=left3./tdtd
align=leftDescription/tdtd align=left:/td
td align=leftinput type=text
name=description/td/tr
trtd align=left 4./tdtd
align=leftPrice/tdtd align=left:/td
td align=leftinput type=text
name=price/td/tr
trtd align=left5./tdtd
align=leftInformation/tdtd align=left:/td
td align=leftinput type=text
name=information/td/tr
trtd colspan=4 align=centerinput
type=submit value=Save src=img/ok.png
input type=reset value=Clear
src=img/no.png/td/tr
/table
/form
Please tell me. Thank you very much in advance.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Multi Table Delete
I have 2 tables t and t1. In this case, t1 is a copy of t. I want to
delete rows from t1 based on criteria on the t table and a relationship
between t ad t1 (in this case the id column). In the results below, I
would think that the delete should have deleted row 1 {1 5 me) and not
row 3 (1 5 they) when I run this statement
delete t1 from t, t1 where t.id = t1.id and t.id=1 and t.name = 'me';
Any ideas on why row 2 is deleted?
Same results on Your MySQL connection id is 38495 to server version:
4.0.10-gamma-nt Windows 2000
or Your MySQL connection id is 221 to server version:
4.0.13-Max Linux 8.0
This is the contents of t t1 to start
mysql select * from t1;
+--+--+--+
| id | no | name |
+--+--+--+
|1 |5 | me |
|2 |7 | you |
|1 |5 | they |
|2 |5 | me |
|3 |7 | you |
|3 |7 | they |
|3 |5 | we |
+--+--+--+
7 rows in set (0.00 sec)
This is the delete statement
mysql delete t1 from t, t1 where t.id = t1.id and t.id=1 and
t.name = 'me';
Query OK, 2 rows affected (0.00 sec)
This is the result
mysql select * from t1;
+--+--+--+
| id | no | name |
+--+--+--+
|2 |7 | you |
|2 |5 | me |
|3 |7 | you |
|3 |7 | they |
|3 |5 | we |
+--+--+--+
5 rows in set (0.01 sec)
mysql show create table t;
+---+---
+
| Table | Create Table
|
+---+---
+
| t | CREATE TABLE `t` (
`id` int(11) default NULL,
`no` int(11) default NULL,
`name` char(20) default NULL
) TYPE=MyISAM |
+---+---
+
1 row in set (0.00 sec)
mysql show create table t1;
+---+---
-+
| Table | Create Table
|
+---+---
-+
| t1| CREATE TABLE `t1` (
`id` int(11) default NULL,
`no` int(11) default NULL,
`name` char(20) default NULL
) TYPE=MyISAM |
+---+---
-+
1 row in set (0.00 sec)
mysql truncate t1;
Query OK, 0 rows affected (0.01 sec)
mysql insert into t1 select * from t;
Query OK, 7 rows affected (0.01 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql select * from t1;
+--+--+--+
| id | no | name |
+--+--+--+
|1 |5 | me |
|2 |7 | you |
|1 |5 | they |
|2 |5 | me |
|3 |7 | you |
|3 |7 | they |
|3 |5 | we |
+--+--+--+
7 rows in set (0.00 sec)
mysql delete t1 from t, t1 where t.id = t1.id and t.id=1 and t.name =
'me';
Query OK, 2 rows affected (0.00 sec)
mysql select * from t1;
+--+--+--+
| id | no | name |
+--+--+--+
|2 |7 | you |
|2 |5 | me |
|3 |7 | you |
|3 |7 | they |
|3 |5 | we |
+--+--+--+
5 rows in set (0.01 sec)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
join query result difference between 3.23.49 and 4.0.13
hello, i have what seems to me a very common operation i'm performing. i need to find the balance on an invoice. i was not having any problems until the production server was upgraded to mysql v4.0.13-standard for pc-linux. there must be a better way to query for this information than the method i'm using, since the result with v4.0 is not what i expected, nor what i received with v3.23. i'm including sample data and queries with my results. i've not been able to find any relevant messages in the list archives. any comments are greatly appreciated. here's the table structure and some sample data: CREATE TABLE `billing` ( `invoice` mediumint(9) NOT NULL auto_increment, `user_id` mediumint(9) NOT NULL default '0', `invoice_date` date NOT NULL default '-00-00', `amount` float NOT NULL default '0', `timestamp` timestamp(14) NOT NULL, PRIMARY KEY (`invoice`), KEY `user_id` (`user_id`), KEY `user_invoice` (`user_id`,`invoice`) ) TYPE=MyISAM COMMENT='invoices'; INSERT INTO `billing` VALUES (1, 1, '2003-07-01', '500', 20030716092700); INSERT INTO `billing` VALUES (10001, 1, '2003-07-03', '600', 20030716092807); # CREATE TABLE `billing_payment` ( `invoice` mediumint(9) NOT NULL default '0', `amount_paid` mediumint(9) NOT NULL default '0', `payment_status` varchar(15) NOT NULL default '', `pending_reason` varchar(15) default NULL, `payment_date` date default NULL, `txn_id` varchar(20) default NULL, `timestamp` timestamp(14) NOT NULL, KEY `txn_id` (`txn_id`), KEY `invoice` (`invoice`) ) TYPE=MyISAM COMMENT='payments on invoices'; INSERT INTO `billing_payment` VALUES (1, 500, 'Completed', NULL, '2003-07-02', '112233', 20030716092746); here are the queries and results. note that query #1 gives the expected (and desired) result on both versions, but query #2 only gives the expected (and useful) result in v3.23. to give a brief explanation of the difference between the queries: invoice 1 has a payment against it, while invoice 10001 has no payment records in the payment table. === v3.23.49 query #1 mysql SELECT billing.invoice, SUM(amount_paid) AS paid, (billing.amount - SUM(amount_paid)) AS balance FROM billing LEFT JOIN billing_payment ON ( billing.invoice=billing_payment.invoice ) WHERE billing.invoice=1 GROUP BY billing_payment.invoice; +-+--+-+ | invoice | paid | balance | +-+--+-+ | 1 | 500 | 0 | +-+--+-+ 1 row in set (0.00 sec) query #2 mysql SELECT billing.invoice, SUM(amount_paid) AS paid, (billing.amount - SUM(amount_paid)) AS balance FROM billing LEFT JOIN billing_payment ON ( billing.invoice=billing_payment.invoice ) WHERE billing.invoice=10001 GROUP BY billing_payment.invoice; +-+--+-+ | invoice | paid | balance | +-+--+-+ | 10001 |0 | 600 | +-+--+-+ 1 row in set (0.00 sec) === v4.0.13 query #1 mysql SELECT billing.invoice, SUM(amount_paid) AS paid, (billing.amount - SUM(amount_paid)) AS balance FROM billing LEFT JOIN billing_payment ON ( billing.invoice=billing_payment.invoice ) WHERE billing.invoice=1 GROUP BY billing_payment.invoice; +-+--+-+ | invoice | paid | balance | +-+--+-+ | 1 | 500 | 0 | +-+--+-+ 1 row in set (0.01 sec) query #2 mysql SELECT billing.invoice, SUM(amount_paid) AS paid, (billing.amount - SUM(amount_paid)) AS balance FROM billing LEFT JOIN billing_payment ON ( billing.invoice=billing_payment.invoice ) WHERE billing.invoice=10001 GROUP BY billing_payment.invoice; +-+--+-+ | invoice | paid | balance | +-+--+-+ | 10001 | NULL |NULL | +-+--+-+ 1 row in set (0.00 sec) NULL values in this result are not expected, nor are they helpful in determining the invoice balance. thanks again for any suggestions, doug -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Index phpadmin
Hi, i have a quick question in phpadmin when i create an Index on an none empty table. i see that in Cardinality is either a number or has written None what does it mean?? Thank you Anthony
Re: MySQL Multi Table Delete
At 11:39 -0500 7/16/03, Gordon wrote:
I have 2 tables t and t1. In this case, t1 is a copy of t. I want to
delete rows from t1 based on criteria on the t table and a relationship
between t ad t1 (in this case the id column). In the results below, I
would think that the delete should have deleted row 1 {1 5 me) and not
row 3 (1 5 they) when I run this statement
delete t1 from t, t1 where t.id = t1.id and t.id=1 and t.name = 'me';
Any ideas on why row 2 is deleted?
You're deleting from t1 but your name = 'me' condition is on t.
t has two rows with id 1 and name 'me'. The query then deletes from
t1 rows with id 1.
Did you mean t1.name = 'me' ?
Same results on Your MySQL connection id is 38495 to server version:
4.0.10-gamma-nt Windows 2000
or Your MySQL connection id is 221 to server version:
4.0.13-Max Linux 8.0
This is the contents of t t1 to start
mysql select * from t1;
+--+--+--+
| id | no | name |
+--+--+--+
|1 |5 | me |
|2 |7 | you |
|1 |5 | they |
|2 |5 | me |
|3 |7 | you |
|3 |7 | they |
|3 |5 | we |
+--+--+--+
7 rows in set (0.00 sec)
This is the delete statement
mysql delete t1 from t, t1 where t.id = t1.id and t.id=1 and
t.name = 'me';
Query OK, 2 rows affected (0.00 sec)
This is the result
mysql select * from t1;
+--+--+--+
| id | no | name |
+--+--+--+
|2 |7 | you |
|2 |5 | me |
|3 |7 | you |
|3 |7 | they |
|3 |5 | we |
+--+--+--+
5 rows in set (0.01 sec)
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to terminate dead connections that are in SLEEP?
Sure I could create an external process that will poll the process list every few minutes but I was hoping for some direction on how to have the MySQL server do it internally. At least that was my impression from reading the docs on the 'wait_timeout' value. Paul Rudy Metzger [EMAIL PROTECTED] wrote: Kill them :) http://www.mysql.com/doc/en/KILL.html Cheers /rudy -Original Message- From: PAUL MENARD [mailto:[EMAIL PROTECTED] Sent: woensdag 16 juli 2003 16:44 To: [EMAIL PROTECTED] Subject: How to terminate dead connections that are in SLEEP? Good morning all, I have a problem with inceasing connection to my database that eventually result in connections being rejected. I know I have an application that is terminating a thread without closing the database handle. Problem is I'm waiting for the fix on some other changes. Here is my reseach. If I check the connections with 'SHOW PROCESSLIST'. I may have 30 connections showing. Some of these show a 'Time' value of 500+ and the 'Command' column reads 'Sleep'. If I check in 15 minutes this same ID will still show as connected but of course the 'Time' value will be greater. So, I checked my variables and for 'wait_timeout' I have this set to '65'. Question is how can I terminate these 'dead' connections? Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Re: query
Thanks a lot that is the solution El Mié 16 Jul 2003 12:24, Egor Egorov escribió: Patricio Gigoux [EMAIL PROTECTED] wrote: Hello: I have 2 tables t1: id age 1 7 2 6 3 7 4 8 5 9 6 4 t2: age 7 9 then I like select all in t1 without are in t2, so I need a result as follow id age 2 6 4 8 6 4 SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.age=t2.age WHERE t2.age IS NULL; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
column default value
Hello: I'm using version 3.23.41. How may I change the default value of an existing table? (type will remain the same) Pointers to docs are welcome and invited. thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Frequent Table Corruption - Please Help
It is a Redhat 7.2 with a 2.4.7-10smp kernel.It was upgraded last september and mysqld has never been restarted since then (mysqld uptime is now 316 days). Hope this helps Joseph Bueno Richard Gabriel wrote: I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved the problem? What 2.4 version exactly did you run and was it a RedHat kernel? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Tom Roos [EMAIL PROTECTED] Cc: Richard Gabriel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:10 AM Subject: Re: Frequent Table Corruption - Please Help Have you tried to use a non SMP kernel ? I have also experienced table corruptions 2 years ago with mysql 3.23.xx and a 2.2.14smp kernel. I had several servers with the same configuration but only the most loaded had this problem. I had no more corruptions in single CPU mode. I upgraded later to a newer smp kernel (2.4) that solved the problem. It may be a temporary fix until you schedule an upgrade. Hope this helps Joseph Bueno Tom Roos wrote: hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 22:35 To: Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Frequent Table Corruption - Please Help Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:08 PM Subject: Re: Frequent Table Corruption - Please Help Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again! it may be worthwhile to test a new kernel in one of those problematic computers. We believe corruption problems in RH 2.4.18/drivers are random. Then any small change can provoke them. But we will probably never know what exactly was wrong in some 2.4.18 computers. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 9:52 PM Subject: Frequent Table Corruption - Please Help Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck every hour to try to do some damage control. The biggest problem is that once the table is corrupted, it seems to be locked. Well, no clients can read from it. Once repaired, just one record is usually lost for each time the corruption occurs. I am not sure if this is a MySQL bug or even how to reproduce it, but I was hoping that someone here could help. I have included all the information that I have about this below. Any insight is greatly appreciated! Here is the mysqlbug information: Release: mysql-4.0.13 (Official MySQL RPM) C compiler:2.95.3 C++ compiler: 2.95.3 Environment: System: Linux *.com 2.4.18-14smp #1 SMP Wed Sep 4 12:34:47 EDT 2002 i686 i686 i386 GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/ccGCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs Configured with: ../configure --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking --host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit Thread model: posix gcc version 3.2
Advice needed on starting out with MySql...
Greetings all, I have formerly installed mysql 4.0.12 on my machine running win2k Advanced Sever, with Apache 2.0.46 and PHP 4.3.2. Somehow I messed up my configuration file and decided to start the whole thing from scratch. Now I hear that version 4.0.14 release date is only days away. My question is, is it advisable to wait and install 4.0.14 or should I just install 4.0.13. I am a real newbie and was wondering how hard would it be to upgrade from one version to the next? Please advice... Thanks Ola
Re: Frequent Table Corruption - Please Help
Hmm... I am running RedHat 8.0 with 2.4.18smp. The machine itself has been up for 270 days, but MySQL does crash from time to time and also sometimes tables are corrupted. I think I may be left with trial and error at this point. I will try the following things in order: 1. Install the forthcoming MySQL 4.0.14 to see if any bugs fixed solve my problem. 2. Upgrade the kernel to RedHat's 2.4.20 (update to RH 8.0) 3. Try to tweak MySQL settings 4. Install kernel.org's 2.4.21 kernel without RedHat patches. Does anyone have any other ideas? Thanks again for your help! Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Richard Gabriel [EMAIL PROTECTED] Cc: Tom Roos [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 1:10 PM Subject: Re: Frequent Table Corruption - Please Help It is a Redhat 7.2 with a 2.4.7-10smp kernel.It was upgraded last september and mysqld has never been restarted since then (mysqld uptime is now 316 days). Hope this helps Joseph Bueno Richard Gabriel wrote: I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it solved the problem? What 2.4 version exactly did you run and was it a RedHat kernel? Thanks. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Tom Roos [EMAIL PROTECTED] Cc: Richard Gabriel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 4:10 AM Subject: Re: Frequent Table Corruption - Please Help Have you tried to use a non SMP kernel ? I have also experienced table corruptions 2 years ago with mysql 3.23.xx and a 2.2.14smp kernel. I had several servers with the same configuration but only the most loaded had this problem. I had no more corruptions in single CPU mode. I upgraded later to a newer smp kernel (2.4) that solved the problem. It may be a temporary fix until you schedule an upgrade. Hope this helps Joseph Bueno Tom Roos wrote: hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 22:35 To: Heikki Tuuri; [EMAIL PROTECTED] Subject: Re: Frequent Table Corruption - Please Help Thank you very much for the help. I will schedule the upgrade and see if helps. I have 2 other machines running 2.4.18 without problems, but they also do not run the volume that the problematic machine has and they do not have RAID. Take care. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 4:08 PM Subject: Re: Frequent Table Corruption - Please Help Richard, - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 10:53 PM Subject: Re: Frequent Table Corruption - Please Help Thanks for the tip. I'll see about upgrading, but it won't be a small task. Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm trying to search for a solution that does not involve upgrading kernels on 20 machines that are in production use right now. Thanks again! it may be worthwhile to test a new kernel in one of those problematic computers. We believe corruption problems in RH 2.4.18/drivers are random. Then any small change can provoke them. But we will probably never know what exactly was wrong in some 2.4.18 computers. Richard Gabriel Director of Technology, CoreSense Inc. (518) 306-3043 x3951 Regards, Heikki - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 3:45 PM Subject: Re: Frequent Table Corruption - Please Help Richard, you are running a Red Hat kernel 2.4.18? Kernels 2.4.20 seem to be much more reliable. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Richard Gabriel [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, July 15, 2003 9:52 PM Subject: Frequent Table Corruption - Please Help Hi everyone, Since we upgraded to MySQL 4.0.13 from 3.23, we have been getting table corruption often. It happens about twice per week (with about 500 queries per second average). I have even set up a cron to run mysqlcheck
Re: column default value
At 9:02 -0800 7/16/03, Tim Johnson wrote: Hello: I'm using version 3.23.41. How may I change the default value of an existing table? (type will remain the same) Pointers to docs are welcome and invited. thanks tim -- Tim Johnson [EMAIL PROTECTED] http://www.alaska-internet-solutions.com http://www.johnsons-web.com ALTER TABLE t ALTER col_name SET DEFAULT value; http://www.mysql.com/doc/en/ALTER_TABLE.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.0 Roadmap ?
Hi! - Original Message - From: Blah Blah [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 16, 2003 7:03 PM Subject: Re: 4.1.0 Roadmap ? Yes, any information at all would be helpful. daniel Andy J awjarrett[at]hotmail[dot]com wrote in message news:[EMAIL PROTECTED] Hi there, i am half way through a project and looking at using sub-selects, which is only available in ver 4.1.0 alpha. I was just wondering if anyone new when the gamma version whas scheduled for release. As you can understand i dont want develop around a product that isnt in at least the Gamma stage by the time i have to go live In questions like these it is best to look at empirical data. For version 4.0 it took 14 months to reach the gamma status. Thus, we can guess 4.1 will be labeled gamma in June 2004. But many people use also beta versions in production. I believe better than trust labels is to test your own application. Also a 'stable' version can contain a bug which stops your application. Regards Andy Jarrett www.thebluefrogcompany.net Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: first time to use MySQL on MS Platform with PHP.
Those are php notices (not warning or errors) .. change your ini error
reporting settings.. you can either disable those messages or correctly
initialize all variables before trying to use them.
I'd suggest posting your msg to PHP list..
On Wed, 16 Jul 2003, Prabu Subroto wrote:
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
Notice: Undefined variable: productid in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: itemname in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: description in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: price in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: information in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
16
Saved successfully
Here is the code of productsave.php :
?php
include(functions.php);
$sql=
insert into product ( productid, itemname,
description, price, information )
values ('$productid', '$itemname', '$description',
'$price', '$information')
;
$conn=connection();
choosedb();
if (mysql_query($sql,$conn)){
echo Saved successfullybr;
}
else echo mysql_error();
mysql_close($conn);
?
Here is the code of the form which calls
productsave.php (it's cgi program):
form action=cgi/productsave.php method=POST
centerbuData Entry - Product
List/u/b/center
br
table align=center border=0
trtd align=left1./tdtd align=leftProduct
ID/tdtd align=left :/td
td align=left input type=text name=productid
readonly=yes/td/tr
trtd align=left2./tdtd align=leftItem
Name/tdtd align=left:/td
td align=leftinput type=text
name=itemname/td/tr
trtd align=left3./tdtd
align=leftDescription/tdtd align=left:/td
td align=leftinput type=text
name=description/td/tr
trtd align=left 4./tdtd
align=leftPrice/tdtd align=left:/td
td align=leftinput type=text
name=price/td/tr
trtd align=left5./tdtd
align=leftInformation/tdtd align=left:/td
td align=leftinput type=text
name=information/td/tr
trtd colspan=4 align=centerinput
type=submit value=Save src=img/ok.png
input type=reset value=Clear
src=img/no.png/td/tr
/table
/form
Please tell me. Thank you very much in advance.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question again : mysql.sock
Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from socket=/var/lib/mysql/mysql.sock to socket=/tmp/mysql.sock. That doesnt work. What can I do? Perhaps put a link ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock in /tmp Oliver -- t-host GmbH Mobil: 0170/2781117 D-80337 Mnchen Tel: +49 89 54071102 Tumblinger Strae 50 Fax: +49 89 54071103 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question again : mysql.sock
Hello Tim, OK easiest thing to is cd to /tmp and issue ln -s /var/lib/mysql/mysql.sock mysql.sock What else can I do? Oliver Etzel -Original Message- From: Oliver Etzel - GoodnGo.COM (R) [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 12:31 PM To: [EMAIL PROTECTED] Subject: Question again : mysql.sock Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from socket=/var/lib/mysql/mysql.sock to socket=/tmp/mysql.sock. That doesn´t work. What can I do? Perhaps put a link ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock in /tmp Oliver -- t-host GmbH Mobil: 0170/2781117 D-80337 München Tel: +49 89 54071102 Tumblinger Straße 50 Fax: +49 89 54071103 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: first time to use MySQL on MS Platform with PHP.
Hi,
This is a PHP issue not MySQL.
If anything got inserted at all it will be blanks for no where in your
code were your variables ('$productid', '$itemname', '$description',
'$price', '$information') defined.
Try this in the productsave.php code right at the TOP after your include
:
//(since your form action method is POST use $_POST, use $_GET for get
methods)
$p = $_POST;
$productid = $p['productid'];
$itemname = $p['itemname'];
$description = $p['description'];
$price = $p['price'];
$information = $p['informatation'];
Once this is done then the variables are defined and you can now call
your insert query and those PHP warnings should go away.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 12:59 PM
To: Prabu Subroto
Cc: [EMAIL PROTECTED]
Subject: Re: first time to use MySQL on MS Platform with PHP.
Those are php notices (not warning or errors) .. change your ini error
reporting settings.. you can either disable those messages or
correctly
initialize all variables before trying to use them.
I'd suggest posting your msg to PHP list..
On Wed, 16 Jul 2003, Prabu Subroto wrote:
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
Notice: Undefined variable: productid in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: itemname in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: description in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: price in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: information in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
16
Saved successfully
Here is the code of productsave.php :
?php
include(functions.php);
$sql=
insert into product ( productid, itemname,
description, price, information )
values ('$productid', '$itemname', '$description',
'$price', '$information')
;
$conn=connection();
choosedb();
if (mysql_query($sql,$conn)){
echo Saved successfullybr;
}
else echo mysql_error();
mysql_close($conn);
?
Here is the code of the form which calls
productsave.php (it's cgi program):
form action=cgi/productsave.php method=POST
centerbuData Entry - Product
List/u/b/center
br
table align=center border=0
trtd align=left1./tdtd align=leftProduct
ID/tdtd align=left :/td
td align=left input type=text name=productid
readonly=yes/td/tr
trtd align=left2./tdtd align=leftItem
Name/tdtd align=left:/td
td align=leftinput type=text
name=itemname/td/tr
trtd align=left3./tdtd
align=leftDescription/tdtd align=left:/td
td align=leftinput type=text
name=description/td/tr
trtd align=left 4./tdtd
align=leftPrice/tdtd align=left:/td
td align=leftinput type=text
name=price/td/tr
trtd align=left5./tdtd
align=leftInformation/tdtd align=left:/td
td align=leftinput type=text
name=information/td/tr
trtd colspan=4 align=centerinput
type=submit value=Save src=img/ok.png
input type=reset value=Clear
src=img/no.png/td/tr
/table
/form
Please tell me. Thank you very much in advance.
__
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL query problems
Since the first query works, the second one should also work as it is
virtually the same. It is querying the same database using the exact
same query. The only difference is the variable names passed to it by
the form.
i.e.
$playerfrom may = Hossa
$playerto may = Alfredsson
$namefrom may = Bill
$nameto may = John
If I change the from and the to values to the opposite of the above
example I get the same thing. The second query does not work (which
works if I use it as the first query). Even if I use the exact same
query for both - the second one will not work.
Hope this makes sense.
-Original Message-
From: Jef S [mailto:[EMAIL PROTECTED]
Sent: July 16, 2003 12:50 PM
To: [EMAIL PROTECTED]
Subject: RE: MySQL query problems
Have you checked the query in an editor to see if they are working? Just
substitute known values in the place of the variables you are using.
Jef
-Original Message-
From: C. Reeve [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 10:16 AM
To: [EMAIL PROTECTED]
Subject: MySQL query problems
Hi,
Not sure if the problem here is PHP or MySQL, but here we go. I am
trying to do two queries on a database - one after the other, but the
second one never seems to get executed. The two queries are identical
except for two variables. I have checked my form and they are correct
and are being sent to the PHP script the way they should be.
The variables are $playerto, $playerfrom, $nameto, $namefrom. The 'TO'
query is the one that doesn't work.
Here is my code. Any help is appreciated.
if ($namefrom != $nameto) {
if ($playerfrom != $playerto) {
include(2004server.inc);
if($error) {
include(trades-input.php);
exit;
}
$query1 = select manager.idn, manager.total,
roster.idp, position, points from roster join reference
join manager where manager.idn=reference.idn and
reference.idp=roster.idp and manager.idn like '$namefrom' and
roster.idp like '$playerfrom';
$result1 = mysql_query($query1) or $mysqlerror =
mysql_error();
if ($mysqlerror) {
$error = $d_base_error$email_error;
include(trades-input.php);
exit;
}
$line = mysql_fetch_row($result1);
mysql_free_result($result1);
$query2 = select manager.idn, manager.total,
roster.idp, position, points from roster join reference
join manager where manager.idn=reference.idn and
reference.idp=roster.idp and manager.idn like '$nameto' and
roster.idp like '$playerto';
$result2 = mysql_query($query2) or $mysqlerror =
mysql_error();
if ($mysqlerror) {
$error = $d_base_error$email_error;
include(trades-inputs.php);
exit;
}
$row = mysql_fetch_array($result2);
mysql_free_result($result2);
}
}
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
encrypted entries
Hi, I'm using mysql along with Postfix MTA and courier imapd to run a virtual aliased domain email server. I have no problem connecting to and retrieving mail when i use clear passwords, but when i have the imap client try to connect using tls/ssl..it fails. I've read the docs and know that i need to have an encrypted version of the password in the sql database and I've also read that there is a certain way to do it..but i can't seem to find it. i looked through the docs but came up with nothing.. Can someone tell me how to do this, or at least point me to a specific reference. I'm also wondering if i just use 'crypt' on the desired password and then cut and past this value into the database is the proper way to do this? I've seen somewhere that the encrypt function of mysql isn't compatible with courier. Thanks in advance, Aaron Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL make test error
Could anyone tell me how to get past this error please? When I 'make test' some of the tests run but then it dies with. create [ pass ] ERROR: /home/tekton/src/mysql-4.0.13/mysql-test/var/run/master.pid was not created in 30 seconds; Aborting Or can this be safely ignored? Any help would be appreciated. Thanks, Jamie -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL, FreeBSD, LinuxThreads, and 950 connections?
Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x and handling more than 950 connections? If so, did you need to do anything special to make it work? I'm seeing this: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug When I push past roughly 950 connections. I've tried various thread_stack sizes but that doesn't have an effect. Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 209,351,354 queries (356/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Best practice column type for storing decimal currency amounts?
Thanks for the reply, Rudy. My source for the statement that decimal values are stored as strings is: http://www.mysql.com/doc/en/Numeric_types.html : DECIMAL and NUMERIC values are stored as strings, rather than as binary floating-point numbers, in order to preserve the decimal precision of those values. One character is used for each digit of the value, the decimal point (if scale 0), and the `-' sign (for negative numbers). If scale is 0, DECIMAL and NUMERIC values contain no decimal point or fractional part. But you sound knowledgeable. Is the manual in error? --John On Wednesday 16 July 2003 04:36 am, Rudy Metzger wrote: Problem is that DECIMALs are currently stored as FLOAT or DOUBLE in the DB (at least MyISAM). MySQL AB is busy with adding a true monetary type (like MONEY) to the system. What I am doing when using monetary values is putting them into floats if I can live with rounding problems or put them into in ints and multiply them by 100 (or 1000) before putting them there (thus taking care of the decimal point myself). Cheers /rudy ps: I wish DECIMALS would be stored as char :) -Original Message- From: John Hicks [mailto:[EMAIL PROTECTED] Sent: dinsdag 15 juli 2003 21:39 To: [EMAIL PROTECTED] Subject: Best practice column type for storing decimal currency amounts? Is there an accepted best practice on whether to store decimal currency amounts (e.g. dollars and cents) in MySQL decimal column types? Certainly, the most straightforward way is to use decimal columns. But it appears that such values are stored as ASCII strings, which would be inefficient for calculations (requiring conversion to a numeric type for each calculation). I guess the alternative would be to use integer columns (and multiply by 100 to store the value as total cents). My particular context is a PHP/MySQL sales system. What's the consensus? Thanks much, --John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How can I display images from a mySQL Database in a web page?
Dan Anderson wrote: I have created a BLOB field to store images. Is there any way to embed them within HTML with something like: I've done some notes on this at http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html - assuming of course you're using PHP as a WWW backend to dig the stuff out of the database. image start: jpeg /image Thanks in advance, Dan -- From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL, FreeBSD, LinuxThreads, and 950 connections?
In the last episode (Jul 16), Jeremy Zawodny said: Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x and handling more than 950 connections? If so, did you need to do anything special to make it work? I'm seeing this: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug I don't suppose you're hitting a maxproc resource limit? Check limits -a and sysctl -a | grep maxproc. When I push past roughly 950 connections. I've tried various thread_stack sizes but that doesn't have an effect. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Error while using Mysqldump
Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I run mysqldump like below /usr/local/mysql/bin/mysqldump -u root -pabc -d -r /usr/local/mysql/testbackup/schemadump.sql --all-databases It abort with following error /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'address' (Can't open file: 'address.InnoDB'. (errno: 1)) But if I take out -u root -p option then it work fine. Also I don't have any table like address, see below | Tables | +---+ | ACCOMPANIEDTRAVEL | | ADVRESTKT | | AGENCYCALCULATE | | BASEFAREINFOTBL | | TABLE02 | | bench1| | bench_1 | | bench_10 | | bench_11 | | bench_12 | | bench_13 | | bench_14 | | bench_15 | | bench_16 | | bench_17 | | bench_18 | | bench_19 | | bench_2 | | bench_20 | | bench_21 | | bench_22 | | bench_23 | | bench_24 | | bench_3 | | bench_4 | | bench_5 | | bench_6 | | bench_7 | | bench_8 | | bench_9 | | testac| | testad| +---+ Am I missing anything here for root privilege. My login id is mysql, which owns the MySQL binaries. I have tried with different database and it's same behavior. Appreciate it. Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Best practice column type for storing decimal currency amounts?
On 16 Jul 2003 at 16:02, John Hicks wrote: Thanks for the reply, Rudy. My source for the statement that decimal values are stored as strings is: http://www.mysql.com/doc/en/Numeric_types.html : DECIMAL values may very well be stored as strings, but presumably you're going to do some calculations on them as well at some point, and it's likely that not all those calculations are going to occur in MySQL (even assuming MySQL handles DECIMAL calculations exactly). You may have an easier time in your applications doing the calculations on integers. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql setup compared to oracle
Hi, I'm new to mysql. Coming from the oracle database a couple of questions came up. Perhaps somebody, who has also experience in oracle, can set me on the tracks. Questions: 1. is mysql simular organized as oracle: instance/users/tables, so that I have to connect to chossen instance and user? 2. does mysql also use the term tablespace and can it administrated in the same way? 3. when creating a mysql database, how to determine where the datafiles are located? 4. is there something like a init.ora? 5. is it possible to start several databases from the same installation? 6. is there something like ORACLE_HOME and ORACLE_SID? Hope you can give me details prepared for a newbie and point me to the suitable commands or docs. Thanks in advance Harald -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How can I display images from a mySQL Database in a web page?
image start: jpeg /image use this: echo 'img src='.mysql_result($conn, 0, 0).' alt='; where 0,0 is the result-set index for your mysql field. you might use other mysql functions of course, but the place to put the output in is the same the html-source code will look like it is only a normal image path, but the server sends the binary data too hope that helps Maik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Stopping MySQL taking down a server?
What Operating system are you using and how are you measuring unresponsiveness? -- Michael Conlen Tim Fountain wrote: This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the box until they complete. I don't mind how long these things take but the box shouldn't become unresponsive while they are running. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Error while using Mysqldump
This issue is closed. THANKS ! -Original Message- From: Sagar, Sanjeev Sent: Wednesday, July 16, 2003 3:28 PM To: [EMAIL PROTECTED] Cc: Sagar, Sanjeev Subject: Error while using Mysqldump Hello All, I am using Mysql 4.0.13-max-log on Solaris 2.8 If I run mysqldump like below /usr/local/mysql/bin/mysqldump -u root -pabc -d -r /usr/local/mysql/testbackup/schemadump.sql --all-databases It abort with following error /usr/local/mysql/bin/mysqldump: Can't get CREATE TABLE for table 'address' (Can't open file: 'address.InnoDB'. (errno: 1)) But if I take out -u root -p option then it work fine. Also I don't have any table like address, see below | Tables | +---+ | ACCOMPANIEDTRAVEL | | ADVRESTKT | | AGENCYCALCULATE | | BASEFAREINFOTBL | | TABLE02 | | bench1| | bench_1 | | bench_10 | | bench_11 | | bench_12 | | bench_13 | | bench_14 | | bench_15 | | bench_16 | | bench_17 | | bench_18 | | bench_19 | | bench_2 | | bench_20 | | bench_21 | | bench_22 | | bench_23 | | bench_24 | | bench_3 | | bench_4 | | bench_5 | | bench_6 | | bench_7 | | bench_8 | | bench_9 | | testac| | testad| +---+ Am I missing anything here for root privilege. My login id is mysql, which owns the MySQL binaries. I have tried with different database and it's same behavior. Appreciate it. File: Sagar, Sanjeev.vcf -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL, FreeBSD, LinuxThreads, and 950 connections?
On Wed, Jul 16, 2003 at 03:16:26PM -0500, Dan Nelson wrote: In the last episode (Jul 16), Jeremy Zawodny said: Does anyone have MySQL built with LinuxThreads running on FreeBSD 4.x and handling more than 950 connections? If so, did you need to do anything special to make it work? I'm seeing this: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug I don't suppose you're hitting a maxproc resource limit? Check limits -a and sysctl -a | grep maxproc. Does't seem that way, no. bash-2.05b# limits -a Resource limits (current): cputime infinity secs filesize infinity kb datasize 1048576 kb stacksize 65536 kb coredumpsize infinity kb memoryuseinfinity kb memorylocked infinity kb maxprocesses 3686 openfiles 14745 sbsize infinity bytes vmemoryuse infinity kb bash-2.05b# sysctl -a | grep maxproc kern.maxproc: 4096 kern.maxprocperuid: 3686 Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 211,735,955 queries (355/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MYI file difference
Hi All, I tarred up the data directory from mirror1 data base - slave. Copied the tarball to mirror2 with the hopes of rebuilding mirror2 - another slave. Backed up the data directory from mirror2 into old and untarred mirror1 Then I did a diff -r against another mirror and the diff came back with Binary files old/blahblahblah.MYI and data/blahblahblah.MYI differ, For all the .MYI files. Any insight as to why these indexes are different? Thanks Mike
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
Hi All: I am trying to run mysql in a Windows XP environment. I downloaded the binary and installation went smoothly. What I am expecting is that if I have winmysqladmin in my startup it should launch and I should be able to connect using the mysql control centre as my client. So far no joy. Unfortunately the error message conveys no useful information as to where my problem lies. I am presuming something in the configuration of the server or clients is incorrect but I have no idea of what it is. My.ini is: #This File was made using the WinMySQLAdmin 1.4 Tool #7/11/2003 9:45:28 AM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=24.239.132.16 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld.exe user=root password= In the cc I have hostname as localhost. I do note that my environment details as displayed in the admin program have details that I do not appear to be able to modify (e.g. an IP address.) If I try and match these I find the client wants to go out to the internet to access the server. What should these details be. Help!
Re: mysqlcc bug ?
Asfar as I know that is the default settings in the mysql server to be returned. So you will have to set the necessary parameter from the mysql command line client. Best regards Nils Valentin Tokyo/Japan 2003 7 16 22:32Weir Travis : I have noticed that mySQL Control Center (beta 092), will only return back 1000 rows whenever I doubleclick on a table that I know contains an amount greater than 1000 rows. I've checked all properties in mysqlcc and nothing makes a difference. When I select the table and then choose Return all Rows, same behaviour - 1000 rows outputted only. When I select Return Limit, and enter a very large number, I then get the all of the rows retrieved and displayed ... Is this a bug ? Thanks, Travis Weir Cognos Inc. Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos Business Forum. Taking place in over 25 cities around the world, its an opportunity for Business and IT leaders to learn about strategies for driving performance. Visit http://www.cognos.com/enterprise03 for more details. This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
