<div dir="ltr"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
The one advantage of having separate databases is for backup purposes.<br>
The thumbnail database in particular can be massive and having it<br>
separate makes it easier especially since it is basically throwaway data<br>
anyway.<br>
<br></blockquote><div><br></div><div>This is true. But still easy to remove or drop the tables related to it.</div><div>Only "problem" would be the backup size, as it would include the thumbnails..</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
The performance of MySQL doesn't really come into it. You can in theory<br>
partition different databases into different locations/disks etc. and<br>
that might be of interest to some but it would be a pretty special use case.<br>
<br>
I think that the correct default would be to use a common name for all<br>
three but allow separate names if required.<br></blockquote><div><br></div><div>I think teh default should be one database also.</div><div><br></div><div>I guess, having the possibility to separate the databases would introduce much more work right? I am not sure.. not a developer.. i only know some about infrastructure .</div><div> </div></div></div>