Re: Innodb gets disabled
I did the same as you have written, but innodb storage engine is not available now. Even the skip-innodb is commented in my.cnf On Jan 16, 2008 9:43 PM, Rolando Edwards [EMAIL PROTECTED] wrote: 1) 'mysqldump' all databases to an SQL file 2) Drop all databases 3) Shutdown mysqld 4) Delete the ibdata1, ib_logfile0, ib_logfile1 5) Add innodb_file_per_table to my.cnf (which you already did) 6) Make sure you gave this setting in [mysqld] group of my.cnfinnodb_data_file_path=ibdata1:10M:autoextend 7) Start mysqld mysqld should recreate ibdata1, ib_logfile0, ib_logfile1 8) Reload all the databases from the SQL file Give it a try !!! -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 7:52 AM To: MySql Subject: Innodb gets disabled Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql -server innodb engine gets disabled. What can be the issue. Please help me, Even if any body know to enable innodb storage engine in mysql please let me know Thanks Krishna Chandra Prajapati -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]
[HELP] I'm looking for document about References attribute for Mysql 4.1
Hi all, I'm looking for information about References attribute in Mysql, help me! thanks in advance. Bo
MySql at 100% CPU
Dear MySql, I hope you can help me trace a problem. Every few days one of my 5.0.45 will stick at 100% CPU whilst not doing very much. The server is a replication master and slave, but idle at this time. I am running 100% InnoDB and there is nothing in the error log. It will stay that way for minutes or hours, or until it is restarted. This load cannot be accounted for by the processlist. I need to know why MySql does this. If any person knows how I an identify the problem, please let me know! Thanks! Ben Clewett. # top top - 08:19:50 up 5 days, 9:52, 1 user, load average: 1.40, 1.76, 1.09 Tasks: 129 total, 1 running, 128 sleeping, 0 stopped, 0 zombie Cpu(s): 25.3%us, 0.2%sy, 0.0%ni, 74.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 10235936k total, 9946508k used, 289428k free, 179584k buffers Swap: 10490436k total, 124k used, 10490312k free, 5449908k cached PID USER PR NI VIRT RES SHR S %CPU %MEMTIME+ COMMAND 6296 mysql 15 0 4163m 3.6g 5728 S 100 37.1 342:14.36 mysqld mysql show processlist; ++-+--+---+-+--+---+--+ | Id | User| Host | db| Command | Time | State | Info | ++-+--+---+-+--+---+--+ | 386295 | system user | | NULL | Connect | 488 | Waiting for master to send event | NULL | | 386296 | system user | | NULL | Connect |0 | Has read all relay log; waiting for the slave I/O thread to update it | NULL | | 386340 | slave | hp-tm-07.roadtech.private:53998 | NULL | Binlog Dump | 408 | Has sent all binlog to slave; waiting for binlog to be updated| NULL | | 386667 | root| localhost| NULL | Query |0 | NULL | show processlist | | 386669 | webservice | fls-16-05.roadtech.private:44277 | par_4 | Query |1 | Sending data | SELECT COUNT(*) FROM - WHERE comp_code = '---' AND veh_code = '---' AND t BETWEEN | ++-+--+---+-+--+---+--+ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Lost Connection each hour :(
On Tue, Jan 15, 2008 at 09:27:10PM +0100, MAS! wrote: Can anyone help me to understand why my site (php 4.4.2 / ubuntu dapper) loose all connections to mysql server when /etc/cron/hourly starts? (there are no process to start hourly, the directory is empty) Is the assumption correct, that this happens each hour at exactly the same time, in exact 60min intervals? Grep the syslog then for corresponding CRON entries. Hourly cronjobs will more likely be found in /etc/cron.d or in /var/spool/cron/crontabs. Regards, Matthias Witte -- [netzquadrat] GmbH www.billiger-telefonieren.de Gladbacher Straße 74 www.billiger-surfen.de 40219 Düsseldorf www.sms.de Tel/Fax: +49 211 30 20 33 18/22 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
performances and optimization in multiple join queries
Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the recordset. I was looking for some (right) way to optimize the search. there were some solutions proposed around, like split in n simpler queries and then merge the results, or create some temporary tables containing the filtered data to let the main query execute without too many iterations... I was wondering if there was anybody here, to suggest the best approach to this kind of performance issues. Thanks, Stefano. p.s.: this is a sample of the query we are talking about.. each sub_table has 2 fields: cs_AN (indexed) and a data field (usually text, not indexed) SELECT field_1 FROM table_A LEFT JOIN sub_table_AUON table_A.mt_AN = sub_table_AU.cs_AN LEFT JOIN sub_table_BNON table_A.mt_AN = sub_table_BN.cs_AN LEFT JOIN sub_table_CNON table_A.mt_AN = sub_table_CN.cs_AN LEFT JOIN sub_table_CSON table_A.mt_AN = sub_table_CS.cs_AN LEFT JOIN sub_table_DTON table_A.mt_AN = sub_table_DT.cs_AN LEFT JOIN sub_table_EMON table_A.mt_AN = sub_table_EM.cs_AN LEFT JOIN sub_table_GNON table_A.mt_AN = sub_table_GN.cs_AN LEFT JOIN sub_table_IDON table_A.mt_AN = sub_table_ID.cs_AN LEFT JOIN sub_table_LAON table_A.mt_AN = sub_table_LA.cs_AN LEFT JOIN sub_table_OION table_A.mt_AN = sub_table_OI.cs_AN LEFT JOIN sub_table_ODON table_A.mt_AN = sub_table_OD.cs_AN LEFT JOIN sub_table_RNON table_A.mt_AN = sub_table_RN.cs_AN LEFT JOIN sub_table_KWON table_A.mt_AN = sub_table_KW.cs_AN WHERE ( sub_table_AU.cs_AU like '%key1wor%' or sub_table_BN.cs_PU like '%key1wor%' or sub_table_CN.cs_CN like '%key1wor%' or sub_table_CS.cs_CS like '%key1wor%' or sub_table_DT.cs_DT like '%key1wor%' or sub_table_EM.cs_EM like '%key1wor%' or sub_table_GN.cs_GN like '%key1wor%' or sub_table_ID.cs_ID like '%key1wor%' or sub_table_LA.cs_LA like '%key1wor%' or sub_table_OI.cs_OI like '%key1wor%' or sub_table_OD.cs_OD like '%key1wor%' or sub_table_RN.cs_PU like '%key1wor%' or sub_table_KW.cs_KW like '%key1wor%' ) or ( sub_table_AU.cs_AU like '%key2wor%' or sub_table_BN.cs_PU like '%key2wor%' or sub_table_CN.cs_CN like '%key2wor%' or sub_table_CS.cs_CS like '%key2wor%' or sub_table_DT.cs_DT like '%key2wor%' or sub_table_EM.cs_EM like '%key2wor%' or sub_table_GN.cs_GN like '%key2wor%' or sub_table_ID.cs_ID like '%key2wor%' or sub_table_LA.cs_LA like '%key2wor%' or sub_table_OI.cs_OI like '%key2wor%' or sub_table_OD.cs_OD like '%key2wor%' or sub_table_RN.cs_PU like '%key2wor%' or sub_table_KW.cs_KW like '%key2wor%' ... [other OR blocks] ... ) GROUP BY field_1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump - new version = no data?
I've been using mysqldump in a Perl script for a client of mine to do database dumps for several years and until recently it has worked fine. However I noticed that in a recent dump, no data or schema was created. Since I don't know for sure where 'mysqldump' is located on the remote system I use 'whereis' to find it. Then I use the first path I find. Here are the paths containing 'mysql': /usr/bin/mysql /usr/lib/mysql /usr/include/mysql /usr/share/mysql My command string is then similar to this: usr/bin/mysqldump -uusername -ppassword database_name mydatadump.sql Now this command produces this output file: -- MySQL dump 10.10 -- -- Host: localhostDatabase: database_name -- -- -- Server version 5.0.27 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; Previous outputs had header data: -- MySQL dump 8.23 -- -- Host: localhostDatabase: database_name - -- Server version 3.23.58 So it appears the host has updated the MySQL server, and of course mysqldump is new. Now my script is broken until I patch my code with a new set of parameters. I would not have discovered this unless I had been doing some poking around on the server. This is very frustrating and potentially dangerous, since my client could have done a dump / restore not knowing there wasn't really a dump to work with. Has anyone else had this problem, and hopefully got a working solution? If this is going to keep happening every time the server gets updated then I (and lots of others I assume) will have to find an alternative way to let my client do backups. -- Amer Neely - Web Mechanic w: www.webmechanic.softouch.on.ca/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: performances and optimization in multiple join queries
So many tables join.OH. Can you paste your explain results here? On 1/17/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the recordset. I was looking for some (right) way to optimize the search. there were some solutions proposed around, like split in n simpler queries and then merge the results, or create some temporary tables containing the filtered data to let the main query execute without too many iterations... I was wondering if there was anybody here, to suggest the best approach to this kind of performance issues. Thanks, Stefano. p.s.: this is a sample of the query we are talking about.. each sub_table has 2 fields: cs_AN (indexed) and a data field (usually text, not indexed) SELECT field_1 FROM table_A LEFT JOIN sub_table_AUON table_A.mt_AN = sub_table_AU.cs_AN LEFT JOIN sub_table_BNON table_A.mt_AN = sub_table_BN.cs_AN LEFT JOIN sub_table_CNON table_A.mt_AN = sub_table_CN.cs_AN LEFT JOIN sub_table_CSON table_A.mt_AN = sub_table_CS.cs_AN LEFT JOIN sub_table_DTON table_A.mt_AN = sub_table_DT.cs_AN LEFT JOIN sub_table_EMON table_A.mt_AN = sub_table_EM.cs_AN LEFT JOIN sub_table_GNON table_A.mt_AN = sub_table_GN.cs_AN LEFT JOIN sub_table_IDON table_A.mt_AN = sub_table_ID.cs_AN LEFT JOIN sub_table_LAON table_A.mt_AN = sub_table_LA.cs_AN LEFT JOIN sub_table_OION table_A.mt_AN = sub_table_OI.cs_AN LEFT JOIN sub_table_ODON table_A.mt_AN = sub_table_OD.cs_AN LEFT JOIN sub_table_RNON table_A.mt_AN = sub_table_RN.cs_AN LEFT JOIN sub_table_KWON table_A.mt_AN = sub_table_KW.cs_AN WHERE ( sub_table_AU.cs_AU like '%key1wor%' or sub_table_BN.cs_PU like '%key1wor%' or sub_table_CN.cs_CN like '%key1wor%' or sub_table_CS.cs_CS like '%key1wor%' or sub_table_DT.cs_DT like '%key1wor%' or sub_table_EM.cs_EM like '%key1wor%' or sub_table_GN.cs_GN like '%key1wor%' or sub_table_ID.cs_ID like '%key1wor%' or sub_table_LA.cs_LA like '%key1wor%' or sub_table_OI.cs_OI like '%key1wor%' or sub_table_OD.cs_OD like '%key1wor%' or sub_table_RN.cs_PU like '%key1wor%' or sub_table_KW.cs_KW like '%key1wor%' ) or ( sub_table_AU.cs_AU like '%key2wor%' or sub_table_BN.cs_PU like '%key2wor%' or sub_table_CN.cs_CN like '%key2wor%' or sub_table_CS.cs_CS like '%key2wor%' or sub_table_DT.cs_DT like '%key2wor%' or sub_table_EM.cs_EM like '%key2wor%' or sub_table_GN.cs_GN like '%key2wor%' or sub_table_ID.cs_ID like '%key2wor%' or sub_table_LA.cs_LA like '%key2wor%' or sub_table_OI.cs_OI like '%key2wor%' or sub_table_OD.cs_OD like '%key2wor%' or sub_table_RN.cs_PU like '%key2wor%' or sub_table_KW.cs_KW like '%key2wor%' ... [other OR blocks] ... ) GROUP BY field_1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- I'm a mysql DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
memory usage in relation to open connections
hello, i'm searching for some information about how many system memory mysql uses in relation to the open connections. in the last weeks we often had the problem of too many connections, but before raising the configuration value, we would like to calculate a maximum amount of used memory. the system has 1GB ram, and according to statistics most of it is already in use. current value of max_connections for MySQL is 160. are there any algorithms to calculate the average/maximum memory usage? thanks in advance, jonas PS: i'm not subscribed to the list, please Cc me in your replies -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: performances and optimization in multiple join queries
[EMAIL PROTECTED] schrieb: Hello everybody! I have a huge query (something similar to a search engine), full of left joins and my testing server takes several minutes each time to output the recordset. I was looking for some (right) way to optimize the search. there were some solutions proposed around, like split in n simpler queries and then merge the results, or create some temporary tables containing the filtered data to let the main query execute without too many iterations... I was wondering if there was anybody here, to suggest the best approach to this kind of performance issues. Thanks, Stefano. p.s.: this is a sample of the query we are talking about.. each sub_table has 2 fields: cs_AN (indexed) and a data field (usually text, not indexed) SELECT field_1 FROM table_A LEFT JOIN sub_table_AUON table_A.mt_AN = sub_table_AU.cs_AN LEFT JOIN sub_table_BNON table_A.mt_AN = sub_table_BN.cs_AN LEFT JOIN sub_table_CNON table_A.mt_AN = sub_table_CN.cs_AN LEFT JOIN sub_table_CSON table_A.mt_AN = sub_table_CS.cs_AN LEFT JOIN sub_table_DTON table_A.mt_AN = sub_table_DT.cs_AN LEFT JOIN sub_table_EMON table_A.mt_AN = sub_table_EM.cs_AN LEFT JOIN sub_table_GNON table_A.mt_AN = sub_table_GN.cs_AN LEFT JOIN sub_table_IDON table_A.mt_AN = sub_table_ID.cs_AN LEFT JOIN sub_table_LAON table_A.mt_AN = sub_table_LA.cs_AN LEFT JOIN sub_table_OION table_A.mt_AN = sub_table_OI.cs_AN LEFT JOIN sub_table_ODON table_A.mt_AN = sub_table_OD.cs_AN LEFT JOIN sub_table_RNON table_A.mt_AN = sub_table_RN.cs_AN LEFT JOIN sub_table_KWON table_A.mt_AN = sub_table_KW.cs_AN WHERE ([...] create a merge table over your sub_tables, search this merge and join table_A to this, and not otherwise -- Sebastian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb gets disabled
Have you checked filesystem permissions where InnoDB needs to create its files? And you're sure you've removed ALL of InnoDB's previous data and log files? And there's nothing in the server's error logs? Are you looking in the right error logs? (cause an error deliberately and look for it to be sure). On Jan 17, 2008 3:04 AM, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote: I did the same as you have written, but innodb storage engine is not available now. Even the skip-innodb is commented in my.cnf On Jan 16, 2008 9:43 PM, Rolando Edwards [EMAIL PROTECTED] wrote: 1) 'mysqldump' all databases to an SQL file 2) Drop all databases 3) Shutdown mysqld 4) Delete the ibdata1, ib_logfile0, ib_logfile1 5) Add innodb_file_per_table to my.cnf (which you already did) 6) Make sure you gave this setting in [mysqld] group of my.cnfinnodb_data_file_path=ibdata1:10M:autoextend 7) Start mysqld mysqld should recreate ibdata1, ib_logfile0, ib_logfile1 8) Reload all the databases from the SQL file Give it a try !!! -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 7:52 AM To: MySql Subject: Innodb gets disabled Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql -server innodb engine gets disabled. What can be the issue. Please help me, Even if any body know to enable innodb storage engine in mysql please let me know Thanks Krishna Chandra Prajapati -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: changed directory name
This is actually a PHP issue and nothing to do with MySQL. You're correct in that since you renamed the directory, the scripts can't find their includes. Ideally, they should be using relative path names and/or setting the include_path php.ini variable to avoid this. The quick however, answer is given to you in the error message i.e. Change line 52 of C:\webserver\xampplite\htdocs\extreme\admin\index.php to be: include(C:/webserver/xampplite/htdocs/extreme/include/language/en/lang.inc .php) (and all the other include, require calls as appropriate) PS: I'd advise against using any upper-case characters in your web folder names (URLs) as this can lead to annoying problems later down the line. It's much simpler to keep it all lowercase. Edward -Original Message- From: Nicoleen Nel [mailto:[EMAIL PROTECTED] Sent: 17 January 2008 13:34 To: mysql@lists.mysql.com Subject: changed directory name Hi guys, Im really new to this (I only have html background) so if im asking stupid q's please bare with me. I changed my open reallty file name to extreme, when I try to load the file http://localhost/Extreme/admin/index.php in explorer and I keep on getting these errors, I think I have to change the base path, but im unsure of where to change it and how: *Warning*: include(C:/webserver/xampplite/htdocs/open/include/language/en/lan g.inc.php) [function.include http://localhost/Extreme/admin/function.include]: failed to open stream: include(C:/webserver/xampplite/htdocs/open/include/language/en/lan g.inc.php) *Warning*: include() [function.includehttp://localhost/Extreme/admin/function.include]: Failed opening 'C:/webserver/xampplite/htdocs/open/include/language/en/lang.inc.php' for inclusion (include_path='.;C:\webserver\xampplite\php\pear\') in * C:\webserver\xampplite\htdocs\extreme\admin\index.php* on line *52* *Warning*: require_once(C:/webserver/xampplite/htdocs/open/include/login.inc.php) [ function.require-once http://localhost/Extreme/admin/function.require-once]: failed to open stream: No such file or directory in * C:\webserver\xampplite\htdocs\extreme\admin\index.php* on line *54* *Fatal error*: require_once() [function.requirehttp://localhost/Extreme/admin/function.require]: Failed opening required 'C:/webserver/xampplite/htdocs/open/include/login.inc.php' (include_path='.;C:\webserver\xampplite\php\pear\') in * C:\webserver\xampplite\htdocs\extreme\admin\index.php* on line *54* Im using xampplite. Please help me:) Nix -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
creating temp file, modifying data and putting into other table
Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another whilst making a modification. I thought that this could be done using a temporary table in a batch script that is unique to that session e.g. create temporary table Ttable1 (select * from masterlist where ref='ABCDE'); update Ttable1 set ref='SMI0C001'; insert into sublist select * from Ttable1; drop Ttable1; I know the above syntax doesn't work but it shows the steps I am looking to take. Hope this makes enough sense to be able to answer. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
slaves to specific tables
hey guys - is it possible to have a lightweight slave setup? so that you only take X amount of tables from the DB curious what good solutios are out there
changed directory name
Hi guys, Im really new to this (I only have html background) so if im asking stupid q's please bare with me. I changed my open reallty file name to extreme, when I try to load the file http://localhost/Extreme/admin/index.php in explorer and I keep on getting these errors, I think I have to change the base path, but im unsure of where to change it and how: *Warning*: include(C:/webserver/xampplite/htdocs/open/include/language/en/lang.inc.php) [function.include http://localhost/Extreme/admin/function.include]: failed to open stream: No such file or directory in * C:\webserver\xampplite\htdocs\extreme\admin\index.php* on line *52* *Warning*: include() [function.includehttp://localhost/Extreme/admin/function.include]: Failed opening 'C:/webserver/xampplite/htdocs/open/include/language/en/lang.inc.php' for inclusion (include_path='.;C:\webserver\xampplite\php\pear\') in * C:\webserver\xampplite\htdocs\extreme\admin\index.php* on line *52* *Warning*: require_once(C:/webserver/xampplite/htdocs/open/include/login.inc.php) [ function.require-once http://localhost/Extreme/admin/function.require-once]: failed to open stream: No such file or directory in * C:\webserver\xampplite\htdocs\extreme\admin\index.php* on line *54* *Fatal error*: require_once() [function.requirehttp://localhost/Extreme/admin/function.require]: Failed opening required 'C:/webserver/xampplite/htdocs/open/include/login.inc.php' (include_path='.;C:\webserver\xampplite\php\pear\') in * C:\webserver\xampplite\htdocs\extreme\admin\index.php* on line *54* Im using xampplite. Please help me:) Nix
Re: MySql at 100% CPU
At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote: I need to know why MySql does this. If any person knows how I an identify the problem, please let me know! I think this package helped another person out on this list a couple days ago: http://debaday.debian.net/2007/12/26/mytop-a-top-clone-for-mysql/ HTH, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: slaves to specific tables
I do it all the time, look at: --replicate-do-table In: http://dev.mysql.com/doc/refman/5.0/en/replication-options.html Section of my mysql.conf: # Replication Options replicate_do_table = db.member replicate_do_table = db.company replicate_do_table = db.site replicate_do_table = (etc) Ben Paul Berry wrote: hey guys - is it possible to have a lightweight slave setup? so that you only take X amount of tables from the DB curious what good solutios are out there -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sun and mysql
I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? Greetings from the just wondering... Olaf - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Sun and mysql
[snip] I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? [/snip] Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Prepared SQL statements - Faster performance?
I can't speak to the exact internals of MySQL, but in database practice one *generally* uses prepared statements for two reasons: 1. Security 2. Speed If your system is at all exposed to the outside world *and you at all value your data*, your biggest concern should /absolutely/ be security. By using prepared statements, you reduce the number of places to secure by letting the database do your escaping for you (e.g. database developer's know better what to escape than you). It's actually better than that, but that's a simple explanation. If you're not exposed to the Internet at large, and speed is your concern, prepared statements can give a speed improvement, but not always. The reason for the alleged speed improvement is that generally one prepares the statement once and then aggregates the cost of preparation over more than one execution. Juxtapose with reparsing and executing for every set of arguments, where the plans are largely the same: the parsing phase is duplicate work. But preparation is not always a win. Say I have a table of stored materials. Picking the perfect plan is highly dependent on what data I have, and what data I want. Take this query as an example PREPARE( SELECT material FROM stock WHERE mass = ? ); Presumably, just having an index on 'mass' will make things faster, right? That makes an assumption that I have an evenly distributed set of data. What if 5 billion items in my warehouse are 5kg, and 3 items are 10kg? If I plug in 5kg, my indexes are useless, and are in fact a loss to use. If I plug in 10kg, my indexes are a huge gain. Without knowing before hand what data I'll need, the planner will likely make a poor decision in favor of the best general decision. To answer what you can expect from planning: YMMV. I have had code bases improve from 90 minutes to 5 minutes on the same hardware. I have also had code bases show decreased performance by implementing planning. As the previous poster said, the only way you'll know what *your* speed gain/loss will be, is to do it and find out. You may be surprised. Kevin At 10:56p -0500 on 15 Jan 2008, Moon's Father wrote: To know the exact speed improvement ,you have to have a test yourself append on your hardware mathine. On Jan 15, 2008 11:39 PM, mos [EMAIL PROTECTED] wrote: At 11:25 AM 1/14/2008, Jay Pipes wrote: Are you using the PREPARE STATEMENT server-side syntax or an emulated prepared statement like in PDO? -jay Jay, Currently I'm not using prepared statements at all. Before I switch, I wanted to know how much of a speed improvement I can expect, if any. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Innodb gets disabled
Login to mysql and execute SHOW VARIABLES LIKE 'innodb%'; And email the display Also, show the last 30-50 lines of your error log And let's see if they reveal anything From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 3:04 AM To: Rolando Edwards Cc: MySql Subject: Re: Innodb gets disabled I did the same as you have written, but innodb storage engine is not available now. Even the skip-innodb is commented in my.cnf On Jan 16, 2008 9:43 PM, Rolando Edwards [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: 1) 'mysqldump' all databases to an SQL file 2) Drop all databases 3) Shutdown mysqld 4) Delete the ibdata1, ib_logfile0, ib_logfile1 5) Add innodb_file_per_table to my.cnf (which you already did) 6) Make sure you gave this setting in [mysqld] group of my.cnf innodb_data_file_path=ibdata1:10M:autoextend 7) Start mysqld mysqld should recreate ibdata1, ib_logfile0, ib_logfile1 8) Reload all the databases from the SQL file Give it a try !!! -Original Message- From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2008 7:52 AM To: MySql Subject: Innodb gets disabled Hi all, In order to reclaim the free space from mysql innodb storage engine. I have stopped the mysql server, remove all the things from data (to create new datadirectory and log files) directory, added innodb_file_per_table component in my.cnf. Restarted mysql server. After restarting mysql -server innodb engine gets disabled. What can be the issue. Please help me, Even if any body know to enable innodb storage engine in mysql please let me know Thanks Krishna Chandra Prajapati -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road , Secunderabad. Pin Code: 53 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.comhttp://ed-ventures-online.com Email-id: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Re: Sun and mysql
On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay Blanchard [EMAIL PROTECTED] wrote: Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet. Uh, you both have to be kidding comparing MySQL with Youtube and Facebook, right? I'm not saying the $1 billion for MySQL was the right price, I believe it was a bargain for Sun but you are comparing apples and oranges. Go out on the street and ask people if they ever heard of these three. I bet you a few people will know MySQL, a lot will know Facebook and everybody will know Youtube. Youtube and Facebook are websites, visited by millions of people every day. That's what makes it it's value, future and present advertisements. YouTube was even used by CNN for the Republican and Democratic debates. Did you ever hear of MySQL on TV, anywhere? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql
Olaf Stein wrote: I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Two words: Marketing Potential. :) -- Mark Leith, Manager of Support, Americas MySQL AB, www.mysql.com Are you MySQL certified? www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql
I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Olaf On 1/17/08 12:10 PM, Barry Newton [EMAIL PROTECTED] wrote: Olaf Stein wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? Greetings from the just wondering... Olaf MySQL A.B., so far as I know, derives income from training, pubs sales, and enterprise support, with expense for salaries, space leases (at least some staff work from home), and equipment. The value of such an organization is inevitably based on somebody's best guess about future revenues. I'm encouraged about the prospects of MySQL when I remember that Sun is a major sponsor of open source application software. - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql
Olaf Stein wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? Greetings from the just wondering... Olaf MySQL A.B., so far as I know, derives income from training, pubs sales, and enterprise support, with expense for salaries, space leases (at least some staff work from home), and equipment. The value of such an Don't forget licensing MySQL. organization is inevitably based on somebody's best guess about future revenues. I'm encouraged about the prospects of MySQL when I remember that Sun is a major sponsor of open source application software. Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
generating numbers from other fields
how can i join three fields Values into one field? so in three select boxes i have date : Projects type 1 - 7 and project type 1 - 6 so the third Filed would be 116200824 generated by the other three fields? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
valuation tangent (was Re: Sun and mysql)
Olaf Stein [EMAIL PROTECTED] wrote: It will be interesting to see if facebook, youtube and alike websites will ever generate enough earnings to cover the costs they were bought for. Just because 50 million people know a website, it does not mean it makes money automatically. The Google model shows that if you can get huge numbers of people to visit your web site(s) *repeatedly*, and target advertising well, you can make gigantic gobs of money. Facebook in particular clearly has the first part down: they've got millions of members who visit the site several times a day every day (and millions more who visit several times a week). I think some of their ways of targeting ads may work out, and their potential for revenue is far more than MySQL's. YouTube... got folded into the existing Google. Google's just trying to make sure every single one of us visits their sites multiple times every single time we get online :) nuts. Maybe I am too old with 30, but I have never even been to facebook. I think that puts you near the current median age on Facebook. The net moves fast! Facebook as a site mainly for 20-somethings is so 2006 :) -- Cos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql at 100% CPU
Hi Kevin, Thanks for the advise. The package you show gives the same output as the 'SHOW PROCESSLIST' output, which I included in my previous email :) The problem I have is that the process list, by 'mytop' or 'SHOW PROCESSLIST' shows the server doing noting. Yet 'top' and other tools show MySQL using 100% CPU I really need any kind MySQL guru who can give me some advise on how to track down and stop my four MySQL servers doing what ever they doing... I think it might be something to do with replication, as it's only my severs which are replication slaves and masters at the same time who tend to do this 100% CPU thing for hours on end... Kind regards, Ben Kevin Hunter wrote: At 3:25a -0500 on 17 Jan 2008, Ben Clewett wrote: I need to know why MySql does this. If any person knows how I an identify the problem, please let me know! I think this package helped another person out on this list a couple days ago: http://debaday.debian.net/2007/12/26/mytop-a-top-clone-for-mysql/ HTH, Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql
You have a point. But, facebook makes NO money at this time, has about 400 employees and Microsoft estimates its values at 15 billion dollars. I simply think this is nuts. Maybe I am too old with 30, but I have never even been to facebook. It will be interesting to see if facebook, youtube and alike websites will ever generate enough earnings to cover the costs they were bought for. Just because 50 million people know a website, it does not mean it makes money automatically. Olaf On 1/17/08 11:37 AM, Peter (MySQL List) [EMAIL PROTECTED] wrote: On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay Blanchard [EMAIL PROTECTED] wrote: Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet. Uh, you both have to be kidding comparing MySQL with Youtube and Facebook, right? I'm not saying the $1 billion for MySQL was the right price, I believe it was a bargain for Sun but you are comparing apples and oranges. Go out on the street and ask people if they ever heard of these three. I bet you a few people will know MySQL, a lot will know Facebook and everybody will know Youtube. Youtube and Facebook are websites, visited by millions of people every day. That's what makes it it's value, future and present advertisements. YouTube was even used by CNN for the Republican and Democratic debates. Did you ever hear of MySQL on TV, anywhere? - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql
Olaf Stein wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? Greetings from the just wondering... Olaf MySQL A.B., so far as I know, derives income from training, pubs sales, and enterprise support, with expense for salaries, space leases (at least some staff work from home), and equipment. The value of such an organization is inevitably based on somebody's best guess about future revenues. I'm encouraged about the prospects of MySQL when I remember that Sun is a major sponsor of open source application software. -- Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql
I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Much bigger market :-) Ability to hype something? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql
I understand the marketing and hype thing. I still have a hard time believing that the net worth is actually that high. I guess we will see in 10 years or so... Maybe facebook should by GM, Ford can use some of that hype On 1/17/08 12:19 PM, Mark Leith [EMAIL PROTECTED] wrote: Olaf Stein wrote: I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Two words: Marketing Potential. :) - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Upcoming Mandatory Changes post-Sun Acquisition
Greetings! Bill Bilano here to chime in on what the Sun acquisition will mean to everyone here! Below you will find a list of changes that may impact how the MySQL Server and Client tools products will be utilized in the future. This list is in no way complete and I believe that additional changes will be announced as I see fit. Now that the big dogs are in the house, it's time to get a few things in line and get our ducks in a row. We need to make sure we don't rock the boat and everyone is carrying their own weight. We don't want any suprises! There are some big changes that are needed in order to compete in this rapidly growing market segment. 1. Now that Sun in large and in charge, you all need to learn up some new rules: HIPPA, SOX, PCI, and GLB. 2. The name of the product is changing to Product SuperNova; no more of this cowboy B.S.! 2. No more of that ISO ANSI SQL junks! Sun is not interestes in that! From now on ALL search queries must be submitsed in accoding with a forthcoming XML DTD! There wont be ANY exceptions! (YES THAT MEANS YOU, MONTY!) 2. The backend must be complete re-writted in 100% pure Java! This is going to be made into a case study in how Java usage can fix the mistakes that bad programmers made! MySLQ seems PERFECT for this! 3. All administor tools need to be redone in SWING! This is the only cross platform widget standard there is and you have to use it. Immediately. 4. Create and Optomize an NFS table storage mechanism! Find a way of doing this. 5. We need something to complete with SQLLite so GET 'ER DONE! LOLLL! 6. Full steam forward on MySQL-FS projet!! this needs to be merged into the primary source trunk... we know that ZFS is balls and Billy goat Gates tried to meet the brokeback demon with YUKON but he couldn't work it. HINT: This is the joker up our hole! 7. Zero tolreance for anybody who gives Theo allowed to access the source tree any more! For any reason! Even if he promises! 8. Be ready to do a presentation on why you need to keep your job with MyQSL after the merger. Have this ready for the next board meeting because they will be interviewing all employees! Some of you will be fired so have a plan for this as it is not MySLQ's problem! Now that I've spelledt it all our for you guys, you can thank me! Just as an FYI: _I do not work for MySQL or Sun_... I have some big Suns 6800s in my server room here at the bank and them is some fast, but these are the changes that I see as absolutely ESSENTIAL to the success of the product in the futuer!!! If SUN follows my lead, and I believe they will becacuse of my mile long list of credentials, then we can look forward to wide acceptence of this fantastic product in the futare! (i am IT director for a huge US bank and as such I demand respect, and i typially get it because of my great ideas and tireless devotuoion to the cfommunity!) Thanks for your TIME AND ATTENTION!!! p.S SELECT visit.my.bloglog ON internets AT www.bilano.biz WHEN PRIORITY = now; -- Mr. Billy B. Bilano, MSCE, CCNA, CISSP, and now QISP http://www.bilano.biz/ Expert Sysadmin Since 2003! 'C:\WINDOWS, C:\WINDOWS\GO, C:\PC\CRAWL' -- RMS -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Sun and mysql - sorry
I guess Ford is not a GM brand. Just substitute Ford with a GM brand On 1/17/08 12:23 PM, Olaf Stein [EMAIL PROTECTED] wrote: I understand the marketing and hype thing. I still have a hard time believing that the net worth is actually that high. I guess we will see in 10 years or so... Maybe facebook should by GM, Ford can use some of that hype On 1/17/08 12:19 PM, Mark Leith [EMAIL PROTECTED] wrote: Olaf Stein wrote: I am not judging this move by mysql, as long as it stays open source, this is probably good for the product itself. I just think it is weird that a pure entertainment website (admittedly with lots of users) is estimated at so much more than a software company. Two words: Marketing Potential. :) - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql at 100% CPU
At 12:08p -0500 on 17 Jan 2008, Ben Clewett wrote: The package you show gives the same output as the 'SHOW PROCESSLIST' output, which I included in my previous email :) Heh, that'll teach me to actually /use/ the package before recommending it. :-P (I just found out about it when that article came out, and haven't yet had a chance to try it out.) Good luck with your problem! Kevin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Computerworld reporter would like to hear from you ASAP today, on MySQL,acquisition by Sun...
Todd, I'd be happy to answer all of your questions. See my responses in-line below: What are your impressions of this deal? I think it is fantastic because it means that even more money will be made and this is what Sun's top priority is and represents what they care about, realistically. This is why I use commercial software instead of open-source. Is this good for the MySQL community? Absolutely, Todd. It will help get the errant programmers back on-track with sound software design and solid methodologies. Being able to rely on the sage judgment and wisdom of Sun's proven software developers and technological leadership will only make the community stronger and the products better. Good for MySQL users? Todd, I can't express how much better it will be for end-users! If you take a look at one of my other posts to this very mailing list, you'll see a broad strategy that I've outlined for the future of MySQL. I've put forth a number of proposals including a new MySQL-FS file system, new cross-platform administrative tools, and a renewed focus on the Java language and how it can be used to help MySQL along the road to success. Do you see a downside here? Not yet I don't! Overall, is this a good thing for MySQL and its users or a bad thing? As I've outlined, I think it's a fantastic first-step towards bringing MySQL out of the 20th century and into the 21st. This is nothing but the beginning of a bold new era in the annals of MySQL history. Together, Sun, MySQL, and the community can bring about the change that is needed. Please tell me your thoughts in as much detail as possible. Be sure, please to give me your FULL NAME, Job Title, PHONE NUMBER, e-mail address and what you do for a living -- whether programmer, consultant, etc. My name is Billy B. Bilano. I am the Director of Information Technology at a Major US Bank. If you need anything more, please contact me directly by emailing [EMAIL PROTECTED] and I'll get back to you in short order. Thanks so much for your quick reply! Thank you, Todd, for helping me share with your readers! -- Mr. Billy B. Bilano, MSCE, CCNA, CISSP, and now QISP http://www.bilano.biz/ Expert Sysadmin Since 2003! 'C:\WINDOWS, C:\WINDOWS\GO, C:\PC\CRAWL' -- RMS -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: creating temp file, modifying data and putting into other table
On Jan 17, 2008 2:22 PM, Kerry Frater wrote: Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another whilst making a modification. create temporary table Ttable1 (select * from masterlist where ref='ABCDE'); update Ttable1 set ref='SMI0C001'; insert into sublist select * from Ttable1; drop Ttable1; How about: INSERT INTO sublist (ref, field1, field2, field3) SELECT 'SMI0C001' , field1 , field2 , field3 FROM masterlist WHERE ref='ABCDE' ; Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Computerworld reporter would like to hear from you ASAP today on MySQL acquisition by Sun...
Hello, I'm a reporter at Computerworld magazine and I'm writing a story today on MySQL user and developer reax to the Sun acquisition of MySQL. Can you drop me a note and let me know your thoughts about this ASAP? I'd like to know: What are your impressions of this deal? Is this good for the MySQL community? Good for MySQL users? Do you see a downside here? Overall, is this a good thing for MySQL and its users or a bad thing? Please tell me your thoughts in as much detail as possible. Be sure, please to give me your FULL NAME, Job Title, PHONE NUMBER, e-mail address and what you do for a living -- whether programmer, consultant, etc. Thanks so much for your quick reply! Best wishes, Todd Weiss Computerworld Todd R. Weiss General Assignment Reporter Computerworld Voice: 717-560-5255 [EMAIL PROTECTED] http://www.computerworld.com Computerworld -- The Voice of IT Management
RE: creating temp file, modifying data and putting into other table
Thanks for the input Jochem. I am testing the code using the MySQL Query Browser 1.1.20 and putting the script in a single Query window over multiple lines. The first line create temporary table Ttable1 (select * from masterlist where ref='ABCDE'); works fine (well I don't get any errors). The problem is that when it processes the second line update Ttable1 set ref='SMI0C001'; it tells me that Ttable1 doesn't exist. I thought that temporary files exist for the session? Or am I testing the functionality the wrong way? Kerry -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: 17 January 2008 19:34 To: MySql Subject: Re: creating temp file, modifying data and putting into other table On Jan 17, 2008 2:22 PM, Kerry Frater wrote: Can someone please advise. I am looking to create a multiuser friendly way of getting a subset number of rows from a table into another whilst making a modification. create temporary table Ttable1 (select * from masterlist where ref='ABCDE'); update Ttable1 set ref='SMI0C001'; insert into sublist select * from Ttable1; drop Ttable1; How about: INSERT INTO sublist (ref, field1, field2, field3) SELECT 'SMI0C001' , field1 , field2 , field3 FROM masterlist WHERE ref='ABCDE' ; Jochem -- 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: [SPAM] - Re: Sun and mysql - Email found in subject
-Original Message- From: Olaf Stein [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 12:13 PM To: Peter (MySQL List); MySql Subject: [SPAM] - Re: Sun and mysql - Email found in subject You have a point. But, facebook makes NO money at this time, has about 400 employees and Microsoft estimates its values at 15 billion dollars. I simply think this is nuts. Maybe I am too old with 30, but I have never even been to facebook. It will be interesting to see if facebook, youtube and alike websites will ever generate enough earnings to cover the costs they were bought for. With a perfect business plan I bet it will. Just because 50 million people know a website, it does not mean it makes money automatically. Yes, I agree but once this 50 million visits the website and it would be a different story. Olaf On 1/17/08 11:37 AM, Peter (MySQL List) [EMAIL PROTECTED] wrote: On Thu, 17 Jan 2008 11:07:19 -0500 Olaf Stein [EMAIL PROTECTED] wrote: I am still amazed by the fact that youtube is worth 1.5 billion and MySQL AB barely 1 billion. Did they sell under price? Or does Google just have way to much many to spend/waste? On Thu, 17 Jan 2008 10:14:36 -0600 Jay Blanchard [EMAIL PROTECTED] wrote: Or that Facebook is 'worth' multiple billions when they do not really have a way to make money yet. Uh, you both have to be kidding comparing MySQL with Youtube and Facebook, right? I'm not saying the $1 billion for MySQL was the right price, I believe it was a bargain for Sun but you are comparing apples and oranges. Go out on the street and ask people if they ever heard of these three. I bet you a few people will know MySQL, a lot will know Facebook and everybody will know Youtube. Youtube and Facebook are websites, visited by millions of people every day. That's what makes it it's value, future and present advertisements. YouTube was even used by CNN for the Republican and Democratic debates. Did you ever hear of MySQL on TV, anywhere? - Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. It may contain sensitive and private proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you are not the intended recipient, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. FXDirectDealer, LLC reserves the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them. Unless otherwise stated, any pricing information given in this message is indicative only, is subject to change and does not constitute an offer to deal at any price quoted. Any reference to the terms of executed transactions should be treated as preliminary only and subject to our formal confirmation. FXDirectDealer, LLC is not responsible for any recommendation, solicitation, offer or agreement or any information about any transaction, customer account or account activity contained in this communication. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:
Full Text Search
hi all, i just want to know whether it is useful to alter the 50% threshold scheme that mysql uses by default ,is it beneficial in any way regarding serach(either by increasing or decreasing its value)or is it good to use default value of 50% only. which is better (altering the file to change 50% value or using default 50 %) thanx and regards -- View this message in context: http://www.nabble.com/Full-Text-Search-tp14947073p14947073.html 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]