- discuss - lists.mariadb.org

[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

[Maria-discuss] Guidance required
by Rushi Shukla 26 Jan '14

26 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

2 1

[Maria-discuss] New Question: Stable release of 10.0
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "What is in the different MariaDB releases?" by pranava: -------------------------------- Hi, In which month there will be a stable release of 10.0? We are using 5.5.34 and want to upgrade to 10.0 but are waiting for a stable release. Thanks Pranav. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/stable-release-of-100/

1 0

[Maria-discuss] New Question: Asynchronous Replication with Galera Cluster ?
by AskMonty KB 24 Jan '14

24 Jan '14

Hello, A new question has been asked in "Galera" by nicolasblanc: -------------------------------- My question is simple. Today i have a Galera Cluster with 3 nodes to write/read. And i want to put one(more to come) slave (asynchronous replication) to the cluster. As all my writes are located on 1 node, it's ok. But if i change the node on which the writes come... My slave is not synchronized anymore. I had to change the master of the slave to have the new written node as master. It seems that each galera node write only transactions from "real client" to replication binary log, not the ones from wsrep. Is there a way that i can ask to a Galera cluster node to always write commited transaction on the replication binary log ? Even if the transaction come from wsrep and not "real client" ? Thx in advance, -- Nicolas Blanc. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/asynchronous-replication-with-galera-cluster/

1 0

[Maria-discuss] Software patent?
by Peter Laursen 24 Jan '14

24 Jan '14

I occasionally found this in a Google search: http://www.google.nl/patents/US8510270 What does this mean? Are anybody able to explain what the patent covers that has not been used in MySQL replication for 10+ years before the patent? Does this mean any restrictions for utilizing binary log information in applications? -- Peter -- Webyog

4 6

[Maria-discuss] mysqltuner
by Reindl Harald 22 Jan '14

22 Jan '14

mysqltuner seems to be no longer maintained while you should not take any recommendation blindly it was really usefull over the years, with MariaDB some values are looking wrong Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B) [OK] Query cache efficiency: 48.1% (10M cached / 21M selects) 21M selects out of 15M queries as example :-) it would be pretty cool have a compareable tool (maybe native code) in the MariaDB setup - sadly Bash/PHP are my skills :-( ______________________________________ >> MySQLTuner 1.2.0 - Major Hayden <major(a)mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> Run with '--help' for additional options and output filtering Please enter your MySQL administrative login: root Please enter your MySQL administrative password: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.5.34-MariaDB-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 472M (Tables: 4995) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [!!] Total fragmented tables: 141 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 3d 17h 7m 44s (15M q [47.927 qps], 477K conn, TX: 33B, RX: 3B) [--] Reads / Writes: 92% / 8% [--] Total buffers: 1.8G global + 1.8M per thread (500 max threads) [OK] Maximum possible memory usage: 2.6G (26% of installed RAM) [OK] Slow queries: 0% (2/15M) [OK] Highest usage of available connections: 8% (44/500) [OK] Key buffer size / total MyISAM indexes: 256.0M/189.1M [OK] Key buffer hit rate: 100.0% (328M cached / 71K reads) [OK] Query cache efficiency: 48.1% (10M cached / 21M selects) [OK] Query cache prunes per day: 0 [OK] Sorts requiring temporary tables: 1% (737 temp sorts / 55K sorts) [!!] Joins performed without indexes: 1140 [OK] Temporary tables created on disk: 22% (45K on disk / 201K total) [OK] Thread cache hit rate: 99% (44 created / 477K connections) [OK] Table cache hit rate: 36% (5K open / 14K opened) [OK] Open file limit used: 1% (10K/750K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Adjust your join queries to always utilize indexes Variables to adjust: join_buffer_size (> 1.0M, or always use indexes with joins)

2 2

[Maria-discuss] Statistics/Counters for number SHOW INDEX FROM queries
by Markus Uckelmann 22 Jan '14

22 Jan '14

Hi all, We have a lot of SHOW INDEX FROM queries coming from our ORM layer. Usually there is a mechanism to prevent this but it doesn't seem to work at the moment. To better analyze the problem it would be helpful if we could see how many such queries happened on a server. Is there a counter or a statistic which can provide us this information? We use MariaDB 5.5. Cheers, Shorty

3 4