Gabriel, in your SHOW VARIABLES, I see a handful of settings that are
much, much larger than normal:
| max_binlog_cache_size | 18446744073709551615
| max_join_size | 18446744073709551615
| max_seeks_for_key | 18446744073709551615
| max_write_lock_count | 18446744073709551615
| myisam_max_sort_file_size | 9223372036854775807
These values appear insanely large to me, especially given you've got
just 4 GB RAM. I'd adjust these down and see what effect that has.
Also, I noticed that your threads_created value seems fairly large
(2701) for about 10 hours of uptime. You might consider upping your
thread_cache size a bit. Doubt this is causing the hangs though.
When the MySQL software hangs, other processes on the machine are still
responsive? Anything of interest in your system log? You mention this
is new hardware ... wonder if you could have a problem with it.
Dan
Gabriel PREDA wrote:
Hi list,
Since we bought a better hardware for our dedicated MySQL Server we
have been running into some problems.
We are using:
- Fedora Core 3 - 64bit version
- Kernel: 2.6.9-1.667smp - x86_64
- MySQL 5.0.21-standard - for 64bit
- RAM: 4 GB
- RAID 5 matrix with 3 SCSI disks at 15k rotations
We are using InnoDB tables (with one or 2 exceptions... for some
FullText indexes)...
We are not using transactions... yet !
I'll drop config. details lower...
Still at given moments MySQL hangs... it does not accept connections
anymore...
We can't kill the process... with KILL command... the only thing we
can do is ask the hosting provider to do a HARDWARE reset... and
someone goes to the machine and pushes the reset button... this hppens
at least once a week...
Does this happened to someone else ?
What was the problem ?
Thanx in advance !
--
Dan Buettner
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]