Tag Info

New answers tagged

1

myisamchck did its best job, so that may be the maximum what you can get out of mytable.MYD. The structure of MyISAM record is pretty simple, integers are stored in packed format, strings are prefixed with their length(1 or 2 bytes). So you can write a C program with pre-defined pattern that would try to fetch records of out the MYD file. This approached ...


0

You will need to tune InnoDB with the following innodb_read_io_threads = 8 innodb_write_io_threads = 8 innodb_buffer_pool_size = 512M innodb_log_file_size = 128M innodb_log_buffer_size = 32M You should then download and run mysqltuner.pl You should get output resembling this # ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden ...


1

Basically, you need the following paradigm Session #1 (MySQL) Lock all tables Read Lock Sleep for a Long Time Session #2 (Windows) : This you are already doing Copy the .frm, .MYD, .MYI files for every MyISAM table Session #3 (After Session #2 is Complete) Look for Sleeping Connection of Session #1 Kill the SLEEP Query (Session #1 Will Terminate) ...


0

If you are using transactions, please ensure that you use either a COMMIT or ROLLBACK statement before closing the connection. If this is already the case, you probably need to increase the thread_cache_size value in order to reuse as much as possible the existing connection threads instead of creating new ones from start. Please note the following values: ...


4

To answer your second question: MySQL does not have a parallel query execution engine, so even if you partition the query, you are still single threaded. This will eventually kill your scale. However, you could partition the table by visitor_id. This would allow you to run several queries (one per partition) in parallel, all of them form: SELECT ...


0

Your key_buffer_size is way too big. Since your MyISAM indexes is that small, set it to 128K. You need to open my.cnf and add this under the [mysqld] group header [mysqld] key_buffer_size = 128K; You don't need to restart mysql. Just run this SET GLOBAL key_buffer_size = 1024 * 128; Give it a Try !!! Based on the mysqltuner output, you can drop the ...



Top 50 recent answers are included