…MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql…comments> Main Production Database. Percona, Michael Coburn comments> <tables> <table name=”parent” comments=”Parent table“>
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… environment I’m in — obviously a FreeBSD box is different). For example, [percona@db1 ~]$ uname -… and see if there’s anything worth commenting on there. Depending on the workload, there …, including checking for default users in the mysql.* tables, running mk-duplicate-key-checker to find redundant…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…used 10mil row table which would look as following in terms of data and index size: mysql> show table status … Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) So…you think about building index stage. On this box with 8GB of memory allocating 6GB to buffer…
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: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
…their stats and post reviews. Box Anemometer Anemometer is a tool for visualizing collected data from the MySQL Slow Query Log. … * explaining queries; * searching and displaying samples; * displaying table status and CREATE statements; * reviewing and commenting on queries. Despite its lack of …
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
…some distributions would not offer MySQL upgrade to the next major version out of the box it is not …bit more confusing. Per this table RHEL4 is Supported all the way to MySQL 5.5 yet it does not… would appreciate your feedback on this matter either as comments to this blog posts or as direct email to…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…requests to MySQL table for larger ones you can log only small portion of them. I usually keep one table per…data to a different box for data crunching and remove the old ones. The log table should contain URL, …- this can be done by adding request ID as comment to Sphinx log so you can profile it …
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… This number is per core. In theory this box which has 4 cores should be able …the following table: CREATE TABLE `m4` ( `c` char(128) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1 mysql> show table status…Checksum: NULL Create_options: Comment: 1 row in set (0.00 sec) mysql> select count(*) from m4 …
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the … reporting query or 5 hours ALTER TABLE command. Let me also comment on the memory fit diagram – understanding …also fully support Matt in his views of black boxes. If you want to be able to resolve …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…box, using RAID10 over 8 disks and a FusionIO 320GB MLC card. First, the results for tpcc-mysql… from commenter I put also results with different innodb_io_capacity for MySQL 5….mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables…
