Great idea, I want this!

That mysql doesn't support unicode fully took a while to track down.

I thought that i created invald unicode characters somehow.

Hi,

currently I have a great interest in this feature and would like to contribute on getting the requirements down so we can also use the full functionality of our storage engine. Whom to I have to talk with to communicate our imagination?

cheers, Peter

I don't think you will get this right without too much effort and that effort is better used elsewhere, like in making subqueries work in all cases.

Use -ltcmalloc_minimal, not -ltcmalloc. Perf results are at https://code.google.com/p/google-mysql-tools/wiki/SmpPerformance. It helps to expose some of TCmalloc to the dba via: SHOW TCMALLOC STATUS and FREE MEMORY -- see the Google V2 or pending V3 patch for the extensions.

Can the first step to be documenting the interfaces for all system functions?

Use tcmalloc. It has a BSD license, an active community, is being ported to many platforms and is known to make MySQL much faster on some benchmarks -- https://code.google.com/p/google-mysql-tools/wiki/SmpPerformance

Few of the fields in the rusage structure are updated on Linux. I tried it and then switched to code that parses /proc/self/stat and exports the result in SHOW STATUS

Some users have this today via the SHOW USER_STATS patch from Percona and OurDelta.

This would be nice to have but you need new versions of Linux and/or glibc to get this on Linux. And just because the getrusage interfaces are there doesn't mean that you will get per-thread results. We learned this the hard way.