RE: MySQL Thread Pool Plugin + Percona Server?

(I'm not using such.) Would you explain what your application is doing that would push the limits of thread concurrency? > -Original Message- > From: Singer Wang [mailto:w...@singerwang.com] > Sent: Wednesday, October 31, 2012 2:08 PM > To: mysql@lists.mysql.com > S

MySQL Thread Pool Plugin + Percona Server?

Hey, I'm looking to combine the benefits of the MySQL Thread Pool Plugin and Percona-Server. All the benchmarks show that the Thread Pool Plugin handles higher concurrency much better then just setting innodb_thread_concurrency. Alas Percona server has many tweaks that improve performance.

MySQL Thread Memory Usage

Hello all, I am looking for a way to view the max values that have been used by all threads or a signal thread for read_buffer, read_rnd_buffer, sort_buffer, and net_buffer. I want to know these values so that I can turn them appropriately. Regards, --Dave David W. Juntgen Medical Informati

Re: Locks acquired with get_lock() persisting, even after MySQL thread has exited

Adam Newby wrote: Description: We have distributed applications which make extensive use of the get_lock() function to acquire a system-wide lock. Occasionally, all copies of a given application block attempting to acquire a lock on the same lock string. Using is_used_lock() repo

Locks acquired with get_lock() persisting, even after MySQL thread has exited

Description: We have distributed applications which make extensive use of the get_lock() function to acquire a system-wide lock. Occasionally, all copies of a given application block attempting to acquire a lock on the same lock string. Using is_used_lock() reports

mysql thread resource control?

Hello list, Is it possible to limit the mysql thread resource? Say, when there is a heavy-load query, it will not use 99% of the cpu time and afect other system processes. Idea? -- Patrick Hsieh <[EMAIL PROTECTED]> GPG public key http://pahud.net/pubkeys/pahudatpah

Re: MySQL thread hanging on Win2K

Hi Sinisa, Sinisa Milivojevic wrote: > > There are several possibilities. You could be reaching some OS limits > or haning user / group permission problems. Don't think its permissions, since I had a similar process which ran fine, but I had to change the schema to use the last insert id for ot

Re: MySQL thread hanging on Win2K

Chris Withers writes: > Hi, > > I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables. > > I'm running an import process which inserts a big set of rows ('bout 27 > million), as part of a document indexing process. Each new row uses the > AUTO_INCREMENT_ID from the previous

MySQL thread hanging on Win2K

Hi, I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables. I'm running an import process which inserts a big set of rows ('bout 27 million), as part of a document indexing process. Each new row uses the AUTO_INCREMENT_ID from the previous row. So, I have a loop which basica

mysql & thread

Hi, all... I configured for mysql-3.23.33 below: --prefix=... --enable-static --with-pthread --enable-thread-safe-client -- with-unix-socket-path=... --with-tcp-port=... --with-charset=euc_kr At first, --prefix, --with-unix-socket-path and --with-tcp-port options is used because already