…lot faster and can contribute to the Development process a lot more effectively when I know the…5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:… – Names, number of children, parents, count of columns, row counts, and comments — a great way for …
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… rules are processed. There are some informative flowcharts in addition to the textual explanation. Q: What is my recommendation for MySQL 5… mounted, and went to try to install MySQL. It failed miserably on the mysql_install_db process. Every time I tried, I got… server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…peak traffic. The standby server does not process query traffic except for replication. The …| percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name… because update statements that match no rows or insert statements that have duplicate …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… higher QPI speed (and thus, faster inter-process/node communication). Results: First of all, we… Dimitri was using 8 tables with 1M rows each (about 2.1GB) for his tests,…0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
… product is about beating data processing limitations of current systems. This raises valid question how fast can MySQL process (filter) data using it… filtered row, which is not that bad considering abstraction of storage engine which requires “row by row” processing which means function calls for each row. Lets see if we do some row function on those 10.000.000 rows (to…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle…: 21847267 BYTES_SENT: 336986112 BINLOG_BYTES_WRITTEN: 0 ROWS_FETCHED: 485139 ROWS_UPDATED: 0 TABLE_ROWS_READ: 610954 SELECT_COMMANDS: 181243 UPDATE_COMMANDS…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES WHERE TABLE_SCHEMA=’employees’ AND TABLE_NAME=’salaries’; +————+ | ROW… “make” command. After the compile process we can use constraints_parser to recover the rows in a human readable format. ~/…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… work on rows! Why would you break this paradigm by passing around rows instead of sets? From a distributed processing standpoint, rows are the worst case for performance. Optimal mathematical performance requires operations on reduced sets. Keep in mind, that rows… SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies to the distributed processing. The results from the…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.0 and 5.1 installations that would upgrade or are in the process of upgrading to MySQL… | id | x | +—-+——+ | 1 | foo | | 2 | bar | +—-+——+ 2 rows in set (0.00 sec) session3 > show processlist; …
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… as only actual rows which are found and returned up to the top level MySQL part for processing are counted the Rows_examined remains… b where a.id=5 and b.id=a.k; mysql> explain select * from sbtest a,sbtest b where a.id… but because the access type to the tables is “const” MySQL does not count it as access to two tables. In…
