… to /etc/my.cnf After doing that and following the procedure i originally posted, the log files were created with the…
Comment: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 27, 2012 By 10 Comments
Michael, I am not interested in Windows, I do not have hardware nor technical experience to do that. I think TRIM is overrated and probably not relevant to this benchmark. I do not create/delete many files. I just random write into files created just after secure erase procedure.
Comment: Solving INFORMATION_SCHEMA slowness
April 20, 2012 By 16 Comments
… the pt-online-schema-change tool into our own migration procedures. It was taking the tool about one hour just to…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
… Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) you can…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… with MySQL 5.5 with addition of user variables, stored procedures, prepared statements etc which can be a memory hog. My…
Comment: mysql-proxy, urgh performance and scalability ?
February 27, 2012 By 27 Comments
…. – Sharding. – Query Router. In addition it is better support stored-procedure and transparent between Mysql Server and application client. SQL Relay…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… or server upgrade, this method can be good quick rollback procedure in case something fails during the operation. * While writing this…
Post: MySQL Stored Procedures problems and use practices
June 12, 2007 By 21 Comments
… slow query log will contain full stored procedure calls. On the other hand Stored Procedures Indeed can help to Improve MySQL Performance… 10% slower than 4.1 without stored procedures but was 20% faster if Stored Procedures are used. And this is of course… more work to send it back than Stored Procedure to process it. Stored Procedures also have number of performance gotchas which I…
Post: PROCEDURE ANALYSE
March 23, 2009 By 9 Comments
… a native feature to perform this task – PROCEDURE ANALYSE Here is sample run of PROCEDURE ANALYSE on drupal schema of Percona web…’ve omitted everything by few rows. mysql> select * from node procedure analyse() \G *************************** 1. row *************************** Field_name: percona_drupal.node.nid…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
… VALUES(this_year())’ STORED PROCEDURES The behaviour of stored procedures and functions are completely different. If our stored procedure write data to our tables the queries inside the procedure get…
