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://prom

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 t

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 t

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 t

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

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 l

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

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

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 be

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

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 -

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

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

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 --

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 r

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 Ya

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 Ya

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 po

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