- discuss - lists.mariadb.org

[Maria-discuss] New Question: Table replication with xtra column on slave
by AskMonty KB 01 Sep '15

01 Sep '15

Hello, A new question has been asked in "MariaDB Community" by rahularman. Please answer it at http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I have one table DailyMetrics on Interim server like below. Mater DB->Secondary DB--> Interim DB Master DB: Table DailyMetrics ( a char,b char Secondary DB: Table DailyMetrics ( a char,b char Interim DB: Table DailyMetrics ( a char,b char, InsertTime timestamp default current_timestamp) Replication is working fine but added column InsertTime on interim DB is storing 000.000.00 00-00-00 value. It is not storing current system timestamp. When I issue separate insert statement on slave side, it is storing system time but nor with replication. Can anyone suggest me how to achieve system timestamp on slave side. Other details as follows: MySQl DB: MariaDB 5.5.23 Replication Type: Row based. Platform: Linux -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/table-replication-with-xtra-column-on-slave/

1 0

[Maria-discuss] New Question: Login Question
by AskMonty KB 31 Aug '15

31 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/login-question/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to log into a remote MairaDB and keep getting Host [IP] is not allowed to connect to this mariadb server. {client side} tried both mysql -p --port=3307 -h [hostname] mysql -p --port=3307 -h [hostname.domain.xxx] {server side} mysql login accounts tried user/root @ %.domain.xxx user/root @ hostname% Both client and server are in DNS and resolvable. What or how does mariadb determine when to use an IP vs hostname with connection security ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/login-question/

1 0

[Maria-discuss] Double linked list
by Roberto Spadim 28 Aug '15

28 Aug '15

hi guys, i'm with some doibts... I'm trying to replicate a double linked list, my information is: 1) insert at position xxx (and move others to next position) 2) update position yyyy 3) change position zzz with www 4) delete position xxxx to vvvv 5) return all positions 6) return positions with value > zzz My doubt is... I have only one writer and many many readers, writer can't be blocked for more than 1-3 seconds Some times i need to read history (functions 1 to 6) and recreate the linked list at a point in time List is something like: Position - json structure (arraylist in c#) like 0-[0,1,2,4,5] 1-[2.3,4,8,0] It update very fast, minimal update interval is 0.001second (max of 1000updates per second) for each list I will have 100-2000 lists --- Doubts : 1) Whats the best method to create the current double linked list? (The list positioned at last operatiom) A memory table? A row level lock table? A cache solution (memcached) with only one key-value and value with the full list? 2) considering a table: 2.1)what the best method to change position? Update set position=if() where position in (xxx, yyy) In this case what should be the primary key? If i use positionas primary key in this update i cam have non unique values... 2.2) ehat to do with delete/inserts? Insert+update positions? Delete+update positions? 3) any idea if oqgraph could solve this or if there's a storage engine solving this problem? Thanks guys :) -- Roberto Spadim SPAEmpresarial - Software ERP Eng. Automação e Controle

1 0

[Maria-discuss] random non-zero exit status 1
by Reindl Harald 26 Aug '15

26 Aug '15

on machines mysqld mysqld regulary for backup reasons i observe over months now *randomly* starting mysqld fails because exit-code 1 leading in systemd stop the service and start it again while the is no single indication on the mysqld error-log anybody else? ________________________________________________________________________________ Aug 26 01:45:02 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:03 buildserver systemd: Stopped MariaDB Database. Aug 26 01:45:10 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:10 buildserver mysqld: 150826 1:45:10 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31936 ... Aug 26 01:45:10 buildserver systemd: mysqld.service: control process exited, code=exited status=1 Aug 26 01:45:12 buildserver systemd: Failed to start MariaDB Database. Aug 26 01:45:12 buildserver systemd: Unit mysqld.service entered failed state. Aug 26 01:45:12 buildserver systemd: mysqld.service failed. Aug 26 01:45:13 buildserver systemd: mysqld.service holdoff time over, scheduling restart. Aug 26 01:45:14 buildserver systemd: Stopping MariaDB Database... Aug 26 01:45:14 buildserver systemd: Starting MariaDB Database... Aug 26 01:45:14 buildserver mysqld: 150826 1:45:14 [Note] /usr/libexec/mysqld (mysqld 10.0.21-MariaDB) starting as process 31988 ... Aug 26 01:45:14 buildserver systemd: Started MariaDB Database. ________________________________________________________________________________ 150826 1:45:02 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:02 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:02 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:02 [Note] InnoDB: Starting shutdown... 150826 1:45:03 [Note] InnoDB: Shutdown completed; log sequence number 17271831 150826 1:45:03 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:10 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:10 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:10 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:10 [Note] InnoDB: Memory barrier is not used 150826 1:45:10 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:10 [Note] InnoDB: Using Linux native AIO 150826 1:45:10 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:10 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:10 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:10 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:10 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:10 [Note] InnoDB: Waiting for purge to start 150826 1:45:10 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271831 150826 1:45:10 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:10 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:10 [Note] /usr/libexec/mysqld: Normal shutdown 150826 1:45:10 [Note] Event Scheduler: Loaded 0 events 150826 1:45:10 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge 150826 1:45:10 [Note] Event Scheduler: Purging the queue. 0 events 150826 1:45:10 [Note] InnoDB: FTS optimize thread exiting. 150826 1:45:10 [Note] InnoDB: Starting shutdown... 150826 1:45:12 [Note] InnoDB: Shutdown completed; log sequence number 17271841 150826 1:45:12 [Note] /usr/libexec/mysqld: Shutdown complete 150826 1:45:14 [Note] InnoDB: Using mutexes to ref count buffer pool pages 150826 1:45:14 [Note] InnoDB: The InnoDB memory heap is disabled 150826 1:45:14 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 150826 1:45:14 [Note] InnoDB: Memory barrier is not used 150826 1:45:14 [Note] InnoDB: Compressed tables use zlib 1.2.8 150826 1:45:14 [Note] InnoDB: Using Linux native AIO 150826 1:45:14 [Note] InnoDB: Using CPU crc32 instructions 150826 1:45:14 [Note] InnoDB: Initializing buffer pool, size = 16.0M 150826 1:45:14 [Note] InnoDB: Completed initialization of buffer pool 150826 1:45:14 [Note] InnoDB: Highest supported file format is Barracuda. 150826 1:45:14 [Note] InnoDB: 128 rollback segment(s) are active. 150826 1:45:14 [Note] InnoDB: Waiting for purge to start 150826 1:45:14 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 17271841 150826 1:45:14 [Note] Plugin 'FEEDBACK' is disabled. 150826 1:45:14 [Note] Server socket created on IP: '127.0.0.1'. 150826 1:45:14 [Note] Event Scheduler: Loaded 0 events 150826 1:45:14 [Note] /usr/libexec/mysqld: ready for connections. Version: '10.0.21-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 thelounge

1 0

[Maria-discuss] New Question: MariaDB 10.1 system variables
by AskMonty KB 26 Aug '15

26 Aug '15

Hello, A new question has been asked in "What is in the Different MariaDB Releases?" by diptijoshi. Please answer it at http://mariadb.com/kb/en/mariadb-101-system-variables/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- What is the difference between MariaDB 10.1 and MySQL 5.6 system variables ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/mariadb-101-system-variables/

1 0

[Maria-discuss] New Question: SET Variable statement
by AskMonty KB 24 Aug '15

24 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/set-variable-statement/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I'm trying to write a SQL script that creates a database and a few other things. I'm having trouble with a user defined variable statement. SET @dbname = CAST(trees AS VARCHAR(10)); comes directly from https://mariadb.com/kb/en/mariadb/user-defined-variables/ And I keep getting --> Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'VARCHAR(10))' at line 1 Running MariaDB 10.0.20 on SLES 12, I have no idea what the problem is ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/set-variable-statement/

1 0

[Maria-discuss] New Question: Visual Studio - MariaDB - Entity Framework 6+
by AskMonty KB 23 Aug '15

23 Aug '15

Hello, A new question has been asked in "MariaDB FAQ" by vaclav. Please answer it at http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Dear Specialists, We can use at the moment "Visual Studio ADO.NET Driver for MySQL" (https://www.mysql.com/products/connector/) and also there was lots of work done with Visual Studio Integration for MySQL. (http://dev.mysql.com/doc/connector-net/en/connector-net-visual-studio.html). The question is while now it is compatible with MariaDB and I can use MariaDB instead of MySQL, how long if at all there will be a point when this won't become anymore compatible. Is this connection compatibility related with a core or some layer in MariaDB which doesn't change and so it should be working in the future. The reason I am asking is to decide with the strategy. I am testing MariaDB with Entity Framework and the driver/connection mentioned above and it is working but what if you deviate from the connectivity at certain point? Thank you. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/visual-studio-mariadb-entity-framework-6/

1 0

[Maria-discuss] problem with optimizer
by Roberto Spadim 21 Aug '15

21 Aug '15

Hi guys I'm running two queries: first: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 it use primary key and key_len =16 but including a new = element [AND oe_tipo='oe' ]: explain SELECT lote_spa,mov_id FROM est_mov WHERE unidade_id=1001 AND lote_tipo='v' AND lote_spa IN (1150150.0,1150532.0,1152187.0,1152361.0,1155813.0,1156244.0,1156654.0) AND item_id=67 AND item_id_red=1423 AND oe_tipo='oe' it use primary key but key_len=4 (near to a full table scan) what's wrong? -- Roberto Spadim

1 2

[Maria-discuss] New Question: Multiple DB instances - in multiple cnf files
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Community" by cisaksen. Please answer it at http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is it possible to breakup the [mysqldx] [mysqld1] .. [mysqld2] .. and so on into multiple cnf. files (like one each) and include them using the !includedir statement ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/multiple-db-instances-in-multiple-cnf-files/

1 0

[Maria-discuss] New Question: PDF or search area
by AskMonty KB 20 Aug '15

20 Aug '15

Hello, A new question has been asked in "MariaDB Documentation" by cisaksen. Please answer it at http://mariadb.com/kb/en/pdf-or-search-area/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a PDF version of the documentation or a way to search the online documentation ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/pdf-or-search-area/

1 0