June 19, 2013

Post: Implementing SchemaSpy in your MySQL environment

…: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql-connector-…comments>

name=”parent” comments=”Parent table”>
name=”parent_id” primaryKey=”true”>
name=”child_A” …

Post: Side load may massively impact your MySQL Performance

…-driver=mysqlmysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password…-driver=mysqlmysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_big –oltp-table-size=17600000 –mysql-user=msandbox –mysql-password…

Post: Percona XtraDB Cluster reference architecture with HaProxy

….so datadir=/var/lib/mysql wsrep_slave_threads=2 wsrep_cluster_name=pxctest wsrep_sst_method=xtrabackup wsrep_node_name=ip-10-112…=oltp –db-driver=mysqlmysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql-password=sbpass –oltp…

Post: Looking for RAID Controller without Battery Learning problems ?

… problems and its impact to MySQL Performance. Here are couple of links…-0 (18252) Firmware : 5.2-0 (18252) Driver : 1.1-5 (24702) Boot Flash … ———————————————————————- Logical device number 0 Logical device name : RAID10-A RAID level : 10 Status…

Post: MySQL Prepared Statements

… you care about archiving best performance in your application using MySQL you should learn about prepared statements. These do not neccesary… and some other drivers had forever. Now query passed to the server contained placeholders for parameters, for example “select name from user… forget to close prepared statements – Many memory leaks reported in MySQL Server turned out to be prepare statements or cursors which…

Post: Virident tachIOn: New player on Flash PCI-E cards market

…soon. I actually was not aware about any real names at that time, it was just a guess, …and will be fixed in the production release of driver. I think it would be fair to get comparison…performance (important in question for log related activity in MySQL) I am looking forward to present results in …