…MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql…children, parents, count of columns, row counts, and …zero in on a particular table Constraints – lists the explicit Foreign Key constraints in the database (this does not include…
Post: Sphinx 0.9.8 is released just in time for OSCON 2008
July 20, 2008 By 2 Comments
…to over 15 months of work. With zero in front it still looks like “beta” …scalability. Because of this we included Sphinx chapter in High Performance MySQL book – check out Appendix C….counting number of documents per site_id takes 3.6 seconds to do using Sphinx, compared to 7.5 seconds using MySQL…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…including testing innodb_old_blocks_time=1000 on MySQL 5.5.30 and testing multiple buffer pools on MySQL 5.5.30. Finally, MySQL…in pages afterwards: mysql> select sq.*, pages / (@@innodb_buffer_pool_size / 16384) * 100 pct_buffer_pool from ( select table_name, index_name, count…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… existing flushing implementations (including both MySQL native adaptive flushing and that in Percona Server) …zero, and may stay in that state for a long time (minutes). This comes from the fact that MySQL performs changes in… worse, the count of flushed neighbor pages is counted toward the number…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…in Semaphores information: ———- SEMAPHORES ———- OS WAIT ARRAY INFO: reservation count 13569, signal count 11421 –Thread 1152170336 has waited at ./../include…in microseconds. mysql tables in use 1, locked 0 is number of tables used by transaction in… pages is zero as in this case database…
Post: Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
… man in the middle like mysql-proxy, so it has basically zero impact on the running server (tcpdump is very efficient) and zero impact… _____ # This item is included in the report because it matches –limit. # pct total min max avg 95% stddev median # Count 12 1 # Exec… protocol enough to see the flags set in the protocol, indicating the warning count, error count, rows affected, and whether no index or…
