June 18, 2013

Post: Recovery deleted ibdata1

lead to corruption and data loss. For the same reason we can’t make MySQL… can set dirty pages percentage to zero: mysql> set global innodb_max_dirty_pages_…it’s never less than 1): ————————————- INSERT BUFFER AND ADAPTIVE HASH INDEX ————————————- Ibuf: …

Post: Bug#12704861

… serious problem that is fixed in MySQL 5.1.60. I’ll repeat… request to allocate a BLOB page leads to the tablespace being extended, crash…transaction are consistent (have not been zeroed out). btr_page_alloc_low(): Refactored…columns are being made off-page in insert-by-update, invoke btr_mark_freed_…

Post: Read/Write Splitting with PHP Webinar Questions Followup

…classes. Q: Does storing the position in $_SESSION lead to local storage and limit scalabilty? A: …to. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to split…bandwidth issues, the seconds behind master will report zero seconds behind if the SQL thread is …

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_ft_list2′; Query OK, 0 rows affected (0.00 sec) mysql: INSERT… are completely different; the scores are zero, which means “no match.” This looks promising… between the two engines; sometimes this leads to wildly different results. If you …

Post: Tuning InnoDB Concurrency Tickets

… this number is decremented until it reaches zero (“entering InnoDB” appears only to occur …mysql> INSERT INTO parent (id) VALUES (1),(2),(3),(4); — 3 Tickets Used Query OK, 4 rows affected (0.03 sec) mysql> INSERT…the other hand, these are the queries that lead to revenue generation, you may want …

Post: Falcon Storage Engine Design Review

…unavailable. We’ll see where this leads us but I believe on …match my needs. I love this Zero administration thing and I would …been implemented outside of MySQL Storage Engine level for MySQL – reading rows in … records in B which were modified/inserted after you started transaction. [-] Isolation …