…level lock for each row returned by the SELECT. These locks are all stored in RAM. The …locks when calling back into MySQL to do things like open a table, create a session structure (THD)… is that the init function returns quickly, but the first queries that access PBXT tables may hang waiting for…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… MyISAM tables out of MySQL database directory…table is checked and ready application gets error rather than stalling forever which allows application to become partially functional… users initially (returning error to others…store index cardinality in tables, instead it computes them on first table…
Post: Make your file system error resilient
August 24, 2011 By 8 Comments
…way when device have some “flapping” problems returning errors every so often as this would…needed for partition you store MySQL data on, as chances are MySQL server is only one …functions for your data partition and just check it manually as needed, same as you would every so often check MySQL tables…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… however bad idea to use > mysql_ functions directly as well – I would…can be much more modest. DVD Store was special > type of …TABLE or OPTIMIZE TABLE > now locks small table for few seconds rather than giant 100GB table…of rows are scanned and returned. SELECT * FROM articles INNER JOIN users…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… a slave node will return results as current as… should we use some randomize function or HA proxy? A:… store $_SESSION. I have audited sites that stored $_SESSION in the MySQL …table. For best scalability, I’d recommend storing $_SESSION in an in-memory data store such as Memcached or APC. Store…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… to MySQL Server, by measuring just the time it takes cache to return the data… so you might be better off storing your data on network with memcached….MySQL queries. On Selecting from the table I should note MySQL is rather fast selecting from the table… File: global.php file with benchmark function…
Post: Query_cache and column level privileges
August 6, 2007 By 5 Comments
…table has column level privileges – function query_cache_send_result_to_client just stopped and returns… +——+ 1 row in set (0.00 sec) mysql> show global status like ‘qcache%’; …tables with defined column level privileges can’t be cached – but actually even more – the query is stored…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… if triggers or stored procedures are used, or if non deterministic functions like RAND() …return an error: HA_ERR_KEY_NOT_FOUND. This is probably best shown by example. First, lets create a test table on a MySQL master database and populate it with some data. CREATE TABLE `t1` ( …
