RE: Hi, how did u do de-emphasis of sql statements?
Let me change your example slightly... select * from table where name’A’ versus select * from table where name’Z’ Now, let's assume you have an INDEX starting with `name` and names are distributed in the typical way. The will be perhaps 1% of the names satisfying 'Z', but 95% satisfying 'A'. The index would be very useful for Z, but a waste for A. Hence, it is a feature that MySQL does not cache execution plans. You will also find that MySQL's query analyzer is very fast (compared to the competition). Hence, there is much less need for a cache than 'they' have. -Original Message- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Monday, August 13, 2012 5:49 AM To: MID.night Cc: 673575760; mysql Subject: Re: Hi, how did u do de-emphasis of sql statements? - Original Message - From: MID.night 693893...@qq.com Like select * from table where name’A’ is just The same as select * from table where name’B’. The execution plan for both statements is indeed likely (but not guaranteed!) to be the same. As far as I'm aware, though, MySQL does not bother about that, though, as there is no execution plan cache. The query result cache does not equate the statements - it works based off the EXACT query text, INCLUDING spaces and capitalization. When analyzing various logs, the Maatkit/Aspersa/Percona toolset does transform SQL statements into their canonical form, though; so if you're looking for ways to do that you can have a look at how it's done there. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Hi, how did u do de-emphasis of sql statements?
- Original Message - From: MID.night 693893...@qq.com Like select * from table where name’A’ is just The same as select * from table where name’B’. The execution plan for both statements is indeed likely (but not guaranteed!) to be the same. As far as I'm aware, though, MySQL does not bother about that, though, as there is no execution plan cache. The query result cache does not equate the statements - it works based off the EXACT query text, INCLUDING spaces and capitalization. When analyzing various logs, the Maatkit/Aspersa/Percona toolset does transform SQL statements into their canonical form, though; so if you're looking for ways to do that you can have a look at how it's done there. -- Linux Bier Wanderung 2012, now also available in Belgium! August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: hi.. is it possible
MuraliKrishna wrote: Hi is it possible to have two instances of mysql over single windows xp. because I want to workout with those as server and client. please help me regarding this. Sure you can! Read this and get back to us with questions: http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html -- Shawn Green, MySQL Senior Support Engineer Sun Microsystems, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: hi.. is it possible
Yes you can, but port has to be different. Regards, Thiyaghu CK www.mafiree.com On Sat, Feb 6, 2010 at 2:50 PM, MuraliKrishna murali_kris...@arthaoptions.com wrote: Hi is it possible to have two instances of mysql over single windows xp. because I want to workout with those as server and client. please help me regarding this.
RE: hi help to take backup-mysql-windows-xp
What error are you getting? === John Daisley MySQL 5.0 Certified Database Administrator (CMDBA) MySQL 5.0 Certified Developer Cognos BI Developer Telephone: +44(0)1283 537111 Mobile: +44(0)7812 451238 Email: john.dais...@butterflysystems.co.uk === Sent via HP IPAQ mobile device -Original Message- From: muralikrishna g muralikrishn...@gmail.com Sent: 02 February 2010 06:45 To: mysql@lists.mysql.com Subject: hi help to take backup-mysql-windows-xp hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: hi help to take backup-mysql-windows-xp
Please paste the error and don't give the spave between -p and password. On Tue, Feb 2, 2010 at 12:05 PM, muralikrishna g muralikrishn...@gmail.comwrote: hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me -- Thanks Suresh Kuna MySQL DBA
Re: hi help to take backup-mysql-windows-xp
hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me mysql mysqldump -u root -p dbadmin murali backupfile.sql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql dump -u root -p dbadmin murali backupfile.sql' at line 1 mysql mysqldump -uroot -pdbadmin murali backupfile.sql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql dump -uroot -pdbadmin murali backupfile.sql' at line 1 mysql On 2/2/10, Suresh Kuna sureshkumar...@gmail.com wrote: Please paste the error and don't give the spave between -p and password. On Tue, Feb 2, 2010 at 12:05 PM, muralikrishna g muralikrishn...@gmail.com wrote: hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me -- Thanks Suresh Kuna MySQL DBA
Re: hi help to take backup-mysql-windows-xp
Hi Murali, You have to execute it outside mysql prompt i.e command prompt. Thanks Suresh Kuna MySQL DBA Sent from BlackBerry® on Airtel -Original Message- From: muralikrishna g muralikrishn...@gmail.com Date: Tue, 2 Feb 2010 12:17:24 To: Suresh Kunasureshkumar...@gmail.com Cc: mysql@lists.mysql.com Subject: Re: hi help to take backup-mysql-windows-xp hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me mysql mysqldump -u root -p dbadmin murali backupfile.sql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql dump -u root -p dbadmin murali backupfile.sql' at line 1 mysql mysqldump -uroot -pdbadmin murali backupfile.sql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql dump -uroot -pdbadmin murali backupfile.sql' at line 1 mysql On 2/2/10, Suresh Kuna sureshkumar...@gmail.com wrote: Please paste the error and don't give the spave between -p and password. On Tue, Feb 2, 2010 at 12:05 PM, muralikrishna g muralikrishn...@gmail.com wrote: hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me -- Thanks Suresh Kuna MySQL DBA
RE: hi help to take backup-mysql-windows-xp
Hey guys Try using this option from the command prompt via run Mysqldump.exe -u root -p --all-database backup.txt This should work. Thanks, Dilipkumar Database Engineering phone: +91-44-6637 3167 mailto: dilipkumar.par...@eds.com Pager mail:9884430...@nma.vodafone.in -Original Message- From: sureshkumar...@gmail.com [mailto:sureshkumar...@gmail.com] Sent: Tuesday, February 02, 2010 12:22 PM To: muralikrishna g Cc: mysql@lists.mysql.com Subject: Re: hi help to take backup-mysql-windows-xp Hi Murali, You have to execute it outside mysql prompt i.e command prompt. Thanks Suresh Kuna MySQL DBA Sent from BlackBerry® on Airtel -Original Message- From: muralikrishna g muralikrishn...@gmail.com Date: Tue, 2 Feb 2010 12:17:24 To: Suresh Kunasureshkumar...@gmail.com Cc: mysql@lists.mysql.com Subject: Re: hi help to take backup-mysql-windows-xp hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me mysql mysqldump -u root -p dbadmin murali backupfile.sql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql dump -u root -p dbadmin murali backupfile.sql' at line 1 mysql mysqldump -uroot -pdbadmin murali backupfile.sql; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql dump -uroot -pdbadmin murali backupfile.sql' at line 1 mysql On 2/2/10, Suresh Kuna sureshkumar...@gmail.com wrote: Please paste the error and don't give the spave between -p and password. On Tue, Feb 2, 2010 at 12:05 PM, muralikrishna g muralikrishn...@gmail.com wrote: hi to all.. i was in need to take backup of database.. i am using sql server version:5.0.27-coomunity-nt i have tried by using mysqldump -u name -p password database_name backup.sql; but i am getting error.. i am using windows xp system.. please help me -- Thanks Suresh Kuna MySQL DBA
Re: Hi Query Optimization steps
Hi! bharani kumar wrote: Then which DB engine is better. Which fruit is better, an apple or a banana? And if X is better, why do farmers still grow Y, and why do people buy it? More serious: Different engines offer different features, as described in the manual. The most obvious differences are full-text search (MyISAM) versus transactions and referential integrity (InnoDB), but there are more. During your database schema design you should for each table select the engine which is appropriate. Jörg -- Joerg Bruehe, MySQL Build Team, joerg.bru...@sun.com Sun Microsystems GmbH, Komturstraße 18a, D-12099 Berlin Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Hi Query Optimization steps
-Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: Wednesday, August 26, 2009 5:08 AM To: mysql@lists.mysql.com Cc: bharani kumar Subject: Re: Hi Query Optimization steps Hi! bharani kumar wrote: Then which DB engine is better. Which fruit is better, an apple or a banana? And if X is better, why do farmers still grow Y, and why do people buy it? [JS] Good answer. I did performance consulting for over 25 years, on *NIX and other operating systems, and there was one response that suited all questions: It depends. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Hi Query Optimization steps
Then which DB engine is better. Thanks On Mon, Aug 24, 2009 at 8:16 PM, mos mo...@fastmail.fm wrote: At 05:01 AM 8/22/2009, you wrote: Hi all Tell Me few Query Optimization Tips For example.. some people saying that , avoid using more of and condition in the query Huh? You need to carefully plan your table structure and use indexes sparingly on the columns you are using in the Where clauses. An EXPLAIN in front of the Select statement will show you which indexes it is using. This sort of very basic things please tell me ... Also tell me , in the optimization view ,, which database engine is best If you need transactions or RI then you have to use InnoDb. Otherwise MyISAM is quite fast. Again it depends on the type of queries you are executing. Thanks Bharanikumar There is no magic wand to getting MySQL to run faster except planning and knowledge. It will take some effort on your part but it will be fun. Take a look at High Performance MySQL 2nd Edition. Some of the first edition is online at http://books.google.com/books?id=sgMvu2uZXlsCprintsec=frontcoverdq=high+performance+mysql#v=onepageq=f=false You can get the second edition at Amazon. Also you may need to read other MySQL books like MySQL Cookbook http://books.google.com/books?id=aC3blgT3D3YCprintsec=frontcoverdq=mysql+cookbook#v=onepageq=f=false The 2nd edition is at Amazon. or MySQL by Paul DuBois is also quite good. These will get you started on the right foot. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=bharanikumariyer...@gmail.com -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/
Re: Hi Query Optimization steps
At 05:01 AM 8/22/2009, you wrote: Hi all Tell Me few Query Optimization Tips For example.. some people saying that , avoid using more of and condition in the query Huh? You need to carefully plan your table structure and use indexes sparingly on the columns you are using in the Where clauses. An EXPLAIN in front of the Select statement will show you which indexes it is using. This sort of very basic things please tell me ... Also tell me , in the optimization view ,, which database engine is best If you need transactions or RI then you have to use InnoDb. Otherwise MyISAM is quite fast. Again it depends on the type of queries you are executing. Thanks Bharanikumar There is no magic wand to getting MySQL to run faster except planning and knowledge. It will take some effort on your part but it will be fun. Take a look at High Performance MySQL 2nd Edition. Some of the first edition is online at http://books.google.com/books?id=sgMvu2uZXlsCprintsec=frontcoverdq=high+performance+mysql#v=onepageq=f=false You can get the second edition at Amazon. Also you may need to read other MySQL books like MySQL Cookbook http://books.google.com/books?id=aC3blgT3D3YCprintsec=frontcoverdq=mysql+cookbook#v=onepageq=f=false The 2nd edition is at Amazon. or MySQL by Paul DuBois is also quite good. These will get you started on the right foot. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Hi,I want to know how big to configurate the max-connections parameter in my.cnf?
On Dec 22, 2007 10:55 AM, Moon's Father [EMAIL PROTECTED] wrote: how big your mysql connections's users. How big users? don't know what you said. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hi, I am not able view all the records in the tabel
Annam Srinivas wrote: Hi, Problem is like this. There is table with 'table_name-1' where, when I am executing the query like ' select * from table_name-1;' it is showing only 432 records but acctually there are 539 records in the table. when I select individual records from the table it is showing (able to view the record data) from 1, . . . 539 record. How do you know there are 539? Did you count them by hand? There could be id's missing in the list, eg: 1 2 3 -- 4 is missing 5 where records have been deleted. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hi how to merge data of various sql files
HI, In this case if you want to import try to use force method. mysqlimport -u root -p *-i* databasename filename.sql _*(-i, --ignoreIf duplicate unique key was found, keep old row)*_ VenuGopal Papasani wrote: hi all, I have got a problem.I have data entered in different machines in a database now i have got all the data in different .sql files.Now i was importing the same files in order to merge them in a same database.Herethere was a problem in merging, There were some tables which does´not change those tables always remains constant such as areacode table.Now if i am trying to merge these tables it was giving an error called error::Duplicate entry 1 . I dont know exactly how many tables does not change.Is there any procedure to import and merge into a single database in these kind of suituations. Thanks and Regards, venu. -- Thanks Regards, Dilipkumar DBA Support ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in
Re: hi how to merge data of various sql files
Hi, In backup directory cat *.sql | mysql -u root -p database * and *Use import which is given below* * Dilipkumar wrote: HI, In this case if you want to import try to use force method. mysqlimport -u root -p *-i* databasename filename.sql _*(-i, --ignoreIf duplicate unique key was found, keep old row)*_ VenuGopal Papasani wrote: hi all, I have got a problem.I have data entered in different machines in a database now i have got all the data in different .sql files.Now i was importing the same files in order to merge them in a same database.Herethere was a problem in merging, There were some tables which does´not change those tables always remains constant such as areacode table.Now if i am trying to merge these tables it was giving an error called error::Duplicate entry 1 . I dont know exactly how many tables does not change.Is there any procedure to import and merge into a single database in these kind of suituations. Thanks and Regards, venu. -- Thanks Regards, Dilipkumar DBA Support ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If this is a forwarded message, the content of this E-MAIL may not have been sent with the authority of the Company. If you are not the intended recipient, an agent of the intended recipient or a person responsible for delivering the information to the named recipient, you are notified that any use, distribution, transmission, printing, copying or dissemination of this information in any way or in any manner is strictly prohibited. If you have received this communication in error, please delete this mail notify us immediately at [EMAIL PROTECTED] Watch India vs. England LIVE, Hot videos and more only on Sify Max! Click Here. www.sifymax.com Get to see what's happening in your favourite City on Bangalore Live! www.bangalorelive.in
Re: Hi, newbie question on a select statement
Perhaps you were using CAST() incorrectly? What was your attempt? my test table: show create table ultimas_repuestas; +---+-+ | Table | Create Table | +---+-+ | ultimas_repuestas | CREATE TABLE `ultimas_repuestas` ( `valorSNMP` varchar(3) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +---+-+ 1 row in set (0.00 sec) then I put some values in it: mysql select * from ultimas_repuestas order by valorSNMP; +---+ | valorSNMP | +---+ | 1 | | 10| | 11| | 12| | 13| | 14| | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | +---+ 14 rows in set (0.02 sec) Then I tried a CAST() statement: mysql select * from ultimas_repuestas order by CAST(valorSNMP as SIGNED INTEGER); +---+ | valorSNMP | +---+ | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | | 10| | 11| | 12| | 13| | 14| +---+ 14 rows in set (0.00 sec) works just fine in MySQL 5.0. not that you gave the version #.although this works fine, too: mysql select * from ultimas_repuestas order by valorSNMP+0; +---+ | valorSNMP | +---+ | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | | 10| | 11| | 12| | 13| | 14| +---+ 14 rows in set (0.00 sec) Hope this helps! Next time, instead of saying this didn't work give the example, and what you got back (what does 'doesn't work' mean? did you get an error? Or it didn't return things in the right order?) -Sheeri On 2/16/06, Ariel Sánchez Mora [EMAIL PROTECTED] wrote: I searched the other lists and couldn't find one that was more appropiate for this question; if there is, please tell me so :) I am monitoring networking equipment and so far I'm saving all my data in a MySQL database (hence an email to this list). I'm using only VARCHARs because the SNMP agent returns only strings and I didn't find enough a reason for converting the different types of answers, since most string comparations are donde correctly; I received both text and numbers from the monitoring tasks and wanted to keep it simple. However when I execute this select statement I am getting this problem: select info_oficina,valorSNMP from ultimas_respuestas_snmp where columna_donde_guardar='USO_CPU_1min' order by valorSNMP desc limit 10; info_oficina valorSNMP CSF Desamparados error Periferica Palmares 4 CSF San Pedro4 Sucursal Guapiles4 Periferica Pentagono San Pablo 30 Periferica Tibas 3 Periferica Buenos Aires 3 Sucursal Turrialba 3 Ventanilla Florencia 3 CSF del Sur (Ciudad Neilly) 3 Where info_oficina, valorSNMP are columns, ultimas_respuestas_snmp is my table, etc. The summary question is: given a column with the numbers 0 to 99 of type varchar, how can i tell MySQL to order it as if they were integer values, so that instead of 99,98,97,96,95,94,93,92,91,90,9,89 I'd have 99,98,97,96,95,94,93,92,91,90,89,88 Apparently, CAST() does not have an effect (but feel free to prove me wrong) Thanks! Ariel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Hi, newbie question on a select statement
Hi Ariel, It works fine for me localhost.testshow create table mytest\G *** 1. row *** Table: mytest Create Table: CREATE TABLE `mytest` ( `id` int(11) NOT NULL auto_increment, `test_col` varchar(10) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 1 row in set (0.00 sec) 5.0.18-max on port mysql.sock as [EMAIL PROTECTED] localhost.test 5.0.18-max on port mysql.sock as [EMAIL PROTECTED] localhost.testselect * from mytest order by test_col; ++--+ | id | test_col | ++--+ | 1 | 1| | 10 | 10 | | 12 | 11 | | 2 | 2| | 11 | 20 | | 3 | 3| | 4 | 4| | 5 | 5| | 6 | 6| | 7 | 7| | 8 | 8| | 9 | 9| ++--+ 12 rows in set (0.01 sec) 5.0.18-max on port mysql.sock as [EMAIL PROTECTED] localhost.testselect * from mytest order by CAST(test_col as unsigned); ++--+ | id | test_col | ++--+ | 1 | 1| | 2 | 2| | 3 | 3| | 4 | 4| | 5 | 5| | 6 | 6| | 7 | 7| | 8 | 8| | 9 | 9| | 10 | 10 | | 12 | 11 | | 11 | 20 | ++--+ 12 rows in set (0.00 sec) Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Ariel Sánchez Mora [mailto:[EMAIL PROTECTED] Sent: Friday, 17 February 2006 11:29 AM To: mysql@lists.mysql.com Subject: Hi, newbie question on a select statement I searched the other lists and couldn't find one that was more appropiate for this question; if there is, please tell me so :) I am monitoring networking equipment and so far I'm saving all my data in a MySQL database (hence an email to this list). I'm using only VARCHARs because the SNMP agent returns only strings and I didn't find enough a reason for converting the different types of answers, since most string comparations are donde correctly; I received both text and numbers from the monitoring tasks and wanted to keep it simple. However when I execute this select statement I am getting this problem: select info_oficina,valorSNMP from ultimas_respuestas_snmp where columna_donde_guardar='USO_CPU_1min' order by valorSNMP desc limit 10; info_oficina valorSNMP CSF Desamparados error Periferica Palmares 4 CSF San Pedro4 Sucursal Guapiles4 Periferica Pentagono San Pablo 30 Periferica Tibas 3 Periferica Buenos Aires 3 Sucursal Turrialba 3 Ventanilla Florencia 3 CSF del Sur (Ciudad Neilly) 3 Where info_oficina, valorSNMP are columns, ultimas_respuestas_snmp is my table, etc. The summary question is: given a column with the numbers 0 to 99 of type varchar, how can i tell MySQL to order it as if they were integer values, so that instead of 99,98,97,96,95,94,93,92,91,90,9,89 I'd have 99,98,97,96,95,94,93,92,91,90,89,88 Apparently, CAST() does not have an effect (but feel free to prove me wrong) Thanks! Ariel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi all
On Sun, 2005-10-30 at 00:14 -0300, Fabricio Mota wrote: Anybody has worked as a developer to MySQL Database Server features? If you mean people who work for MySQL hacking on Cluster, then yes, we exist. -- Stewart Smith, Software Engineer MySQL AB, www.mysql.com Office: +14082136540 Ext: 6616 VoIP: [EMAIL PROTECTED] Mobile: +61 4 3 8844 332 Jumpstart your cluster: http://www.mysql.com/consulting/packaged/cluster.html signature.asc Description: This is a digitally signed message part
Re: Hi, a problem about selecting...
Have a look at fulltext searches. This is described in the MySQL manual at http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html. If you put all of your columns in the column list following the FULLTEXT keyword, you will be able to use MATCH AGAINST expressions to find what you want. I'm assuming that all of the columns you are searching are character columns; I don't think you can put numeric or date/time columns in the FULLTEXT column list, although I have never tried it so I may be wrong. Rhino - Original Message - From: Gokce Hazaroglu To: [EMAIL PROTECTED] Sent: Thursday, October 14, 2004 12:42 PM Subject: Hi, a problem about selecting... I've a table and many fields. I want to search something in all fields. - select * from table where table.* like '%something%' did not work.. Is there a way to do this? Gokce AKKAYA HAZAROGLU OptikNet Bilgisayar [EMAIL PROTECTED] http://www.optiknet.com.tr
RE: Hi all.
-Message d'origine- De : Andy Fletcher [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, January 27, 2004 4:42 AM À : [EMAIL PROTECTED] Objet : Hi all. I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing. The database I have created needs to store Documents and I have used Blob type columns for this. If I want to: Select USERID,NAME,LNAME Where DOC contains what ever words or phrases ; How would I do this ? First, try to use a significant subjet to your messages. It helps when searching the archive. Then, I don't think your needs can be fullfilled, since I don't think mysql can tell what is in a Blob, except that it is a series of 1 and 0. hth Many thanks for information on this. Here from you soon I hope, Best regards Andy Fletcher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi all.
MySQL can help you out here, but there are many questions you need to answer first. 1. What exactly is in the DOC column? Binary data of some disgusting, inferior proprietary word processor document format, plain text, XML, LaTeX files? 2. If you answered But I like Clippy! to the above, go to jail! Go directly to jail! Do not pass go, do not collect any cash! This goes for Word, WordPerfect, OpenOffice/StarOffice's default saves (please read on before flaming me!) etc. To continue, be a true geek and switch to something that claims to emphasise substance over structure, like LaTeX or DocBook XML. 3. If you've gotten to here, it's just a matter of conjugating your query: SELECT userid, name, lname FROM funky_table WHERE doc LIKE '%search_string%'; SQL uses the percentage character (%) as a wildcard to match 0 or more of any character. Use it to fill in the space in and around your search string. The LIKE predicate above tells MySQL to ignore case when doing comparisons. If you want to use a word processor document format, look at decompressing OpenOffice files before inserting them, and you get XML to play with. Additional things that may be of use to you: 1. TEXT fields and BLOB fields are basically identical, except that comparisons done with regard to TEXT fields are case-insensitive. The manual calls them case-insensitive BLOBs. 2. The above works on all MySQL table types but can be slow as all buggery. Populate that WHERE clause with everything you can to reduce the rows examined. Also, avoid strings that are less than 3 characters long, otherwise MySQL 4.0.x and above won't use one of the faster search techniques that the optimiser has at it's disposal. 3. If you can work without transactions (many applications can) or you are happy to have at least the document field in a MyISAM table, look into FULLTEXT searches. Of course, this only really works nicely for plain text, and has a new set of caveats to deal with. MySQL 4.1.x brings rather nice enhancements to this part of MySQL, but don't bug poor Heikki about adding FULLTEXT to InnoDB as some of us are of the opinion that no one at Innobase Oy ever sleeps or goes home (or MySQL AB for that matter). Regards, Chris Ugo Bellavance wrote: -Message d'origine- De : Andy Fletcher [mailto:[EMAIL PROTECTED] Envoyé : Tuesday, January 27, 2004 4:42 AM À : [EMAIL PROTECTED] Objet : Hi all. I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing. The database I have created needs to store Documents and I have used Blob type columns for this. If I want to: Select USERID,NAME,LNAME Where DOC contains what ever words or phrases ; How would I do this ? First, try to use a significant subjet to your messages. It helps when searching the archive. Then, I don't think your needs can be fullfilled, since I don't think mysql can tell what is in a Blob, except that it is a series of 1 and 0. hth Many thanks for information on this. Here from you soon I hope, Best regards Andy Fletcher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi all.
At 03:41 AM 1/27/2004, you wrote: I am just starting to work with SQL and Mysql server language and am embedding some queries into another program I am developing. The database I have created needs to store Documents and I have used Blob type columns for this. If I want to: Select USERID,NAME,LNAME Where DOC contains what ever words or phrases ; How would I do this ? Many thanks for information on this. Here from you soon I hope, Best regards Andy Fletcher Andy, You probably want to use FullText searching on text fields which is much faster than using wild card searches using LIKE '%something%'. Please see the manual http://www.mysql.com/doc/en/Fulltext_Search.html. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi CPU on FreeBSD
We had the same problem. Upgrading Freebsd to 4.8 and recompiling MySQL to work with Linux style threads seemed to work. The MySQLd process no longer pops up to ~90% on each request. However, with the application we're running that queries the database (Request Tracker 3), we still get process bloat with certain queries (searches mostly). But, this problem doesn't come up with any other application, or with manual querys of the database, so we think it's a bug in the app. Lalo Gunnar Helliesen wrote: On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote: On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote: We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. There have been a few threads regarding high CPU utilization on FreeBSD systems. Yeah, I mostly ingored them because I thought it was a fluke. But it happens much more than I had thought. It's still happening on the site I first reported it on. We're currently running max-4.0.11-gamma, but the problem has been present since 3.x. FreeBSD 4.4 and 4.5. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi CPU on FreeBSD
On Mon, Jun 09, 2003 at 11:26:36AM -0700, Lalo Castro wrote: We had the same problem. Upgrading Freebsd to 4.8 and recompiling MySQL to work with Linux style threads seemed to work. Great. The MySQLd process no longer pops up to ~90% on each request. However, with the application we're running that queries the database (Request Tracker 3), we still get process bloat with certain queries (searches mostly). But, this problem doesn't come up with any other application, or with manual querys of the database, so we think it's a bug in the app. Is this process bloat on the MySQL site or on the RT/Perl side? If it's on the MySQL side, can you describe it a bit and perhaps post your my.cnf file along with a sample query and table structure that tends to trigger the bloat? I suspect that if it's a design deficiency in RT, Jesse and the folks at Best Practical would like to fix it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 195,846,290 queries (348/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi CPU on FreeBSD
the load average in my freebsd 5.0 (latest releng) compiled statically with linuxthreads decreased 80% after I tunned these variables: set-variable = key_buffer_size=100MB set-variable = read_buffer_size=5M set-variable = table_cache=500 set-variable = max_delayed_threads=0 set-variable = max_user_connections=25 set-variable = query_cache_size=50M set-variable = thread_cache_size=100 The only problem I couldn't solve is that some connections will never die... since most of this connections come from tomcat, I'm restarting it more often. Using query cache and thread cache will definetely give you a boost of performance This machine has lots of memory, so you have to be careful with variables like key_buffer_size, table_cache and query_cache_size... you need memory for that, don't let it swap. Lalo Castro wrote: We had the same problem. Upgrading Freebsd to 4.8 and recompiling MySQL to work with Linux style threads seemed to work. The MySQLd process no longer pops up to ~90% on each request. However, with the application we're running that queries the database (Request Tracker 3), we still get process bloat with certain queries (searches mostly). But, this problem doesn't come up with any other application, or with manual querys of the database, so we think it's a bug in the app. Lalo Gunnar Helliesen wrote: On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote: On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote: We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. There have been a few threads regarding high CPU utilization on FreeBSD systems. Yeah, I mostly ingored them because I thought it was a fluke. But it happens much more than I had thought. It's still happening on the site I first reported it on. We're currently running max-4.0.11-gamma, but the problem has been present since 3.x. FreeBSD 4.4 and 4.5. -- -- Gustavo Baratto - Programming and Technical Support [EMAIL PROTECTED] * (604) 638-2525 ext. 408 Technical support web-site: http://support.superb.net Superb Internet Corp. Ahead of the Rest - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi CPU on FreeBSD
On Mon, Jun 09, 2003 at 01:41:00PM +, Gustavo A. Baratto wrote: the load average in my freebsd 5.0 (latest releng) compiled statically with linuxthreads decreased 80% after I tunned these variables: What about actual CPU usage? Did is increase similarly? The load average isn't necessarily a good measure of performance. It's often a good measure of bottlenecks beyond the scheduler's control--suck as poor I/O. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 6 days, processed 198,532,567 queries (349/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi CPU on FreeBSD
CPU usage improved a lot as well... It's always above 90% free and before it was 70-75% idle... here is a snapshot: last pid: 58730; load averages: 0.09, 0.11, 0.08 up 9+20:59:57 17:11:24 216 processes: 1 running, 215 sleeping CPU states: 0.0% user, 1.8% nice, 1.2% system, 0.2% interrupt, 96.9% idle Jeremy Zawodny wrote: On Mon, Jun 09, 2003 at 01:41:00PM +, Gustavo A. Baratto wrote: the load average in my freebsd 5.0 (latest releng) compiled statically with linuxthreads decreased 80% after I tunned these variables: What about actual CPU usage? Did is increase similarly? The load average isn't necessarily a good measure of performance. It's often a good measure of bottlenecks beyond the scheduler's control--suck as poor I/O. Jeremy -- -- Gustavo Baratto - Programming and Technical Support [EMAIL PROTECTED] * (604) 638-2525 ext. 408 Technical support web-site: http://support.superb.net Superb Internet Corp. Ahead of the Rest - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi CPU on FreeBSD
On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote: On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote: We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. There have been a few threads regarding high CPU utilization on FreeBSD systems. Yeah, I mostly ingored them because I thought it was a fluke. But it happens much more than I had thought. It's still happening on the site I first reported it on. We're currently running max-4.0.11-gamma, but the problem has been present since 3.x. FreeBSD 4.4 and 4.5. The 2nd processor may be causing the problem. We can reproduce it on a single CPU box too. The number of CPUs isn't the issue. Same here. One or more CPUs makes _no_ difference. Load seems to factor in, though. Since I made my original post http://lists.mysql.com/list.php?list=mysqlpost=107745, I've moved the load (web site access tracking ++) from the single-CPU machine to the SMP machine. The problem moved right along with the load. You may want to contact the original authors to see if they've come up with a solution. I likely will. Thanks. Jeremy Any news? Gunnar -- Gunnar Helliesen | Bergen IT Consult | Open Source activist Systems Consultant | Bergen, Norway| Jaguar enthusiast [EMAIL PROTECTED] | www.bitcon.no/~gunnar | Märklin collector -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi CPU on FreeBSD
On Sun, Jun 08, 2003 at 03:37:17PM +0200, Gunnar Helliesen wrote: On Sat, 22 Jun 2002 17:43:12 -0700 Jeremy Zawodny wrote: On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote: We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. There have been a few threads regarding high CPU utilization on FreeBSD systems. Yeah, I mostly ingored them because I thought it was a fluke. But it happens much more than I had thought. [snip] Any news? Wow, you fond 1-year old thread on this. Impressive. :-) Yes, there's good news: http://jeremy.zawodny.com/blog/archives/000697.html Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 5 days, processed 170,695,248 queries (358/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Hi,All ,About mysqldump and mysqlimport
Edit the script created by mysqldump. Add create database if not exists databaseName; to the beginning of the script. Or what I usually do is create the database first then use: mysql -A databaseName test.sql to load it. =C= * Cal Evans * http://www.christianperformer.com * Stay plugged into your audience -Original Message- From: Li Yang [mailto:[EMAIL PROTECTED] Sent: Sunday, March 30, 2003 8:10 PM To: mysql Subject: Hi,All ,About mysqldump and mysqlimport Hi, I'm a newbie to MySQL I have use mysqldump to backup a database to an file named test.sql ,but how I can load the test.sql to create the same database to another server?? Thanks! Best Regards Li Yang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: hi
On Thursday 27 March 2003 06:18, Hridyesh Pant wrote: i am just new for MySql,can any body tell be from where i have to start learn MySql for Unix or Linux. Take this brand new Paul's book: http://www.mysql.com/portal/books/item-75.html It's really excellent. That will help. Thanks. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hi
The first step is to get a working example- WARNING: you may have to compile the library to get it working on your platform.. Good Luck, Martin - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:08 AM Subject: re: hi On Thursday 27 March 2003 06:18, Hridyesh Pant wrote: i am just new for MySql,can any body tell be from where i have to start learn MySql for Unix or Linux. Take this brand new Paul's book: http://www.mysql.com/portal/books/item-75.html It's really excellent. That will help. Thanks. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: hi
See www.mysql.org. There you can find a complete documentation for mysql. You have a good decision to use mysql on linux. I don't believe mysql on MS. MySQL on MS is not optimal in my opinion. Sorry if I am wrong. --- Hridyesh Pant [EMAIL PROTECTED] wrote: Hi all, i am just new for MySql,can any body tell be from where i have to start learn MySql for Unix or Linux. Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Hi and why
At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote: Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird developer and have to acomplish some tasks using a mysql based database. So i'm looking about how things work in mysql. My question... i created a table TEST, with two columns, ID_TEST int(11) and NAME varchar(50).. and added three records. This way: 1, ppl1 2, ppl2 3, null ok.. why when i execute this sql, mysql return the two first rows, instead of raising an error? select * from TEST where NAME = 2?? I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? TIA. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi and why
I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? I didn't end my query with the two question marks. :) And if i put 0 instead of (2 or any different of zero) after the equal sign the sql return nothing. (better than returning garbage) I was expecting something like 'Column NAME isn't of type integer'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi and why
Sorry, correcting my last email, the sql result the two rows when i use 'NAME = 0'. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Valdir Stiebe Junior [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 4:33 PM Subject: Re: Hi and why At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote: Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird developer and have to acomplish some tasks using a mysql based database. So i'm looking about how things work in mysql. My question... i created a table TEST, with two columns, ID_TEST int(11) and NAME varchar(50).. and added three records. This way: 1, ppl1 2, ppl2 3, null ok.. why when i execute this sql, mysql return the two first rows, instead of raising an error? select * from TEST where NAME = 2?? I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? TIA. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi and why
At 16:47 -0200 1/21/03, Valdir Stiebe Junior wrote: I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? I didn't end my query with the two question marks. :) And if i put 0 instead of (2 or any different of zero) after the equal sign the sql return nothing. (better than returning garbage) I was expecting something like 'Column NAME isn't of type integer'. That won't happen. MySQL performs extensive type conversion of values, attempting to execute the query in the most sensible way given what you provide. I'm stlll surprised that NAME = 2 returns anything. When I tried your example, it returned no rows. I get two rows with NAME = 0, nothing with NAME = 2. Are you sure you're not mixing up your test results? NAME = 0 is a string-to-number conversion. MySQL converts the string to a number and performs a numeric comparison. Of your three values, 'ppl1' and 'ppl2' will be converted to 0 (which compares the same as 0), but NULL is still NULL (which does not compare the same as 0). If you're getting two rows with NAME = 2 and nothing with NAME = 0, I'm at a loss to explain it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hi and why
I'm stlll surprised that NAME = 2 returns anything. When I tried your example, it returned no rows. I get two rows with NAME = 0, nothing with NAME = 2. Are you sure you're not mixing up your test results? Sorry, my mistake. NAME = 0 is a string-to-number conversion. MySQL converts the string to a number and performs a numeric comparison. Of your three values, 'ppl1' and 'ppl2' will be converted to 0 (which compares the same as 0), but NULL is still NULL (which does not compare the same as 0). Ok, i understand now. This is useful when you have things like '10' or '342'. But when you have 'ppl1' isn't deterministic wich number it represent. But thanks. I'm studying to understand how MySql works. I have another question, will open another thread to it. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hi and why
At 18:11 -0200 1/21/03, Valdir Stiebe Junior wrote: I'm stlll surprised that NAME = 2 returns anything. When I tried your example, it returned no rows. I get two rows with NAME = 0, nothing with NAME = 2. Are you sure you're not mixing up your test results? Sorry, my mistake. NAME = 0 is a string-to-number conversion. MySQL converts the string to a number and performs a numeric comparison. Of your three values, 'ppl1' and 'ppl2' will be converted to 0 (which compares the same as 0), but NULL is still NULL (which does not compare the same as 0). Ok, i understand now. This is useful when you have things like '10' or '342'. But when you have 'ppl1' isn't deterministic wich number it represent. Yes, it is. 'ppl1' doesn't begin with digits, so it converts to zero in numeric context. But thanks. I'm studying to understand how MySql works. I have another question, will open another thread to it. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Hi and why
I just tried it myself and I get an empty set as expected. What do you get when you do a 'select * from test'? -Original Message- From: Valdir Stiebe Junior [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 22 January 2003 5:48 am To: [EMAIL PROTECTED] Subject: Re: Hi and why I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? I didn't end my query with the two question marks. :) And if i put 0 instead of (2 or any different of zero) after the equal sign the sql return nothing. (better than returning garbage) I was expecting something like 'Column NAME isn't of type integer'. - Before posting, please check: http://www.mysql.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
Re: Hi and why
ppl1 converted to numeric is 0. You are compareing to a number. Valdir Stiebe Junior wrote: Sorry, correcting my last email, the sql result the two rows when i use 'NAME = 0'. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Valdir Stiebe Junior [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 4:33 PM Subject: Re: Hi and why At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote: Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird developer and have to acomplish some tasks using a mysql based database. So i'm looking about how things work in mysql. My question... i created a table TEST, with two columns, ID_TEST int(11) and NAME varchar(50).. and added three records. This way: 1, ppl1 2, ppl2 3, null ok.. why when i execute this sql, mysql return the two first rows, instead of raising an error? select * from TEST where NAME = 2?? I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? TIA. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi and why
Hi, Indeed...this happend in both main version of MySQL (ver. 3.x and 4.0.x) However ,if you use : select * from test_table where NAME='2'; you will have the correct result. Regards, Gelu ___ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Valdir Stiebe Junior [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 8:47 PM Subject: Re: Hi and why I don't know why it returns the first two rows, but (assuming you didn't really end your query with two question marks) what error are you expecting to occur? I didn't end my query with the two question marks. :) And if i put 0 instead of (2 or any different of zero) after the equal sign the sql return nothing. (better than returning garbage) I was expecting something like 'Column NAME isn't of type integer'. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi, I have question about the User Privileges system
At 21:39 -0500 8/12/02, Jason wrote: I have been searching for a way to restrict access to a database. So far all I see that is possible is to grant access to databases. What if I want a user account to be able to access every database except for the mysql database? There is no way to do this without running grant statements for every database I add. I just want a place where I can restrict access. This would make things so much easier! As far as I can tell this is not possible. If it is, please let me know. It's not. Thanks, -- Jason Clawson [EMAIL PROTECTED] I will meet your needs and exceed your expectations - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi CPU on FreeBSD
On Sat, Jun 22, 2002 at 07:26:36PM -0500, mos wrote: We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. There have been a few threads regarding high CPU utilization on FreeBSD systems. Yeah, I mostly ingored them because I thought it was a fluke. But it happens much more than I had thought. The 2nd processor may be causing the problem. We can reproduce it on a single CPU box too. The number of CPUs isn't the issue. You may want to contact the original authors to see if they've come up with a solution. I likely will. Thanks. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 24 days, processed 517,620,372 queries (249/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: Hi CPU on FreeBSD
On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote: Re Gunnar Helliesen e-mail I have FreeBSD4.2 and MySQL 3.23.49. I two have hi cpu (99%) on a twin cpu system. (Compaq DL380) After making the suggested changes to my.cnf we rebooted the system. For 3 days all ran fine (low cpu) then at 2am cpu went back up to 99%. Has any body know why FreeBSD with MySQL had this problem? Simon PS apart from that it kicks ass.as MySQL should... We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.51: up 23 days, processed 517,327,740 queries (249/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: Hi CPU on FreeBSD
At 06:59 PM 6/22/2002, you wrote: On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote: Re Gunnar Helliesen e-mail I have FreeBSD4.2 and MySQL 3.23.49. I two have hi cpu (99%) on a twin cpu system. (Compaq DL380) After making the suggested changes to my.cnf we rebooted the system. For 3 days all ran fine (low cpu) then at 2am cpu went back up to 99%. Has any body know why FreeBSD with MySQL had this problem? Simon PS apart from that it kicks ass.as MySQL should... We've managed to reproduce this pretty reliably at Yahoo and are working to track and fix the bug. If we find a resolution, I'll post a note here. There have been a few threads regarding high CPU utilization on FreeBSD systems. The 2nd processor may be causing the problem. You may want to contact the original authors to see if they've come up with a solution. Mike Here are 3 threads: Thread #1: X-Sieve: CMU Sieve 2.1 Received: from www.fastmail.fm ([unix socket]) by www.fastmail.fm (Cyrus v2.1.3) with LMTP; Tue, 11 Jun 2002 04:13:55 -0500 Received: from www.fastmail.fm (localhost [127.0.0.1]) by localhost.localdomain (Postfix) with ESMTP id 398FF6D9FB for [EMAIL PROTECTED]; Tue, 11 Jun 2002 04:13:55 -0500 (CDT) X-Mail-from: [EMAIL PROTECTED] X-Delivered-to: [EMAIL PROTECTED] Received: from web.mysql.com (web.mysql.com [192.58.197.162]) by www.fastmail.fm (Postfix) with SMTP id 43FE26D9E5 for [EMAIL PROTECTED]; Tue, 11 Jun 2002 04:13:54 -0500 (CDT) Received: (qmail 1417 invoked by uid 7797); 11 Jun 2002 09:04:38 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Post: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 1341 invoked from network); 11 Jun 2002 09:04:17 - Content-Type: text/plain; charset=iso-8859-1 From: Leo De Geer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Organization: Kristianstad Teknikverkstad To: Simon Green [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd Date: Tue, 11 Jun 2002 11:12:46 +0200 X-Mailer: KMail [version 1.4] References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 Message-Id: [EMAIL PROTECTED] On Tuesday 11 June 2002 10.48, Simon Green wrote: We are ruing a box with freeBSD and MySQL with twin processors It looked like it was using only on processor but we decided that it was the way FreeBSD's threads work? There seems to be two problems with ruing MySQL on FreeBSD. One: Seems not to use both processors (on twin system) Two: All ways a load on 1 even when the system in not at hi load (seem to go down when it is!) What is up with freeBSD or MySQL. Simon -Original Message- From: Leo De Geer [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:35 To: Alexander V Zubchenko Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: but in my case its not good to have it that way im having one dedikated dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. In such case provide, please additional info. AFAIU, You want to use both cpu for sql, in other words, optimal use of Your server. Than, do You recompile (or compile) kernel with SMP support (afaik, this is only arch for multicpu systems, supported by fbsd)? You can b sure, that if mysql will run separate process for each request, it will slowdown perfomance, but never increase it. In fact, balancing load on many cpus is OS task. And multithreaded processes _must_ b processed similarly to multiprocess environment (but i don't know, how exactly fbsd smp-support built). Check Your kernel config /usr/src/sys/i386/conf/name. You may find also this name interesting: LINT - list [almost?] all options recognized in config-file. With respect, Alexander V Zubchenko, E-Mail: [EMAIL PROTECTED] System Administrator, WWW: http://www.hermes-comp.zp.ua/ Hermes-comp, Ukraine, Zaporizhzhya, Geroev Stalingrada 50 phone/fax: +380 612 64-19-72 the kernel is runing both cpu. and the balancing is working good on everything but the sql! i have on my linux sql server aproximatly 100 simultanius conections that du you think that the standard memory size of 128 do you think i nead to put it up to 256 meg in the kernel the problen nr 2 i dont have but the server we have dont handle the load on one cpu. at the moment we are runing the sql on a linux
RE: Hi I'm a Newbie
sql,query I also looking for a good ASP 3.0 mailing list Peter Sampson http://www.cfcnet.co.uk The information contained in this email is intended only for the person or organization to which it is addressed. If you have received it by mistake, please disregard and notify the sender immediately. Unauthorized disclosure or use of such information may be a breach of legislation or confidentiality and may be legally privileged. Emails sent from and received by Members and employees of Norfolk County Council may be monitored. Unless this email relates to Norfolk County Council business it will be regarded by the Council as personal and will not be authorized by or sent on behalf of the Council. The sender will have sole responsibility for any legal actions or disputes that may arise. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: hi
--- [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards? http://movies.yahoo.com/ __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.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: Hi
- Original Message - From: cherian [EMAIL PROTECTED] To: MySql [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 1:12 PM Subject: Hi Hi, I have an application that has got Oracle as the central databse, if all the client machines are online then it will update the central oracle databse otherwise in the offline mode the client machine will update the local MS Access databse, and later on when ever the network comes back the central databse is updated with the changes. I want now to change the MS Access with MySql in the client machine, is it possible to do so ? Of course it's possible but you don't give many clues about what info you're after? What are your timescales, what's the budget, what are the clients written in, what is the central db update process written in, any ODBC... and a hundred other questions. Just what are you asking here? Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi
Hi , I am using Mysql in Linux OS. I created a table in Mysql. The table has 3 fields and one is Primary key among them. I have populated 40K entries in the table. While populating the entries in the table, For each 500 entries that i populated in the table, i have searched for a single entry in the table using primary key and measured the time taken to complete the search.As the Number of entries grows in the table, the time taken to search for a entry are increasing linearly. Why is the time increases linearly? Is this the Mysql behavior? I read in Myself manual that, by default Mysql creates index file(.MYI) on Primary Key using B-Tree algorithm. My Question is , When Mysql using B-Tree for searching, Why the time taken to search for entries increases linearly as the entries in the table grows? According to B-Tree algorithm, the time has to be O(log n) , which is not linear as n increases. Even though if we assume disk overhead as some constant (typically O(log m), where m is the order ), it is not linear. Why is this happening ? Can any one help me out? Thank You, Battini Chandra Sekhar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi
Hi , I am using Mysql in Linux OS. I created a table in Mysql. The table has 3 fields and one is Primary key among them. I have populated 40K entries in the table. While populating the entries in the table, For each 500 entries that i populated in the table, i have searched for a single entry in the table using primary key and measured the time taken to complete the search.As the Number of entries grows in the table, the time taken to search for a entry are increasing linearly.Why is the time increasing linearly ? can any one help me ? Thank You, Battini Chandra Sekhar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi
Are you adding the data in order ? If Btree is not balanced then it matters. It search them all. But I don't believe it is not balanced. Makis -Original Message- From: Battini, Chandrashekar [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 4:38 PM To: '[EMAIL PROTECTED]' Subject: Hi Hi , I am using Mysql in Linux OS. I created a table in Mysql. The table has 3 fields and one is Primary key among them. I have populated 40K entries in the table. While populating the entries in the table, For each 500 entries that i populated in the table, i have searched for a single entry in the table using primary key and measured the time taken to complete the search. As the Number of entries grows in the table, the time taken to search for a entry are increasing linearly. Why is the time increases linearly? Is this the Mysql behavior? I read in Myself manual that, by default Mysql creates index file(.MYI) on Primary Key using B-Tree algorithm. My Question is , When Mysql using B-Tree for searching, Why the time taken to search for entries increases linearly as the entries in the table grows? According to B-Tree algorithm, the time has to be O(log n) , which is not linear as n increases. Even though if we assume disk overhead as some constant (typically O(log m), where m is the order ), it is not linear. Why is this happening ? Can any one help me out? Thank You, Battini Chandra Sekhar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi, Help!
On Mon, Feb 04, 2002 at 04:37:33PM -0600, Erin Lilly wrote: Hi, this is Erin Lilly, I've used support before with you all for bodyconsultant.com and you were extremely helpful. I'm installing mysql on erinlilly.net and have run into that common /tmp/mysql.sock (111) error Hi, you just mailed your root password to an open mailing list. Take care. You might want to change your password now. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hi Folks!
Sebastian Grewe wrote: I have a problem with my Website. I want to list only 25 results of a db query. When the user klicks on Second Page he should see the next 25 results and so on. How can I do that? Thx for replies. Sebastian - Sebastian: The MySQL end of it is the LIMIT clause. But, you'll need to do some math manipulation within your web application for creating forward and backward links, etc. for navigating through the result set. This is more a php3/cgi question than MySQL. Regards, Van -- = Linux rocks!!! http://www.dedserius.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: Hi. Here is the An-san City of the South Korea.
Just a thought. It is a well known fact that MySQL is being used as the backend software for Yahoo Finance. However, the response as mentioned in this mail is also typical from a customer looking at commercial application development. How can the larger business community perception be changed with regards to products like MySQL which are better than or atleast comparable to any other commercial products like say Oracle? Lets face it, in these times of recession, it is important for the businesses to reduce costs of automation theough application development. Using a free software would certainly reduce the costs involved in software. But is it worth it? What would be the typical percentage of software costs in any custom application development in relation to the total costs of Hardware, Software and Development costs? Anybody care to share their thoughts? Rgds, Durga Prasad Placed At : À̼º°è [EMAIL PROTECTED] on 12/29/2001 12:48:50 PM Please respond to À̼º°è [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Durga Prasad/Satyam) Subject: Hi. Here is the An-san City of the South Korea. Hi. Here is the An-san City of the South Korea. We are the company which is developing the programs #8211; ERP(ENTERPRISE RESOURCE PLANNING) and has been concerned with MY_SQL DATABASE. Recently, we suggested to the client of Korea that we want to develop the programs(ERP, MIS, MRP) with adapting your MY_SQL DB, but we are rejected by the client. We took the response to the client ,after we discussed the problem with the client, that if we offer to the client an efficiency test table of MY_SQL and the rest of data, the client will examine this data. Thus, we would like to take the data with the following questions from yours. - Brief yours and what is your adapted businesses? - If the ERP is developed with MY-SQL, is it possible for the ERP to adapt with MY_SQL ? - What is the representative company which is adapted? - User number of MY_SQL, speed, efficiency and stability (in the Window 2000 Server and Linux) - The price list for the user number (in the case of Window 2000 and Linux) - If the client agrees to our company ?s using your DB, can you recognize us to the main agency of Korea? So far, thank you for reading our letter. We wanna receive your response as soon as possible. 2001. 12.28 Arcline. Cor. A principal administrative officer Mun-choel Shin === ¿ì¸® ÀÎÅͳÝ, Daum http://www.daum.net - 2002 ´ëÀÔ 1:1»ó´ã,¿ø¼Á¢¼ö,ÇÕ°ÝÀÚ¹ßÇ¥ ¢Ñ http://hmm.daum.net/daeip_0112 - ÀÎÅͳݿ¡¼ 'ÅäÁ¤ºñ°á' º¸¼¼¿ä~ ¢Ñ http://hmm.daum.net/fortune_0112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi all,
At 3:07 PM -0500 9/26/01, Dan Liu wrote: Hi all, I am running a query on mysql.The query is simple.It retrieves 2800 rows and 250 columns data.I created index for the query.But it still takes over a minute. Could somebody tell me what should I do?And why it is so slow? Thanks! Dan You may get a better answer if you post your query. -- Paul DuBois, [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: hi.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 25 Sep 2001, kurelli rajashaker wrote: Hello everyone, We have been using the mysql database for our placement division of our company. I have been facing with the problem of slowness of retrieving the results from the database. Right now there are only 1000 records and it is taking quiet an amount of time to retrieve the results. What will happen in future when the records are going to increase.? I have tried using INDEX to improve the performance. But did not find any change/improvement. If anyone of u can suggest me some other means of improving the query time/ retrieving the results from the database. i shall be very thankful. waiting to hear about this. warm regards, Raj I think unless you provide the table definition and the query which is so slow, little help could come from the list. - -- Marco Bizzarri - Responsabile Tecnico - Icube S.r.l. Sede: Via Ridolfi 15 - 56124 Pisa (PI), Italia E-mail: [EMAIL PROTECTED] WWW: www.icube.it Tel:(+39) 050 97 02 07 Fax: (+39) 050 31 36 588 -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE7sKQ4XhfyAQQVoaIRApIUAKCoEekNICS63WNSdV4d3qJUh8SPBwCeKyjq EsJ9/pe7LrBa8PUpbR5y5DE= =D0is -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: hi new to mysql
helo anybody there to help me for my project my project is on PERL and Mysql in Linux please say me the procedure to study those stuffs. thanx in advance Buy the book MySQL written by Paul DuBois. Take a look at www.devshed.com and on webmonkey. Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi,sir.I have a question!
At 16:11 06/07/2001 +0800, rqhuang wrote: Hi, I would like to ask you a favour for to make a test when you not are able to stop the slave. There is a tool called NETWATCH.EXE from Microsoft to be used on Win9x machines, this tools it isn't installed by the default and you can find instructions how to install it at: http://msdn.microsoft.com/library/en-us/dnwinpro99/html/netwatch.asp Please see if the tool identifies the thread from the slave and try to remove the thread. Send for us the results of this test. Regards, Miguel Hi,Sir I encounter a problem while using mysql. My Mysql version is Mysql 3.23.38! I'm in WindowsMe system. I encouter a problem in Replication. I set master/slave replication according to the manual in your website(chapter 11).It works, but I have trouble to stop the slave thread. I set the server not to start the slave on the startup.At a certain time, I use slave start to start the slave. I can properly start and load updates from the master. but if I use slave stop command in mysql, it takes quite a long time to stop the slave thread.It takes more than 20 minutes, some times it even not any response. I'm in a lan, I wander why it takes so many time to stop the slave thread I check the processlist, the state is always waiting for slave to stop. I wonder how to accelerate the speed of stopping master/slave replication. thx ¨¨¡î¨¨¡î¨¨ ËÍÐÇÐÇǧ°Ù¿Å... rqhuang ¨¡î¡î¡î¡î¡î¡î¨ ¨¨¡î¡î¡î¡î¨¨ ÉúÃü»îµÃ¾«²Ê²ÓÀÃ... [EMAIL PROTECTED] ¨¨¨¡î¡î¨¨¨ ¨¨¨¨¨¨¨¨ Ô¸Äã¿ìÀÖ ^_^01-7-6 15:28:57 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hi
Try link is with -L/path to your library -lmysqlclient You need library libmysqlclient which is currently in instaldir/lib/mysql/... --- Dvoøáèek Michal mailto:[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: Hi!
What OS are you using? Simon -Original Message- From: Morgan Sagmo [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 11:19 To: '[EMAIL PROTECTED]' Subject: Hi! I dont understand this. I am trying to make a database...Have not done it before, and I have red about MySQL. I have downloaded mysql-3.23.38, mysqlgui-1.7.5 and fltk. I am not good at this database thing... must say...but what do I do now? I cant find any .exe files? How can I use MySQL? Please help me!!! regards Morgan *** Morgan Sagmo Norwegian University of Science and Technology (NTNU); Faculty of Electrical Engineering and Telecommunications; O.S.Bragstads plass 2E; N-7491 Trondheim;NORWAY Email: [EMAIL PROTECTED] [EMAIL PROTECTED] TLF:73 59 42 87 FAX:73 59 42 79 MOB:91 57 02 37 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi!
Well, if you're looking for an exe file, I would say you have downloaded the wrong version. You will need to download the correct version for Windows and read the manual on how to install. If you have other problems, you'll need to be more specific. - Original Message - From: Morgan Sagmo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 18:18 Subject: Hi! I dont understand this. I am trying to make a database...Have not done it before, and I have red about MySQL. I have downloaded mysql-3.23.38, mysqlgui-1.7.5 and fltk. I am not good at this database thing... must say...but what do I do now? I cant find any .exe files? How can I use MySQL? Please help me!!! regards Morgan *** Morgan Sagmo Norwegian University of Science and Technology (NTNU); Faculty of Electrical Engineering and Telecommunications; O.S.Bragstads plass 2E; N-7491 Trondheim;NORWAY Email: [EMAIL PROTECTED] [EMAIL PROTECTED] TLF: 73 59 42 87 FAX: 73 59 42 79 MOB: 91 57 02 37 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hi help needed!
What's your code? How are you trying to connect? - Original Message - From: "manikandan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 15:02 Subject: Hi help needed! Hi All! I am not able to connect to remote Mysql running on a Linux meachine .I am running a win2k where apache and php are configured . Please let me know what could be wrong or how to connect to remore Mysql database Thanks in advance Manikandan _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re : Hi
Hi Andy, I dont think so to be honest it could be but i removed mysql and reinstalled it several times and each time, it works for a few times and then it collapses... any other idea ??? murat, At 19:13 10.02.2001 +0100, Dingfelder Andy wrote: Hello Murrat, is it possible, that someone deletes your mysql-database or the host table? Maybe yourself? The server needs this table for the "authorization rules", and a deletion should be avoided! Hope that helps. Regards Andy -Ursprngliche Nachricht- Von: Murat YESILDAL [mailto:[EMAIL PROTECTED]] Gesendet: Samstag, 10. Februar 2001 18:08 An: [EMAIL PROTECTED] Betreff: Hi, Hi, I have a problem i was using mysql and it was very well but yesterday it didn't work then i removed it and reinstalled it , it worked 2 times and then again it doesn't work, when i run mysqld it doesn't run in the background of windows, and in the error file it says 13:05:14 C:\MYSQL\BIN\MYSQLD.EXE: Table 'mysql.host' doesn't exist when i remove it and reinstall it i am able to run it a few times and after a few times, it gives that error, that could be the problem ? thanks, murat, \\\I/// ( o o ) ( n ) ( - ) o0o-o0o | | | Mehmet Murat Yesildal | |BILKENT UNIVERSITY | | Dept : Computer Engineering Information Science | | E-mail : [EMAIL PROTECTED] | | Homepage : http://www.ug.bcc.bilkent.edu.tr/~yesildal | --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php \\\I/// ( o o ) ( n ) ( - ) o0o-o0o | | | Mehmet Murat Yesildal | |BILKENT UNIVERSITY | | Dept : Computer Engineering Information Science | | E-mail : [EMAIL PROTECTED] | | Homepage : http://www.ug.bcc.bilkent.edu.tr/~yesildal | --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php