…MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql… Viewing SchemaSpy output A completed Relationships view of these three tables…table sizes and an easy way to use the search feature of your browser to zero in on a particular table…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode …views. However, the more general descriptors optimization in Percona Server showed fairly close results in our tests. In…> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and variable reference table. But …lock_wait_timeoutblogpercona.commanual locked_in_memoryblogpercona.commanual logblogpercona.commanual …commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual Uptimeblogpercona….
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
… view will not see trx with id >= 12304, sees < 12301 As you can see in this case the query self joins the table…, ACTIVE 9 sec mysql tables in use 2, locked 2 8316 lock struct(s), heap size 1948088, 10008317 row lock(s) MySQL thread id 53173… sec fetching rows mysql tables in use 1, locked 1 9417 lock struct(s), heap size 915896, 696679 row lock(s) MySQL thread id 53173…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… thing you need to consider is string comparison in MySQL is case insensitive by default while hash …indexes to be in memory only those portions of them which are accessed frequently. The size of this…temporary table or external sort. Q: How can we manage indexes on servers from DBA point of view …
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…table-size 16777216 tmpdir /tmp transaction-alloc-block-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size 4096 updatable-views…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… by t.table_schema, t.table_name, i.index_name; Now we can can see index sizing information in the all_indexes view: mysql> select * from all_indexes\G … *************************** 33. row *************************** TABLE_SCHEMA: sakila TABLE_NAME: rental INDEX_NAME…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…, view# 18: Primary, number of nodes: 3, my index: 0, protocol version 2 120619 13:20:17 [Warning] WSREP: Gap in state…-driver=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp-table-size=10000 prepare…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… would share my own view on using MyISAM in production. For me it is not only about table locks. Table locks is only one… have many tables which are being repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table will be locked while repair is going. If this is frequently used table…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…mysql instance (or simply the database which is not replicated) to log updates in heap/myisam/archive table and aggregate it in the database for example each hour. If your memcache is sized…
