Van

Jul
21
answered MySQL not updating a row (zero row(s) affected)
Jul
21
comment MySQL not updating a row (zero row(s) affected)
Yep, and that is the problem!!! Someone added a trigger recently - didn't bother to run it by us DBAs first. A flogging shall be held this evening....
Jul
21
asked MySQL not updating a row (zero row(s) affected)
May
18
awarded Notable Question
Apr
10
accepted shell script + mutt: mutt terminating while loop
Apr
10
asked Recommend a linux VT220 emulator with extensible key-mapping features?
Mar
28
comment Single database won't load MySQL
Make sure the my.cnf file being used on boot is the one you expect. I have seen confusion where people create/use /etc/my.cnf but the init.d script is using /etc/mysql/my.cnf or vice-versa.
Mar
28
comment Mysql search matching multiple values in multiple columns
Statements like column like '%term%' is by definition a full table scan - which is the source of your performance problem. Lets not mention the fact that you are doing it on multiple columns. This is the price you pay for letting your users search for anything in any field. FULLTEXT indexes, as jynus pointed out, may be a solution.
Mar
18
awarded Supporter
Mar
18
awarded Scholar
Mar
18
accepted How to calculate lever force when lever has uniformed distributed load?
Mar
17
revised How to calculate lever force when lever has uniformed distributed load?
added 160 characters in body
Mar
17
awarded Editor
Mar
17
revised How to calculate lever force when lever has uniformed distributed load?
added 160 characters in body
Mar
17
awarded Student
Mar
17
asked How to calculate lever force when lever has uniformed distributed load?
Mar
2
asked LDAP master (provider) crashed and lost. How to promote slave(consumer) to master?
Feb
22
asked Upgrade 12.04->14.04 broke mdadm RAID10. Boot stops
Jan
15
comment Warning: A long semaphore wait
Having a similar issue with 5.6.21. I reported a bug here: bugs.mysql.com/bug.php?id=75517
Jan
9
awarded Supporter
1 2 3 4 5