Van

23h
awarded Nice Question
Feb
2
awarded Yearling
Feb
2
awarded Nice Answer
Feb
2
awarded Yearling
Jan
25
awarded Notable Question
Jan
4
awarded Peer Pressure
Jan
3
awarded Famous Question
Oct
27
awarded Popular Question
Sep
1
awarded Popular Question
Aug
14
awarded Yearling
Aug
13
accepted MySQL not updating a row (zero row(s) affected)
Aug
12
asked Best practice: Web service to issue sequence numbers
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.
1 2 3 4 5