Design help

2013-04-20 Thread Neil Tompkins
Hi I'm creating the following basic tables COUNTRIES countries_id name REGIONS region_id countries_id name CITIES cities_id region_id Using joins I can obtain which country each city belongs too. However, should I consider putting a foreign key in the CITIES table referencing the countries_i

Re: Troubleshoot excessive memory usage in InnoDB

2013-04-20 Thread Denis Jedig
19.04.2013 23:39, Ilya Kazakevich: Try to use "tuning-primer.sh": this scripts reads your variables and prints memory size you need for that. I tried that. The results are inconspicious: MEMORY USAGE Max Memory Ever Allocated : 5.27 G Configured Max Per-thread Buffers : 1.92 G Configured Max