maria-discuss team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

.. to some @MariaDB: We need a 'moderator' here!

-- Peter

On Sat, Nov 22, 2014 at 1:25 PM, Peter Laursen <peter_laursen@xxxxxxxxxx>
wrote:

> @harald .. I really do not understand why you continue this discussion.
> Can't you understand that the problem has been SOLVED? I also cannot accpet
> the *tone* here "please don't discuss on that level". , On the opposite I
> can only understand that you have a much too big **EGO** to interact with
> other people in a proper way.  I asked why MariaDB asked much more memory
> than comparable servers.  Wlad provided the answer: the Maria DB 10.1
> Windows installer sets a larger buffer for innodb_buffer_pool_size (and all
> the other settngs you list don't matter much - except for max_connections
> if P_S is enabled)
>
> Windows Control Panel  .. System ..Advanced System Settings ..
> Performance.. Advanced .. Virtual Memory (translated from Danish Windows
> interface).  Please see attached image. Maybe you should learn a little bit
> about Windows? There is (only) one disadvantage of this setting: if the
> system crashes because o fmemory exhaustion, there will be no stack trace
> saved.
>
> . and @harald.  I'd like to ask you to ignore my mails to the maling llist
> for the future.  Frankly I have been extremely irritated by you several
> times before. If the communications channel her was a Forums system and not
> a mailing list, I would have blocked you long ago. You are EXTREMELY
> ANNOYING AND IRRITATING! And sometimes very rude too (and not only to me, I
> have noticed).
>
> -- Peter
>
> On Sat, Nov 22, 2014 at 11:58 AM, Reindl Harald <h.reindl@xxxxxxxxxxxxx>
> wrote:
>
>>
>> Am 22.11.2014 um 11:50 schrieb Peter Laursen:
>>
>>> My Windows installation does not have virtual memory as I turned it off
>>>
>>
>> virtual memory != swap, please don't discuss on that level until
>> you understand basic operation system tasks, a prerequisite to
>> talk about memory usage at all
>>
>> http://en.wikipedia.org/wiki/Virtual_memory
>>
>> just the fact that you try to compare memory usage outputs of Unix and
>> Windows 1:1.... no better i don't say the rest
>>
>>  (I don't need it as I have sufficient physical memory not to have it). I
>>> have now set InnoDB buffer size to 1G for MySQL 5.6  5.7 as well as
>>> Maria DB 10.0 and 10.1. That is more than enough for my needs. The
>>> MariaDB instances now show total allocated memory ~2.5 G (5.5. and 10.0)
>>> and  ~1.5 G (10.1). The MySQL instances ~1.5 G.
>>>
>>
>> there is a ton of other tuneables
>>
>> query_cache_limit                       = 512K
>> query_cache_min_res_unit                = 1K
>> query_cache_size                        = 128M
>> query_cache_type                        = 1
>> table_cache                             = 15000
>> thread_cache_size                       = 600
>> table_definition_cache                  = 768
>> tmp_table_size                          = 512M
>> max_heap_table_size                     = 512M
>> key_buffer_size                         = 256M
>> sort_buffer_size                        = 320K
>> read_rnd_buffer_size                    = 256K
>> join_buffer_size                        = 320K
>> read_buffer_size                        = 128K
>> preload_buffer_size                     = 128K
>> myisam_sort_buffer_size                 = 128M
>> innodb_buffer_pool_size                 = 5120M
>> innodb_buffer_pool_instances            = 5
>> innodb_purge_threads                    = 1
>> innodb_max_purge_lag                    = 200000
>> innodb_max_dirty_pages_pct              = 60
>> innodb_additional_mem_pool_size         = 32M
>> innodb_log_file_size                    = 512M
>> innodb_log_buffer_size                  = 256M
>> innodb_thread_concurrency               = 0
>> innodb_thread_sleep_delay               = 10
>> innodb_flush_log_at_trx_commit          = 2
>> innodb_support_xa                       = 1
>> innodb_lock_wait_timeout                = 50
>> innodb_table_locks                      = 0
>> innodb_checksums                        = 0
>> innodb_file_format                      = barracuda
>> innodb_file_per_table                   = 1
>> innodb_open_files                       = 600
>> innodb_io_capacity                      = 400
>> innodb_read_io_threads                  = 4
>> innodb_write_io_threads                 = 4
>> innodb_doublewrite                      = 1
>> innodb_adaptive_flushing_method         = keep_average
>> innodb_flush_method                     = ALL_O_DIRECT
>> innodb_stats_on_metadata                = 0
>> transaction-isolation                   = READ-COMMITTED
>>
>>  On Sat, Nov 22, 2014 at 11:33 AM, Reindl Harald <h.reindl@xxxxxxxxxxxxx
>>> <mailto:h.reindl@xxxxxxxxxxxxx>> wrote:
>>>
>>>
>>>     Am 22.11.2014 um 11:08 schrieb Peter Laursen:
>>>
>>>         On a side-remark (if someone is interested) the numbers
>>> displayed in
>>>         Task Manager for the VM running SuSE with MariaDB 10.0.9 must be
>>>         incorrect (ther is a full OS runnnig and with a lot of server
>>>         programs -
>>>         LDAP, Apache etc. etc.).  It seems that Windows does not get true
>>>         information  from the VM process. Also when task manager
>>>         displays 19-20
>>>         GB of memory use in total, Windows will start complaining that
>>> it is
>>>         about to run of of memory and programs should be closed  So it
>>> seems
>>>         that around 10 GB memory used by VMs are unaccounted for when it
>>>         happens.
>>>
>>>
>>>     windows has alsao the concept of virtual, shared and real memory and
>>>     thes same problem as unix telling how how much an application is
>>>     using because that mix
>>>
>>>     the real problem of that thtead is that you *must not* compare two
>>>     mysql/mariadb installations until you made 100% sure they are using
>>>     the same buffer and cache configuration and have the same dataaset
>>>     and uptime
>>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>