Re: [Maria-developers] Next steps in improving single-threaded performance

2014-01-28 Thread Kristian Nielsen
Sergey Vojtovich s...@mariadb.org writes: Still a questions mostly to educate myself. According to proc mysqld executable size is something like: VmExe: 12228 kB VmLib:6272 kB I assume the above refers to overall instructions. Level 1 instruction cache size is like

Re: [Maria-developers] Review request for a fix for MDEV-5506

2014-01-28 Thread Sergei Golubchik
Hi, Alexander! On Jan 28, Alexander Barkov wrote: These types of bug are annoying. We've fixed a lot of them. I hoped to extend the new code gradually for non-static strings as well: - to fix String::c_ptr*() not to use realloc if constructor knows that the value is null terminated. -

Re: [Maria-developers] Next steps in improving single-threaded performance

2014-01-28 Thread Axel Schwenke
Hi Kristian, Kristian Nielsen wrote: I have been analysing CPU bottlenecks in single-threaded sysbench read-only load. I found that icache misses is the main bottleneck, and that profile-guided compiler optimisation (PGO) with GCC gives a large speedup, 25% or more. (More details in my

Re: [Maria-developers] Next steps in improving single-threaded performance

2014-01-28 Thread Kristian Nielsen
Axel Schwenke a...@askmonty.org writes: Wow. 25% is a lot. Have you also tried compiling MySQL 5.6 with PGO? No. Because if that gets the same improvement, we haven't won anything in the comparison. On the contrary, if the same works for MySQL 5.6 (and it seems likely it will), then we have

Re: [Maria-developers] The Monty Program AB vendor check (rpm)

2014-01-28 Thread Oden Eriksson
tisdagen den 28 januari 2014 11.30.01 skrev Colin Charles: On 25 Jan 2014, at 16:26, Sergei Golubchik s...@mariadb.org wrote: Hi, Oden! On Dec 03, Oden Eriksson wrote: I got assigned to look at the rpm packaging and fixed some stuff there, but got stuck at the Monty Program AB vendor