New answers tagged

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

You have to change fields/tables encoding to utf8_spanish_ci or utf8_spanish2_ci so you can save spanish characters.


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


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


0

It seems like just the session id would be 'unique' for defining the User? And maybe a separate table would hold the multiple bell_mode values for each user? You have to think through the application to figure out what is "unique"; we cannot do it for you. CURDATE() is a date, not a datetime. NOW() is a datetime. CURDATE() < ring_date -- before ...


0

You have several issues that need to be addressed. ISSUE #1 : Index column order If you have to delete data by date, the the ring_date should be the first column in the index. ISSUE #2 : Index uniqueness The index should not be unique. Why ? If two or more ring events occur at the same time, the unique index prevents subsequent insertions after the first ...


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


0

What is the problem? There are 11 items, you get 10, then you get 1? But you don't like that? You would prefer to simply show all 11 and be finished? If so, use LIMIT 12 (or 20 or whatever); see if you get only 11; if only 11, then show all of them; if more than (whatever), show only 10 and plan for a new page later. Or is the problem about "clustering" ...


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


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


0

Using the hint Rick James provided, I came up with the following. I'm not sure about efficiency, but it gives me the results I was looking for. SELECT testData.questionUUID, COUNT(testData.answerUUID) AS wrongAnswerCount FROM testData LEFT JOIN answerData ON answerData.uuid=testData.answerUUID LEFT JOIN testHistory ON ...



Top 50 recent answers are included