… as testing your application on table with 1000 rows may well give you very …in PHP at all. Many summary tables can be built by INSERT … SELECT, or some others purely SQL…tables and original tables on the same server which can limit your scalability. Using FEDERATED Tables can work for some cases in…
Post: Using innodb_sys_tables and innodb_sys_indexes
June 15, 2012 By Leave a Comment
…sql-430c_2e | 1 | 8 | 15 | +———-+——–+————–+——+——–+——-+ 1 row in set (0.00 sec) mysql> select * from innodb_sys_indexes where table… | 1 | 3 | 15 | +———-+———+———-+——+———-+———+——-+ 1 row in set (0.00 sec) This table same ALTER TABLE…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…table. The times for full table scan vs range scan by index: mysql> select count(pad) from large; +————+ | count(pad) | +————+ | 31457280 | +————+ 1 row in…
Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
…rows in set (0.34 sec) (Just some ranfom data. The only row we really need is with 2147483647) mysql> explain select…table would happen with correct value, such as 3000000000, while inserting the same value in…
Post: MySQL caching methods and tips
April 4, 2011 By 5 Comments
… row in any table, the query cache entries for every query which accessed that table…multiple requests need data for the same key, but the key recently …TABLE .. SELECT and INSERT .. SELECT. These SQL commands can be used to either replace the contents of, or insert new data into the summary table…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…! The order of statements is not the same in the binlog as I typed into …bin.000006 Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave… row into the test.ins table. Let’s see: master > call test_temp(); master > select * from test.ins; +——+ | a | +——+ | …
Post: On Character Sets and Disappearing Tables
June 21, 2012 By 1 Comment
…of ‘./oops4/#sql-3c13_14′ to …Table ‘oops4.dos2′ doesn’t exist (root@localhost) [oops4]> show tables; +—————–+ | Tables_in_oops4 | +—————–+ | dos1 | | dos3 | +—————–+ 2 rows in… tables could cause the same…TABLE recovery LIKE `#sql2-3c13-14`; INSERT INTO recovery SELECT…
Comment: Why MySQL could be slow with large tables ?
March 11, 2009 By 141 Comments
… web application that uses MS SQL database. When invoking a SELECT statement in LogDetails table(having approx. 4 million rows), the execution time is more… MYSql instead of MS SQL. It took approx. 2.5-3 mins to invoke the same query used in SETUP A. SPECS of SETUP B: OS: Red Hat Linux 4 Memory: 512MB QUESTION: 1) Why does MS SQL…
Comment: MySQL Query Cache
September 9, 2009 By 70 Comments
Hi, I have a table which is quite big. I do alot of INSERTS, UPDATE and SELECT on this table. If the number of rows in the tables keeps on increasing, but the same SQL query is used, will query cache actually help?
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…table, three orders of magnitude more quickly than COUNT(*). mysql> select count(*) cnt from order_lines\G *************************** 1. row *************************** cnt: 155187034 1 row in…
