Jeremy Zawodny's gcc flags or MySQL AB' for a FreeBSD?
Good day. From these sources: http://jeremy.zawodny.com/blog/archives/000458.html http://dev.mysql.com/doc/mysql/en/FreeBSD.html Jeremy is using -O -march=pentiumpro and MySQL AB -O2 -fno-strength-reduce. Does anyone compared this? Or it make no sense? PS. MySQL 4.x and FreeBSD 4.x -- Best regards, Evgeny. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Many updates or one replace?
Hallo. What is faster: 1) Making about 80 different(!) updates 2) Making one REPLACE kinda REPLACE INTO table VALUES (a,b),(c,d)... on a MYSAM table. P.S. Of course i'm locking table :) P.S.P.S. sql, query -- Have a nice day. - 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 shared lock with JOINs
Hallo. I have this query: SELECT table1.id FROM table1 LEFT JOIN table2 USING(id) WHERE table1.a=1 and table2.b=1 table1 is MyISAM and table2 is InnoDB. I want a shared mode lock on the table2. Is it possible, or i should split this query? -- Have a nice day. - 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
text fields isolation
Hi. For example one have a table with some fields including text(blob). Is it faster at all with SELECTs that doesn't use this(those) text fields if they are moved into another table and linked using primary key or it does not signify? sql,query Best regards Evgeny. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Record dependencies
Ok, what actualy do you wanna do? Sort records by dependencies, then other records(that don't have them) sort in other order(alphabeticaly or in order of appearance in the table)? if it is so you can do this: SELECT fieldName FROM table ORDER BY dependatOn,fieldName(or id - an auto_increment field) sql,query -- Best regards, Evgeny mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ENCODE algorithm
What algorithm do ENCODE-DECODE functions use? sql,query -- Best regards, Evgeny mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with BACKUP TABLE
When try to use BACKUP TABLE, i get an error 'Failed copying .frm file: errno = 2' in the result table. What's the problem? P.S. Unix FreeBSD, MySQL 3.23.40 and type of the table is MyISAM (CHECK works fine). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: problems with BACKUP TABLE
When try to use BACKUP TABLE, i get an error 'Failed copying .frm file: errno = 2' in the result table. What's the problem? RC BACKUP TABLE write files with the user MySQLd is running... RC So if your deamon run as mysql, you had to autorize user RC mysql to write into your backup destination... well... it doesn't work even when i'm dumping it to '/tmp/test.sql'. i suppose '/tmp' is world writable. -- Ñ óâàæåíèåì, Evgeny mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: problems with BACKUP TABLE
RC On mardi, mai 28, 2002, at 09:35 , Evgeny Chuykov wrote: When try to use BACKUP TABLE, i get an error 'Failed copying .frm file: errno = 2' in the result table. What's the problem? Sorry, my stupid mistake. As you said there was problems whith rights and dir 'test' didn't exists in '/tmp', so mysqld couldn't write. Thanks. -- Best regards, Evgeny mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php