February 2015 - discuss - lists.mariadb.org

[Maria-discuss] New Question: Maria 10.0.15 high CPU/disk usage without queries
by AskMonty KB 16 Feb '15

16 Feb '15

Hello, A new question has been asked in "MariaDB Community" by artemkuchin. Please answer it at http://mariadb.com/kb/en/maria-10015-high-cpudisk-usage-without-queries/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- I just migrated the server from mysql 5.5 to mariadb 10.0.15 It is a web hosting server with about 100 sites on different platforms. So, there are about 100 databases. Most tables myisam, some innodb (mostly joomla 3) Before with mysql CPU load was less than 10%, disk uses by mysqld was also not very high. No, with top and top -mio i see pretty high numbers. mysqld takes from 20 to 30% cpu and 80-100% disk About configuration. It is xeon 4 cores+HT (8 cores seen by OS) with 32GB ram, 2 3TB SATA disks in software mirror. os is FreeBSD 10.1 stable I tried using thread of pools, one thread per connection - all the same The weird think what i show processlist i ass about 20 haning connection without any question. This is is normal, some sites leave connections for a while (mod_perl, php) the weirdness is that thare no queies while 20-30% load of CPU. What is mariddb doing? my.cnf [mysqld] #thread-handling= one-thread-per-connection thread_handling=pool-of-threads thread_pool_size=4 thread_cache_size = 45 init-connect='SET NAMES cp1251' default-storage-engine = MyISAM port= 3306 socket= /hoster/tmp/mysql.sock skip-external-locking skip-networking slow_query_log=1 slow_query_log_file=/hosts/MYSQLDB/slow.log # GLOBAL max_connections=800 max_allowed_packet = 50M key_buffer_size = 512M table_open_cache = 32768 query_cache_size = 256M query_cache_limit = 32M # PER THREAD read_buffer_size = 2M # PER REQUEST sort_buffer_size = 32M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 128M join_buffer_size=2M server-id = 1 innodb_data_home_dir = /hosts/MYSQLDB innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend innodb_log_group_home_dir = /hosts/MYSQLDB innodb_buffer_pool_size = 384M innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 3 innodb_lock_wait_timeout = 50 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/maria-10015-high-cpudisk-usage-without-queries/

1 0

Re: [Maria-discuss] Idea of monitoring tool of Mariadb
by Seung Hoon Yoo 12 Feb '15

12 Feb '15

Thanks reply Lefranc. I think 2 git monitoring solution u mention that would be using SQL execute and caching i think ( i guess, my short program knowledge) MY idea is not "SQL access" , but " GATHER info IN Memory Structure on mysqld proces" example select * from performance_schem => cache => GUI/HTTP ( SQL Method) => i think bad pfs structure (sql_parse.cc, pfs.cc) => memcopy... ( => I WANT METHOD) => i think good. 2 soultion u mentioned is use Direct Access Memory or SQL execute ?? Thanks!! and sorry My short English grammer. 2015-02-12 20:48 GMT+09:00 Guillaume Lefranc <guillaume(a)adishatz.net>: > Hello Seung Hoon Yoo, > > there are already some (experimental) tools which do that: > > https://github.com/svaroqui/http_monitor is a plugin for MariaDB 10 which > collects information based on information and performance schema > https://github.com/sjmudd/pstop is a performance monitor top-like you can > run as a command line UI > > Best regards, > > > 2015-02-12 12:36 GMT+01:00 Seung Hoon Yoo <sehyoo96(a)gmail.com>: > >> Hello, >> >> i think about monitoring gui tool ( sure, monyog Nagius support mariadb) >> Mysql Enterprise Monitor is cool, but commercial ver and that is oracle >> haha >> >> Anyway my idea first Performance schema info, >> that is store info in memory structure in source, >> so if during every 1 sec memcopy from performance schema to user-define >> structure >> and that information transfer out of mariadb by udp port etc.. >> >> So, until world in mysql / maria, their tool using proxy method or sql >> script >> thas will be some performance issue happen. >> >> so Direct Mariadb memory Access Method is useful.. >> >> >> So.. mariadb.com has any plan GUI Monitoring tool? >> and how about my idea about gathering performance schema ( + >> information_schema etc) >> info in mysqld thread info( memory structure) ?? >> >> >> Thanks for reading! >> >> p.s i am not used to english. ;) >> >> LG CNS post architecture Team >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp >> >> >

2 1

[Maria-discuss] Idea of monitoring tool of Mariadb
by Seung Hoon Yoo 12 Feb '15

12 Feb '15

Hello, i think about monitoring gui tool ( sure, monyog Nagius support mariadb) Mysql Enterprise Monitor is cool, but commercial ver and that is oracle haha Anyway my idea first Performance schema info, that is store info in memory structure in source, so if during every 1 sec memcopy from performance schema to user-define structure and that information transfer out of mariadb by udp port etc.. So, until world in mysql / maria, their tool using proxy method or sql script thas will be some performance issue happen. so Direct Mariadb memory Access Method is useful.. So.. mariadb.com has any plan GUI Monitoring tool? and how about my idea about gathering performance schema ( + information_schema etc) info in mysqld thread info( memory structure) ?? Thanks for reading! p.s i am not used to english. ;) LG CNS post architecture Team

1 0

[Maria-discuss] New Question: Migrating MySQL 5.5 Windows to MariaDB 10.x on new Windows server
by AskMonty KB 11 Feb '15

11 Feb '15

Hello, A new question has been asked in "Moving to MariaDB" by davidgonsalves. Please answer it at http://mariadb.com/kb/en/migrating-mysql-55-windows-to-mariadb-10x-on-new-w… as the person asking the question may not be subscribed to the mailing list. -------------------------------- My company is contemplating moving from MySQL 5.5 to MariaDB 10.x. We don't want to do an in place upgrade because the existing server is an older machine running Win 2003 x64. We have a new server that we're going to build out (don't know complete specs yet), and would like to know how we can best migrate the existing MySQL instance to a new instance of MariaDB on the new server. Is it as simple as doing a mysqldump from the existing server and piping it into the new? I've read how to do it here: http://dba.stackexchange.com/questions/174/how-can-i-move-a-database-from-o… are these answers adequate? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/migrating-mysql-55-windows-to-mariadb-10x-on-new-w…

1 0

[Maria-discuss] New Question: XtraDB + query_cache_size MariaDB 10
by AskMonty KB 11 Feb '15

11 Feb '15

Hello, A new question has been asked in "MariaDB Community" by chrismatthews. Please answer it at http://mariadb.com/kb/en/xtradb-query_cache_size-mariadb-10/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I have read that if your using MySQL InnoDB then you should not use query_cache_size. Does this also apply to MariaDB 10 with XtraDB ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/xtradb-query_cache_size-mariadb-10/

1 0

[Maria-discuss] New Question: Warning: mysqli::mysqli(): Headers and client library minor version mismatch.
by AskMonty KB 11 Feb '15

11 Feb '15

Hello, A new question has been asked in "MariaDB FAQ" by ariez_ahito_g. Please answer it at http://mariadb.com/kb/en/warning-mysqlimysqli-headers-and-client-library-mi… as the person asking the question may not be subscribed to the mailing list. -------------------------------- i am having error with phpipam installation in my centos box.. i got this error Warning: mysqli::mysqli(): Headers and client library minor version mismatch. Headers:50173 Library:50312 -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/warning-mysqlimysqli-headers-and-client-library-mi…

3 2

[Maria-discuss] New Question: Get the error log of Mariadb
by AskMonty KB 09 Feb '15

09 Feb '15

Hello, A new question has been asked in "MariaDB Community" by nunocarapito. Please answer it at http://mariadb.com/kb/en/get-the-error-log-of-mariadb/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi there. First of all sorry if I shouldn't be asking this. I have a big database with MariaDB running on CentOS 7, and recently it has been crashing about a time a day. I'm affraid to try anything and crush all database, making it offline for some time. I can't see what is the problem of it, because I cant find the error log of it. How can I enable it or start it? Thanks -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/get-the-error-log-of-mariadb/

1 0

[Maria-discuss] doubt... show table status
by Roberto Spadim 07 Feb '15

07 Feb '15

guys, i'm creating a table with: CREATE TABLE xxx SELECT * FROM yyyy this one take a long time (more than 1 hour) to end... my problem is... i'm using HeidiSQL sometimes to check tables and etc... when i open database it execute a SHOW TABLE STATUS FROM `database` but is blocked while create table don't end, could we implement a non block show table? or a timeout? -- Roberto Spadim SPAEmpresarial Eng. Automação e Controle

2 2

[Maria-discuss] Restated: JSON cannot represent binary data
by Tom Worster 06 Feb '15

06 Feb '15

I think we're getting lost in the detail. Beyond dispute are two facts: 1. BINARY is a valid datatype in dynamic columns. 2. JSON cannot represent binary data. It follows that: COLUMN_JSON() cannot (correctly) represent all dynamic column values. So I ask the question is: What *should* COLUMN_JSON() do when a dynamic column contains BINARY values? When I file a bug report, I like to give an expected result. I don't know what it is in this case. Every other decent JSON encoder errors on such input. Is that what Maria should do?

6 18

[Maria-discuss] direct send data to app client
by Roberto Spadim 04 Feb '15

04 Feb '15

... i was thinking about big table results, internall network use, and optimization ... should be interesting, if we have a database-side way to export data directly to app-client i'm thinking about a configuration like... client app ----(conect)---> app server, app mysql client ----(connect)---> mysql server client app send a post/get/or any other rpc/ipc method app server, execute some functions ask to mysql database and return data sometimes data is too big, and we transfer data from mysql to app, and from app to client, my idea is transfer mysql to client app this idea have some security problems, but let's think about the solution... at app server we send queries to server and report to server save it, server send a ticket, with a ttl or something like it, app them send this ticket to app client app client connect to mysql/mariadb server with a daemon plugin and 'download' this data i didn't google about this yet, but, should this be possible? in this case, i think the json/bson should be interesting since we need to translate the mysql rows/columns to a standard encode (probably json, bson, xml, html table, csv or something like it), i'm thinking about http/https (or any other network file system / file share protocol) protocol at mysql side or... i didn't think if that's possible without some patch... could the mysql server save the result to a file? like a mysqldump but using only SQL interface? maybe a create table with connect engine? ideas are wellcome -- Roberto Spadim

2 1