Mysqlcheck -r very slow on big tables
Hello! :) mysqlcheck -r is very slow when repair big tables (over 4GB data - repair it 1h and 40m). Is there any config option to fasten it. Regards: Kosyo __ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 3.23 and use index
Hello! My Mysql version is 3.23.56. I want to use specific index, but when I use "use index" EXPLAIN gives me that key not used. And when I'don use "use index" mysql uses other index. Where I test this in 4.0.14 with force index it works and the query time is 4x faster with index I choose, then the index mysql use. Is anybody can tell me how to fix this problem. May be the way(sequence) of creating indexes has matter? Thank you! Kosyo __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 3.23 and use index
Hello! My Mysql version is 3.23.56. I want to use specific index, but when I use "use index" EXPLAIN gives me that key not used. And when I'don use "use index" mysql uses other index. Where I test this in 4.0.14 with force index it works and the query time is 4x faster with index I choose, then the index mysql use. Is anybody can tell me how to fix this problem. May be the way(sequence) of creating indexes has matter? Thank you! Kosyo __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql 3.23 and use index
Hello! My Mysql version is 3.23.56. I want to use specific index, but when I use "use index" EXPLAIN gives me that key not used. And when I'don use "use index" mysql uses other index. Where I test this in 4.0.14 with force index it works and the query time is 4x faster with index I choose, then the index mysql use. Is anybody can tell me how to fix this problem. May be the way(sequence) of creating indexes has matter? Thank you! Kosyo __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql - Dual Xeon or Dual Opteron
Hello! :) Our server is very heavy loaded: CPUs states are in 0.0% idle almost all day. Linux 7.3 running myslq 3.23.56 and apache 1.3.27 on 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. Mysql have around 166 threads and perforn over 400 Queries per second. We are going to uprade our server but I'am wondering between new Opteron (1.4GHz)and Xeon (2.4). We are going to choose Dual Xeon solutions but after reading article about Opteron and Xeon performance with Mysql and Linux http://www.aceshardware.com/read.jsp?id=55000261, where Opteron is 38% faster on query than Xeon, I am very confused what to do. If anybody can help with more information about this, I would be very appriated. Kosyo __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with enum and cyrillic symbol 'ÿ'
Hello! I tried to create table with field enum and if there is cyrillic symbol "ÿ" query passes but when i start describe table in others fields names apperes funny characters. If I relplace "ÿ" with "ß" åverythin is Ok. Can anybody give me some advice in this strange situation? I'm using RedHat linux 7.3 with mysql 3.23.49 Kosyo __ 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
mysql and swap
Hello! :) The problem is that after working 5-6 hours without swapping Mysql begin to swap. If I switch off swap with swapoff -a and then switch it on again after 5-6 horis withut swapping Mysql begin to swap again. Can anybody give me some advice? I'm using Apache with mod_perl enabled+mysql OS is Linux RedHat 7.3 kernel 2.4.18-3smp 2 CPU x 1GHz Intel 1 GB RAM SCSI Seagate HDD/with scsi controller which transfer rate is 20MB/s !!! I still can persuade my boss to change it/. Thanks. Bye __ 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
undo command from mysql prompt
Hello! :) Is there a way to undo query. For example if execute from mysql prompt update table set address='something'; and update all row is there a way to undo this action. Thank you. Kosyo __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.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
undo command from mysql prompt
Hello! :) Is there a way to undo query. For example if execute from mysql prompt update table set address='something'; and update all row is there a way to undo this action. Thank you. Kosyo __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.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
InnoDB or MyIsam?
Hello! :) I'm wondering which table type is better and why for web project with about 100 000 customers. May be InnoDB gives better query performance? I'm using now MyIsam, but is this better idea to move to InnoDB? Thank you! :) __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.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
How to select last record?
Hello! :) Is there any chance to select last record in one sql statement? Thanks. Kosyo __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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
Broken table
Hello! :) One of my table suddunly stop working when I try to execute SQL statement it'returns error msg: Got error 127 from table handler Is there a way to repair it. The information in this table i very important for me. Thank you. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.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
Mysql binary logs
Hello! :) I want to ask about binary log - what kind of info it writes and how I can use it. Is this info is connected with optimizing mysql work. Thanks. Kosyo __ Do You Yahoo!? Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.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
Hello! Is there a way to find out bad queries? Also a way for verifing tables? Tnank you
Hello! Is there a way to find out bad query? Also a way for verifing tables? Tnank you __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: release_lock
The problem is that mysql server restarts itself. I read in mysql list that the possible reason is some bad query. I understand that I can find it in the mysqlbinlog. There is 3 queries in it and I repair one, but others were from module Apache::Session. One was this and looks OK but what is the reason to be in mysql bin log? Kosyo __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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
release_lock
Hello there! I'm using Apache-Session module and it seems that everything work properly, but in bin log is this query: DO RELEASE_LOCK("Apache-Session-0c47492fccde576b180ea37fa07de395"); What could be wrong in it? Please help! Kosyo __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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
release_lock
Hello there! I'm using Apache-Session module and it seems that everything work properly, but in bin log is this query: DO RELEASE_LOCK("Apache-Session-0c47492fccde576b180ea37fa07de395"); What could be wrong in it? Please help! Kosyo __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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
MySql 3.23.29 on RedHat 6.2 restarts itself
Hello! My MySql server on RedHat 6.2 restarts itself. In the MySql log writes: Number of processes running now: 0 020116 14:16:16 mysqld restarted 020116 14:16:17 Can't start server: Bind on TCP/IP port: Address already in 020116 14:16:17 Do you already have another mysqld server running on port: 020116 14:16:17 Aborting 020116 14:16:17 mysqld ended\n Can somebody help me! It's urgent. Is the problem in scripts. Do I need to upgrade mysql version. Thank you __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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
Help MySQL
Hello there! I've site with 1000 hits per day. Scripts are written in Perl and use MySQL database. MySQL server works good, but sometimes suddenly crashes. Error log says: Number of processes running now: 0 020113 02:50:41 mysqld restarted 020113 2:50:42 Can't start server: Bind on TCP/IP port: Address already in 020113 2:50:42 Do you already have another mysqld server running on port: 020113 2:50:42 Aborting 020113 02:50:42 mysqld ended\n My OS is Linux RedHat 6.2 RAM 128MB CPU Celeron 500Mhz Please help! Thank you in advance. Kosyo __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - 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