Fw: Client API version is wrong or am I?
I have installed the MySQL database 4.0.4 client, but when I look at phpinfo() I see that it says: Client API version: 4.0.2-alpha Why? Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with replication
SHOW GRANTS FOR 'repluser'@'replmachine'; yes there is file grant on *.* - i used a simple password to avoid writing it wrong. as i said, if i connect with mysql client tool from the slave machine, i CAN login into the master server! Only the slave can't login into the master server (with the same authentication data!) (on the master server, of course). Check for the FILE privilege. The slave user won't need anything else. It doesn't need SELECT or whatever, only FILE. On the master server, you can do the following: DELETE FROM mysql.user WHERE User = 'repluser'; DELETE FROM mysql.db WHERE User = 'repluser'; FLUSH PRIVILEGES; GRANT FILE ON *.* [or only on the database you want to replicate] TO 'repluser'@'replmachine' IDENTIFIED BY 'some-password'; i did that - as described in the manual! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
thread_concurrency (Try number of CPU's*2 for thread_concurrency)
set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 If I have 2 CPU's, does the above mean that I should set thread_concurrency=16 ? I am using a MySQL database 4.0.4 Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: thread_concurrency (Try number of CPU's*2 for thread_concurrency)
Hi, No, you should set it to 4 if you have 2 CPU :) (2*2 ;)) Regards, Jocelyn - Original Message - From: Jacob Friis Larsen [EMAIL PROTECTED] To: Mysql maillist [EMAIL PROTECTED] Sent: Monday, November 25, 2002 8:46 AM Subject: thread_concurrency (Try number of CPU's*2 for thread_concurrency) set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 If I have 2 CPU's, does the above mean that I should set thread_concurrency=16 ? I am using a MySQL database 4.0.4 Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
4.0.5 RPMs?
All of the other distribution files on mysql.com are showing version 4.0.5, but the linux RPMs are still at 4.0.4. Are these likely to be updated to 4.0.5 in the near future? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: UPDATE LOW_PRIORITY database
Venlig hilsen Jacob Friis Larsen [ JFL WebCom | www.webcom.dk | +45 7027 0767 ] -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sendt: 25. november 2002 11:02 Til: Jacob Friis Larsen Emne: Re: UPDATE LOW_PRIORITY database Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: If I use UPDATE LOW_PRIORITY, will the client then have to wait for the update to finish or not? Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tmpdir
I am running MySQL database 4.0.4 on a RedHat Linux 7.3 with the database path being on raid disks and /tmp/ on a non raid disk. Should the tmpdir be on a raid disk? If so they will be at the same disk as the database. Is that the best option? Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: SV: UPDATE LOW_PRIORITY database
Jacob, Monday, November 25, 2002, 12:03:14 PM, you wrote: If I use UPDATE LOW_PRIORITY, will the client then have to wait for the update to finish or not? Yes, it will wait. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UPDATE LOW_PRIORITY
If I use UPDATE LOW_PRIORITY, will the client then have to wait for the update query to finish or not? Regards, Jacob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Disable InnoDB
Can i get more speed by disabling InnoDB tables, if I'm only using MyISAM and HEAP tables? Any warnings about this? Regards, Jacob http://www.sharksforum.com sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Disable InnoDB
JFL Can i get more speed by disabling InnoDB tables, if I'm only using JFL MyISAM and HEAP tables? JFL Any warnings about this? If your server is need more resources ( memory , etc... ), Yes. The InnoDB only uses processor if the tables typped InnoDB are used , but the memory is allocated. to disable the InnoDB only put this line: skip-innodb in your my.cnf on [mysqld] section. but, only disable InnoDb not get more speed in your application , check the variables: key_buffer join_buffer sort_buffer This variables are very important in case of MyISAM tables. no warnings bye, - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The Licence of MySQl
The licence in mysql page is obscure for version 4.0 What is a diference of MySQL-Classic and MySQL-Pro ? When may i use MySQL-Classic ? When may i use MySQL-Pro ? My Application is a commercial multi-database , running in mysql and interbase , in my case , witch these licenceses must i use ? I am confused :( Tnks, sql,query - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.5 RPMs?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 25 November 2002 10:56, Graham Murray wrote: All of the other distribution files on mysql.com are showing version 4.0.5, but the linux RPMs are still at 4.0.4. Are these likely to be updated to 4.0.5 in the near future? Yes, working on it... I hope to have them ready in the next 1-2 days. Sorry for the delay. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE94iXDSVDhKrJykfIRAg1EAJoCalh4arTiq0QswIHMCBbxLzjc1QCePZCM xcyv0tqGhdNCsrKBSAtZNEM= =B1ep -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Have a problem when I try to connect MySQL( on Linux) thru win32
He all, I have a problem with MySQL ver 3.23.52 on Linux Redhat 8. It is working successfully on the server, and can response all request comming on Server. But, when I try to connect to the database thru any client running on a Windows 2000 (like MySQLAdmin), I can't connect it. Firstly, I got an error message like Error 2013: Lost Connection to MySQL Server during query. I checked the mysqld log file on Server (/var/log/mysqld.log) and I was sure that, when I try to connect to the server, my attempt is received by mysql with an error like: Cannot initialize Innodb as 'innodb_data_file_path is not set. If you do not want to use transactional InnoDB tables, add a line skip_Innodb to the [mysqld] section of init parameters in your my.cnf ... I did it. But still I can't see the databases declared on the mysql (On Linux) from my win2000 PC. Still, on every attempt of connection, a new paragraph is being added to the mysqld.log, now without any error message (mysqld process hanging, pid - killed 020210 03:26:11 mysqld restarted /usr/libexec/mysqld: ready for connection. I am dying to see any databases existing on the Linux server. (In order to be sure that, there is no problem on my client configuration, I installed Mysql win32 version into my friends PC (Win2000).My PC can easily connect and operate the databases that are on my friends PC over network.) Would anyone help me! Cem Yagli - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: The Licence of MySQl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 25 November 2002 13:53, Dyego Souza do Carmo wrote: The licence in mysql page is obscure for version 4.0 What is a diference of MySQL-Classic and MySQL-Pro ? The only difference between those two is InnoDB - MySQL-Classic does not include it, while MySQL-Pro does. Both products are available under a commercial (non-GPL) license only. If you want to use MySQL under the terms of the GPL, please use MySQL-Standard instead. This is exactly the same as MySQL-Pro (with InnoDB), but under the GPL. When may i use MySQL-Classic ? When may i use MySQL-Pro ? It depends on if you require InnoDB or not - that's the only difference. My Application is a commercial multi-database , running in mysql and interbase , in my case , witch these licenceses must i use ? I am confused :( I am sorry, if you find it confusing. I would like to recommend you to contact our sales people at [EMAIL PROTECTED] if you are in doubt - they should be able to answer all your questions and clear the confusion. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE94immSVDhKrJykfIRAt+QAJ4ihr/PW8RMfH388g9tBPoQCIKL/QCggRjU agbOEJksifAA4G5Jpkj7qEY= =1ILo -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
script
Hi All. I have written a SQL script that should retrieve all the rows from a table that match a value given as parameter by the user. The script is something like: SELECT TEST_NAME AS NAME, TEST_DATE FROM TEST WHERE TEST_NAME=NAME; where NAME is the parameter the user should give. I tried to launch this script by command line, using the SOURCE command, but I received an error message. Can I launch scripts asking user parameters? How can I do it? Thanks for your help! Monica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Demande d'inscription à mysql-france
Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe support Yahoo! Groupes L'utilisation du service Yahoo! Groupes est soumise à l'acceptation des Conditions d'utilisation et de la Charte sur la vie privée, disponibles respectivement sur http://fr.docs.yahoo.com/info/utos.html et http://fr.docs.yahoo.com/info/privacy.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: The Licence of MySQl
The licence in mysql page is obscure for version 4.0 What is a diference of MySQL-Classic and MySQL-Pro ? LG The only difference between those two is InnoDB - MySQL-Classic does not LG include it, while MySQL-Pro does. Both products are available under a LG commercial (non-GPL) license only. If you want to use MySQL under the terms LG of the GPL, please use MySQL-Standard instead. This is exactly the same as LG MySQL-Pro (with InnoDB), but under the GPL. When may i use MySQL-Classic ? When may i use MySQL-Pro ? LG It depends on if you require InnoDB or not - that's the only difference. My Application is a commercial multi-database , running in mysql and interbase , in my case , witch these licenceses must i use ? I am confused :( ohhh, i´m sorry , the licences i was confused about are: MySQL-Standard and MySQL-Pro , not mysql-classic ;) What are the deferences between mysql-standard and mysql-pro ? My Application is a commercial multi-database , running on Mysql+InnoDB or Interbase , in my case , witch these licences must i use ? on the mysql page i could read that if my software only depends on mysql to run , i have to order a licence , if not ( in multi-database case ) , i haven´t to order a commercial licence. How this licences works ? according the page i had understood i don't need to buy a licence. am i right ? Tnks, - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql@lists.mysql.com
mysql reference manual for version 3.23.7-alpha. - ...:ÄúºÃ! ÆÕ¹âÍøÂç ÐֵܽãÃÃÃÇÈ¥Õâ¸öÍøÕ¾ÇÆһϣ¬Èç¹û¾õµÄ¿ÉÒԵĻ°¾Í×¢²á°É¡£Ç®ÊÇÉÙÒ»µã²»¹ý¶¼ ÊÇʵÔڵģ¬ÎÒÒѵõ½ÁË30¶àÔªÁË¡£ http://www.nu18.com/hz/?mid=extraterres´ó¼ÒֻҪͨ¹ýÏÂÏß¾ãÀÖÁªÃË×¢²á³ÉΪÆÕͨ»áÔ±(ÊÇÃâ·ÑµÄѽ)£¬Íê³ÉÿÌìµÄ10¸öµã»÷Á´½Ó£¬ºÃºÃµØ×ö£¬Ã»ÓÐϼ¶´úÀíÿ¸öÔÂÒ²ÄÜÊÕÇ® £¡£²£µ£¥Ëļ¶Ï¼¶´úÀíÌá³É£¡£¡£¡ÔÚÿÈË·¢Õ¹5¸öϼ¶´úÀíµÄÇé¿öÏ£¬ÄãµÄËļ¶Ï¼¶´úÀí×ܹ²Îª£º 5+25+125+625=780ÈË £¬Ã¿ÌìÿÈËÒÔ10µã»÷¼ÆË㣬£²£µ£¥Ëļ¶Ï¼¶´úÀíÌá³É£º 780*0.0075*10=58.5Ôª/Ìì¡£ ·¢Õ¹Îå¸öϼ¶´úÀí²»ÄÑ°É,¸ß¼¶»áÔ±µÄÊÕÈëÔÚ2±¶ÒÔÉÏ¡£ ¸¶¿î·½Ê½¶àÑù£¬¼´¿ÉÒÔÊǹúÄÚÒøÐÐÕÊ»§£¬ÒÔ¿ÉÒÔÓÃÍøÉÏEgold¸¶¿î¡£ ×îµÍÖ§¸¶¶î:¹úÄÚÒøÐÐÕÊ»§£ºÆÕͨ»áÔ±:$5|¸ß¼¶»áÔ±:$2; ¡¡Egold:¡¡ÆÕͨ»áÔ±$3|¸ß¼¶»áÔ±£º$0.01£®±¾Õ¾Ö§³ÖËļ¶Ï¼¶´úÀí,ÿ¼¶Ï¼¶´úÀí¶¼ÊÇ25%£¡ »¹µÈʲô¿ìÀ´°É£¡£¡£¡http://www.nu18.com/hz/?mid=extraterres Ö Àñ! ÆÕ¹âÍøÂç [EMAIL PROTECTED] 2002-11-25 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: To join, or not to join?
On Fri, Nov 22, 2002 at 08:13:46PM -0500, Philip Mak wrote: SELECT * FROM boards LEFT JOIN boardAdmins ON boardAdmins.userId = #{userId} AND boardAdmins.boardId = boards.id LEFT JOIN boardMembers ON boardMembers.userId = #{userId} AND boardMembers.boardId = boards.id AND boards.id = #{boardId} Part of your problem is that you're not quite normalized; if you had a table boardUsers with a SET field of admins|members then it would be easier to show ... however, I'd do: SELECT * FROM boards LEFT JOIN boardAdmins ON boardAdmins.boardId = boards.id LEFT JOIN boardMembers ON boardMembers.boardId = boards.id WHERE boards.id = #{boardId} AND boardAdmins.userId = #{userId} AND boardMembers.userId = #{userId} See how the ON clauses in the QUERY all refer the current table back to the previous table? I'm not sure about parentheses, but this should work (untested). -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to Retreive Web Links from MySQL to HTML ???
On Sat, Nov 23, 2002 at 04:37:01AM +0200, Octavian Rasnita wrote: I can do all the job with Perl, but if the link contains a ? sign, it is replaced by the string NULL in the MySQL database and the link stored will be something like: Just look up $dbh-quote(...) in the documentation. $URL = ; $QUERY = INSERT INTO foo (bar) VALUES(.$dbh-quote($URL).); (Or you can use prepare, which makes this even cleaner; exercise left to reader) -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: The Licence of MySQl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 25 November 2002 15:03, Dyego Souza do Carmo wrote: ohhh, i´m sorry , the licences i was confused about are: MySQL-Standard and MySQL-Pro , not mysql-classic ;) What are the deferences between mysql-standard and mysql-pro ? Well, as I said: MySQL-Standard is the GPL version, while MySQL-Classic is only available under a commercial (non-GPL) license. That's the only difference - they do not differ feature-wise. My Application is a commercial multi-database , running on Mysql+InnoDB or Interbase , in my case , witch these licences must i use ? on the mysql page i could read that if my software only depends on mysql to run , i have to order a licence , if not ( in multi-database case ) , i haven´t to order a commercial licence. How this licences works ? according the page i had understood i don't need to buy a licence. am i right ? Sorry, I can't assist you in licensing questions - if you have further questions about it, please contact our sales people at [EMAIL PROTECTED] Thanks! Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE94jSzSVDhKrJykfIRAt2bAJ41F9Vj6pTnz0ZGTU4iRDLM92/d1gCeJeiQ 9fozcL24JjjWTf2Av67OGpQ= =bhzw -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: displaying a letter based on a query value
Greetings... I thin you need to look into the enum datatype. It stores data as integer but when queried it will return data in text. Rgds Insane SQLyog - The Definitive GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Monday, November 25, 2002 3:54 AM Subject: displaying a letter based on a query value Hey All, I'm working on a site that displays all the players on my hockey team and I want to the page to indicate the captains automatically. Right now im using the following query to display all the captains, however, captains are indicated by a 1, is it possible to display a C when a 1 is found? How would i do this? select captain from stats where captain 0 and number = '23' group by number; this returns a 1 for any player with the number that matches being a captain, however it display a 1 is it possible to make that 1 displayed as a C on my page? mysql Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: search query crashing mysql ..... :S
You did not run the quote() funcion on $arch. If $arch contains any special characters, it will break your query. toby z wrote: hay guyz im havin a weired problem i ve this search query $srch_qry = select ctnt_inf.* from ctnt_inf . where (match (firstName ) against (\.$srch.\) . or match (lastName ) against (\.$srch.\) . or match (summary ) against (\.$srch.\) . or match (body) against (\.$srch.\) . or match (title ) against (\.$srch.\) ); $srch_qry_hndl = mysql_query ($srch_qry) or die ('qry failed ! DA tbl must xixt in DA db specifyd bov :s'); n im gettin bizzar results . i)sometimes it works perfect showin all the results ii)n some times it missbehavez . shows a sorry note for the strings i KNOW exist in the full text fields im serchin on . iii)but most of the times it crashes mysql . :S i get thid msg box declaring mysql is gonna shut down now 1. i ve got win 2K pro, php 4.2.2, mysql 3.23.39 , apache 1.3.24 2. im workin with unicode text n most of the fulltext fields im searching on are unicode guyz im all stuck with this query plz hlp thnx a mill toby .. _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: displaying a letter based on a query value
Alternatively, use the IF() function -- SELECT IF(captain=0, C, ) from stats where captain 0 and number = '23' group by number; Or something similar. Nick - Original Message - From: Insanely Great [EMAIL PROTECTED] To: Alex Behrens [EMAIL PROTECTED]; MYSQL [EMAIL PROTECTED] Sent: Monday, November 25, 2002 8:25 AM Subject: Re: displaying a letter based on a query value Greetings... I thin you need to look into the enum datatype. It stores data as integer but when queried it will return data in text. Rgds Insane SQLyog - The Definitive GUI for MySQL http://www.webyog.com/sqlyog/download.html - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Monday, November 25, 2002 3:54 AM Subject: displaying a letter based on a query value Hey All, I'm working on a site that displays all the players on my hockey team and I want to the page to indicate the captains automatically. Right now im using the following query to display all the captains, however, captains are indicated by a 1, is it possible to display a C when a 1 is found? How would i do this? select captain from stats where captain 0 and number = '23' group by number; this returns a 1 for any player with the number that matches being a captain, however it display a 1 is it possible to make that 1 displayed as a C on my page? mysql Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Athlon 2200 vs Xeon 2.8 performance
Hello, I'm considering building a dual athlon or dual xeon machine. Which gives better results for mysql queiries using LIKES on text columns? (under linux) Currently availabe athlon 2.2 (1.8 ghtz) or Xeon 2.8? Anyone run any numbrs between the two? Thanks, John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: getting InnoDB running on windows 2000
In your InnoDB Section you need: innodb_data_home_dir = c:/mysql/innodbdatapath set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/mysql/innodblogspath set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=3M innodb_log_arch_dir = c:/mysql/innodblogspath innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=60 make sure that the paths used exist before you bring the server back up otherwise innodb will not create the files because the directories do not exists. HTH Jfernando ** sql ** -Original Message- From: Bruce Kuppers [mailto:[EMAIL PROTECTED]] Sent: November 22, 2002 22:36 To: mysql help email Subject: getting InnoDB running on windows 2000 I have mysql running using its standard myisam database. The server is version 3.23.39-max, clien 3.23.36 Operating system Windows 2000 5.00.2195 Service pack 2 I am using the following my.ini #This File was made using the WinMySQLadmin 1.1 Tool #11/21/2002 9:16:12 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=192.168.1.100 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # my.ini file to invoke InnoDB option for mysql # - example form page 508 of manual # innodb_data_file_path = ibdata1:50M:autoextend # # set buffer pool size to 50- 80% (for now less) # #set-variable = innodb_buffer_pool_size=60M #set-variable = innodb_additional_mem_pool_size=10M # # log file 25% of buffer pool size # #set-variable = innodb_log_file_size=20M #set-variable = innodb_log_buffer_size=8M # # flush log commit - value of 0 loses transactions #innodb_flush_log_at_trx_commit=1 [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=Bruce password=Lillian1 I get the following message: - 020329 1:07:55 Aborted connection 1 to db: 'test' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 020329 12:55:30 Aborted connection 4 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html the database will not come up or generate the files needed for InnoDB, and when I bring up in default - haveinnodb = DISABLED Can anyone tell me what I am doing wrong? Thanks Bruce A R Kuppers B.Sc.(Hons), M.Sc., Ph.D. Phone: (250) 656-3678 Toll Free: (866) 605-0259 E-Commerce -- Wave of the Future! Get Involved! Claim Your Future! Ask How! Visit: www.bww.com/kuppers Password: bruce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hel to new guy
Here is an example of our data, I had to create 800 web pages for each organization, I had to make a text file from our DOS database. I am wondering which program to put the data in. I also checked with our server, we only have 7 meg. of space which is donated. I know he has SQL server but won't let anyone use it. We are a small group, we don't get any funding. This program looks like you need to be a genius to run. I wish you had step by step procedure how to do this. You can go to our website ISL for example. We are using EXCITE. Thanks Norm - 403 (City of Sarnia) Wing AFAC 102 1/2 S. Christina Street, Sarnia, ON N7T 7H9 Office : (519) 344-8050 ;Fax :(519) 336-5564 Contact(s): John Stewart, 1st Vice President Non profit organization. Supports the Air Cadets # 44 Squadron, various youth organizations, also supports the Veterans' Soccer Field through bingos. E-Mail address : [EMAIL PROTECTED] ABC CHILD CARE CENTRE 811 London Road, Sarnia, ON N7T 4X7 Office : (519) 337-8668 ;Fax :(519) 337-9908 Contact(s): Lise Boyle Provides care to children between the ages of 3 months and 5 years old. Subsidized children are accepted from both the City and the County. Half day programs are available, minimum 2 days a week for children over 2 years of age. Full days available, minimum 2 days per week for all ages. No transportation. Special rates for full time children (5 days/week). Internet address : www.londonbridge.com E-Mail address : [EMAIL PROTECTED] -- - Visit me - http://www2.ebtech.net/~nlamoure/index.htm - Information Sarnia Lambton - http://www.informsarnialambton.org - Sarnia Computer Users' Group - http://www.sarnia.com/scug - Lawrence House Centre for the Arts - http://www.lawrencehouse.ca - Good computer website - http://www.techtv.com Looking for Star Wars and View Masters ! Also any U.S. state quarters. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.49 - strange replication error
Hi I've got a master database with 2 slaves. I've had them up and running for quite a while now with no problems, but today I noticed an error - there was a slave running on the master! I checked /etc/my.cnf - no mention of slaves (it hadn't been changed for a good while anyway). I looked everywhere else mysql looks for my.cnf files but there were none. I tried to stop the slave by running SLAVE STOP - it said 0 rows changed and SHOW SLAVE STATUS showed that the slave was still running! I stopped mysql, moved the master.info and restarted mysql - this fixed the problem (none of the proper slaves reported any errors at any point) but I'm still a little worried why this happened. The master.info created on the master is shown below (I've put in the \n's so you can see where there were blank lines): \n 4\n \n test\n \n 3306\n 60\n Anyone have any ideas why this might have happened? This error first started when one of my colleagues restarted mysql today, but we restart it fairly regularly, I checked the command he used - it was fine. FYI - we run Redhat 7.2. Kind regards Liz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on virtual hosting
(This is a forward of some private mail with the original poster, with his permission.) Date: Sun, 24 Nov 2002 22:59:33 -0500 From: Brian Reichert [EMAIL PROTECTED] To: Sweethome.co.il Webmaster [EMAIL PROTECTED] Cc: Brian Reichert [EMAIL PROTECTED] Subject: Re: MySQL on virtual hosting On Mon, Nov 25, 2002 at 03:15:00AM +0200, Sweethome.co.il Webmaster wrote: The Virtual dedicated systems will need much more resources in real life. I can't imagine having 40 MySQL servers running at once when I can't restrain a single one :) You can constrain a single one, very easily: # nice limits -d whatever -m whatever /usr/local/mysql/libexec/mysqld Of course, you may not want the jail methodology in general; I'm not trying to trick you into it, by any means. If you're virtual hosting, there is the implication that you have more than one customer on a single system, say, forty of them. You have at least two options: - You can let all forty clients (with all of their myriad users, sets of users, etc.) talk to a single MySQL daemon. You have the ease of no clever engineering to get the to all use this daemon, but you now have the task of accounting for their usage, and constraining them individually. - You can give each client their own separate MySQL daemon. You have the overhead of each MySQL daemon process consuming some OS resources, but now you have the freedom to almost completely manage the resources of any one of these daemons. Plus, you get to deal with the extra hassles of: - Isolating which clients want binary replication: those logs each eat up diskspace, and client's shouldn't unduly impair each other's backups. - What if one client make a request that makes MySQL spin? That'll impair everyone else's ability to process queries. - What if someone needs the ability to use DATAFILES under MySQL? Now you get to juggle who gets read/write permission to the same directories that the MySQL does... If you generalize this work above to other services, such as mail servers, web servers, etc., you'll see that you're re-solving the same kind of problem, over and over again. And when you try to worry about how much bandwidth each of these services is really consuming, one tends to migrate to virtual machines as a more complete, general solution. No matter how you cut it, you'll still have forty clients (humans, not mysql clients; each might be dozens of connections) wanting to interact with your daemon(s). Either your machine has the gnads to handle that, or it doesn't. My desktop is a dual-CPU box, with 1.5G of memory. An idle instance of MySQL looks like this: natto% ps auxwwe -p 196 USERPID %CPU %MEM VSZ RSS TT STAT STARTED TIME COMMAND mysql 196 0.0 1.0 11896 10728 con- S29Oct02 5023:13.08 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/natto.numachi.com.pid Having forty MySQL daemons, unto itself, doesn't cost the OS very much at all. But I _do_ think that for manageability, accounting, 'fairness' to your other clients, that there's a lot to said for sandboxing them as completely as possible. Using a jail gets you all they down to network traffic. If nothing else, you can learn who the 'piggy' clients are, and decide to migrate them to another box, where they have more room... Have fun. :) Justin -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hel to new guy
From: Norm Lamoureux [EMAIL PROTECTED] ...I had to create 800 web pages... ...make a text file from our DOS database. I am wondering which program to put the data in. Hi Norm, It sounds to me like you are trying to build a data driven web site on a server with no database available, as aposed to trying to figure out MySQL. Is that right? If so, what level of CGI options do you have? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A SUM with more decimal places than the values being SUMed?
I'm running a query to SUM a Decimal field with the configuration of DECIMAL(6,2) and I get a result looking like: 56.5515009 How is this possible??? Thank you in advance... Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Executing concurrent select statements from perl on MySQL ISAM tables(fwd)
I am trying to make my perl script fork several processes that all execute 'select' statements on MySQL. I want the statements to happen concurrently (as I want to monitor the behaviour of MySQL with native ISAM tables under this concurrent Read access). So I am using 'fork'. However, I think my 'select' statements are not happening concurrently. Is there something I am missing? Thanks. Does anyone please have any sample code on how to execute *concurrent* MySQL select statements on MyISAM tables? I am looking for perl scripts, bash scripts, whatever. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A SUM with more decimal places than the values being SUMed?
From: Andrew Kuebler [EMAIL PROTECTED] I'm running a query to SUM a Decimal field with the configuration of DECIMAL(6,2) and I get a result looking like: 56.5515009 Hi Andrew, I just did this (v 3.23.52): mysql create table dd ( myfloat decimal(6,2)) mysql insert into dd (myfloat) values (56.123456789), (1234.5678); mysql select * from dd; +-+ | myfloat | +-+ | 1234.57 | | 56.12 | +-+ mysql select sum(myfloat) from dd; +--+ | sum(myfloat) | +--+ | 1290.69 | +--+ Unless I'm missing something, this works as it should. --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Executing concurrent select statements from perl on MySQL ISAM tables (fwd)
In the last episode (Nov 25), Geetika Tewari said: I am trying to make my perl script fork several processes that all execute 'select' statements on MySQL. I want the statements to happen concurrently (as I want to monitor the behaviour of MySQL with native ISAM tables under this concurrent Read access). So I am using 'fork'. However, I think my 'select' statements are not happening concurrently. Is there something I am missing? Thanks. That should work. As a test, run two complicated selects, preferably ones that take a couple seconds to run, then run show processlist from a mysql prompt. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Executing concurrent select statements from perl on MySQL ISAM tables(fwd)
From: Geetika Tewari [EMAIL PROTECTED] ...perl script fork several processes... ...I think my 'select' statements are not happening concurrently. Why do you think that? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mailing list mysql@lists.mysql.comµÄ×Ô¶¯»ØÐÅ
Is anybody else getting this mail when they post? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql - Original Message - From: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 25, 2002 11:15 Subject: mailing list [EMAIL PROTECTED]µÄ×Ô¶¯»ØÐÅ ÄãºÃ£¬Äú·¢¸øÎÒµÄÐżþÒѾµ½´ïÎÒµÄÓÊÏ䣬¶àл ÍõïÃñ === Ãâ·Ñµç×ÓÓÊÏä http://home.sina.com.cn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mailing list mysql@lists.mysql.com~{5DWT6/;XPE~}
- Original Message - From: Rodney Broom [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 25, 2002 7:28 PM Subject: Re: mailing list [EMAIL PROTECTED]~{5DWT6/;XPE~} Is anybody else getting this mail when they post? yes, it's written in simplified chinese and it simply means i've received the email that you sent me. so it's obviously an automated answer by someone on mysql list. Stefano - http://dev.obliquid.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Executing concurrent select statements from perl on MySQL ISAM tables(fwd)
My previous question raised some follow up questions, so I am going to try to clarify now by explaining the root of my problems: My original (bash) script is the following: ./getTime.pl result.txt echo started: concurrent. # doing level of concurrency $CL let I=1 while [ $I -le $CL ]; do ./my_read.pl let I=$I+1 done ./getTime.pl result.txt My_read.pl just executes a single select statement on a database of 10^4 tuples in a MySQL version 3.23.53 MyISAM table. One such select takes 1.75 seconds to run serially. The getTime.pl script gives me the time in microseconds before and after the transaction using gettimeofday(). By running many my_real.pl with the sign, I am trying to generate several simultaneous concurrent READ transactions on the database. I want to measure the change in the timing as I raise the concurrency level ($CL). Note I am using MyISAM tables. While they do not have transactional support, they should cater to concurrent Read-only transactions. However the time results I have obtained thus far indicate that the my_read.pl script is running sequentially. The TPS (transactions per seconds) ratio remains constant. I am using Debian with 256MB of RAM, and 4 GB of hard disk. Each tuple in my database has roughly 4 doubles. Also, I am pretty sure that the transactions are long enough to be simultaneous. -- Forwarded message -- Date: Mon, 25 Nov 2002 12:38:45 -0500 (EST) To: [EMAIL PROTECTED] Subject: Executing concurrent select statements from perl on MySQL ISAM tables (fwd) I am trying to make my perl script fork several processes that all execute 'select' statements on MySQL. I want the statements to happen concurrently (as I want to monitor the behaviour of MySQL with native ISAM tables under this concurrent Read access). So I am using 'fork'. However, I think my 'select' statements are not happening concurrently. Is there something I am missing? Thanks. Does anyone please have any sample code on how to execute *concurrent* MySQL select statements on MyISAM tables? I am looking for perl scripts, bash scripts, whatever. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Does FULLTEXT work in mysql-3.23.49?
I'm trying to make what I think is a very simple fulltext index for a small library catalog, viz: create table library ( id INTEGER UNSIGNED PRIMARY KEY NOT NULL, callnumber VARCHAR(8) NOT NULL, lastname TINYTEXT, firstname TINYTEXT, middlename TINYTEXT, title TINYTEXT NOT NULL, subtitle TINYTEXT, comments TINYTEXT, publisher TINYTEXT, year VARCHAR(6) NOT NULL, media VARCHAR(20), FULLTEXT(lastname,firstname,title,subtitle,comments,publisher) ); I load a few hundred records in and then try to search. mysql select * from library where match(title,subtitle) against ('history'); ERROR 1191: Can't find FULLTEXT index matching the column list What am I doing wrong? Does it dislike tinytext? Regards, John Levine, [EMAIL PROTECTED], Primary Perpetrator of The Internet for Dummies, Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner I dropped the toothpaste, said Tom, crestfallenly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Select statement problem
I am creating a search form for the TitleName. When I type in one word it finds all titles with the one word. If I use two words it doesn't work. How do I change my select statement to make it work? Thank you. SELECT * FROM Titles A, ActorTitle B, Actors C WHERE A.TitleID=B.TitleID AND B.ActorID=C.ActorID AND A.TitleName LIKE '%Title%' GROUP BY A.TitleName ASC Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (Name, ActorID) ActorTitle (TitleID, ActorID) TitleGenres (TitleID, GenreID) MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
prepared statement
Hi ; I am usein the following prepared statement: insertOne = dbConnection.prepareStatement( INSERT INTO appointment (apptId,providerId,patientId,serviceLocationId, dateTime, assistant, duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId, clinicId, appSharing) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ); If there is a ' in any of the data field that is defined as char i am getting the following errors: ERROR EXCEPTION: [java.sql.SQLException: Syntax error or access violation: and in the field memo data looks like this: 'PT'S MOTHER COMPLAINED AND REQUESTED THROAT' The versin of the MYSQL i use is 3.22.32 . Operating System is AIX 4.3.3. Thanks for your help Hamid Amjadi 626-449-1705 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New forum
I just want to lets you guys know that I have recently setup a forum for disscusing linux and programming(including MySQL;). Come on and check it out here http://www.linuxforum.hopto.org thanks _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: prepared statement
Hamid Amjadi wrote: Hi ; I am usein the following prepared statement: insertOne = dbConnection.prepareStatement( INSERT INTO appointment (apptId,providerId,patientId,serviceLocationId, dateTime, assistant, duration,state,statechange,memo,cancelMemo,dictationMarked, apptSeqId, clinicId, appSharing) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ); If there is a ' in any of the data field that is defined as char i am getting the following errors: ERROR EXCEPTION: [java.sql.SQLException: Syntax error or access violation: and in the field memo data looks like this: 'PT'S MOTHER COMPLAINED AND REQUESTED THROAT' The versin of the MYSQL i use is 3.22.32 . Operating System is AIX 4.3.3. What version of the JDBC driver are you using? It looks like it's probably a _very_ old one. Either that, or you're escaping the strings before sending them to the .setString() method of PreparedStatement (which takes care of the escaping for you). -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New forum
On Mon, Nov 25, 2002 at 11:51:00AM -0800, Lennart Stevens wrote: I just want to lets you guys know that I have recently setup a forum for disscusing linux and programming(including MySQL;). Come on and check it out here http://www.linuxforum.hopto.org thanks What's wrong with the 6 million exisiting fourms that cover Linux and/or MySQL? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 5 days, processed 192,918,746 queries (410/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.39 (Source distribution) Environment: System: Linux krzych 2.2.19 #93 Thu Jun 21 01:09:03 PDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-slackware-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 sie 21 23:34 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 4783716 maj 26 2001 /lib/libc-2.2.3.so -rw-r--r--1 root root 24721042 maj 26 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 maj 26 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --with-mysqld-user=mysql --with-unix-socket-path=/var/run/mysql/mysql.sock --localstatedir=/var/lib/mysql --with-pthread --enable-thread-safe-client --enable-assembler --with-raid --with-libwrap --without-bench i386-slackware-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need to force Mysql to use port, NOT socket
Hey all, I'm having a painful time trying to get stunnel and mysql to play together. My mysql works fine locally and remotely until I add stunnel. After chasing my tail for a week (and drinking a lot on the weekend) I realized that Mysql is trying to open a socket on the server machine instead of using the TCP port like stunnel needs it to. Is there a way to force Mysql to use the TCP port and not the socket? Many more details are available if required but the crux of it is I need to tell Mysql to use the port. I've done multiple googles, list archive searches, posted to stunnel's list and tried everything I can think of myself. Please help someone who's not as smart as the average bear. = --- If you give a man a fish, he can eat for a day If you bludgeon him to death, you can eat the fish yourself --- __ Do you Yahoo!? Yahoo! Mail Plus Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: New forum
It funny that you ask me this. I originally posted a note up on YOUR site that I had the Red hat 8.0 Files up for download on a site that I set up. They became so popular that I decided to set up a forum to go along with them. Oh, and no there is nothing wrong with the other sites, but you must think so because you continue to sort through tons of junk mail just to find on answer, rather than post it up on a forum. http://www.linuxforum.hopto.org -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, November 25, 2002 12:05 PM To: Lennart Stevens Cc: [EMAIL PROTECTED] Subject: Re: New forum On Mon, Nov 25, 2002 at 11:51:00AM -0800, Lennart Stevens wrote: I just want to lets you guys know that I have recently setup a forum for disscusing linux and programming(including MySQL;). Come on and check it out here http://www.linuxforum.hopto.org thanks What's wrong with the 6 million exisiting fourms that cover Linux and/or MySQL? -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 5 days, processed 192,918,746 queries (410/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to force Mysql to use port, NOT socket
In the last episode (Nov 25), twig les said: Hey all, I'm having a painful time trying to get stunnel and mysql to play together. My mysql works fine locally and remotely until I add stunnel. After chasing my tail for a week (and drinking a lot on the weekend) I realized that Mysql is trying to open a socket on the server machine instead of using the TCP port like stunnel needs it to. Is there a way to force Mysql to use the TCP port and not the socket? Try -h 127.0.0.1, or -h hostname. Don't use -h localhost, because that means use the socket. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Does FULLTEXT work in mysql-3.23.49?
At 13:57 -0500 11/25/02, John R Levine wrote: I'm trying to make what I think is a very simple fulltext index for a small library catalog, viz: create table library ( id INTEGER UNSIGNED PRIMARY KEY NOT NULL, callnumber VARCHAR(8) NOT NULL, lastname TINYTEXT, firstname TINYTEXT, middlename TINYTEXT, title TINYTEXT NOT NULL, subtitle TINYTEXT, comments TINYTEXT, publisher TINYTEXT, year VARCHAR(6) NOT NULL, media VARCHAR(20), FULLTEXT(lastname,firstname,title,subtitle,comments,publisher) ); I load a few hundred records in and then try to search. mysql select * from library where match(title,subtitle) against ('history'); ERROR 1191: Can't find FULLTEXT index matching the column list Your index contains a different set of columns than the columns listed in the match() list. You'll need to create another FULLTEXT index containing just title and subtitle. What am I doing wrong? Does it dislike tinytext? Regards, John Levine, [EMAIL PROTECTED], Primary Perpetrator of The Internet for Dummies, Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner I dropped the toothpaste, said Tom, crestfallenly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Does FULLTEXT work in mysql-3.23.49?
Your index contains a different set of columns than the columns listed in the match() list. You'll need to create another FULLTEXT index containing just title and subtitle. Oh, OK. The manual needs to be corrected. Regards, John Levine, [EMAIL PROTECTED], Primary Perpetrator of The Internet for Dummies, Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner I dropped the toothpaste, said Tom, crestfallenly. PS: sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Does FULLTEXT work in mysql-3.23.49?
sql,query At 16:01 -0500 11/25/02, John R Levine wrote: Your index contains a different set of columns than the columns listed in the match() list. You'll need to create another FULLTEXT index containing just title and subtitle. Oh, OK. The manual needs to be corrected. Can you be more specific? I thought the manual already stated this. Regards, John Levine, [EMAIL PROTECTED], Primary Perpetrator of The Internet for Dummies, Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner I dropped the toothpaste, said Tom, crestfallenly. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL subquery that works
The question is what does Access do in order to perform subqueries on MySQL via MyODBC driversince it is obvious that they work? access contains its own sql engine, so when you link the mysql tables into it, you were then running access queries. What can I do, but I do not want to use access database as a layer between my application and mysql server? I use Visual Basic for accessing mysql server. you may need to do what you need in part sql and part vb code instead of entirely sql. i'm kindof surprised that you're getting such good results from access. i've seen access corrupt databases after they exceeded a gig. also, in stress testing coremodel, access immediately trashed its own database at the beginning of every test, so i recommend caution with access in production. to stress coremodel, i had to move its database into a server. Greetings! I am aware that MySQL does not support subqueries. I have a 3 gb large database of bibliographic records. Database is designed by a model that is accepted by almost every library system, but there is one problem. When searching that database, nested queries are needed and there's a difference between mysql and every other database system. Now, when I linked these tables to Access database and used JET SQL everything was working very nice and nested queries worked too because Access Database supports them. Speed is impressive. The question is what does Access do in order to perform subqueries on MySQL via MyODBC driver since it is obvious that they work? What can I do, but I do not want to use access database as a layer between my application and mysql server? I use Visual Basic for accessing mysql server. Thank You very much Bruno -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select statement problem
Dear John, probably the problem does not derive from MySQL, but from the URL encoded search string, e.g.: Search for oneword = oneword Search for two words = two%20words If you match against two words, there will be no match, as it should match against two%20words. I am not informed which language you use for your application. If it's PHP, you can use the urldecode() function which will convert %20 into , so you can feed MySQL with the decoded string. Hope it helps, -- Stefan Hinz [EMAIL PROTECTED] CEO / Geschäftsleitung iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: John Chang [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 25, 2002 8:20 PM Subject: Select statement problem I am creating a search form for the TitleName. When I type in one word it finds all titles with the one word. If I use two words it doesn't work. How do I change my select statement to make it work? Thank you. SELECT * FROM Titles A, ActorTitle B, Actors C WHERE A.TitleID=B.TitleID AND B.ActorID=C.ActorID AND A.TitleName LIKE '%Title%' GROUP BY A.TitleName ASC Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (Name, ActorID) ActorTitle (TitleID, ActorID) TitleGenres (TitleID, GenreID) MYSQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help - build win2k/cygwin
Hi, I'm trying to build mysql from the development sources (3.23.54, retreived using bitkeeper) under win2k using cygwin. Following the instructions in the mysql manual, I'm having a problem running aclocal: Dango) aclocal aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library If I keep going, I get some more messages, and then configure fails. The version of automake, 1.4-p5, seems to be the most recent available stable version for cygwin (there is a devel version that's also installed but doesn't seem to get called by the wrapper script). Does anyone use cygwin for this, and if so is there something I'm missing? Thanks, -David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hel to new guy
Hi Norm, I gather that you are wanting to bring both databases together into a single MySQL database. In order to do that, you'll have to have the mysql service running on your web server. (Not actually true, but true enough for this conversation) However, it sounds to me like you don't have the option of installing any software on this server. Is that right? If so, you may want to look consilidating the two databases yourself on a different system, like the workstation that you're developing from. Then put all of the data on the web server. Of course, you'll still need some way of storing and accessing the data from your web site. If the web server has Perl installed and available to you, then you're in luck. Actually, you could use any number of CGI programming languages if they are installed, but Perl is the one that I can help you with. Let us know some more about your working enviroment and we'll go from there. From: Norm Lamoureux [EMAIL PROTECTED] No experience, I am a volunteer just trying to figure things out, do a better jon that I am right now, I have to have two seperate databases and I hate that. I was told that My SQL can doi it, it has a web thingy with it. Rodney Broom wrote: It sounds to me like you are trying to build a data driven web site on a server with no database available, as aposed to trying to figure out MySQL. Is that right? If so, what level of CGI options do you have? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Need to force Mysql to use port, NOT socket
I wish that was the answer (ego being less important than sanity). I've put a tcpdump box in the middle and tcp sessions are going out to the mysql server on 3307 (the creative port I chose for stunnel to use for mysql) but the session hangs for about a minute after I send the password. Here are the details: From the MySQL server box. FreeBSD master02.com 4.7-RELEASE FreeBSD 4.7-RELEASE #0: Tue Nov 19 15:24:12 PST 2002 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/FW i386 master02# more /etc/hosts 127.0.0.1 master02.com localhost 192.168.1.6 master02.com master02 192.168.1.6 master02.com. master02# master02# cat /usr/local/etc/stunnel/stunnel.conf # Sample stunnel configuration file # Copyright by Michal Trojnara 2002 # Comment it out on Win32 cert = /usr/local/etc/stunnel/mail.pem chroot = /var/tmp/stunnel # PID is created inside chroot jail pid = /stunnel.pid setuid = stunnel setgid = stunnel # Authentication stuff #verify = 2 # don't forget about c_rehash CApath # it is located inside chroot jail: #CApath = /certs # or simply use CAfile instead: #CAfile = /usr/local/etc/stunnel/certs.pem # Some debugging stuff debug = 7 #output = stunnel.log # Use it for client mode #client = yes foreground = yes # Service-level configuration [3307] accept = 192.168.1.6:3307 #connect = 127.0.0.1:3306 connect = master02.com:3306 #connect = 192.168.1.6:3306 #connect = localhost:3306 master02# more /etc/my.cnf snip comments # The following options will be passed to all MySQL clients [client] #password = port= 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=256M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=8 log-bin server-id = 1 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=10 # Uncomment the following if you are using InnoDB tables #innodb_data_home_dir = /var/db/mysql/ #innodb_data_file_path = ibdata1:10M:autoextend #innodb_log_group_home_dir = /var/db/mysql/ #innodb_log_arch_dir = /var/db/mysql/ # You can set .._buffer_pool_size up to 50 - 80 % # of RAM but beware of setting memory usage too high #set-variable = innodb_buffer_pool_size=256M #set-variable = innodb_additional_mem_pool_size=20M # Set .._log_file_size to 25 % of buffer pool size #set-variable = innodb_log_file_size=64M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #set-variable = innodb_lock_wait_timeout=50 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout This is the debug output for stunnel, which is where I see the TCP connection hang waiting for a socket from Mysql. master02# sh stunnel.sh start 2002.11.25 13:45:02 LOG5[346:134594560]: stunnel 4.00 on i386-portbld-freebsd4.7 PTHREAD+LIBWRAP with OpenSSL 0.9.6g 9 Aug 2002 2002.11.25 13:45:02 LOG7[346:134594560]: RAND_status claims sufficient entropy for the PRNG 2002.11.25 13:45:02 LOG6[346:134594560]: PRNG seeded successfully 2002.11.25 13:45:02 LOG7[346:134594560]: Certificate: /usr/local/etc/stunnel/mail.pem 2002.11.25 13:45:02 LOG7[346:134594560]: Key file: /usr/local/etc/stunnel/mail.pem 2002.11.25 13:45:02 LOG5[346:134594560]: FD_SETSIZE=1024, file ulimit=1792 - 500 clients allowed 2002.11.25 13:45:02 LOG7[346:134594560]: FD 5 in non-blocking mode 2002.11.25 13:45:02 LOG7[346:134594560]: SO_REUSEADDR option set on accept socket 2002.11.25 13:45:02 LOG7[346:134594560]: 3307 bound to 192.168.1.6:3307 2002.11.25 13:45:02 LOG7[346:134594560]: Created pid file /stunnel.pid 2002.11.25 13:45:21 LOG7[346:134594560]: 3307 accepted FD=6 from 192.168.1.4:1058 2002.11.25 13:45:21 LOG7[346:134594560]: FD 6 in non-blocking mode 2002.11.25 13:45:21 LOG7[346:134596608]: 3307 started 2002.11.25 13:45:21 LOG5[346:134596608]: 3307 connected from 192.168.1.4:1058 2002.11.25 13:45:21 LOG7[346:134596608]: FD 7 in non-blocking mode 2002.11.25 13:45:21 LOG7[346:134596608]: 3307 connecting
Re Does FULLTEXT work in mysql-3.23.49?
Your index contains a different set of columns than the columns listed in the match() list. You'll need to create another FULLTEXT index containing just title and subtitle. Oh, OK. The manual needs to be corrected. Can you be more specific? I thought the manual already stated this. Aha, I see that it has been corrected. In section 6.8.1 there's now a second bullet that says: * The MATCH() column list must exactly match the column list in some FULLTEXT index definition for the table, unless this MATCH() is IN BOOLEAN MODE. That wasn't there when I downloaded 3.23.49. Regards, John Levine, [EMAIL PROTECTED], Primary Perpetrator of The Internet for Dummies, Information Superhighwayman wanna-be, http://iecc.com/johnl, Sewer Commissioner I dropped the toothpaste, said Tom, crestfallenly. PS: sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question on optimizing complex query
Hello, I am relatively new to MySQL though I have database experience. I have a query that doesn't seem to want to use an index for the first table despite my indexing several fields. Before I get too far in the details of the query, here is what EXPLAIN SELECT tells me for the first table of the LEFT JOIN: type=ALL possible_keys=NULL extra=where used; using temporary; using filesort I found a reference that usage of a temporary table ...typically happens if you do an ORDER BY on a different column set than you did a GROUP BY on. This is the case as my ORDER BY uses two columns while I group on one. Does that preclude the use of an index? Also, my first table has about 65 rows, and about 95% are used for the query (as limited by a WHERE condition), though any number of rows will be returned. Given that is the case, would that prevent MySQL from using an index? Or does it even matter with a table this size? For the record, it's the second table that has several thousand rows, and MySQL uses an index for that table in this query. - Steve Yates - if (stone != rolling) moss++; ~ Taglines by Taglinator - www.srtware.com ~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NaNs
Greetings. If I have a key on a float and attempt to insert a NaN I get ERROR 1034: Incorrect key file for table: 'foo'. Try to repair it if I attempt to update/delete that row. If I remove the key from the float it seems to behave when I try to update/delete the row. Is this a bug / known limitation in mysql-3.23.52? Thanks for any insight. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost root password.
Hello, I have made the mistake and now have no root access to mySQL. Could you help me, please, to reset the root password. Regards, Jacek. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Javascript and mySQL
Is there anyway to retrieve mySQL data from JavaScript? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Quick Nasty upgrade...
Hi all. I am running MySQL-4.0.4 and have just compiled 4.0.5. On the MySQL website, I found a bit that says: You can always move the MySQL form and datafiles between different versions on the same architecture as long as you have the same base version of MySQL. So does this mean I can do a 'make install' and then dump my old /usr/local/mysql/var directory on top of the new one and all will be OK? I am using MyISAM and InnoDB tables. Or should I use the 'safe' method of backing up with mysqldump and importing into the new install? Thanks! -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Javascript and mySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Michael C. Podlesny wrote: Is there anyway to retrieve mySQL data from JavaScript? Not directly. There's at least two ways to do it...You can use an IFRAME, and post/retrieve to your favorite web programming language which can talk to MySQL, or you can write a Java applet and communicate to the database with JDBC, and communicate with the applet via Javascript. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.1.90 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE94sNVtvXNTca6JD8RAnZqAJ0fesebWLsOgCsvhIiY1CMr5HUXJQCfcM+r cJrLTrsa9b1Z97oLWyYbKKg= =i4Pw -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TIMESTAMP null value help
I am trying to get my TIMESTAMPE field to auto update (use the current time for inserts). However it keeps going to all 00, I read the documentation and it says that is because it is getting an invalid input. However it also states if you put null in it will work, it does on the server, but when I use perl/dbi it goes to 00 Here is the code my $sth1 = $dbh-prepare(insert into CONTACT values (?,?,?,?,?,?,?,?)); $sth1-execute($query-param(NAME), $query-param(COMPANY), $query-param(EMAIL), $query-param(PHONE), $quer y-param(ADDRESS), $query-param(SUBJECT), $query-param(MESSAGE), null) or die Can't execute SQL statement: $ DBI::errstr\n; and the results for the ones using the form about have all zeros, if I do insert into CONTACT (NAME,COMPANY,EMAIL,PHONE,ADDRESS,SUBJECT,MESSAGE,DATE) values (Ron Petty, asdfasdf, [EMAIL PROTECTED], asdfddd, sdfsadfasdfsad, Testing contact, Hey did this thing work?, null); It works, any ideas? Thanks Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: TIMESTAMP null value help
At 19:32 -0600 11/25/02, Ronald Petty wrote: I am trying to get my TIMESTAMPE field to auto update (use the current time for inserts). However it keeps going to all 00, I read the documentation and it says that is because it is getting an invalid input. However it also states if you put null in it will work, it does on the server, but when I use perl/dbi it goes to 00 That's because to specify NULL in DBI, you should use undef. Here is the code my $sth1 = $dbh-prepare(insert into CONTACT values (?,?,?,?,?,?,?,?)); $sth1-execute($query-param(NAME), $query-param(COMPANY), $query-param(EMAIL), $query-param(PHONE), $quer y-param(ADDRESS), $query-param(SUBJECT), $query-param(MESSAGE), null) or die Can't execute SQL statement: $ DBI::errstr\n; and the results for the ones using the form about have all zeros, if I do insert into CONTACT (NAME,COMPANY,EMAIL,PHONE,ADDRESS,SUBJECT,MESSAGE,DATE) values (Ron Petty, asdfasdf, [EMAIL PROTECTED], asdfddd, sdfsadfasdfsad, Testing contact, Hey did this thing work?, null); It works, any ideas? Thanks Ron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyOLEDB
Hello, I have been racking my brains out for the last two days trying to get this thing working.. I am using MS SQL 2000 linking server sp to link to MYSQL at the moment I am using the generic ole db procider but I want to use the myoledb provider, but when I go to use it it errors saying cant create instance if MySQLProv. And the other thing is what version of mysql supports multple sql commands in the one statement eg.. Select 'nathan' ; insert into tablename(field) values(1) any help would be super ;) Kind Regards Nathan Franklin TSN Internet [EMAIL PROTECTED] MSN: [EMAIL PROTECTED] 'Listen because when you say 'I Know', you cease to 'Know' more.' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hello to new guy
Hi, It is 760 organizations listed, when I said two, I meant that on the WWW I have over 700 individual web pages that EXCITE does a search for and my main database in DOS. I don't know whether my server has these programs, I can check. Thanks Norm Rodney Broom wrote: Hi Norm, I gather that you are wanting to bring both databases together into a single MySQL database. In order to do that, you'll have to have the mysql service running on your web server. (Not actually true, but true enough for this conversation) However, it sounds to me like you don't have the option of installing any software on this server. Is that right? If so, you may want to look consilidating the two databases yourself on a different system, like the workstation that you're developing from. Then put all of the data on the web server. Of course, you'll still need some way of storing and accessing the data from your web site. If the web server has Perl installed and available to you, then you're in luck. Actually, you could use any number of CGI programming languages if they are installed, but Perl is the one that I can help you with. Let us know some more about your working enviroment and we'll go from there. From: Norm Lamoureux [EMAIL PROTECTED] No experience, I am a volunteer just trying to figure things out, do a better jon that I am right now, I have to have two seperate databases and I hate that. I was told that My SQL can doi it, it has a web thingy with it. Rodney Broom wrote: It sounds to me like you are trying to build a data driven web site on a server with no database available, as aposed to trying to figure out MySQL. Is that right? If so, what level of CGI options do you have? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- - Visit me - http://www2.ebtech.net/~nlamoure/index.htm - Information Sarnia Lambton - http://www.informsarnialambton.org - Sarnia Computer Users' Group - http://www.sarnia.com/scug - Lawrence House Centre for the Arts - http://www.lawrencehouse.ca - Good computer website - http://www.techtv.com Looking for Star Wars and View Masters ! Also any U.S. state quarters. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Selective Replication question
Hi folks, I'm looking for creative ways to setup a replication config that lets me push all tables to some slaves and only a subset to other slaves. For this scenario, let's say I have three db servers... One is a master and gets all updates. One is an update slave, which gets all the master updates replicated down normally. The last is a read slave, also replicated off the master, which only needs to get updates from 5 of the 20 tables that exist on master. What's the best to configure this? :-) I could just leave both slaves as normal slaves and drop indexes on the read slave since those tables will never be queried. But this still has write overhead on a box that I'd like to optimize for reads. Nothing is ever updated on the read slave, but it's important that the replication stays as closely sync'd as possible. What if I drop all the unused tables on the read slave, and then set replication to ignore all errors? Would that work? What problems do you imagine this creating? Or are there better ways to implement this? Any input you have is very much appreciated, no matter how crazy it might seem. ;-) Thanks, =john PS: Sinisa, I'm going to submit this into the MySQL support queue this week too, so if any of you at MySQL AB have suggestions about how best to implement this, please let me know. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql@lists.mysql.com
mysql:ÄúºÃ!±¾ÈË¿ÉÌṩÒÔÏ·þÎñ£º 1¡¢Ó²¼þ¼ÓÃܹ·Æƽ⣻ 2¡¢Èí¼þÍêÈ«Æƽ⣻ 3¡¢Èí¼þ×¢²á»úÌáÈ¡£» 4¡¢È¥³ýÈí¼þÏÞÖÆ£¨Èç°ÑÍøÂç°æµÄ10Óû§¸Ä³É100Óû§£¬´òÓ¡¹¦Äܵȣ©£» 5¡¢¹úÍâ´óÐÍÊý¾Ý¿âÆƽ⣻ 6¡¢Èí¼þ¼ÓÃÜ£» 7¡¢²¿·ÖÒѽâÈí¼þµÍ¼ÛÌṩ£» 8¡¢ÊÖ»ú¶ÌÐÅϢȺ·¢Èí¼þ--ÆóҵȺ·¢°æ ²¢¸½ËÍ×¢²á»ú£» 9¡¢ÓʼþȺ·¢Èí¼þ¡¢ÓʼþµØÖ·ËÑË÷Èí¼þ¼°1300Íò£¨¹úÄÚ¾³ä·ÖÑéÖ¤ÓÐЧµØÖ·£©ÓʼþµØÖ·Ìṩ£» ËÎÏÈÉú »ØÐÅÇë·¢email: [EMAIL PROTECTED] [EMAIL PROTECTED] Ö Àñ! 2002-11-26 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hello to new guy
From: Norm Lamoureux [EMAIL PROTECTED] ...700 individual web pages that EXCITE does a search for... Are these web pages actual individual files, or are they simply information in a database someplace that needs to get displayed? I don't know whether my server has these programs, I can check. I would doubt that the server is going to have any of your DOS software installed. I'd be willing to bet money that you are going to have to port this data yourself. Since you aren't funded, you may want to just take a brute force aproach. That is, maintain a list of all the information yourself. Say on your home computer. Then, update the web pages by hand as needed. I may be missing what you need, so let me know. Hey, everybody else. Any input? --- Rodney Broom President, R.Broom Consulting http://www.rbroom.com/ sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost connection to MySQL server during query
Yes, again. :( Although reluctantly, I finally decided to upgrade to 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors. Alas, 6 out of 10 times when I start a MySQL application, I get an error like this: DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/libdata/perl/5.00503/News/MySQL/User.pm line 209. The log is very non-telling; it mostly bales at something entirely trivial; 021126 6:15:34 4 Connect news@localhost on xovers 4 Query SELECT domain_id FROM smtp.cwdomains 021126 6:15:35 4 Query SELECT newsgroup FROM newsgroups WHERE local 'y' 4 Quit The program connects via /tmp/mysql.sock from localhost; so there is no real connection or DNS problem. It just loses the connection. :( Can someone please tell me how to end this problem? I checked the databases a zillion times, and they appear fully intact. I am gravely at a loss here. :( - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Javascript and mySQL
First rule of JavaScriptis you don't talk about JavaScript! Second rule of JavaScript is you _don't_ talk about JavaScript! But seriously, remember that JavaScript has very, very few input/output functions that can be used outside of a browser. There really isn't a way to create a JavaScript connection object to link to MySQL or any other database package. However, there is a way to fake it! You can utilize JavaScript data arrays to access information that is stored on your web page. You would use a scripting language like ASP or PHP to output the array on the page and the access the array elements via JavaScript. While this raises quite a few issues (I'll leave that exercise to you), it is a way to access your database information with JavaScript. Good Luck! Dennis Filter: MySQL, SQL, Query - Original Message - From: Michael C. Podlesny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 25, 2002 7:14 PM Subject: Javascript and mySQL Is there anyway to retrieve mySQL data from JavaScript? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: New charset for MySQL
Hi! What is Bengali character set? Does it have a Unicode mapping table like for example this one: ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT Please also send me some links to internet recourses written in Bengali. Regards! Shyamal Banerjee wrote: Dear sir, I want to create a website in my native language. I would like MySQL support for my native character set, which is Bengali. I think MySQL does not support this language. How can I add support for it in MySQL ? Thanks in advance for any reply. Shyamal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql replication mismatched count of records in master/slave db
Hi, I'm new to the list ( mysql) and not sure if there is an archive I can search so apologies if this has been mentioned earlier. I was hoping someone might be able to shed some light on a problem I am having: I'm supporting a mysql 3.23.49 database with one master db (type=BerkleyDB) and two slave databases (both type=MyISAM). If I check the Show master status/show slave status outputs it shows that the databases are all current and pointing to the same file pointer and using the same binary log. Then, if I do a count(*) from TABLENAME_T; on each to check they all are identical as well as current, the two slaves have just over 2000 records less than the master ie masterdb = 27262 records slave01 = 25181records slave02 = 25181 records ie a difference of 2081records this seems to be happening every couple of days and I have to do a mysqldump on the master and restore to the slaves - then the number of records is the same again ( the file pointers are still in sync) until a couple of days later when they go out of sync. I don't see any messages referring to failed transactions in the logs so as far as the error logs are concerned it all looks ok (though I could have basic logging switched on, looking into setting the logging higher now). I've tested the validity of the data for recent updates - if I send a manual update to the master it goes to the slaves and is displayed in the output correctly around the time as it is on the master. I've asked some of the techs who have a similar setup in another department (which has been working for over a year) and theirs always have the same number of records as well as having the file pointers/binary logs in sync. they are using berkley and myisam type tables also. does anyone know what could be causing the number of records to differ? pls let me know if u need more info. any help greatly appreciated! thanks in advance Kath - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: New charset for MySQL
Bengali is the script used in many Indian languages, like Hindi. A search on google turned up a lot of pages written using Bengali, a good example is http://www.parabaas.com/ and, for example, http://www.parabaas.com/PB28/LEKHA/bMarkin28.html Shyamal, if you're a coder, you can add support for it yourself, just check out this page: http://www.mysql.com/doc/en/Adding_character_set.html Dean Harding. -Original Message- From: Alexander Barkov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 26 November 2002 6:00 pm To: Shyamal Banerjee Cc: [EMAIL PROTECTED] Subject: Re: New charset for MySQL Hi! What is Bengali character set? Does it have a Unicode mapping table like for example this one: ftp://ftp.unicode.org/Public/MAPPINGS/ISO8859/8859-1.TXT Please also send me some links to internet recourses written in Bengali. Regards! Shyamal Banerjee wrote: Dear sir, I want to create a website in my native language. I would like MySQL support for my native character set, which is Bengali. I think MySQL does not support this language. How can I add support for it in MySQL ? Thanks in advance for any reply. Shyamal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
My SQL
Hello, I am Miki Tan from Gleneagles Medical Centre. I am interested in MySQL database development. 1.Can I know with platform is suit for MYSQL ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php