- discuss - lists.mariadb.org

[Maria-discuss] New Question: Aria Max Table Size for internal on-disk temporary tables
by AskMonty KB 17 Jun '13

17 Jun '13

Hello, A new question has been asked in "Aria" by trsystran: -------------------------------- Using MariaDB 5.5.31 (deb file for ubuntu 12.04 amd_64: 5.5.31+maria-1~precise). When a query requires an internal temporary tables, and this tables becomes too large to be kept in ram, the table is moved to disk using Aria engine. If the on-disk .MAD file reaches 4GB, an error occurs: {{{ [ERROR] mysqld: The table '/tmp/#sql_74e_0' is full }}} How can we change this limit? In https://kb.askmonty.org/en/aria-max-table-size/ it is recommended to change MAX_ROW, but it only applies for explicitly created temporary tables. Looking at the code I found this in maria_create(): {{{ data_file_length= ((((ulonglong) 1 << ((BLOCK_RECORD_POINTER_SIZE-1) * 8))/2 -1) * maria_block_size); }}} Which amounts to 4GB with default values (8192 for maria_block_size). I created a new DB with aria-block-size = 32768 (the max value), and it still failed at 4GB. Even if it worked, it would mean the max size is only 16GB, and setting a large block size may have performance penalties. So what is the proper fix to increase this limit? With MyISAM as on-disk temporary tables engine the limit seems to be much higher (at least 14GB from experiments). -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/aria-max-table-size-for-internal-on-disk-temporar…

4 7

[Maria-discuss] New Question: compile mariadb from source
by AskMonty KB 17 Jun '13

17 Jun '13

Hello, A new question has been asked in "MariaDB community" by raph: -------------------------------- i try to compile mariadb from source and got error oqgraph not found, so i put option in cmake command -DWITHOUT_OQGRAPH_STORAGE_ENGINE=1 every thing work fine. my os is opensuse11.4 . how do i compile with oqgraph support. thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/compile-mariadb-from-source/

1 0

[Maria-discuss] New Question: Executing a command file from within a command file?
by AskMonty KB 17 Jun '13

17 Jun '13

Hello, A new question has been asked in "mysql client" by JohnD: -------------------------------- I have a bunch of things I'd like to execute one after the other. A simple example would be: - drop table x; - drop table y; - create table y by executing create_table_y.sql - create table x by executing create_table_x.sql With the mysql command line, I can execute "drop table x;", and I can execute a SQL script with -e "source create_table_x.sql". But what is the good way to bundle all these together into a script which will do all the actions? The only way I can think of is to create a batch file which will call out to mysql for each action. And pass the password as an argument to the batch file. Like this: mysql -u root -p mypassword -e "drop table x;" mysql -u root -p mypassword -e "drop table y;" mysql -u root -p mypassword -e "source create_table_y.sql" mysql -u root -p mypassword -e "source create_table_x.sql" But this seems fairly clunky. Is there a better, or even best practice? John D. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/executing-a-command-file-from-within-a-command-fi…

1 0

[Maria-discuss] Memory Leak?
by Steven Barre 14 Jun '13

14 Jun '13

I'm testing out MariaDB 5.5 as a replacement for MySQL, but it seems to be leaking memory. I can't figure out what is causing the RAM usage to keep growing until oom-killer kills it. Here is the output in TOP. System has 8G RAM. PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 7411 mysql 20 0 8861m 7.1g 5212 S 43.9 92.5 89:12.19 mysqld There are no active connections # mysql -e "SHOW PROCESSLIST\G" *************************** 1. row *************************** Id: 853 User: root Host: localhost db: NULL Command: Query Time: 0 State: NULL Info: SHOW PROCESSLIST Progress: 0.000 System Details # uname -a Linux idxdb-carets 2.6.32-358.6.2.el6.x86_64 #1 SMP Thu May 16 20:59:36 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux # cat /etc/redhat-release CentOS release 6.4 (Final) # rpm -qa MariaDB-server MariaDB-server-5.5.31-1.x86_64 # cat /etc/my.cnf [mysqld] aria_pagecache_buffer_size = 32M aria_sort_buffer_size = 32M datadir = /var/lib/mysql default_storage_engine = InnoDB innodb = FORCE innodb_buffer_pool_size = 2G innodb_file_format = barracuda innodb_file_per_table innodb_flush_log_at_trx_commit = 2 innodb_log_file_size = 128M innodb_log_files_in_group = 2 key_buffer_size = 32M log_error = /var/log/mysql/mysql.log log_queries_not_using_indexes = 1 max_allowed_packet = 16M max_connect_errors = 1000000 max_connections = 100 max_heap_table_size = 32M myisam-recover = FORCE,BACKUP open-files-limit = 65535 pid-file = /var/run/mysql/mysql.pid query_cache_limit = 1M query_cache_size = 16M query_cache_type = 2 slow_query_log = 1 slow_query_log_file = /var/log/mysql/slow.log socket = /var/lib/mysql/mysql.sock sysdate_is_now = 1 table_definition_cache = 1024 table_open_cache = 2048 thread_cache_size = 8 tmp_table_size = 32M user = mysql [mysqld_safe] nice = 0 pid-file = /var/run/mysql/mysql.pid socket = /var/lib/mysql/mysql.sock I just don't understand how it is getting up to 7G when innodb_buffer_pool_size = 2G ? There is a cron running every hour that seems to cause the memory to grow when it runs a query like > REPLACE INTO t1 SELECT * FROM t2; And it would be fine if the memory went up during that and went back down after, but it stays high. Any ideas where I should start digging?

1 0

[Maria-discuss] openbsd switched libmysqlclient back to older mysql one
by Colin Charles 13 Jun '13

13 Jun '13

Hi! I noticed this: http://www.openbsd.org/cgi-bin/cvsweb/ports/databases/mariadb/Makefile?rev=… Revert back to using MySQL 5.1 for the time being. MariaDB 5.5 introduces a new libmysqlclient non-blocking API which utilizes co-routines. The X86 specific GCC ASM co-routine support hid the fact that there was an issue. The only fallback code so far is POSIX user contexts which OpenBSD does not support. Is this something we can fix to ensure that OpenBSD users can continue to use our libmysqlclient? cheers, -colin -- Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles MariaDB: Community developed. Feature enhanced. Backward compatible. Download it at: http://www.mariadb.org/ Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/

2 1

[Maria-discuss] New Question: How to define a date in order to import an empty date from a CSV file?
by AskMonty KB 13 Jun '13

13 Jun '13

Hello, A new question has been asked in "Data Types" by JohnD: -------------------------------- I have a CSV file containing amongst other things a couple of date columns. Some of the date values are empty - that is just ",," - a comma followed by another comma. The date rows in the table are defined like this: `PTY_USR_PASSWORD_DATE` DATE NULL DEFAULT NULL, But when I import the data (using HeidiSQL), I get the following error: /* SQL Error (1292): Incorrect date value: '' for column 'PTY_USR_PASSWORD_DATE' at row 1 */ How should I set up the table to allow this? Or how can I modify the CSV? John D. -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/how-to-define-a-date-in-order-to-import-an-empty-…

1 0

[Maria-discuss] MariaDB 10.0.3-alpha now available
by Daniel Bartholomew 11 Jun '13

11 Jun '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.3. This is an alpha release. MariaDB 10.0 is the development version of MariaDB. It is built on the MariaDB 5.5 series with backported and reimplemented features from MySQL 5.6 and entirely new features not found anywhere else. This is the fourth release in the 10.0 series. We are releasing it now to get it into the hands of any who might want to test it. Not all features planned for the MariaDB 10.0 series are included in this release. Additional features will be pushed in future releases. See the release notes and changelog for details on what is new in this release. Do not use alpha releases on production systems. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 10.0.3 Alpha - Release Notes: http://kb.askmonty.org/en/mariadb-1003-release-notes - Changelog: http://kb.askmonty.org/en/mariadb-1003-changelog - Downloads: http://downloads.mariadb.org/mariadb/10.0.3 Overview of MariaDB 10.0: http://kb.askmonty.org/en/what-is-mariadb-100 APT and YUM Repository Configuration Generator: http://downloads.mariadb.org/mariadb/repositories/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://kb.askmonty.org/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://kb.askmonty.org/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] Clear-text plugin
by Peter Laursen 06 Jun '13

06 Jun '13

"no support for dlopen()" . How does this apply to Windows clients? We always build first on Windows and once we have no errors of any kind we build on Linux if the application exists for that platform (what MONyog does and SQLyog does not) and fix what issues may occur there. This issue has occurred with SQLyog (and as such for a Windows client). I am not coder/developer myself, but on Windows I think we have no other option than statically linking? We could of could compile the API as a .dll, but we don't (because we had a lot of problems with it earlier). -- Peter On Thu, Jun 6, 2013 at 3:25 PM, Sergei Golubchik <serg(a)mariadb.org> wrote: > Hi, Peter! > > On Jun 04, Peter Laursen wrote: > > We have the same problem. We cannot test either. But we have a few user > > reports. We will discuss what we can do. > > > > Is there any parameter or compile-time option we should be aware of? Any > > specific documentation somewhere? Anything? > > Not really. If the cleartext plugin is built and installed, it'll be > used when the server requests it. > > I've just checked that this plugin is present both in rpm and deb > packages. I didn't check binary tarballs, but it should be there too. > > So, there's nothing to configure at run-time or compile-time, everything > should work automatically and transparently. > > Hmm, unless you build a completely static client library with no support > for dlopen(). > > Regards, > Sergei >

2 1

[Maria-discuss] New Question: 100% RAM and Swapping
by AskMonty KB 05 Jun '13

05 Jun '13

Hello, A new question has been asked in "MariaDB community" by danezpz: -------------------------------- Hi, Having recently converted our cPanel servers from MySQL to MariaDB we're having issues with MariaDB using 100% of a servers RAM and swap when a customer optimises a table. This doesn't happen under normal circumstances and only when an optimize is run. Any ideas what's cause this? The servers have 16GB RAM and use the following my.cnf: http://paste2.org/P3cZzBHN Using MariaDB 5.5.30 Any help would be appreciated Thanks -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/100-ram-and-swapping/

1 0

[Maria-discuss] New Question: Schema Missing after upgrading from MySQL 5.5.8 to MariaDB 5.5.31
by AskMonty KB 05 Jun '13

05 Jun '13

Hello, A new question has been asked in "Getting, Installing, and Upgrading MariaDB" by reustmd: -------------------------------- My OS is Windows 7 64-bit. I used the MariaDB msi installer. I uninstalled MySQL and installed MariaDB. I then launched sqlyog and it only found the standard mysql schemas (e.g., information_schema, mysql, performance_schema). My application schema appears to be missing. I also tried running "mysql_upgrade --verbose" and that didn't seem to help. Should I have to do something else? Thanks! -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/schema-missing-after-upgrading-from-mysql-558-to-…

1 0