Mysqlians,
Greetings We have been experiencing a performance problem
that relates to either mysql's buffers of the ext3 file cache. Our
mysql servers are experiencing load spikes due to massive disk reads on
datadir( > 3meg sec). Datadir is a seprate disk. Most of the day the disk
Mysqlians,
Does a low_priority behave like a DELAYED for insert and return
to the caller before the update has actually been executed? If not are
their plans for a DELAYED option with update?
Regards,
Trevor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Mysqlians,
1. How can I tell how many words a fulltext index has indexed?(for
purposes of estimating performance)
2. How can I tell how much index file space a full text is responsible for?
( for regular indicies I use (key_length +4)/.067 ) but my
fulltext's are all on text's.
Thanks,
Tr
Jon,
an update statement is supposed to return the # of rows updated, so the
client must wait for a response, which means the client will wait if you
low_priority your updates. But if they are insert delayed then the
client gets a return immediately. This behavior limits the usefullness
of low
Mysql AB,
What is the roadmap for fully compliant GIS?
" The OpenGIS specification defines the following functions, which MySQL
does not yet implement. They should appear in future releases. When
implemented, they will provide full support for spatial analysis, not
just MBR-based support."
Tha
Steve,
I have had this same problem exept the entire server does not hang, only
one thread which experiences a signficiat slowdown. This happens a
couple times a week for our 4 servers. I believe this is a thread
scheduling issue. The mysql support team suggests against using NPTL.
However, I u
Mysqlians,
I just discovered that a server has ft_min_word_len=4 when I want
ft_min_word_len=3 . Do I have to rebuild all the fulltext indicies so
that searches on three-letter words will work correctly?
Trevor
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
