don't create dynamic tables

Image via Wikipedia

If you are creating a table dynamically, that most likely means you do not understand relational database ideology and as a result doing something wrong.
Just create all the tables at application setup from ready made dump and do not create any tables at runtime.
No need to use dynamic table name at all.
taken from:
http://stackoverflow.com/questions/3665784/php-pdo-prepared-statements-dont-work-when-creating-a-table

Related articles

• SQLiteDatabase: Create multiple tables dynamically at runtime? (stackoverflow.com)
• Map multiple tables to a single entity dynamically (stackoverflow.com)

wordpress sqlite

Sudah bisa buat wordpress jalan dengan backend database sqlite, tinggal test bisa jalan pake nginx apa enggak?

catatan dari http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html

The warning against sharing a data directory among servers also applies in an NFS environment. Allowing multiple MySQL servers to access a common data directory over NFS is a very bad idea.

• The primary problem is that NFS is the speed bottleneck. It is not meant for such use.

• Another risk with NFS is that you must devise a way to ensure that two or more servers do not interfere with each other. Usually NFS file locking is handled by the lockd daemon, but at the moment there is no platform that performs locking 100% reliably in every situation.

Make it easy for yourself: Forget about sharing a data directory among servers over NFS. A better solution is to have one computer that contains several CPUs and use an operating system that handles threads efficiently.