- discuss - lists.mariadb.org

[Maria-discuss] 5.5.35 memory usage
by ImperialNetwork 10 Feb '14

10 Feb '14

Hi, Running a mysqltuner.pl scan tells the following: [--] Up for: 6d 15h 31m 3s (139M q [242.402 qps], 2M conn, TX: 427B, RX: 16B) [--] Reads / Writes: 95% / 5% [--] Total buffers: 2.0G global + 2.3M per thread (175 max threads) [OK] Maximum possible memory usage: 2.4G (31% of installed RAM) However , it seems to be using more than what mysqltuner reports (3.3G now): [~]# ps -eo comm,rss|awk '{arr[$1]+=$2} END {for (i in arr) {print arr[i]/1024, i}}'|grep -v '^0 '|grep mysqld 3314.3 mysqld my.cnf: [mysqld] user = mysql extra_port = 3308 default_storage_engine = MyISAM sql-mode = NO_ENGINE_SUBSTITUTION # DATA STORAGE # datadir = /databases/mysql # MariaDB # thread_handling = pool-of-threads optimizer_switch ='mrr=on' optimizer_switch ='mrr_sort_keys=on' optimizer_switch ='mrr_cost_based=off' optimizer_switch ='join_cache_incremental=on' optimizer_switch ='join_cache_hashed=on' optimizer_switch ='join_cache_bka=on' mrr_buffer_size = 1M aria_pagecache_buffer_size = 128M aria_sort_buffer_size = 128M key_cache_segments = 8 # MyISAM # key_buffer_size = 256M myisam_recover = BACKUP,FORCE myisam_sort_buffer_size = 128M group_concat_max_len = 4096 max_seeks_for_key = 1000 #myisam_use_mmap = 1 # SAFETY # max_allowed_packet = 32M max_connect_errors = 1000 local-infile = 0 # CACHES AND LIMITS # tmp_table_size = 128M max_heap_table_size = 128M query_cache_type = 1 query_cache_size = 128M query_cache_limit = 1M query_cache_min_res_unit = 2K max_connections = 175 max_user_connections = 75 thread_cache_size = 32 open_files_limit = 50K table_definition_cache = 10K table_open_cache = 40K join_buffer_size = 1M sort_buffer_size = 512K read_buffer_size = 256K read_rnd_buffer_size = 256K # INNODB # sysdate_is_now = 1 innodb = FORCE innodb_strict_mode = 1 innodb_flush_method = O_DIRECT innodb_log_files_in_group = 2 innodb_log_file_size = 256M innodb_flush_log_at_trx_commit = 2 innodb_file_per_table = 1 innodb_buffer_pool_size = 1536M innodb_read_io_threads = 4 innodb_write_io_threads = 4 innodb_io_capacity = 400 # LOGGING # slow_query_log = 1 long_query_time = 5 connect_timeout=30 interactive_timeout=120 wait_timeout=120 Is this some memory leak problem , problems with the script or normal behavior ? Thank you in advance, Alexandru

2 1

[Maria-discuss] New Question: I am trying to find the latest MariaDB equivelent of the MySQL reference manual
by AskMonty KB 09 Feb '14

09 Feb '14

Hello, A new question has been asked in "MariaDB FAQ" by robsilver: -------------------------------- For example I am trying to determine regarding using implicit and or explicit Locking e.g Issolation Levels , Locking , transactions processing via [FOR UPDATE | LOCK IN SHARE MODE] I have not found a lot out there but if there is an equivalent PDF file that would be great. I currently have the book: MariaDB Crash Course which I can not find one reference to LOCK IN SHARE MODE or FOR UPDATE. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/i-am-trying-to-find-the-latest-mariadb-equivelent-…

3 2

[Maria-discuss] New Question: What should I know if I am moving database from Oracle to MiriaDB?
by AskMonty KB 08 Feb '14

08 Feb '14

Hello, A new question has been asked in "Does MariaDB support..." by jimwu: -------------------------------- Hi, I am trying to find what difficulty would I meet if I move database from Oracle to MariaDB? Are there similar functions in MariaDB like functions in Oracle, like material view or snapshot....? Best Regards, Jim Wu -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/what-should-i-know-if-i-am-moving-database-from-or…

2 1

[Maria-discuss] New Question: CONNECT engine windows
by AskMonty KB 06 Feb '14

06 Feb '14

Hello, A new question has been asked in "CONNECT Table Types" by jpser2: -------------------------------- with mariadb 10.07 installed on windows, how to setup engines, particulary CONNECT engine We do appreciate your effort to produce an efficient product with many engines capabilities, But in your web site communication , it is not obvious that all the soultions exposed ( in particular, ENGINES) are effective, anf it they are : on what OS can they be installed. Thanks for answer -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/connect-engine-windows/

1 0

[Maria-discuss] Connect engine assistance needed with nested first node in XML
by Rasmus Johansson 04 Feb '14

04 Feb '14

Hi, I'm trying to parse GPX files, which are XML with the connect engine. They look like this: <?xml version="1.0" encoding="UTF-8"?> <gpx version="1.1" creator="runtastic - makes sports funtastic, http://www.runtastic.com"> <trk> <trkseg> <trkpt lon="-0.7057708501815800" lat="51.4470825195312003"> <ele>76.6089172363281</ele> <time>2013-08-12T18:17:25.000Z</time> </trkpt> <trkpt lon="-0.7059442996978760" lat="51.4470443725586009"> <ele>72.1513061523437</ele> <time>2013-08-12T18:17:28.000Z</time> </trkpt> <trkpt lon="-0.7059520483016970" lat="51.4470558166503977"> <ele>75.0039749145508</ele> <time>2013-08-12T18:17:30.000Z</time> </trkpt> </trkseg> </trk> </gpx> Once I have the Connect -engine enabled I do the following: create table GPXSource ( lat char(20) field_format='@', lon char(20) field_format='@') engine=CONNECT table_type=XML file_name='/home/rasmus/nodegpxmariadb/public/uploads/runtastic_20130812_2157_Running.gpx' tabname='gpx/trk/trkseg' option_list='rownode=trkpt'; It doesn't work, I cannot figure out how to tell the Connect engine that the data I'm interested is beneath the gpx/trk/trkseg -node (tabname). If I remove the trk and trkseg -nodes from the data and just have the gpx -node left and all trkpt -nodes inside it everything works perfectly. Any help is appriciated. BR, Rasmus -- Rasmus Johansson, VP Engineering MariaDB | t: +358 50 499 9589 | Skype: ratzpo

3 8

[Maria-discuss] Threadpool benchmarks / feature note
by Colin Charles 01 Feb '14

01 Feb '14

Hi! Svoj: this is MDEV-5533 (https://mariadb.atlassian.net/browse/MDEV-5533) XL: Can you think about doing benchmarks like Ranger has done? (http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scala…) Thanks -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

2 2

[Maria-discuss] New Question: Maximum number of columns
by AskMonty KB 30 Jan '14

30 Jan '14

Hello, A new question has been asked in "MariaDB FAQ" by robpaton: -------------------------------- Hi there, What is the maximum number of columns a row can have in MariaDB? I can't find this info anywhere on the web. Best regards, Rob -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maximum-number-of-columns/

4 7

Re: [Maria-discuss] Threadpool benchmarks / feature note
by Colin Charles 30 Jan '14

30 Jan '14

Hi XL, On 28 Jan 2014, at 18:20, Axel Schwenke <axel(a)mariadb.com> wrote: > Hi Colin, > >> XL: Can you think about doing benchmarks like Ranger has done? (http://www.mysqlperformanceblog.com/2014/01/23/percona-server-improve-scala…) > > I did those benchmarks for 5.5. The r/w benchmark looked much worse than > what Percona has here. That's why I blogged results for readonly workload only. > > But they test with much more data - that might make the difference. I agree > that this benchmark should be repeated with 10.0. http://www.mysqlperformanceblog.com/2014/01/29/percona-server-thread-pool-i… Ranger has now responded (if he's reading this list, Hi!) cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

3 3

[Maria-discuss] GSoC 2014
by Rushi Shukla 30 Jan '14

30 Jan '14

Hello I am a student of Dhirubhai Ambani Institute of Information and Communication Technology (DAIICT), Gandhinagar, India. I am really interested in going for GSoC 2014. I would like to contribute to MariaDB community and for it to be my mentoring organisation for GSoC 2014. I am highly dedicated towards programming and research. How do I get started on working with the source code and playing around with it? Any sort of help is highly appreciated.Awaiting your reply soon. Regards, Rushi Shukla irc : rushboy

2 1

[Maria-discuss] Mariadb upgrade issues
by Constantine 27 Jan '14

27 Jan '14

Recently we migrate to mariadb and every version upgrade failed (last failed from 10.0.6 to 10.0.7). After investigation I find this thread http://mirzmaster.wordpress.com/2009/01/16/mysql-access-denied-for-user-deb… after password update issue fixed. I find bug https://bugs.launchpad.net/maria/+bug/983322 but it marked as incomplete -- With Best Regards, Constantine

2 1