…MySQL handles connections, allocating one thread per connection to the server. MySQL is a single process with multiple threads. Not all…this matters — please fill in whatever’s missing in the comments. There can be … was originally coded for MySQL 6.0, but is available now in MariaDB. Unfortunately …
Post: Adaptive flushing in MySQL 5.6 - cont
September 10, 2012 By 13 Comments
…algorithm in MySQL 5.6.6 works as expected. The devil as always is in …whole range of value, including 0 throughput for 1-4 seconds. So what … better, let’s zoom-in to 200 sec interval: In comments to the previous post…8GB logs) and stays in this level. As I understand checkpoint age balances all time …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…siblings : 4 core id : 3 cpu cores : 4 fpu : …commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This…’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ |…all my analysis for sending, add in things I may have noticed along the way (comments…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…have it all in place, we …mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL…mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql-5.0…-buffer-size=4 -m64 -mtune=generic’…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
…mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES; +——————–+———+—————————————————————————-+————–+——+————+ | Engine | Support | Comment…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…as expected. I had to redo all of the benchmarks to get the …alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings…in_prg {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0.6 85% 0… numbers to share, please leave a comment. Next, I plan to look at…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…0 0 70 85 108K 124K 0.0 0 17 0 4 19:17:06 trime P 3 3 node3 Sync T/T 0 0 66 82 100K 124K 0.0 0…_local_state_comment — basically a plaintext word describing the state of the node in terms of … help improve replication speed at all. Conflct Replication conflicts, as described in my last post. lcf …
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…the tar stream being from the future. The 0.3 – 0.4 second delay seems too much to me….a node in PXC can be a master or a slave on asynchronous replication, galera and built-in mysql replication… glad you liked it:). Thanks everyone for all these questions, feel free to ask additional ones in comments…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… queries in LucidDB I could not run all…0 Auto_increment: NULL Create_time: NULL Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment…in Google Spreadsheet or in summary table at the bottom) Query Q1: mysql… InfiniDB Community Edition 0.9.4.0-5-alpha (…
Comment: Upgrading MySQL
January 5, 2010 By 24 Comments
… change in the MyISAM table index format in MySQL 5.0. Upgrade from MySQL 4.1 to 5.0 and repair all MyISAM tables (see Section 2.4.4, “Rebuilding or Repairing Tables or Indexesâ€). Then upgrade from MySQL… wonder if in-place upgrades are wise. It seems to me that a dump and reload is overall a safer approach. Comments?
