|
1.
mySQL DBA: Walking an INNODB table Fast Mar 12, 2009 ... So, to walk an INNODB table fast, and keep liner time or a Big-O of ... This dumps a table very fast, almost as fast as doing a count(*) on ... 2.
mySQL DBA: How to reduce load and response time in PHP in five minutes Feb 3, 2009 ... Request time is proportional to server load. If the application response time is big so will be the server's load. To reduce server load, ... 3.
mySQL DBA: Walking an INNODB table Fast Mar 12, 2009 ... My team found that mySQL causes a table scan to each $pos. ... more disk IO then walking a table, slowing down access to this table. ... 4.
mySQL DBA: INNODB Shared Locks, Exclusive Locks and INSERT INTO ... To verify that Deadlocks will not occur - having an understanding about how locks work in INNODB is key. I suggest reading this page. ... 5.
mySQL DBA: mySQL Disk Benchmarks with Sysbench. When will mySQL ... mySQL Disk Benchmarks with Sysbench. When will mySQL / INNODB stop scaling? Today's "commercial quality disks" are amazing but they follow ... 6.
mySQL DBA SELECT col FROM TABLE LIMIT 1000000, 1000 is executed mySQL will scan all the rows up to row position 1001000 and for each subsequent iteration. ... 7.
mySQL DBA: INNODB Shared Locks, Exclusive Locks and INSERT INTO ... LOAD DATA INFILE "/data/mysql/BuildQueue.log" INSERT INTO TABLE ... INSERT INTO OfflineTasks (object_id, object_type) SELECT * FROM ... 8.
mySQL DBA: How to reduce load and response time in PHP in five minutes Feb 3, 2009 ... Request time is proportional to server load. If the application response time is big so will be the server's load. To reduce server load, ... 9.
mySQL DBA: UAE Broken Proxys - how to work around them UAE Broken Proxys - how to work around them. In the UAE there is a goverment enforcement of all traffic to go through goverment proxy ... 10.
mySQL DBA: INNODB Shared Locks, Exclusive Locks and INSERT INTO ... The INSERT sets an exclusive lock on the rows that are being added, so the Offline Task Sheppard - the process that pops tasks off the queue ... |
