Re: 'mysqladmin slave-st(art|op)' - is it implemented?
Hello again, Turns out it is implemented - but it's 'stop-slave' and 'start-slave'. Shoulda done a 'mysqladmin --help'. Grepping the source found it. - GW. Date: Wed, 29 Jan 2003 11:19:06 +1100 To: [EMAIL PROTECTED] From: Guy Waugh [EMAIL PROTECTED] Subject: 'mysqladmin slave-st(art|op)' - is it implemented? Hello, I see in the mysqladmin man page for version 3.23.55-1 that 'slave-start' and 'slave-stop' have at least been thought of at some stage (they're listed in the COMMAND SYNOPSIS section), but they don't seem to work when I try them... I've just been through the change logs for version 4, and can't find any mention of them in there... Can anyone tell me whether these options for mysqladmin are implemented? If not, can anyone tell me whether I can tell mysqld to stop or start replicating from a shell script rather than the mysql client? Thanks in advance, Guy. - 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: Increment in update
:+---+--+--+-+-++ :| Field | Type | Null | Key | Default | Extra | :+---+--+--+-+-++ :| id | int(11) | | PRI | NULL| :auto_increment | :| descr | varchar(255) | YES| MUL | NULL| | :+---+--+--+-+-++ : : :mysql update tb_roubr set id=id+1 where id1 order by id; :ERROR 1064: You have an error in your SQL syntax near 'order :by id' at line 1 :why this is not working and what are other ways to do such a query. You are defeating the purpose of auto_increment with id=id+1 expression. Simply pass it a NULL or nothing at all: UPDATE tb_roubr SET id=NULL WHERE id 1; Every time you pass id NULL value, mysql will *auto_increment* the value of the column automaticly so you never have to worry about it. Sherzod - 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: query cache
In the last episode (Jan 29), Rusch (ext) Reiner said: I've got one question which belongs to the new query cache in 4.01. I wonder why the cache should be deleted if there's a statement like update, insert etc. I think it must be considered that there are possible situations where this isn't the best way. For example: 1) select * from DATABASE where DATE = '2002-12-02' 2) update DATABASE set NAME = 'my name' where DATE = '2002-12-01' So 2) would kill the whole cache, but for 1) the update doesn't matter! Wouldn't it be better to look for what selects matters for the cache by updating something in the table??? For simple things like that, yes. But how do you determine what matters? Say you have these queries already cached: /* pretend your orignal record before your query 2) had name='fred' */ 3) SELECT count(*) FROM database WHERE name='bob' 4) SELECT count(*) FROM database WHERE name='fred' 5) SELECT date FROM database WHERE name like '%ame%' 6) SELECT * FROM database MONTH(date) = '12' 7) SELECT incomerange FROM database order by name You can keep the results of 3), but have to clear the rest. How do you distinguish between 1), 3), and the rest? The current cache is fast because it simply does a string comparison of the current query against all cached queries. Forcing it to keep record IDs or field ranges for each cached query would slow the lookup process to the point of uselessness. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: examples of user defined functions
On Wed, Jan 29, 2003 at 09:22:50AM -0500, Bill Lovett wrote: I was reading about user defined functions, and although they sound interesting, I can't find many examples of their use. If anyone is using them, what are you using them for? Are they a way to manipulate data going into a record, or a way to run pre-defined queries? Brian Aker has some examples online @ http://software.tangent.org/ Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Find the highest score for a given name mysql SELECT name, max(score) FROM high_score GROUP BY name; Email signature rotated by Signify v1.10 http://www.debian.org/ - 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: datetime field question
:is there a way to use the date part of a datetime field that :still uses the :index on the datetime field? i've tried a few different things :and it keeps :saying in the explain it says that its a possible_key, but :NULL for the key I'm not sure if this ignores the indexes or not, but I mostly use DATE_FORMAT(). Assuming column t is a DATETIME column: SELECT DATE_FORMAT(t, %Y-%d-%m) FROM tbl_name; Have you tried it yet? Sherzod -- mysql,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: unknown table when doing insert...select..where
Hello, I want to do the following query INSERT INTO temp_explanations(tip) SELECT tip FROM explanations WHERE explanations.file=temp_explanations.file AND explanations.level=temp_explanations.level; but I'm getting an 'unknown table temp_explanations' error. How can I get around this? Thanks, Donal -- For the largest free email in Ireland (25MB) File Storage space (20MB), visit http://www.campus.ie Powered by Outblaze - 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
setting up mysql for windows...
i'm trying to set mysql up on windows 2000, and having some problems. i download file and installed. what do i have to do to get it running. never done it on windows just linux _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump, exclude table?
At 11:09 -0600 1/29/03, Ray wrote: is they a way to have mysqldump ignore a list of tables, but get everything else? something like: mysqldump -ume -psecret -hserver --all-databases --exclude-tables=server.acctlog No. -- mysql, sql, query, sql, sql, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: linux novice cannot resolve apache-php-mysql linkage.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dander -- ...and then [EMAIL PROTECTED] said... % ... % and file:/var/www/test1.php could not be found using the browser. % note that /var/www/test1.php is the only ?/www/? directory found. I have to hand it to you for your documentation. You've probably done it enough to do it in your sleep by now :-) but it's still very helpful for potential helpers. Nothing in your procedure looks grossly wrong to me, but I also haven't installed any of these any time recently. There is one problem, though. You're missing the server name spec in your URL. Try file:///var/www/test1.php instead; note the two slashes, which are at the beginning of every URL, and the empty server name (the third slash right up against it). That, however, will only give you the contents of the file, since php is parsed by the server instead of the browser. The trick is that before you can get the test1.php file you'll have to make sure it's under your htdocs dir (see your httpd.conf; you didn't mention what you have for your DocumentRoot setting). Once you have test1.php in your DocumentRoot dir, try http://localhost/test1.php and see what you get. By that point you'll probably be in much better shape :-) At this point you're still struggling with getting apache configured and knowing how to talk to it; php and mysql aren't (or don't have to be) even involved. I don't have any particular pointers, but if you still have problems after these steps, start with the apache docs and try to get something simple like a static html page or an image to come up. HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+OJeyGb7uCXufRwARAo+eAKCjnuQzRlCweqioI+X3BM2r7vawewCgjRJb /tiNYWhIBnbZKFR00AcIb2w= =7wym -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
Mysql 4.1 development source build
Hi. Has anyone successfully build Mysql 4.1 from development source in Windows(XP) environment? Been getting this error(?) in cloning and in executing bk -r get -Sq(executed from cygwin) --- You are trying to create a symlink on a win32 file system. This file type is not supported on this platform. --- If I try to proceed more errors and encountered in make or even in running compile-pentium-debug make[2]: *** [os0proc.o] Error 1 make[2]: Leaving directory `/home/usr/mysql-4.1/innobase/os' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/usr/mysql-4.1/innobase' make: *** [all] Error 2 Anybody have an idea why? TIA _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
:
×ð¾´µÄmysql:ÐÂÄêºÃ! ÎÒÃÇÊÇ¡°ºÓÄÏÊ¡ÔÑô»ªÑô±£½¡Æ·³§¡±£¬½ß³ÏÏòÄúÍƼö ÎÒ³§Ö÷µ¼²úÆ·--¡°»ªÑôÅÆ´ÅÁÆÒ©Õí¡±¡£¸ÃÕíÓÉÃû¹óÖÐÒ©¼Ó ´ÅÁƾ«Öƶø³É£¬ÇáËÉ·½±ãÁÆЧºÃ£¬ÎªÖÚ¶àÒÑ»¨ÊýǧԪҽÁÆ ·ÑµÄ»¼Õß½â³ýÁ˶àÄ겡ʹ£¬»ñµÃ¡°»ªÑôÉñÕí¡±µÄÔÞÓþ¡£ [¹¦Ð§ÔÀí]£ºÐÑÄÔ¿ªÇÏ¡¢Õò¾²°²Éñ¡¢ºÍѪͨÂç¡¢ÐÐÆøֹʹ£¬ ͨ¹ý˯ÃßÓëÈËÌåÃÜÇнӴ¥·¢»ÓÉñÆæµÄÖβ¡½¡ÉíЧ¹û¡£ [Ìصã]£º·½±ãÄÍÓ㬸±×÷ÓÃС£»ÄÜͬʱ·ÀÖζàÖÖÂýÐÔ ¼²²¡£»Ö±´ï²¡Ëù£¬Óúºó²»Ò×ÔÙ¸´·¢¡£ [ÊÊÓ¦¼²²¡]£ºÉñ¾Ë¥Èõ¡¢¸üÄêÆÚ×ÛºÏÖ¢£»¸ßѪѹ¡¢ÄÔ¶¯Âö Ó²»¯¡¢¾±×µ²¡µÈ¡£ [ÊÊÓ¦Ö¢×´]£º¶àÄêÂýÐÔÍ·Í´¡¢Í·ÔΡ¢Ñ£ÔÎÖ¢¡¢¾±×µÍ´¡¢Í· »è¶úÃù¡¢Ê§Ãß½¡Íü¡£ [ҽѧͻÆÆ]£º¶ÔÖÐÄ긾Ů»¼²¡ÂʽϸߵÄÉñ¾ÐÔÍ·Í´¡¢Í·ÔÎ, ÕíÓøÃÕíÁ½¸öÁƳ̺óÒ»°ã¿É³¹µ×¸ùÖΣ¬¼ûЧ¿ì£¬ºÜºÃµØ½â ¾öÁËÕâ¸öҽѧÄÑÌâ¡£ [±£½¡Ð§¹û]£º³¤ÆÚÕíÓÿÉÐÑÄÔÒæÖÇ¡¢ìǿÉí¡£ ---ÿ¸öÈ˶¼Àë²»¿ªË¯Õí,ÄúÖ»ÐëÉÙºÈһƿºÃ¾Æ¾ÍÄܺܿìÓµ ÓлªÑôÉñÕí£¬Ëü²»½öÄÜ´Ù½ø˯Ãߣ¬»¹¿ÉÔÚ˯ÃÎÖÐÇáËÉÖβ¡¡£ ÁíÍâ,Ëü»¹ÊÇΪÆÞ×Ó»ò¸¸Ä¸µÈÇ×ÈËÏ×°®ÐĵĺÃÀñÎï¡£ -Ϊ¼õÉÙÖм价½Ú£¬ÌØ¿ªÕ¹ÍøÉÏÖ±Ïú£¬×ÚÖ¼ÊÇ£º 1--ÊÛ¼ÛºÏÀí£¬ÓÉר¼Ò¸ù¾Ý»¼Õß²¡Ç鶨ÖÆ,¸ú×Ù·þÎñ£» 2--¹úÄÚÃâÊÕÓÊ·Ñ£¬Ò»¸öÔÂÄÚÎÞЧÍË¿î,¿ÛÉÙÁ¿Õ۾ɣ» 3--ÓûÏêϸÁ˽â,Çë·¢EmaiË÷Òª²úƷͼƬºÍ[²¡Àý»ã±à]¡£ 4--ÏÖÍ·Í´Í·ÔÎÐÍÓŻݼÛ180Ôª\¸ßѪѹÐÍ150Ôª\´ßÃß±£½¡ÐÍ ½öÊÛ120Ôª,ÒÔÉÏÐͺžùÓÐÆæЧ,»¶Ó×Éѯ¡¢Ñ¡ÓÃ! ³§Ö·£ººÓÄÏÊ¡ÔÑôÏسÇÎÄÑÒ½Ö29ºÅ ÓÊÕþ±àÂ룺453500 ÁªÏµÈË£º Ëïºêΰ ÊÖ»ú£º13072602821 ÁªÏµµç»°£º0373-7282498 Email: [EMAIL PROTECTED] ÍøÖ·£ºhttp://hybjpc.ebigchina.com Ö Àñ! »ªÑôÔÚÏß ¡¡2003-01-30 - 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: Access XP crashes regularly when linked to MySQL via MyODBC
Loren McDonald wrote: Have you done all the office (or at least Access) XP updates? If not, it is possible that one of them my resolve your crash problem. I have been testing Access XP with the same versions of MyODBC and MySQL for a few weeks now and have yet to see a crash. About the only problem I have ran into is MySQL shutting down, for no apparent reason, every so often. I have just installed .55, so I'm waiting to see if it is still a problem. Can't speak for others, but... I've got the latest MDAC (2.7). I have tested with Access XP - bare, Service Pack 1 and Service Pack 2. I have also tried with a few startup switches, eg /safe which was recommended to me by M$ helpdesk. MyODBC options: - Don't Optimize Column Width - Return Matching Rows - Change BIGINT Columns to INT Drifting off topic... Also, not only does the developer version of Access crash, but the deployable, cut-down versions you can make with the packaging wizard also crash similarly. One stange thing I've noticed is that whereas sometimes Access will crash outright, other times it will simply prevent you from exiting the current record. If you try to either: - exit the form, or - move the focus to a sub / parent form, or - move to another record, Access will give an error dialog saying that the current action will halt any running code, even though there is no code running. Pressing either the 'End' or 'Debug' buttons results in the same dialog box re-appearing (in modal form). The only thing you can do at this point is to use the task manager to shut down Access. Also, (nearly finished) the deployable cut-down version, which isn't supposed to have any form / code editing abilities, also gives the 'End' / 'Debug' dialog. The above problem is another reason why I think the bug is in Access. -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.h and c++ problems
Everytime I try to compile with the MySql.h or any other includes with a gcc++ compiler I have many errors. Are there any known issues with a current release of the files that any one knows of? If someone uses C++ to interact with a MySql database, please let me know or send a sample project to me. Currently, I am using Dev-C++ to edit my code. - 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
Storage issue
Hi, I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. Here's an example of how much data could be stored in a year: 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. A typical value could be 25,5624. How much space (in Mb) could this take up after a year do you think? Best regards, Jonas Askås - 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: Increment in update
Am Donnerstag, 30. Januar 2003 00:02 schrieb Dan Nelson: In the last episode (Jan 29), Igor Kutsyy said: Could you help me with this. I`m trying to increment values of primary auto_increment field from table, and ofcourse it is not working. Could you tell me how to construct a query correctly. +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | descr | varchar(255) | YES| MUL | NULL| | +---+--+--+-+-++ mysql update tb_roubr set id=id+1 where id1 order by id; UPDATE statements return no records, so ORDER BY is meaningless. You can't control the order the records are modified. If your problem is that id is a primary key and it won't let you temporarily have duplicate id's, just drop the index, do your update, and recreate it. If you can't drop the index, you can sort of cheat by creating another unindexed column id1, then do three separate updates: SET id1=id, SET id=NULL, then finally SET id=id1. You might be able to do the first two at the same time with SET id1=id, id=NULL, but test it on a scratch table first :) Actually, you _can_ use ORDER BY with UPDATE. It works fine, if you do an update tb_roubr set id=id+1 where id1 order by id DESC on your table. DESC (=descending) means that UPDATE will iterate through the rows from the end (that is the highest number) to top (that is id=1). That way, you keep the primary key unique. What you have done was an implicit ORDER BY id ASC (=ascending), which obviously failed. -- Christian Kohlschütter [EMAIL PROTECTED] http://www.newsclub.de - Der Meta-Nachrichten-Dienst - 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
Getting Images in and out of a Blob
Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. Preferred web scripting is ColdFusion, but PHP/PERL would be helpful too. Thank you for your help. Mike Walth CinoFusion - 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
Storage issue
Hi, I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. Here's an example of how much data could be stored in a year: 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. A typical value could be 25,5624. How much space (in Mb) could this take up after a year do you think? Best regards, Jonas Askås - 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
Storage issue
Hi, I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. Here's an example of how much data could be stored in a year: 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. A typical value could be 25,5624. How much space (in Mb) could this take up after a year do you think? Best regards, Jonas Askås - 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: problems with 3.23.51 on OS X 10.1.5
[NOM] à [ADRESSE] a écrit le 30/01/03 9:52 : 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,queries,smallint 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: This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3126765099_527469 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Hi, I¹ve been getting the same message MySQL Have you found the solution ?? TIA Stephen --B_3126765099_527469 Content-type: text/html; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable HTML HEAD TITLEproblems with 3.23.51 on OS X 10.1.5/TITLE /HEAD BODY FONT FACE=3DVerdanaHi,BR BR I#8217;ve been getting the same messageBR BR Have you found the solution ??BR BR TIABR BR BR Stephen/FONT /BODY /HTML --B_3126765099_527469--
Dropping foreing key without losing data
Hello, Can you tell me how to drop or desactivate a foreign key without losing any data in SQL for MySQL 3.23.51 ? Thanks in advance. JeanClaude - 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
remote connecion problem
Hi there, I'm running a mysql server on Linux RedHat 7.3: Server version 3.23.49-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Locally everything is ok but when I'm trying to connect remotely I always get the error: ERROR 2013: Lost connection to MySQL server during query I have the same error if i'm trying on the server the command: mysql -u catma -p -h myserver The port 3306 is open. There must be a stupid thing wrong somewhere but could you tell me where ? Thanks in advance, -- Eric PS: here is my my.cnf file : [client] port= 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port= 3306 socket = /var/lib/mysql/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=64 set-variable= sort_buffer=512K set-variable= net_buffer_length=8K set-variable= myisam_sort_buffer_size=8M log-bin server-id = 1 [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=20M set-variable= sort_buffer=20M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout - 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: Help - Convert Date from longtext to MySQL date format
* Roger Baklund [...] UPDATE a SET new_date = ( MID(my_date,7,4),'-', MID(my_date,1,2),'-', MID(my_date,4,2)); huh? How did this happen...? I just checked my outbox, and the message I wrote yesterday[1] contained new_date = CONCAT(. It seems as the substring CON has been replaced with a linefeed somewhere along the way...? Anyway, trying again, the correct statement should be: UPDATE a SET new_date = CONCAT( MID(my_date,7,4),'-', MID(my_date,1,2),'-', MID(my_date,4,2)); [1] That was wednesday. With the current long delays on the list, this message will probably not be read until friday... :/ -- Roger sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Recovery in MySql
Hi My tables are of type MYISAM. What exactly REPAIR does? Is this enough? If my database in not consistent is this command will help? Thanks, Inbal -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 10:10 PM To: Inbal Ovadia; MySQL Mailinglist Subject: Re: Recovery in MySql On 1/29/03 5:13 AM, Inbal Ovadia [EMAIL PROTECTED] wrote: Hi All, I have MySql on Windows. Today i had an electrical power interruption in the middle of working. The database remain not consistent and i could not continue working with it. Is there any Recovery after crash mechanism in mySql? Thanks, Inbal If you tables are of type MYISAM (find out with SHOW CREATE TABLE table) then most of the answers are here (myisamchk): http://www.mysql.com/doc/en/Table_maintenance.html Hth/h - 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
Innodb table with auto-increment column doesn't create (err 1005)
Description: Table not creatable How-To-Repeat: mysql create table foo (id int auto_increment,unique key (id)) type=innodb; ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121) mysql create table stundenliste (id int auto_increment) type=innodb; ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key mysql create table stundenliste (id int auto_increment) type=myisam; *SUCCESS* Fix: Unknown. Submitter-Id: [EMAIL PROTECTED] Originator:Matthias Urlichs Organization: noris network AG MySQL support: licence Synopsis: auto_increment innodb tables don't Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.6-gamma (Bitkeeper source) Environment: System: Linux play.smurf.noris.de 2.4.19-586tsc #1 Sun Oct 6 18:00:21 EST 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext --enable-__cxa_atexit --enable-clocale=gnu --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.2 20030124 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g ' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-01-30 01:26 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1102984 2003-01-21 23:15 /lib/libc-2.3.1.so -rw-r--r--1 root root 2337952 2003-01-21 23:15 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-01-21 23:15 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-innodb' '--enable-static' '--enable-shared' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' 'CC=gcc' 'CFLAGS=-O2 -fomit-frame-pointer -g ' 'CXXFLAGS=-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' 'CXX=g++' - 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: sql CSV import
Hi all I am trying to import a csv file from MySQL and keep getting an error on line one. Is there an alternative way to import a csv file other than using phpmyadmin? I exported the file from MySQL but can't import it back in, any ideas? Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setting up mysql for windows...
try running winmysqladmin.exe under mysql folder lewell The content of this email when sent is as full as practical. Due to the settling of the words the contents might not appear as full as it was but the weight remains the same. The contents is being sent by weight and not by volume. - Original Message - From: Stick Dragon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 9:28 AM Subject: setting up mysql for windows... i'm trying to set mysql up on windows 2000, and having some problems. i download file and installed. what do i have to do to get it running. never done it on windows just linux _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: mysqldump, exclude table?
Actually, you might want to play with sed or perl. mysqldump -u root --no-create-info -q --all-databases | sed s/'INSERT INTO acctlog'.*// is a first draft, although perhaps not optimal in speed. It will remove all acctlog inserts from all databases. You might want to play a bit with shell scripting if you need to remove acctlog inserts from only the 'server' database. If you are on windows, I believe you will find some port of sed for that platform as well. best regards, Jeppe -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 30. januar 2003 03:27 To: [EMAIL PROTECTED] Subject: Re: mysqldump, exclude table? At 11:09 -0600 1/29/03, Ray wrote: is they a way to have mysqldump ignore a list of tables, but get everything else? something like: mysqldump -ume -psecret -hserver --all-databases --exclude-tables=server.acctlog No. -- mysql, sql, query, sql, sql, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: Innodb table with auto-increment column doesn't create (err 1005)
Matthias, what have you done? Below you create table 'foo' but mysql answers that it cannot create 'stundenliste.frm'. mysql create table foo (id int auto_increment,unique key (id)) type=innodb; ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121) mysql create table stundenliste (id int auto_increment) type=innodb; ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key mysql create table stundenliste (id int auto_increment) type=myisam; *SUCCESS* I guess you have the table stundenliste in the internal data dictionary of InnoDB, but have somehow managed to delete the .frm file. Look to the file yourhostname.err in the datadir of MySQL. You should find there: heikki@hundin:~/mysql-standard-4.0.6-gamma-pc-linux-i686/bin mysqld 030130 14:15:17 InnoDB: Started mysqld: ready for connections 030130 14:15:48 InnoDB: Error: table test/stundenliste already exists in InnoDB internal InnoDB: data dictionary. Have you deleted the .frm file InnoDB: and not used DROP TABLE? Have you used DROP DATABASE InnoDB: for InnoDB tables in MySQL version = 3.23.43? InnoDB: See the Restrictions section of the InnoDB manual. InnoDB: You can drop the orphaned table inside InnoDB by InnoDB: creating an InnoDB table with the same name in another InnoDB: database and moving the .frm file to the current database. InnoDB: Then MySQL thinks the table exists, and DROP TABLE will InnoDB: succeed. InnoDB: You can look further help from section 15.1 of InnoDB: http://www.innodb.com/ibman.html I tested deleting the .frm file manually and indeed I got: heikki@hundin:~/mysql-standard-4.0.6-gamma-pc-linux-i686/bin mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 4.0.6-gamma-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql create table stundenliste (id int auto_increment,unique key (id)) type=in nodb; ERROR 1005: Can't create table './test/stundenliste.frm' (errno: 121) mysql Regards, Heikki Innobase Oy sql query Subject: Innodb table with auto-increment column doesn't create (err 1005) From: Smurf Date: Thu, 30 Jan 2003 11:04:18 +0100 Description: Table not creatable How-To-Repeat: mysql create table foo (id int auto_increment,unique key (id)) type=innodb; ERROR 1005: Can't create table './test_smurf/stundenliste.frm' (errno: 121) mysql create table stundenliste (id int auto_increment) type=innodb; ERROR 1075: Incorrect table definition; There can only be one auto column and it must be defined as a key mysql create table stundenliste (id int auto_increment) type=myisam; *SUCCESS* Fix: Unknown. Submitter-Id: [EMAIL PROTECTED] Originator: Matthias Urlichs Organization: noris network AG MySQL support: licence Synopsis: auto_increment innodb tables don't Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.6-gamma (Bitkeeper source) Environment: System: Linux play.smurf.noris.de 2.4.19-586tsc #1 Sun Oct 6 18:00:21 EST 2002 i686 unknown unknown GNU/Linux Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.2.2/specs Configured with: ../src/configure -v --enable-languages=c,c++,java,f77,proto,pascal,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-i nclude-dir=/usr/include/c++/3.2 --enable-shared --with-system-zlib --enable-nls --without-included-gettext - -enable-__cxa_atexit --enable-clocale=gnu --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.2.2 20030124 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g ' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 2003-01-30 01:26 /lib/libc.so.6 - libc-2.3.1.so -rwxr-xr-x1 root root 1102984 2003-01-21 23:15 /lib/libc-2.3.1.so -rw-r--r--1 root root 2337952 2003-01-21 23:15 /usr/lib/libc.a -rw-r--r--1 root root 178 2003-01-21 23:15 /usr/lib/libc.so Configure command: ./configure '--prefix=/usr' '--exec-prefix=/usr' '--libexecdir=/usr/sbin' '--datadir=/usr/share' '--sysconfdir=/etc/mysql' '--localstatedir=/var/lib/mysql' '--includedir=/usr/include' '--infodir=/usr/share/info' '--mandir=/usr/share/man' '--enable-shared' '--with-libwrap' '--enable-assembler' '--with-innodb' '--enable-static' '--enable-shared' '--enable-local-infile' '--with-raid' '--enable-thread-safe-client' '--without-readline' '--with-unix-socket-path=/var/run/mysqld/mysqld.sock' '--with-mysqld-user=mysql' '--without-bench' '--with-client-ldflags=-lstdc++' '--with-extra-charsets=all' 'CC=gcc' 'CFLAGS=-O2 -fomit-frame-pointer -g ' 'CXXFLAGS=-O2
Re: Writing a database program in GNU C++ using MySQL.
Hi Prabu, From my own experience I'd say that PHP is the best option since it can be compiled with MySQL support and you will find that accessing the database is very easy. Regards, Eric On Wed, 29 Jan 2003, Prabu Subroto wrote: Dear my friends, My boss wants a database application running on linux machine without XWindows. Is it easy to make the connection to MySQL with GNU C++ . Is perl better then GNU C++ in this case? How is Jave ? TAC. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock is missing - Please....
Hi, I don't know who is receiving my message, but i have an important request on you. I also have the same problem. I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) the file mysqld.sock doesn't exist on the server. I also can't find the file mysql.server. I'm using Debian 3.0. Debian-Package: mysql-server shell mysql --version gives the following: mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) Please help me! Thank you - 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
Changing user passwords
Hi I have problem with passwords. Normal users who have only 'USAGE' global privileges are not able to change their own password. I tried to do fresh installation of mysql 4.0.9 (and 4.0.8) on my windows workstation. I created new user (as root): GRANT USAGE ON *.* TO dummy@localhost; then I logged in as 'dummy' (mysql -u dummy) and tried to change password for dummy: SET PASSWORD=PASSWORD('newpassword'); I got: ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' This functionality worked just fine with mysql 3.23.54. and 3.23.55. What kind of privileges normal user needs in order to change his/her own password? Teemu Kuulasmaa - 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
Replication Problems/Questions
Hi List I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt. I ve setup a replication between these two servers as discribed in the manual and some small problems comes up. Maybe someone can give me some help. 1.) On the Master I create a user repl with the rights 'replication slave'. On the slave I used a user with all possible rights. Starting the replication with 'reset slave', 'change master to.' and 'start slave', I get an error: Show slave status says Slave_IO_running no and some entry in mysql.err. This Problem I could solve using a user in 'change master to ' that has also admin rights. What could cause the problem? 2.) The more important Problem: If the replication is running, and I try to replicate a table where data was inserted on the master with 'LOAD DATA INFILE...' or 'LOAD DATA LOCAL INFILE' the server process on the slaves crushes The files on the master, for LOAD DATA.were still there. Any Ideas? At Last one question: - could anyone explain me the meaning of the fields from show slave status ( I'm looking for a way to decide if the slave has replicated all the data from the master ) Best regards [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
timing
I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [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
copying a row
Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Cardinality doesn't auto start
Grigor, Peter wrote: You need to run [analyze table] to create the index stats...do this reasonable often (once a day for a well-used table). This script will be run on servers around the world by regular people, not sys admins. I will have no control over their databases. Running [optimize table] on the table recreates index stats AND reorganizes/defrags/coalesces data pages...do this once a week or so. The one index I have in this database is on a field which contains TO_DAYS(NOW()). Therefore the return is automatically grouped in the database as each day is written in order. Is there any value in optomizing in this situation? Apparently, this index is working pretty well, as the time to execute the queries has halted at about 12 seconds on the test site and the time doesn't seem to change after optimizing. The rows in this database will not be edited. Deletion should always occur only from the beginning as deletion is be month or year and I can't imagine anyone not deleting the oldest months first. Will this operation cause fragmentation? I'm having a bit of trouble between the order in which I see the data onscreen and how the actual file is written. Look up the mysqlcheck utility--it lets you do this from scrips pretty easy. I see where I can write a script to run these functions, however, getting an end-user to run a script 'later' after the install, we all know is not an easy thing. I simply find it frustating that MySQL does not start its cardinality count automatically when an index is created at the time the table it created. It has been counting perfectly when I create the index after data is in the table. There also seems to be a 'isamchk -a' function which is supposed to jump start the cardinality count. I'm just hoping for a cure to getting this to start by doing something in the install script where there table is created as well as many other config files. Perhaps if cardinality were set to 0 it would begin the count on its own? I can find very little information regarding cardinality and have no idea about how one would set it to 0 if that did work. Peter -- John Hinton - Goshen, VA. http://www.ew3d.com Those who dance are considered insane by those who can't hear the music - 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: Storage issue
* Jonas Askås I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. mysql does not compress data by default, but you can use a tool to make a compressed read only table, see the manual: URL: http://www.mysql.com/doc/en/myisampack.html Here's an example of how much data could be stored in a year: 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. A typical value could be 25,5624. How much space (in Mb) could this take up after a year do you think? A FLOAT occupies 4 or 8 bytes, depending on the precision. 131400 * 4 = 5012 Mb 131400 * 8 = 10025 Mb However, you would normally need to store something more than just the float value, otherwise it would be difficult to use the data for anything... assuming you also need an integer pointer for each value, you would need 4 extra bytes per row, and mysql also occupies 1 byte for a deletion flag, which will give you a total record length of 4+4+1=9 or 8+4+1=13. 131400 * 9 = 11278 Mb 131400 * 13 = 16290 Mb This is the size of the data, an index will require additional space. URL: http://www.mysql.com/doc/en/Column_types.html URL: http://www.mysql.com/doc/en/Storage_requirements.html -- Roger - 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: Storage issue
Here's an example of how much data could be stored in a year: 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. A typical value could be 25,5624. How much space (in Mb) could this take up after a year do you think? You'll find something here : http://www.mysql.com/doc/en/Storage_requirements.html Typically a float is stored on 4 Bytes ( a Byte is 8 bits ). - 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
copying a row
Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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
schema editor
Hello, My name is Dragos Pruteanu, and I am the author of a web-oriented schema editor. The application is free, and because I'm interested to make it known, I am writing this email with the hope I can get your interest and the interest of the mysql comunity. The application is done in java with jsp, is supplied as war and has functionality which makes it interesting for the developers comunity. It can be found at: http://dprutean.tripod.com ( here with a presentation ) or http://www.sourceforge.com/projects/db-org I hope that I can get your interest and help in making it known, Thank you, Dragos Pruteanu __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Left join over more tables
Is it possible to build a query that contains a left join that refers to a table, that in its turn refers to another table? Thanks best regards DI Horst Scheruga - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL dies after FreeBSD 4.6.2-cvsup-4.7
Well, just a suggestion, but if you did not install world (where the threads are) then you have a mismatch between kernel and world. OT (but what the heck!) proper procedure for freebsd cvsup to desired version cd /usr/src mergemaster -p make buildworld make buildkernel KERNCONF=yourkernel make installkernel KERNCON=yourkernel reboot make installworld mergemaster (your favorite otpions eg: -i ) reboot once more. Have several server running 3.23 and 4.0 with no problems. Ken - Original Message - From: Tuc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 29, 2003 11:25 AM Subject: MYSQL dies after FreeBSD 4.6.2-cvsup-4.7 Hi, We just cvsup'd a FreeBSD machine from 4.6.2 to 4.7, made world, and installed a new kernel. Now mysql is complaining : Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) 030129 10:36:35 mysqld restarted Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) 030129 10:36:35 mysqld restarted Fatal error 'Can't create gc thread' at line ? in file /usr/src/lib/libc_r/uthre ad/uthread_create.c (errno = ?) Any ideas where to start? Tried to recompile mysql to see if it just needed that, and it didn't change anything. (This is 3.23.54a) Thanks, Tuc/TTSG Internet Services, Inc. - 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: Storage issue
I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. see chapter 6.2.6 of the mysql manual. 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. float: 4 byte, so you need about 5 gigs? But you will need space for indexes and such as well. So just get an 18 Gig drive for the start. -- [EMAIL PROTECTED] Collaborative Intrusion Detection join http://www.dshield.org - 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
Character problems
Platform: windows MySQL version: 4.0.9-gamma PHP version: 4.3.0 Connected through Command Prompt via MySQL client to local MySQL server. Output from a SELECT query: mysql select * from category; +++---+--+-++ | id | parent | name | num_elements | description | type | +++---+--+-++ | 1 | 0 | materias |0 | 1 | artigo | | 2 | 0 | artigos |0 | 2 | artigo | | 3 | 1 | Tipos de câncer |0 | 3 | artigo | | 4 | 1 | Crianças carentes |0 | 4 | artigo | | 5 | 3 | Leucemia |0 | 5 | artigo | | 6 | 3 | Câncer de pele|0 | 6 | artigo | | 7 | 3 | Notícias |0 | 7 | ultima | +++---+--+-++ 7 rows in set (0.00 sec) mysql exit Bye Note that for the name field, the characters ç, í, â, are all appearing correctly. Now when I select this information from PHP and print it as a webpage, this is what I get: instead of â, ¡ instead of í instead of ç What's up? I used to do this before without any problems. I'm assuming this is some character encoding issue - however, I don't know if its in PHP or in MySQL the problem. Help! Maximo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql replication
You have written the following: Hello dear all, i try to set-up replication, i've configurated master and slave, and on the slave-side i see this log: 030130 17:22:41 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 35 030130 17:22:41 Slave: reconnected to master 'test@master:3306',replication resumed in log 'FIRST' at position 35 030130 17:22:41 Slave: received 0 length packet from server, apparent master shutdown: (0) my sql version: MySQL 3.23.39 any ideas? T.I.A. fabrizio - 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: Configure prob with FreeBSD/Linuxthreads
-O3 on a production server? Mmmm... not good. gcc 2.95 is sometimes buggy, I suggest to use -O alone. gcc -v Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.2.1 [FreeBSD] 20021119 (release) I don't see any reason to use LinuxThreads. What kind of advantages they have? I neved had performance problems on heavy-used databases (7 mil records, 50 tps) on FreeBSD 4.6. Because with native threads, enabling the second CPU (and thus locking MySQL to one thread, one process, -period-, because running another on another port isnt viable) makes the job take just over twice as long. I know jobs and such have to be optimized to use multiple connections. My problem is, enabling that second cpu has more than -halved- my DB performance, and on this server (which houses our CRM and accounting data) that's -unacceptable-. Even if I could justify it with Well, the second CPU is handling lots of other stuff, I still can't ignore that MySQL is still taking twice as long to do things. And I know, it's a FreeBSD problem. I'm waiting for the work done in 5.0 to be evaluated and see if it really does make MySQL work better with native threads. If not, this project can't wait. I'll probably have to coerce the boss into building a separate db server from the others (which wouldn't be so bad) on Linux or Solaris. -j - 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: Storage issue
These two links should help you. http://www.mysql.com/doc/en/Column_types.html http://www.mysql.com/doc/en/Storage_requirements.html I believe you would be using a 4byte field. So.. (1 314 000 000) * (4) = 5 256 000 000 bytes or, 5.256Tb (assuming my calculations are not in error) Huge. - Johnny Withers [EMAIL PROTECTED] p. 601.932.0211 c. 601.209.4985 -Original Message- From: Jonas Askås [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:52 AM To: [EMAIL PROTECTED] Subject: Storage issue Hi, I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. Here's an example of how much data could be stored in a year: 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. A typical value could be 25,5624. How much space (in Mb) could this take up after a year do you think? Best regards, Jonas Askås - 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: MySQL Truncated returns
Hello all- I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored in the column has a space in it (for example, Tampa Bay), it will only return Tampa (I have the length set at 30 so it is not a length issue). I tried changing the column type to text to no avail. I searched the documentation and couldn't figure it out. Can someone provide some insight for me? Thanks- Anna - 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
How can I start my mysql server with max_connections option
Hi Group, I want to start my mysql with max_connections option. Now I am getting To many connction error. So I want to allow 200 concurrent connections... I tried with safe_mysqld max_connections=200 But it is not coming up... How can I set max_connections as 200. Do I need to specify that in my.cnf Please help.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Getting Images in and out of a Blob
:Has anyone done any work with getting images into and out of a MYSQL :database? I have used mysql for some time, but never stored :an image in a :blob field. I am curious on how to insert the image from a :web form upload, :and how to display the picture on another HTML page. Preferred web :scripting is ColdFusion, but PHP/PERL would be helpful too. :Thank you for :your help. http://gallery.handalak.com/cgi-bin/gallery/1004 The above is my web gallery. That's how it works. I have a control panel from where upload images, and they are stored in mysql tables. Then programmaticly they are retrieved. If you look at the source of images tags, you may have an idea how it's done. Sherzod P.S. It's done in Perl - 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: Configure prob with FreeBSD/Linuxthreads
gcc -v Using built-in specs. Configured with: FreeBSD/i386 system compiler Thread model: posix gcc version 3.2.1 [FreeBSD] 20021119 (release) Okay. Because with native threads, enabling the second CPU (and thus locking MySQL to one thread, one process, -period-, because running another on another port isnt viable) makes the job take just over twice as long. This explains your point of view: I never tried to run MySQL on dual-processor machines. that's -unacceptable-. Even if I could justify it with Well, the second CPU is handling lots of other stuff, I still can't ignore that MySQL is still taking twice as long to do things. And I know, it's a FreeBSD problem. I'm waiting for the work done in 5.0 to be evaluated and see if it really does make MySQL work better with native threads. Absolutely. Most of FreeBSD's 4.x kernel functions are not reentrant: to solve the problem of data corruption if two or more cpu's access the same procedure, a global locking mechanism is implemented. What it means, in practice, is that if two processes calls the same kernel function, one has to wait. They are served sequentially. The mechanism worked surprising well for most applications, but not for MySQL. In MySQL, if I recall right, there's one process that forks many threads, one for every request. Threads are splitted to many cpus, but because they compete to access the same functions, some threads have to wait. This could explain why you experience halved performance. In FreeBSD 5.x all kernel functions are fully reentrant. They did a great job in many areas of the OS, often a complete rewrite to gain more performance and features. I've not tested FreeBSD 5.0 and MySQL yet, nor I plan to do it soon, because I'm happy with FreeBSD 4.x in my work. If you do, please let me (us) know. If not, this project can't wait. I'll probably have to coerce the boss into building a separate db server from the others (which wouldn't be so bad) on Linux or Solaris. Multi-cpu support in Solaris is stable, is efficient, has many years of development and it's ready to use. There's probably a reason why MySQL AB develops MySQL on Solaris first. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting Images in and out of a Blob
Mike, Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. You might want to start here: http://www.mysql.com/doc/en/String_functions.html. Look for LOAD_FILE. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Mike Walth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 9:26 AM Subject: Getting Images in and out of a Blob Has anyone done any work with getting images into and out of a MYSQL database? I have used mysql for some time, but never stored an image in a blob field. I am curious on how to insert the image from a web form upload, and how to display the picture on another HTML page. Preferred web scripting is ColdFusion, but PHP/PERL would be helpful too. Thank you for your help. Mike Walth CinoFusion - 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: mysql.sock is missing - Please....
Thomas, I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Is mysqld up and running? Try ps xa | grep mysqld. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Thomas Schlagbauer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 2:04 PM Subject: Re: mysql.sock is missing - Please Hi, I don't know who is receiving my message, but i have an important request on you. I also have the same problem. I installed MySQL on my server and after reboot i got the error message when starting mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) the file mysqld.sock doesn't exist on the server. I also can't find the file mysql.server. I'm using Debian 3.0. Debian-Package: mysql-server shell mysql --version gives the following: mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) Please help me! Thank you - 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: Increment in update
In the last episode (Jan 30), Christian Kohlsch?tter said: Actually, you _can_ use ORDER BY with UPDATE. It works fine, if you do an update tb_roubr set id=id+1 where id1 order by id DESC on your table. Only if you're runing MySQL 4.0. 3.23 does not allow UPDATE .. ORDER BY. Changes in release 4.0.0 (Oct 2001: Alpha) -- * Added `ORDER BY' syntax to `UPDATE' and `DELETE'. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
binary log not recording 4.0.9
I am trying to use replication with 4.0.9. Changes to the datbase are not being recorded in the bin file on the master for a DB called Medic when presented by an application but will if I setup a test table in the DB mysql and use the mysql client to insert/update. At this point I have no idea what to do. Should I sent this to bugs@mysql? Any ideas? sam - 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: FreeBSD bin-log rotation script
On Thursday 30 January 2003 13:47, you 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,queries,smallint 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: Howdy list, Does anyone have a FreeBSD bin-log rotation script that I could use? I'm not sure how to go about rotating the binary logs. Doesn't the index have to stay in sync? Thanks! Matthias - 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
setting auto increment start value
Hi all, I am creating a new table with an auto_increment primary key. How do i tell mysql to start incrementing at a certain value, let say 1000 instead of 1? Thanks, MT -- - 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
FreeBSD bin-log rotation script
Howdy list, Does anyone have a FreeBSD/MySQL bin-log rotation script that I could use? I'm not sure how to go about rotating the binary logs. Doesn't the index have to stay in sync? Thanks! Matthias - 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: Replication Problems/Questions
Hi, - Original Message - From: Guddack Thorsten ICM MP SCM GO 21 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 3:44 PM Subject: Replication Problems/Questions Hi List I'm using 2 WinNT-Servers, Sp6 with mysql 4.0.5. max-nt. I ve setup a replication between these two servers as discribed in the manual and some small problems comes up. Maybe someone can give me some help. 1.) On the Master I create a user repl with the rights 'replication slave'. On the slave I used a user with all possible rights. Starting the replication with 'reset slave', 'change master to.' and 'start slave', I get an error: Show slave status says Slave_IO_running no and some entry in mysql.err. This Problem I could solve using a user in 'change master to ' that has also admin rights. What could cause the problem? 2.) The more important Problem: If the replication is running, and I try to replicate a table where data was inserted on the master with 'LOAD DATA INFILE...' or 'LOAD DATA LOCAL INFILE' the server process on the slaves crushes The files on the master, for LOAD DATA.were still there. Any Ideas? IMHO: ...this can happening because on the slave you don't have(...i guess) the file for LOAD DATA.By REPLICATION the slave trying to copy every movement of the master and not the data itself.This means that slave trying to execute LOAD DATA INFILE YOUR_PATH_TO_FILE .and not copy the data from the master. At Last one question: - could anyone explain me the meaning of the fields from show slave status ( I'm looking for a way to decide if the slave has replicated all the data from the master ) Best regards Best Regards, Gelu [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Writing a database program in GNU C++ using MySQL.
Accessing a DB via Java is very easy as well.. IMHO PHP and the like scripts are over rated. You'll have much more flexibility with Java. (If you don't have to worry about firewalls...) Since it sounds like you a C++ person you'll pick up on Java quickly, if you don't know it already. If you have to worry about a firewall then you can still use Java with Servlets but there will be an added learning curve. In that case your probably better off using PHP/JSP, etc From: Kamara Eric R-M [EMAIL PROTECTED] Date: 2003/01/30 Thu AM 07:34:58 EST To: Prabu Subroto [EMAIL PROTECTED] CC: [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Writing a database program in GNU C++ using MySQL. Hi Prabu, From my own experience I'd say that PHP is the best option since it can be compiled with MySQL support and you will find that accessing the database is very easy. Regards, Eric On Wed, 29 Jan 2003, Prabu Subroto wrote: Dear my friends, My boss wants a database application running on linux machine without XWindows. Is it easy to make the connection to MySQL with GNU C++ . Is perl better then GNU C++ in this case? How is Jave ? TAC. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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: timing
They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same time, making your reports slower. A machine with one active connection will run queries a lot quicker than an identical machine with 50 connections. Think about what happens when you try to do 50 things at once :) Is the test server using a localhost connect and the production not? Localhost is a lot faster than TCP/IP when running a large amount of queries. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storage issue
Please don't hijack threads. In the last episode (Jan 30), Jonas Ask?s said: I'm wondering how well MySQL compress data. I'm about to design a database which will hold mainly _a lot_ of FLOAT-values, and since I do not really know how well MySQL compress data or how I could calculate this I'd really appriciate a little guidance. According to http://www.mysql.com/doc/en/Storage_requirements.html, a FLOAT takes up 4 bytes. 1 value/minute are stored = 1440 values/day. 365 days / year. We have 100 different tables with 25 columns each. This makes 100*25*365*1440 = 1 314 000 000 values per year. How much space (in Mb) could this take up after a year do you think? 5.2GB for storing the values themselves, plus whatever you need for indexes and other columns (hopefully an id and timestamp at least). -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: timing
no it is dedicated to the DataWarehouse Report Processor. runs one report at a time from a ReportQueue. both have a local host. Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same time, making your reports slower. A machine with one active connection will run queries a lot quicker than an identical machine with 50 connections. Think about what happens when you try to do 50 things at once :) Is the test server using a localhost connect and the production not? Localhost is a lot faster than TCP/IP when running a large amount of queries. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: timing
You are positive there is nothing else running while you are trying to do your reports? Have you tried keeping an eye on the processlist to see where it is getting stuck and to make sure there is nothing else going on? Where does the production server get its data from? Are their updates going on while you are running your reports? Is the production server tuned for the type of complex queries you are running? -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 12:02 PM To: Jennifer Goodie; [EMAIL PROTECTED] Subject: RE: timing no it is dedicated to the DataWarehouse Report Processor. runs one report at a time from a ReportQueue. both have a local host. Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same time, making your reports slower. A machine with one active connection will run queries a lot quicker than an identical machine with 50 connections. Think about what happens when you try to do 50 things at once :) Is the test server using a localhost connect and the production not? Localhost is a lot faster than TCP/IP when running a large amount of queries. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: timing
one other thing , the girl that made them did it with an Access database copy of the warehouse. I changed the connection to the real Datawarehouse. if that makes any difference Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same time, making your reports slower. A machine with one active connection will run queries a lot quicker than an identical machine with 50 connections. Think about what happens when you try to do 50 things at once :) Is the test server using a localhost connect and the production not? Localhost is a lot faster than TCP/IP when running a large amount of queries. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Configure prob with FreeBSD/Linuxthreads
Because with native threads, enabling the second CPU (and thus locking MySQL to one thread, one process, -period-, because running another on another port isnt viable) makes the job take just over twice as long. This explains your point of view: I never tried to run MySQL on dual-processor machines. *nod*. On a single CPU, native threads gives pretty excellent performance, in both 4.7-R and 5.0-R. I haven't run a single CPU linuxthreads test yet (I think I'll go fire one off...) Absolutely. Most of FreeBSD's 4.x kernel functions are not reentrant: to solve the problem of data corruption if two or more cpu's access the same procedure, a global locking mechanism is implemented. What it means, in practice, is that if two processes calls the same kernel function, one has to wait. They are served sequentially. The mechanism worked surprising well for most applications, but not for MySQL. In MySQL, if I recall right, there's one process that forks many threads, one for every request. Threads are splitted to many cpus, but because they compete to access the same functions, some threads have to wait. This could explain why you experience halved performance. In FreeBSD 5.x all kernel functions are fully reentrant. They did a great job in many areas of the OS, often a complete rewrite to gain more performance and features. I've not tested FreeBSD 5.0 and MySQL yet, nor I plan to do it soon, because I'm happy with FreeBSD 4.x in my work. If you do, please let me (us) know. I have to say, this is the best explanation of why things work the way they do I've seen yet. Thank you. As far as 5.0, the box I'm testing on is running 5.0-R. Compiling with native threads gives near-identical performance to 4.7-R with native threads (however, there is a small performance increase in a couple steps of the job, which is nice to see. Since the hardware configuration did not change, I chalk this up to 5.0-R's rewrite affecting other parts of the equation). My assumption right now (and this is based on not having taken the time to peruse the code, so I'm likely wrong - ignore me if I am) is that MySQL says, OK, we're running on FreeBSD. Do we have more than one CPU present? Yes? OK, lock to one thread. If this is true, we are willing to disable this protective code (if feasible) and see what kind of performance/stability we get out of MySQL on 5.0-R with native threads running full bore, unrestricted. Again, this is just the ramblings of a madman (er, ok, the ramblings of a tired sysadmin :). If not, this project can't wait. I'll probably have to coerce the boss into building a separate db server from the others (which wouldn't be so bad) on Linux or Solaris. Multi-cpu support in Solaris is stable, is efficient, has many years of development and it's ready to use. There's probably a reason why MySQL AB develops MySQL on Solaris first. I wasn't aware that they developed on Solaris first, but I've had first-hand experience of Solaris multi-cpu support. It's -great-. I almost got a chance to replace an Oracle cluster with MySQL (because the support contracts are much cheaper :) in a previous life, but that life got the axe too soon. Again, thanks for that explanation. -j - 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: timing
The warehouse is updated once a month at night , with data from the mainframe. no records are updated or added to these databases in any other way. It is strictly a report database. They reports are ordered from a website. A record is put into a database called ReportQueue the VB app checks the queue and runs the reports one at a time and emails them out. Outlook Express is running in order to email the PDF files to the recipient. I can understand it being SOME slower , but not hours slower. Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 2:12 PM To: Mary Stickney; mysql list Subject: RE: timing You are positive there is nothing else running while you are trying to do your reports? Have you tried keeping an eye on the processlist to see where it is getting stuck and to make sure there is nothing else going on? Where does the production server get its data from? Are their updates going on while you are running your reports? Is the production server tuned for the type of complex queries you are running? -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 12:02 PM To: Jennifer Goodie; [EMAIL PROTECTED] Subject: RE: timing no it is dedicated to the DataWarehouse Report Processor. runs one report at a time from a ReportQueue. both have a local host. Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same time, making your reports slower. A machine with one active connection will run queries a lot quicker than an identical machine with 50 connections. Think about what happens when you try to do 50 things at once :) Is the test server using a localhost connect and the production not? Localhost is a lot faster than TCP/IP when running a large amount of queries. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [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
[ mysqlimport ]
I created a file.sql with mysqldump. mysqldump my_db my_table file.sql What I do to get this file with the mysqlimport? mysqlimport ?? Thanks, e. _ MSN Messenger: converse com os seus amigos online. http://messenger.msn.com.br - 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: copying a row
Hi - Original Message - From: W. Enserink [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 4:34 PM Subject: copying a row Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? It should work something like : set @a:=''; set @b:='' set @n:=''; set a variable for each item which you need to insert in to table. select @a:=ITEM1,@b:=ITEM2...@n:ITEMn from your_table where. insert into your_table values(@a,@b@n) Regards, Gelu regards Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storage issue
On 30 Jan 2003, at 15:41, Roger Baklund wrote: However, you would normally need to store something more than just the float value, otherwise it would be difficult to use the data for anything... assuming you also need an integer pointer for each value, you would need 4 extra bytes per row, and mysql also occupies 1 byte for a deletion flag, which will give you a total record length of 4+4+1=9 or 8+4+1=13. 131400 * 9 = 11278 Mb 131400 * 13 = 16290 Mb Jonas said the tables had 25 floats in each record, so the added integer ID and deletion flag would only occur 1/25 as often. There are 1,314,000,000 values but only 52,560,000 records, and the record size would be 25*4+4+1=105 or 25*8+4+1=205. The total size would then be 5256 * 105 = 5519 MB 5256 * 205 = 10775 MB (using ISO megabytes, 10**6, as opposed to mebibytes, 2**20). -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - 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: timing
oh and my test server is my PC , so I had all kinds o crap running on it at the same time. Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [EMAIL PROTECTED] -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 1:57 PM To: Mary Stickney; [EMAIL PROTECTED] Subject: RE: timing They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. The production server is probably trying to do other stuff at the same time, making your reports slower. A machine with one active connection will run queries a lot quicker than an identical machine with 50 connections. Think about what happens when you try to do 50 things at once :) Is the test server using a localhost connect and the production not? Localhost is a lot faster than TCP/IP when running a large amount of queries. -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 6:08 AM To: [EMAIL PROTECTED] Subject: timing I have 2 Crystal Reports 8.5 (for the record I didn't make these reports) that draw straight from the MYSQL database. They use only 1 table. I am calling them to print from VB 6.0 Theses reports have lots of complex calculations in them, counts , sums and groups. My test server has the same code , same database , same indexes , same amount of memory as the Production server, My test server has MYSQL 3.23.51 and MYODBC 3.51 , and I have Crystal installed on my test server. The Production server has MYSQL 3.23 and an older version of MYODBC then I have. No Crystal Reports installed. And the server is a faster machine then mine. They run in 8 minutes on my test server , about 4 minutes each. Printing to a PDF driver. On the Production Server they take HOURS to run and print. Any ideas... Mary Stickney TAG-TMI Data Warehouse Programmer 402-474-7612 x 3099 [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
Fulltext Index
If I create a FULLTEXT index for 2 or more columns in a table will I be able to use it for a MATCH only against a single column (of the above) or do I have to create additional FULLTEXT indices for each of these columns? Thanks/h sql,query,queries,smallint - 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: Increment in update
Am Donnerstag, 30. Januar 2003 19:57 schrieb Dan Nelson: In the last episode (Jan 30), Christian Kohlsch?tter said: Actually, you _can_ use ORDER BY with UPDATE. It works fine, if you do an update tb_roubr set id=id+1 where id1 order by id DESC on your table. Only if you're runing MySQL 4.0. 3.23 does not allow UPDATE .. ORDER BY. Changes in release 4.0.0 (Oct 2001: Alpha) -- * Added `ORDER BY' syntax to `UPDATE' and `DELETE'. This should be pointed out in the documentation at http://www.mysql.com/doc/en/UPDATE.html -- Christian Kohlschütter [EMAIL PROTECTED] http://www.newsclub.de - Der Meta-Nachrichten-Dienst - 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: copying a row
On Thu, Jan 30, 2003 at 04:13:17PM +0100, W. Enserink wrote: Hi all, Im in need of some tps. I want to copy a row in a table to a new row in the same table except for the unique ID. Is there some mysql statement for this? Dear Wilbert, INSERT ... SELECT almost allows you to do this, however you cannot select from the same table that you are inserting into. You will need to do something like this: CREATE TEMPORARY TABLE temp SELECT field_1, field_2, field_3 FROM table WHERE field_1 100; INSERT table (field_1, field_2, field_3) SELECT (field_1, field_2, field_3) FROM temp; DROP TABLE temp; Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com Using and Managing MySQL MySQL Training: Hamburg, March 24-28, 2003 Visit http://mysql.com/training for more information Gosh, Batman. The nobility of the almost-human porpoise. --Robin, the Boy Wonder - 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