…of Java JRE for your platform You will need a Java driver for your database — I’m using the MySQL…of children, parents, count of columns, row counts, and comments — a great way for a high level overview of the table sizes…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each set… is approximately 12GB of data in the largest table. You can find the individual SSB query…/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb_log_file_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In …boxes. You can find setup/config details at the very end of this post…. is a non-trivial amount of updates to the database, all SELECT queries, …innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M …
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
… indication of the numbers of database connections the thread pool supported. I was not part of …MySQL versions, but it was very surprising to find out just few threads in a thread pool were necessary to supports tens of…active connections” when determining a thread pool size. FYI, it was really hard …
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… wanting a small MySQL database server: You’re a uni student …mysql-clients-5.5.30-1 percona-server-5.5.29_rel29.4-1 Total Download Size: 8.07 MiB Total Installed Size…configuration file, you can find it in /etc/mysql/my.cnf If you … but those are outside the scope of this article. To check if mysqld …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…mistake to delete one of MySQL‘s log or data files from disk. The database server will continue to… discussed within InnoDB, but it can find evidence of problems in the server as well as …difficult to handle max_connections problems (the use of fixed-size connection pooling, for example, which can …
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…a clear picture of our users are doing in the database. To accomplish our task of finding unused indexes we…INNODB_INDEX_STATS to get the list of unused indexes: mysql> SELECT INNODB_INDEX_STATS.TABLE_NAME, …that depending on the size of the log the server would need lot of process time and cpu power…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding…Then I simply created a view of a UNION DISTINCT of those two tables: mysql> create view used_indexes as … sec) Now I need a way to find the set of indexes in all_indexes, but not …
Post: Find and remove duplicate indexes
June 20, 2012 By 9 Comments
… can hurt the performance of our database: They make the optimizer phase slower because MySQL needs to examine more … and it can find the three different types of keys explained before. Lets try it: mysql> show create table t; … to improve the execution time and decrease the size of the data read…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… size 7864319 Buffer pool size, bytes 128849002496 Free buffers 1 Database pages 8252672 Old database…MySQL Support contract can be handy. Conclusion Understanding where MySQL can allocate memory can help us to find…I’m very hopeful future releases of MySQL, MariaDB or Drizzle bring improvements in…
