Percona's MySQL & InnoDB performance and scalability blog
…| OK | +———————-+———-+———-+———-+ 1 row in set (4.60 sec) mysql> select * from information_schema.innodb_ft_config; +—————————+———+ | KEY | VALUE | +—————————+———+ | …, I do find that the number of rows in I_S.innodb_…
… “flight” of queries represents a set of drill-down queries to find an anomaly. I am going …in set (0.00 sec) mysql> select * from information_schema.global_status where variable_name like ‘%innodb%read%’; +—————————————+—————-+ | VARIABLE_NAME | VARIABLE_VALUE |…
… were set to a default value of CURRENT_TIMESTAMP. From the manual, here is how MySQL handles timezone locality with timestamp fields: Values for…-table-checksum against node1, we see that even though MySQL is storing these values in UTC internally, we have “data drift” on both… the fly to get the actual rows in need of syncing, it will not find those rows even though pt-table-checksum…
…” pages do we have in the index with current compression settings. The same utility could … level MySQL Replication which among other requirements, needs all auto-increment values in multiple value insert to…value allocated, some may already have values specified. I’m not sure if Heikki will find…
… are where in wild which are running with default settings. Even though you can tune quite a lot of variables in MySQL Servers only… small data set and it is not going to grow dramatically do not oversize innodb_buffer_pool_size you might find better…. Value 0 is a bit faster but is a bit less secure as you can lose transactions even in case MySQL Server crashes. Value…
… should they estimate memory consumption by MySQL Server in given configuration. What is the …Memory allocated by MySQL process. You can also look at “Resident Memory” but I find it … how the value changes so you know memory requirements with current settings and increase/decrease values appropriately…
…’s see what kind of goodies does Helgrind find on MySQL server. Let’s take a recent 5…. be lost, with the counter values slightly smaller than they should be in the end. ==9090== Possible data …that there is no need for workarounds in mutex_get_waiters/mutex_set_waiters above and similar cases. And …
… script (you can find it in the end of the post) which connects to one node in the cluster, … can enable to get fully synchronous replication behavior: mysql> set global wsrep_causal_reads=1; Query OK, 0 … I’m getting following result: … Result Mismatch for Value 48; Retries: 1 Delay: 0.76 ms Result…
…. So, MySQL checks our INSERT, sees that the next auto-inc value is available, and claims it, but then it checks the UNIQUE KEY and finds… 2 rows in set (0.00 sec) (root@localhost) [test]> INSERT INTO update_test (username, host_id) VALUES (‘foo’,…
…mysql> SELECT count(*) FROM Country; +———-+ | count(*) | +———-+ |     239 | +———-+ 1 row in set (0.00 sec) mysql…value is not fixed in MySQL and can be a much wider window (15-60%) depending on the circumstances. In this case, MySQL…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.