[Maria-discuss] New Question: Phenomenon of read-only queries performance

2016-02-02 Thread AskMonty KB
Hello, A new question has been asked in "MariaDB Community" by knizhnik_g. Please answer it at http://mariadb.com/kb/en/phenomenon-of-read-only-queries-performance/ as the person asking the question may not be subscribed to the mailing list. We are evaluating

Re: [Maria-discuss] intentionally corrupting tables

2016-02-02 Thread Justin Swanhart
Hi, If you don't mind corrupting more than just the database (such as open memory mapped files) then you can also try this in your VM: sudo dd if=/dev/zero of=/dev/mem :D On Tue, Feb 2, 2016 at 9:46 AM, Reindl Harald wrote: > > > Am 02.02.2016 um 15:12 schrieb Federico

Re: [Maria-discuss] intentionally corrupting tables

2016-02-02 Thread Reindl Harald
Am 02.02.2016 um 15:12 schrieb Federico Razzoli: I am looking for a way to intentionally corrupt a table in a "natural" way. Of course I can open a file with Vim and change random characters, but I would probably obtain a kind of corruption that never occurs in the real world. The purpose is

Re: [Maria-discuss] Adding timestamp column to a system

2016-02-02 Thread Sergei Golubchik
Hi, Peter! On Jan 29, Peter Mclarty wrote: > Hi All > Running Mariadb 10.0.16 and need to add a timestamp column to a table with > has around 60m rows > > Testing on lesser hardware instances suggest around 40 minutes to make this > change on the production system. > > To reduce the down time I