Percona's MySQL & InnoDB performance and scalability blog
… it is true that InnoDB full-text search in MySQL 5.6 (part 1) in MySQL 5.6 is syntactically identical to MyISAM full-text… actual data. NOTE 3: Also, keep in mind that I used the community editions of MySQL 5.5.30 and MySQL 5.6.10 with no… the few people that likes lower_case_table_names = 1 in /etc/my.cnf), but I think it’s even worse that the…
…… Targets (4): libaio-0.3.109-6 libmysqlclient-5.5.30-1 mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-1 Total Download Size: 8.07… packages from extra… libmysqlclient-5.5.30-1-armv6h 3.2 MiB 435K/s 00:08 [########################################################] 100% mysql-clients-5.5.30-1-armv6h 736.6 KiB 395K… edit the configuration file, you can find it in /etc/mysql/my.cnf If you setup Percona Server to startup at boot time…
…requirements: MySQL 5.1+ row based logging (binlog_format=1) unique server_id in the my.cnf log_slave_updates=1, if this is a MySQL slave …id: 999 c1: 3 c2: 3 *************************** 3. row *************************** dml_type: -1 uow_id: 11 fv$server_id: 999 c1: 1 c2: 1 3 rows in set (…
…COMPACT became the default after MySQL 5.0.3 and has a more …1.1 or MySQL 5.5) you can now leverage table compression by specifying ROW_FORMAT=COMPRESSED. In our case we only wanted MySQL…my.cnf!): SET GLOBAL innodb_file_format=BARRACUDA; One caveat: you must be running with innodb_file_per_table=1…
… high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K…3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack like “a%”; +———-+ | count(*) | +———-+ | 4705992 | +———-+ 1…
…3 (66%) on the 2 nodes communicating each others and 1/3…my.cnf Then we can insert in both nodes without any problem when the connection between the nodes is gone: percona1 mysql…
… was always 1 !! There was a hidden character in my.cnf that was unvalidating the value and then it was set to 1. How…://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_replicate-same-server-id [3] http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql.com…
…my.cnf should look something like this on a relatively weak machine. [mysqld] server_id=1 binlog_format=ROW log_bin=mysql… view# 18: Primary, number of nodes: 3, my index: 0, protocol version 2 120619… ready for connections. Version: ‘5.5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona …
…f65ea19f shard-query-infobright-demo i686 ICE 3.5.2pl1 32bit. Requires m1.small or … ontime_fact;” | ./run_query Array ( [count(*)] => 135125787 ) 1 rows returned (0.084244966506958s, 0.078309059143066s, … InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno….
…Q: Can you quickly show the my.cnf settings again? A: Sure, see…over a wan connection with ~ 5 ms latency? A: Yes, it…replication, galera and built-in mysql replication are independent from each …: When one node in a 3 node cluster is synchronizing with…only to 1, the reason for this is that only 1 node…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.