Timeline for MySQL fulltext selection performance
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 5, 2015 at 1:20 | answer | added | appartisan | timeline score: 1 | |
| S Jul 11, 2015 at 17:49 | history | suggested | Lennart - Slava Ukraini | CC BY-SA 3.0 |
Indented attributes in query
|
| Jul 11, 2015 at 16:37 | review | Suggested edits | |||
| S Jul 11, 2015 at 17:49 | |||||
| Mar 5, 2015 at 9:03 | history | tweeted | twitter.com/#!/StackDBAs/status/573408521909362690 | ||
| Dec 28, 2014 at 4:22 | answer | added | RolandoMySQLDBA | timeline score: 2 | |
| Dec 28, 2014 at 4:14 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
added 5 characters in body; edited tags
|
| Jul 24, 2014 at 16:34 | comment | added | user3841653 | Thanks for helping out. 1. It is MyISAM. You can check table create code. 2. Yes I get consistent results if i execute query multiple times. 3. MySQL 5.6.17. SSD HW, 8GB RAM, using a windows 8 machine with WAMP server. | |
| Jul 24, 2014 at 16:25 | comment | added | jynus | Is this the InnoDB version or the MyISAM one? Do you get consistent results if you reexecute it several times? Which MySQL version and what kind of hardware (memory, disk) are you running it on? | |
| S Jul 24, 2014 at 16:04 | history | suggested | jynus | CC BY-SA 3.0 |
formatting
|
| Jul 24, 2014 at 16:02 | review | Suggested edits | |||
| S Jul 24, 2014 at 16:04 | |||||
| Jul 24, 2014 at 15:50 | comment | added | user3841653 | I've added the profile. | |
| Jul 24, 2014 at 15:46 | history | edited | user3841653 | CC BY-SA 3.0 |
added 7 characters in body
|
| Jul 24, 2014 at 13:56 | comment | added | jynus | I must say I am surprised, I have replicated your setup with similar columns and rows in an Amazon micro instance (700Mb of memory, mechanical disks) and I am getting times of 0.01 seconds. Can you profile your query as instructed here stackoverflow.com/questions/11274892/… to try to identify external problems? MySQL Fulltext is limited, but not that bad. | |
| Jul 23, 2014 at 20:17 | history | edited | user3841653 | CC BY-SA 3.0 |
edited title
|
| S Jul 23, 2014 at 20:14 | history | suggested | Shanky | CC BY-SA 3.0 |
formatted code and minor edit
|
| Jul 23, 2014 at 20:13 | review | Suggested edits | |||
| S Jul 23, 2014 at 20:14 | |||||
| Jul 23, 2014 at 20:05 | review | First posts | |||
| Jul 23, 2014 at 20:13 | |||||
| Jul 23, 2014 at 20:05 | history | asked | user3841653 | CC BY-SA 3.0 |