Timeline for OOM errors when running queries that have a boolean fulltext search?
Current License: CC BY-SA 4.0
9 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Nov 15, 2021 at 1:37 | comment | added | Wilson Hauck | Additional information request, please. Any SSD or NVME devices on MySQL Host server? Post on pastebin.com and share the links. From your SSH login root, Text results of: A) SELECT COUNT(*) FROM information_schema.tables; B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; AND very helpful information, includes - htop OR top for most active apps, ulimit -a for a Linux/Unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, for server workload tuning analysis to provide suggestions. | |
S Oct 30, 2021 at 20:06 | vote | accept | user1031947 | ||
Oct 29, 2021 at 13:51 | answer | added | Rick James | timeline score: 0 | |
Oct 29, 2021 at 4:18 | comment | added | user1031947 | in parallel -- sequential queries seem to not be an issue | |
Oct 29, 2021 at 3:53 | comment | added | Rick James | "If I hammer it a few times" -- sequentially? or in parallel? | |
Oct 29, 2021 at 3:52 | comment | added | Rick James |
How many zillion words match "+s*" ?
|
|
Oct 29, 2021 at 0:51 | vote | accept | user1031947 | ||
S Oct 30, 2021 at 20:06 | |||||
Oct 27, 2021 at 23:10 | answer | added | mustaccio | timeline score: 1 | |
Oct 27, 2021 at 22:51 | history | asked | user1031947 | CC BY-SA 4.0 |