Re: [Maria-discuss] fsync alternative

2019-09-07 Thread Kristian Nielsen
Jure Sah writes: > It would appear that on a typical webserver, the majority of disk i/o > belongs to the MariaDB database process. It would appear it's mostly > waiting on fsync(), which to my understanding is executed at least once > per commit. Group commit can amortise this if there are mult

Re: [Maria-discuss] fsync alternative

2019-09-07 Thread Reindl Harald
Am 07.09.19 um 21:38 schrieb Jure Sah: > On 7. 09. 19 21:03, Jan Steinman wrote: >> I’m using an inexpensive Mac Mini, maxed out with RAM, and a 2GB SSD, >> running NOTHING but MariaDB. I even run it headless, which means all >> the UI processes stay in sleep(3). When I was having web server >> p

Re: [Maria-discuss] fsync alternative

2019-09-07 Thread Jure Sah
Hi, On 7. 09. 19 21:03, Jan Steinman wrote: > I’m using an inexpensive Mac Mini, maxed out with RAM, and a 2GB SSD, > running NOTHING but MariaDB. I even run it headless, which means all > the UI processes stay in sleep(3). When I was having web server > performance issues, that was the one thing

Re: [Maria-discuss] fsync alternative

2019-09-07 Thread Roberto Spadim
Maybe buy battery based raid card Em sáb, 7 de set de 2019 às 15:27, Jure Sah escreveu: > Hi, > > It would appear that on a typical webserver, the majority of disk i/o > belongs to the MariaDB database process. It would appear it's mostly > waiting on fsync(), which to my understanding is execut

[Maria-discuss] fsync alternative

2019-09-07 Thread Jure Sah
Hi, It would appear that on a typical webserver, the majority of disk i/o belongs to the MariaDB database process. It would appear it's mostly waiting on fsync(), which to my understanding is executed at least once per commit. I understand that this is extensively researched in the documentation

Re: [Maria-discuss] stability of 10.4.7

2019-09-07 Thread Sergei Golubchik
Hi, Tom! On Sep 07, Tom Ryan wrote: > Sep 6 14:37:59 node-2 mysqld[1846]: > /usr/sbin/mysqld(handler_index_cond_check+0x8d)[0x5644f6c7b1fd] > Sep 6 14:37:59 node-2 mysqld[1846]: > /usr/sbin/mysqld(+0x566623)[0x5644f6973623] > Sep 6 14:37:59 node-2 mysqld[1846]: > /usr/sbin/mysqld(+0xbb4ba8)

Re: [Maria-discuss] Thread State: Unlocking tables

2019-09-07 Thread Sergei Golubchik
Hi! On Sep 04, mari...@biblestuph.com wrote: > On 9/3/2019 4:27 PM, Sergei Golubchik wrote: > > On Sep 03, mari...@biblestuph.com wrote: > >> Can someone fill me in as to what's happening behind the scenes > >> when a thread has the state "Unlocking tables?" > > > > It literally does just that, u

Re: [Maria-discuss] stability of 10.4.7

2019-09-07 Thread Tom Ryan
On Fri, Sep 6, 2019 at 5:56 PM Sergei Golubchik wrote: > Hi, Tom! > > On Sep 06, Tom Ryan wrote: > > > > Sep 6 14:37:59 node-2 mysqld[1846]: stack_bottom = 0x7f3271446dd8 > thread_stack 0x49000 > > Sep 6 14:37:59 node-2 mysqld[1846]: > /usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x5644f71dcf4e] >