Hot answers tagged

2

please refer to this link? this should answer your question Yes, 100% reasonable to make use of the MySQL caching system! How to "warm up" a cold DB server? Warm-up is needed because the best performance of a database is achieved when its various caches are populated with the most relevant data, since reading from memory is generally ...


2

MySQL is completely capable of serving as your full text search engine. InnoDB FTS indexes are reasonably good. With the size you described it should all fit in memory but of course that depends on the other tenants on the shared hosting. If it's not available (you mentioned shared hosting) you can implement your own pretty easily. Full text search is just ...


1

The answer is simple... MySQL WorkBench! Enables migrations from the following systems. SQL Server, Access, PostgreSQL, SyBase, etc... Manage migration projects Source & Target selection Object migration Version upgrades Here's the link... http://www.mysql.com/products/workbench/migrate/ Price is good too! ;-) -Tony


1

Check and log/dump the insert/update queries - this looks to me as if the php code somehow recodes your data. The 00f1 is the hexadecimal representation of the character ñ and in the form \u00f1 it might be used as an special/escape sequence (for example in JSON).


1

I often query a 170K-row table using InnoDB FULLTEXT. (Avg: 300 words.) I typically get the answer of a few dozen rows in under 200ms. That 200ms drops to below 20ms if the cache is warm. I don't think the number of documents in the table matters as much as the number of documents returned. If you need to fetch the text for 100 documents (after ...


1

No need to store them in php. Creates a table excactly like the one specified, Note: copies only columns CREATE TABLE tbl_name LIKE db_name.tbl_name; If you want specific column names: CREATE TABLE tbl_name SELECT column_name, column_name FROM db_name.tbl_name; Then if you want to copy all the data do INSERT INTO tbl_name SELECT * FROM ...



Only top voted, non community-wiki answers of a minimum length are eligible