Tag Info

New answers tagged

2

Foreign keys are not required in order to execute a JOIN. Foreign keys are restrictions that are there for security reasons (so that you cannot change the value of a column, or delete/insert a row ending up with an inconsistent state between tables). It is true that in most cases foreign key are used as JOIN matching conditions. The reasons why InnoDB is ...


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



Top 50 recent answers are included