101 reputation
2
bio website
location
age
visits member for 2 years, 3 months
seen Jan 28 at 15:30

Apr
12
awarded  Commentator
Apr
12
comment MySQL my.cnf Optimization
Are you monitoring the hardware resource usage? What seems to be the bottleneck according to it?
Mar
6
comment mysqld_safe version different than mysqld?
The socket doesn't have a version, it just connects you to a server. How may different mysqld processes do you have?
Mar
5
comment mysqld_safe version different than mysqld?
do you remember installing both versions, and if so in which order did you install them?
Jun
27
comment How to speed up this query
can you post the EXPLAIN of that query?
Apr
24
comment MySQL Character set and Collation Issue.?
check both tables in the "information_schema.tables" table or with "show create table xxx" and see the differences between both tables
Apr
12
comment How to restructure this slow query
which mysql version are you using? can you post the explain for that query?
Apr
10
awarded  Supporter
Feb
29
comment Why is MySQL making the CPU run at about 80%?
I don't know much more than this... see the contents of those files, specially "status", or kill the thread and see what appears in the logs
Feb
28
comment Why is MySQL making the CPU run at about 80%?
try to get information about the thread, in the /proc/<LWP> directory
Feb
28
comment Why is MySQL making the CPU run at about 80%?
In column 5 check for a high value, that's the thread you want; column 4 is its LWP or thread id
Feb
28
comment Why is MySQL making the CPU run at about 80%?
Try "ps -eLf | grep -i mysql | less -S" to see which thread is the one using the CPU