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
Hi, how did u do de-emphasis of sql statements?
Hey man, I would like to ask a question about de-emphasis of sql statements? I Mean mysql engines have to be aware of which two statements are exactly the same Despite of variables?? values at runtime. Because in slow log, the execution counter is Maintained for each sql statement. De-emphasis is obviously behind the back. Like select * from table where name??A?? is just The same as select * from table where name??B??. How did u do this emphasis?
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
?????? Hi, how did u do de-emphasis of sql statements?
As I consult the oracle 9i reference , I found they actualy have values of 'similar' and 'force' to be set for cursor_shareing parameter, which allows oracle to treat hard-coded statements to bind-variable statements in order to use the same execution plans. I wonder how they do this?..._/// -- -- ??: Johan De Meersmanvegiv...@tuxera.be; : 2012??8??13??(??) 8:48 ??: MID.night693893...@qq.com; : 673575760673575...@qq.com; mysqlmysql@lists.mysql.com; : 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
hi all
Dear: A open source development community for unix-like systems. http://dev.unix-like.net http://dev.unix-like.net/ Thanks.
buf/buf0buf.c:597 hi count
Anyone has idea if this is normal? I have a rather hi count on some mutexes on one of my servers: Find below: - server status - last section of mutex status - full innodb status. Thanks Claudio mysql status; -- mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1 Connection id: 4319976 Current database: Current user: cna...@localhost SSL:Not in use Current pager: stdout Using outfile: '' Using delimiter:; Server version: 5.1.44-log MySQL Community Server (GPL) Protocol version: 10 Connection: Localhost via UNIX socket Server characterset:latin1 Db characterset:latin1 Client characterset:latin1 Conn. characterset:latin1 UNIX socket:/tmp/mysqlg3.sock Uptime: 100 days 17 hours 2 min 14 sec Threads: 3 Questions: 1018296737 Slow queries: 817553 Opens: 486433 Flush tables: 2 Open tables: 512 Queries per second avg: 117.27 mysql show mutex status; ... ... ... | InnoDB | buf/buf0buf.c:547 | os_waits=0| | InnoDB | buf/buf0buf.c:545 | os_waits=1| | InnoDB | buf/buf0buf.c:547 | os_waits=0| | InnoDB | buf/buf0buf.c:545 | os_waits=0| | InnoDB | buf/buf0buf.c:547 | os_waits=0| | InnoDB | buf/buf0buf.c:545 | os_waits=0| | InnoDB | buf/buf0buf.c:547 | os_waits=0| | InnoDB | buf/buf0buf.c:545 | os_waits=0| | InnoDB | buf/buf0buf.c:547 | os_waits=0| | InnoDB | buf/buf0buf.c:545 | os_waits=0| | InnoDB | buf/buf0buf.c:547 | os_waits=0| | InnoDB | buf/buf0buf.c:545 | os_waits=1| | InnoDB | buf/buf0buf.c:547 | os_waits=0| | InnoDB | buf/buf0buf.c:545 | os_waits=0| | InnoDB | buf/buf0buf.c:597 | os_waits=14107661 | | InnoDB | fil/fil0fil.c:1313| os_waits=15487| | InnoDB | srv/srv0start.c:1234 | os_waits=0| | InnoDB | srv/srv0start.c:1227 | os_waits=0| | InnoDB | srv/srv0start.c:1205 | os_waits=0| | InnoDB | dict/dict0mem.c:90| os_waits=0| | InnoDB | dict/dict0mem.c:90| os_waits=0| | InnoDB | srv/srv0srv.c:888 | os_waits=2| | InnoDB | srv/srv0srv.c:886 | os_waits=1987771 | | InnoDB | thr/thr0loc.c:227 | os_waits=19 | | InnoDB | mem/mem0pool.c:206| os_waits=100246 | | InnoDB | sync/sync0sync.c:1336 | os_waits=0| ++---+---+ 524667 rows in set, 1 warning (0.37 sec) mysql show engine innodb status\G *** 1. row *** Type: InnoDB Name: Status: = 10 17:20:22 INNODB MONITOR OUTPUT = Per second averages calculated from the last 22 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 48478335, signal count 42451353 Mutex spin waits 0, rounds 8815343059, OS waits 19199213 RW-shared spins 41005267, OS waits 15171494; RW-excl spins 37475092, OS waits 3827085 TRANSACTIONS Trx id counter 0 884763960 Purge done for trx's n:o 0 884763426 undo n:o 0 0 History list length 153 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 25247, OS thread id 1190668608 MySQL thread id 4319976, query id 1018250617 localhost cnanni show engine innodb status ---TRANSACTION 0 884763959, not started, process no 25247, OS thread id 1206376768 MySQL thread id 4318685, query id 1018250616 Has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 0 0, not started, process no 25247, OS thread id 1178954048 MySQL thread id 8168, query id 1018247620 localhost 127.0.0.1 mysqlagent FILE I/O I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 36754202 OS file reads, 766794698 OS file writes, 741205810 OS fsyncs 3.41 reads/s, 28180 avg bytes/read, 54.32 writes/s, 53.32 fsyncs/s - INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf: size 1, free list len 287, seg size 289, 7992065 inserts, 7991987 merged recs, 717873 merges Hash table size 8850487, node heap has 4996 buffer(s) 427.94 hash searches/s, 123.45 non-hash searches/s --- LOG --- Log sequence number 465 1466637443 Log flushed up to 465 1466637443 Last checkpoint at 465 1382185700 0 pending log writes, 0 pending chkp writes 736518756 log i/o's done, 53.09 log i/o's/second -- BUFFER POOL AND MEMORY -- Total memory allocated
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
hi.. is it possible
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.. 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
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
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
Hi Query Optimization steps
Hi all Tell Me few Query Optimization Tips For example.. some people saying that , avoid using more of and condition in the query This sort of very basic things please tell me ... Also tell me , in the optimization view ,, which database engine is best Thanks Bharanikumar
Hi query with more relation
Hi all *country* IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ID%60+ASCtoken=48055f87d08d88620138b58feb711be2 Namehttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60Name%60+ASCtoken=48055f87d08d88620138b58feb711be2 Tel_Codehttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60Tel_Code%60+ASCtoken=48055f87d08d88620138b58feb711be2 ActiveIndhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=countrysql_query=SELECT+%2A+FROM+%60country%60+ORDER+BY+%60country%60.%60ActiveInd%60+ASCtoken=48055f87d08d88620138b58feb711be2 103 India 91 1 104 Indonesia 62 1 105 Iran 98 1 106 Iraq 964 1 *city* *IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=citysql_query=SELECT+%2A+FROM+%60city%60+ORDER+BY+%60city%60.%60ID%60+ASCtoken=48055f87d08d88620138b58feb711be2 * *Namehttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=citysql_query=SELECT+%2A+FROM+%60city%60+ORDER+BY+%60city%60.%60Name%60+ASCtoken=48055f87d08d88620138b58feb711be2 * *ActiveIndhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=citysql_query=SELECT+%2A+FROM+%60city%60+ORDER+BY+%60city%60.%60ActiveInd%60+ASCtoken=48055f87d08d88620138b58feb711be2 * 1 chennai 1 2 mumbai 1 3 pattaya 1 *country_city* *IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=country_citysql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60ID%60+ASCtoken=48055f87d08d88620138b58feb711be2 * *City_IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=country_citysql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60City_ID%60+ASCtoken=48055f87d08d88620138b58feb711be2 * *Country_IDhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=country_citysql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60Country_ID%60+ASCtoken=48055f87d08d88620138b58feb711be2 * *ActiveIndhttp://localhost/phpmyadmin/sql.php?db=totallyairportstable=country_citysql_query=SELECT+%2A+FROM+%60country_city%60+ORDER+BY+%60country_city%60.%60ActiveInd%60+ASCtoken=48055f87d08d88620138b58feb711be2 * 1 1 103 1 2 2 103 1 3 3 216 1 Hi can i want the query which display the below output *Cityname | countryname | cityid | countryid* chennai | india | 1 | 103 mumbai | india | 2 | 103 Can u please the query ,
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]
Hi mysql.list.server
hi -- View this message in context: http://www.nabble.com/Hi-mysql.list.server-tf4287546.html#a12205370 Sent from the MySQL - General mailing list archive at Nabble.com. -- 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]
hi, I am not able view all the records in the tabel
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. I want all the records to be displayed when i select using 'select * from table_name-1;'. Regards A Srinivas
HI, I am Annam Srinivas
hi how to merge data of various sql files
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.
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]
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
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
RES: Hi all
In true, I have a project to develop a new (revolutionary) engine for mySQL, and so increase many times applications performance, and reduce enterprises cost with hardware infraestruture. So I'm looking for peoples to help me to develop this project - or appoval by MySQL AB. My regards, Fabricio Mota -Mensagem original- De: Stewart Smith [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 31 de outubro de 2005 05:08 Para: Fabricio Mota Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RES: Hi all
On Mon, 2005-10-31 at 21:16 -0300, Fabricio Mota wrote: In true, I have a project to develop a new (revolutionary) engine for mySQL, and so increase many times applications performance, and reduce enterprises cost with hardware infraestruture. So I'm looking for peoples to help me to develop this project - or appoval by MySQL AB. You certainly don't need anybody's permission. (distributing under a non-GPL license would). Best bet is to start hacking and ask when you get stuck. There are a couple of articles around on writing a storage engine - as well as the best doc ever - the code. (btw, this probably should be on internals, not mysql, cluster or plusplus list) -- 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
RES: RES: Hi all
Ok, could you suggest me where I may find it with more occurrences? Another problem is: MySQL is a very big project, and I have no UML (or any abstraction) that could help me to understand it!! Can you tell me where could I find this kind of documentation? My Regards Fabricio Mota -Mensagem original- De: Stewart Smith [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 31 de outubro de 2005 23:14 Para: Fabricio Mota Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: Re: RES: Hi all On Mon, 2005-10-31 at 21:16 -0300, Fabricio Mota wrote: In true, I have a project to develop a new (revolutionary) engine for mySQL, and so increase many times applications performance, and reduce enterprises cost with hardware infraestruture. So I'm looking for peoples to help me to develop this project - or appoval by MySQL AB. You certainly don't need anybody's permission. (distributing under a non-GPL license would). Best bet is to start hacking and ask when you get stuck. There are a couple of articles around on writing a storage engine - as well as the best doc ever - the code. (btw, this probably should be on internals, not mysql, cluster or plusplus list) -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: RES: Hi all
Hi Fabricio, You can find a lot of information in the manual, more specifically at http://dev.mysql.com/doc/refman/5.0/en/example-storage-engine.html This would be a very good place to start. Otherwise, as suggested, ask questions on the internals list. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Fabricio Mota [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 November 2005 12:54 PM To: Stewart Smith Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RES: RES: Hi all Ok, could you suggest me where I may find it with more occurrences? Another problem is: MySQL is a very big project, and I have no UML (or any abstraction) that could help me to understand it!! Can you tell me where could I find this kind of documentation? My Regards Fabricio Mota -Mensagem original- De: Stewart Smith [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 31 de outubro de 2005 23:14 Para: Fabricio Mota Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: Re: RES: Hi all On Mon, 2005-10-31 at 21:16 -0300, Fabricio Mota wrote: In true, I have a project to develop a new (revolutionary) engine for mySQL, and so increase many times applications performance, and reduce enterprises cost with hardware infraestruture. So I'm looking for peoples to help me to develop this project - or appoval by MySQL AB. You certainly don't need anybody's permission. (distributing under a non-GPL license would). Best bet is to start hacking and ask when you get stuck. There are a couple of articles around on writing a storage engine - as well as the best doc ever - the code. (btw, this probably should be on internals, not mysql, cluster or plusplus list) -- 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 -- 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]
RES: RES: Hi all
Ok, David. Thank you, I'll take a good look on it! My Regards, Fabricio Mota -Mensagem original- De: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 31 de outubro de 2005 23:36 Para: Fabricio Mota; Stewart Smith Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: RE: RES: Hi all Hi Fabricio, You can find a lot of information in the manual, more specifically at http://dev.mysql.com/doc/refman/5.0/en/example-storage-engine.html This would be a very good place to start. Otherwise, as suggested, ask questions on the internals list. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -Original Message- From: Fabricio Mota [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 November 2005 12:54 PM To: Stewart Smith Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RES: RES: Hi all Ok, could you suggest me where I may find it with more occurrences? Another problem is: MySQL is a very big project, and I have no UML (or any abstraction) that could help me to understand it!! Can you tell me where could I find this kind of documentation? My Regards Fabricio Mota -Mensagem original- De: Stewart Smith [mailto:[EMAIL PROTECTED] Enviada em: segunda-feira, 31 de outubro de 2005 23:14 Para: Fabricio Mota Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]; [EMAIL PROTECTED] Assunto: Re: RES: Hi all On Mon, 2005-10-31 at 21:16 -0300, Fabricio Mota wrote: In true, I have a project to develop a new (revolutionary) engine for mySQL, and so increase many times applications performance, and reduce enterprises cost with hardware infraestruture. So I'm looking for peoples to help me to develop this project - or appoval by MySQL AB. You certainly don't need anybody's permission. (distributing under a non-GPL license would). Best bet is to start hacking and ask when you get stuck. There are a couple of articles around on writing a storage engine - as well as the best doc ever - the code. (btw, this probably should be on internals, not mysql, cluster or plusplus list) -- 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 -- 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]
Hi all
Hi all, Anybody has worked as a developer to MySQL Database Server features? Thank you Fabricio Mota -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[Fwd: Hi Glen, could I ask a favor regarding the MYSQL list?]
auto_parser wrote: Glen, Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This violates RFC 821/2505/2821 http://www.rfc-ignorant.org/ After contacting rfc-ignorant.org, they assured me it is a mistake in the way mysql is implementing the RFC protocol, and that I'm not on any black lists. As I can't contact the list, I can't resolve the issue. Unfortunately, my query optimization is a more pressing problem at this moment. Thanks for your help, Scott. * Question for MySQL: Subject: Select query optimization help! 45 seconds+ query... The following query is in desperate need of optimization. Any gurus out there who can share some insights, I'd greatly appreciate it. I have a request table, from which I'm pulling all records. Each request record has a part number, and for each requested part number, I'd like to query the inventory table for all matching inventory items for that part number, and calculate the potential value of the inventory. Each inventory record has 4 price fields, and it is the HIGHEST value of these fields used in the calculation. As you can tell by running the query, it is incredibly expensive. We have potentially millions of inventory records and 10,000+ requests, so the query is going to take several minutes to complete. Also, I found that due to the joining on each record(?), I couldn't implement a limit clause to save time. Whether or not a limit clause is tacked onto the end of the query, it completes the entire calculation process for both tables, and THEN returns the limited number of records. This of course saves me no time. :( Any help is greatly appreciated, Thanks. ps, all pertinent fields have already been indexed. This reduced the query time by half, but half of an eternity is still not that impressive. SELECT r.id, r.company, r.dateSent, r.fullName, r.phone, r.fax, r.email, r.address1, r.address2, r.city, r.province, r.country, r.comments, r.partNumber, r.description, r.dateCode, r.qty, r.targetPrice, r.manufacturer, r.expiryDate, r.companyType, r.yearEstablished, r.url, r.languages, GREATEST(i.distySellCost, i.originalCost, i.unitCost,i.unitSellCost)*r.qty AS 'highestValue', count(i.id) as 'matches', SUM(i.qty) as 'qtyAvailable' FROM request r LEFT JOIN inventory i ON ( i.MPN LIKE CONCAT(r.partNumber, '%') OR i.MPNClean LIKE CONCAT(r.partNumber, '%')) AND i.status=1 WHERE r.deleted=0 GROUP BY r.id; -- Gleb Paharenko [EMAIL PROTECTED] ---BeginMessage--- Glen, Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This violates RFC 821/2505/2821 http://www.rfc-ignorant.org/ After contacting rfc-ignorant.org, they assured me it is a mistake in the way mysql is implementing the RFC protocol, and that I'm not on any black lists. As I can't contact the list, I can't resolve the issue. Unfortunately, my query optimization is a more pressing problem at this moment. Thanks for your help, Scott. * Question for MySQL: Subject: Select query optimization help! 45 seconds+ query... The following query is in desperate need of optimization. Any gurus out there who can share some insights, I'd greatly appreciate it. I have a request table, from which I'm pulling all records. Each request record has a part number, and for each requested part number, I'd like to query the inventory table for all matching inventory items for that part number, and calculate the potential value of the inventory. Each inventory record has 4 price fields, and it is the HIGHEST value of these fields used in the calculation. As you can tell by running the query, it is incredibly expensive. We have potentially millions of inventory records and 10,000+ requests, so the query is going to take several minutes to complete. Also, I found that due to the joining on each record(?), I couldn't implement a limit clause to save time. Whether or not a limit clause is tacked onto the end of the query, it completes the entire calculation process for both tables, and THEN returns the limited number of records. This of course saves me no time. :( Any help is greatly appreciated, Thanks. ps, all pertinent fields have already been
Re: [Fwd: Hi Glen, could I ask a favor regarding the MYSQL list?]
On 7/12/05, Gleb Paharenko wrote: auto_parser wrote: Would you be able to forward the following message to the mysql list. I keep getting bounce-backs with the following: Recipient: mysql@lists.mysql.com Reason:Mail from HELO priv-edtnes27.telusplanet.net rejected because it does not accept bounces. This violates RFC 821/2505/2821 http://www.rfc-ignorant.org/ After contacting rfc-ignorant.org, they assured me it is a mistake in the way mysql is implementing the RFC protocol, and that I'm not on any black lists. The problem is not a blacklist. The problem is that priv-edtnes27.telusplanet.net resolves to a RFC 1918 address. Your message does not make clear which MTA gives this error, but if it is MySQL they are right to reject it. And if it isn't MySQL, you are barking up the wrong tree. As I can't contact the list, I can't resolve the issue. Sure you can: fix your DNS mail setup. Public facing DNS servers should not advertise RFC 1918 addresses. MUAs/MTAs should use the correct hostname in the HELO. I have a request table, from which I'm pulling all records. Each request record has a part number, and for each requested part number, I'd like to query the inventory table for all matching inventory items for that part number, and calculate the potential value of the inventory. Each inventory record has 4 price fields, and it is the HIGHEST value of these fields used in the calculation. As you can tell by running the query, it is incredibly expensive. We have potentially millions of inventory records and 10,000+ requests, so the query is going to take several minutes to complete. Can you show the EXPLAIN output? Which version are you using? Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
just hi
well im from argentina, and today i begin using mysql, i have a lot of questions, first of all, is there a mysql official manual at www.mysql.com? i have searched but don't found it :S I want to read something before ask thnx :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: just hi
Hi Ezequiel, see: http://dev.mysql.com/doc/ /Johan Ezequiel Rodriguez wrote: well im from argentina, and today i begin using mysql, i have a lot of questions, first of all, is there a mysql official manual at www.mysql.com? i have searched but don't found it :S I want to read something before ask thnx :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: just hi
Ezequiel, Tambien hay una lista de mysql en Espagnol. :-) -Original Message- From: Johan H��k [EMAIL PROTECTED] Sent: May 11, 2005 4:35 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: just hi Hi Ezequiel, see: http://dev.mysql.com/doc/ /Johan Ezequiel Rodriguez wrote: well im from argentina, and today i begin using mysql, i have a lot of questions, first of all, is there a mysql official manual at www.mysql.com? i have searched but don't found it :S I want to read something before ask thnx :D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 wayto dothis? Gokce AKKAYA HAZAROGLU OptikNet Bilgisayar [EMAIL PROTECTED] http://www.optiknet.com.tr
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
Hi!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 ? Many thanks for information on this. Here from you soon I hope, Best regards Andy Fletcher
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]
Hi, I sent you a greeting from AOL E-Cards
To view your greeting, choose from the options below. Click on the following link: http://www.pickup.aol.egreetings.com/view.pd?i=6375961m=5319rr=ysource=aole999 OR Copy and paste the above link into your web browser's address window. Thank you for using AOL E-Cards! -- 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]
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
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]
hi
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]
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]
@hi, need sync mysql users password with LDAP3.x
Hi, I very need sync password for same mysql users with LDAP (or *nix passwd file). Any idea? -- Miroslav Ris System Administrator iNet System iNet WebMail System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi and why
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?? 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 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
Hi, I have question about the User Privileges system
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. 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, 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
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 ? Regards, Cherian. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
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 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
Hi, Help!
Erin, Tuesday, February 05, 2002, 12:37:33 AM, you wrote: EL Hi, this is Erin Lilly, I've used support before with you all for EL bodyconsultant.com and you were extremely helpful. I'm installing mysql on EL erinlilly.net and have run into that common /tmp/mysql.sock (111) error EL version: 3.23.45-pc-linux EL you then need to type in /usr/local to see where I've installed the EL mysql-3.23.45 EL Please take a look where I had installed it in EL /usr/local/mysql-3.23.45-pc-linux-i686 EL I've created a ln -s from tmp to /usr/local/mysql-3.23 EL have created a ln -s from mysql-3.23.45 and mysql EL What's the problem?? When I go to do the ./bin/safe_mysql command it turns EL server on then logs off. Also when I do bin/mysqladmin -u root -p password EL it gives me the /tmp/mysql.sock (111) not found - even though I have ln -s EL that tmp directory to the mysql-3.23.45 ... EL Have tested the telnet erinlilly.net 3306 - and no connection. EL MY QUESTIONS: EL 1. What do I need to do to get the connection going. EL 2. How can I be sure the tables were created. I ran install_db and it EL appeared to do everything. You should do : ls data_dir/mysql data_dir is the MySQL data directory. EL 3. What do I need to do to make things right here? EL 4. Have all my ln -s created some inherent problems? Check the following links: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html http://www.mysql.com/doc/m/y/mysql_install_db.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 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
Hi, Help!
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 version: 3.23.45-pc-linux To telnet in as root: erinlilly.net log-admin pw-paws you then need to type in /usr/local to see where I've installed the mysql-3.23.45 Please take a look where I had installed it in /usr/local/mysql-3.23.45-pc-linux-i686 I've created a ln -s from tmp to /usr/local/mysql-3.23 have created a ln -s from mysql-3.23.45 and mysql What's the problem?? When I go to do the ./bin/safe_mysql command it turns server on then logs off. Also when I do bin/mysqladmin -u root -p password it gives me the /tmp/mysql.sock (111) not found - even though I have ln -s that tmp directory to the mysql-3.23.45 ... Have tested the telnet erinlilly.net 3306 - and no connection. MY QUESTIONS: 1. What do I need to do to get the connection going. 2. How can I be sure the tables were created. I ran install_db and it appeared to do everything. 3. What do I need to do to make things right here? 4. Have all my ln -s created some inherent problems? HERE's the MYSQL registration info: erin6817 fevnodfi order number 6755 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hi Folks!
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
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
Hi all,
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
hi.
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 = RAJ.. __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.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.
-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