… picking up long_query_time when…MySQL but this would make replication to be delayed few more hours because of the time Innodb takes to open tables…for me so I turned my attention to mysqlsla which I remembered parses all kinds of MySQL Logs. Too bad MySQL… looking for, if you strip out comments, USE…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…comment to suggest to test db_STRESS benchmark on XtraDB by Dimitri. And I tested and tuned for…table). This is the lock for each index tree. We may be able to disperse the lock using by the partitioning of MySQL…
Post: Bug#12704861
November 20, 2011 By 1 Comment
…problem that is fixed in MySQL 5.1.60. I’ll…being updated in an InnoDB table. (Bug #12704861)” This wasn’t… to have recovery bugs for a very long time before and people …it too often and greatly reduce your exposure to such bugs. For … pages. row_build(): Correct a comment, and add a debug assertion…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…tables and run on linux with 16gigs or ram. Here is our my.cnf # sammple MySQL config file for…length_for_sort_data=2048 max_sort_length=2048 long-…RAM but beware of setting memory usage too high innodb_buffer_pool_size…allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… capability. For example tables used for logging less critical… for MySQL Proxy 0.8.2 still says: “MySQL…embedded in SQL comments, instead of instantiating …long as the page remains in the buffer pool. But the read/write split solution is intended for cases where the query load is too high for…
Post: Caching techinques
August 8, 2006 By 11 Comments
… Let me start with couple of comments about Jays article. First – caching …data long term – ie if you got it from some Web Service. For … MySQL Query Cache works by removing all queries derived from the table if that table… – approach used by MySQL Query Cache is too coarse invalidating a lot …
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…and nice comments. As …For example, with the sandbox server I used for the examples, it would be pt-query-digest –review S=/tmp/mysql…For pt-online-schema-change, does renaming the table take a long time, and what about the transaction in the meanwhile? The rename table… a server too difficult, …
