[phpOpenTracker-general] Problems with split_tables 1.0.1
Léonard Wauters <[email protected]> Sun, 29 May 2005 23:50:36 +0200
| Newsgroups | gmane.comp.web.phpopentracker.general |
|---|---|
| Message-ID | <[email protected]> |
This is a multi-part message in MIME format. --------------060900020703000902080905 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by bat.berlios.de id j4U532m10326 Hello, Im' migrating an old phpOpenTracker system (1.2.0) to 1.5.0 with=20 merge_tables. I found the split_tables script, and planned to use it. So, first, I=20 made a copy and an upgrade of the existing database with the=20 1_2_X_to_1_3_0.sql script. After that, I ran split_tables.php. It didn't effectively worked, look=20 at the tables it has created : Before : Tables_in_phpot_dtil pot_accesslog pot_add_data pot_documents pot_exit_targets pot_hostnames pot_operating_systems pot_referers pot_search_engines pot_user_agents pot_visitors After : Tables_in_phpot_dtil pot_accesslog pot_accesslog_200505_200301 pot_accesslog_200505_200302 pot_accesslog_200505_200303 pot_accesslog_200505_200304 pot_accesslog_200505_200305 pot_accesslog_200505_200306 pot_accesslog_200505_200307 pot_accesslog_200505_200308 pot_accesslog_200505_200309 pot_accesslog_200505_200310 pot_accesslog_200505_200311 pot_accesslog_200505_200312 pot_accesslog_200505_200401 pot_accesslog_200505_200402 pot_accesslog_200505_200403 pot_accesslog_200505_200404 pot_accesslog_200505_200405 pot_accesslog_200505_200406 pot_accesslog_200505_200407 pot_accesslog_200505_200408 pot_accesslog_200505_200409 pot_accesslog_200505_200410 pot_accesslog_200505_200411 pot_accesslog_200505_200412 pot_accesslog_200505_200501 pot_accesslog_200505_200502 pot_accesslog_200505_200503 pot_accesslog_200505_200504 pot_accesslog_200505_200505 pot_accesslog_200506 pot_accesslog_200507 pot_accesslog_200508 pot_accesslog_200509 pot_accesslog_200510 pot_accesslog_200511 pot_accesslog_200512 pot_add_data pot_documents pot_exit_targets pot_hostnames pot_operating_systems pot_referers pot_search_engines pot_user_agents pot_visitors pot_visitors_200505_200301 pot_visitors_200505_200302 pot_visitors_200505_200303 pot_visitors_200505_200304 pot_visitors_200505_200305 pot_visitors_200505_200306 pot_visitors_200505_200307 pot_visitors_200505_200308 pot_visitors_200505_200309 pot_visitors_200505_200310 pot_visitors_200505_200311 pot_visitors_200505_200312 pot_visitors_200505_200401 pot_visitors_200505_200402 pot_visitors_200505_200403 pot_visitors_200505_200404 pot_visitors_200505_200405 pot_visitors_200505_200406 pot_visitors_200505_200407 pot_visitors_200505_200408 pot_visitors_200505_200409 pot_visitors_200505_200410 pot_visitors_200505_200411 pot_visitors_200505_200412 pot_visitors_200505_200501 pot_visitors_200505_200502 pot_visitors_200505_200503 pot_visitors_200505_200504 pot_visitors_200505_200505 pot_visitors_200506 pot_visitors_200507 pot_visitors_200508 pot_visitors_200509 pot_visitors_200510 pot_visitors_200511 pot_visitors_200512 Notice that every pot_visitors_xxxxxx and pot_accesslog_xxxxxx were empty. The output of split_tables.php is in attachment. Note that I tried to run split_tables in command-line style, and it had=20 the same effect. I am using MySQL 4.1, Apache 1.3 and Php 5.0.4 in a Windows 2000 machine. If it can help, I wrote a script to migrate all the data between 'mysql'=20 and 'mysql_merge' schemes. It has to be modified in order to work=20 properly as a plug-in, but its quite simple. Would you want me to send it ? L=E9o. --------------060900020703000902080905 Content-Type: text/html; name="split_tables.htm" Content-Disposition: inline; filename="split_tables.htm" Content-Transfer-Encoding: quoted-printable #!/usr/local/bin/php -Cq <table border=3D"1" width=3D"100%"><tr><td valign=3D"top">1</td><td valig= n=3D"top">0.000691000000</td><td valign=3D"top" colspan=3D"10"><pre>SELEC= T MIN(timestamp) AS first_entry, MAX(timestamp) AS last_entry FROM pot_accesslog</pre></td></tr><tr><td> </td><td valign=3D"top">i= d:<br /><nobr>1</nobr></td><td valign=3D"top">select_type:<br /><nobr>SIM= PLE</nobr></td><td valign=3D"top">table:<br /><nobr></nobr></td><td valig= n=3D"top">type:<br /><nobr></nobr></td><td valign=3D"top">possible_keys:<= br /><nobr></nobr></td><td valign=3D"top">key:<br /><nobr></nobr></td><td= valign=3D"top">key_len:<br /><nobr></nobr></td><td valign=3D"top">ref:<b= r /><nobr></nobr></td><td valign=3D"top">rows:<br /><nobr></nobr></td><td= valign=3D"top">Extra:<br /><nobr>Select tables optimized away</nobr></td= ></tr></table><table border=3D"1" width=3D"100%"><tr><td valign=3D"top">2= </td><td valign=3D"top">0.000472000000</td><td valign=3D"top" colspan=3D"= 1"><pre>CREATE TABLE pot_accesslog_200505_200301 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1041375600 AND 1044053999;</pre></td></tr></table= ><table border=3D"1" width=3D"100%"><tr><td valign=3D"top">3</td><td vali= gn=3D"top"> </td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE= IF NOT EXISTS pot_accesslog_200505 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">4</td><td valign=3D"top">&nb= sp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS= pot_visitors_200505 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">5</td><td valign=3D"top"> </td><td val= ign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS pot_accesslog_= 200506 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">6</td><td valign=3D"top">&nb= sp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS= pot_visitors_200506 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">7</td><td valign=3D"top"> </td><td val= ign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS pot_accesslog_= 200507 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">8</td><td valign=3D"top">&nb= sp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS= pot_visitors_200507 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">9</td><td valign=3D"top"> </td><td val= ign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS pot_accesslog_= 200508 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">10</td><td valign=3D"top">&n= bsp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXIST= S pot_visitors_200508 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">11</td><td valign=3D"top"> </td><td va= lign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS pot_accesslog= _200509 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">12</td><td valign=3D"top">&n= bsp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXIST= S pot_visitors_200509 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">13</td><td valign=3D"top"> </td><td va= lign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS pot_accesslog= _200510 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">14</td><td valign=3D"top">&n= bsp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXIST= S pot_visitors_200510 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">15</td><td valign=3D"top"> </td><td va= lign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS pot_accesslog= _200511 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">16</td><td valign=3D"top">&n= bsp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXIST= S pot_visitors_200511 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">17</td><td valign=3D"top"> </td><td va= lign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXISTS pot_accesslog= _200512 ( accesslog_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, document_id INT(11) NOT NULL, exit_target_id INT(11) DEFAULT '0' NOT NULL, entry_document TINYINT(1) UNSIGNED NOT NULL, KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) DELAY_KEY_WRITE=3D1 PACK_KEYS=3D1;</pre></td></tr></table><table border= =3D"1" width=3D"100%"><tr><td valign=3D"top">18</td><td valign=3D"top">&n= bsp;</td><td valign=3D"top" colspan=3D"1"><pre>CREATE TABLE IF NOT EXIST= S pot_visitors_200512 ( accesslog_id INT(11) NOT NULL, visitor_id INT(11) NOT NULL, client_id INT(10) UNSIGNED NOT NULL, operating_system_id INT(11) NOT NULL, user_agent_id INT(11) NOT NULL, host_id INT(11) NOT NULL, referer_id INT(11) NOT NULL, timestamp INT(10) UNSIGNED NOT NULL, weekday TINYINT(1) UNSIGNED NOT NULL, `hour` TINYINT(2) UNSIGNED NOT NULL, returning_visitor TINYINT(1) UNSIGNED NOT NULL, PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) DELAY_KEY_WRITE=3D1;</pre></td></tr></table><table border=3D"1" width=3D= "100%"><tr><td valign=3D"top">19</td><td valign=3D"top"> </td><td va= lign=3D"top" colspan=3D"1"><pre>SHOW TABLES</pre></td></tr></table><table= border=3D"1" width=3D"100%"><tr><td valign=3D"top">20</td><td valign=3D"= top"> </td><td valign=3D"top" colspan=3D"1"><pre>SHOW TABLES</pre></= td></tr></table><table border=3D"1" width=3D"100%"><tr><td valign=3D"top"= >21</td><td valign=3D"top"> </td><td valign=3D"top" colspan=3D"1"><p= re>ALTER TABLE pot_accesslog UNION=3D(pot_accesslog_200505,pot_accesslog_= 200506,pot_accesslog_200507,pot_accesslog_200508,pot_accesslog_200509,pot= _accesslog_200510,pot_accesslog_200511,pot_accesslog_200512)</pre></td></= tr></table><table border=3D"1" width=3D"100%"><tr><td valign=3D"top">22</= td><td valign=3D"top"> </td><td valign=3D"top" colspan=3D"1"><pre>SH= OW TABLES</pre></td></tr></table><table border=3D"1" width=3D"100%"><tr><= td valign=3D"top">23</td><td valign=3D"top"> </td><td valign=3D"top"= colspan=3D"1"><pre>SHOW TABLES</pre></td></tr></table><table border=3D"1= " width=3D"100%"><tr><td valign=3D"top">24</td><td valign=3D"top"> <= /td><td valign=3D"top" colspan=3D"1"><pre>ALTER TABLE pot_visitors UNION=3D= (pot_visitors_200505,pot_visitors_200506,pot_visitors_200507,pot_visitors= _200508,pot_visitors_200509,pot_visitors_200510,pot_visitors_200511,pot_v= isitors_200512)</pre></td></tr></table><table border=3D"1" width=3D"100%"= ><tr><td valign=3D"top">25</td><td valign=3D"top">0.001868000000</td><td = valign=3D"top" colspan=3D"10"><pre>CREATE TABLE pot_accesslog_200505_2003= 01 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1041375600 AND 1044053999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">26</td><td valign=3D= "top">0.000582000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200302 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1044054000 AND 1046473199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">27</td><td valign=3D= "top">0.000669000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200303 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1046473200 AND 1049147999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">28</td><td valign=3D= "top">0.000543000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200304 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1049148000 AND 1051739999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">29</td><td valign=3D= "top">0.000671000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200305 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1051740000 AND 1054418399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">30</td><td valign=3D= "top">0.000654000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200306 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1054418400 AND 1057010399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">31</td><td valign=3D= "top">0.001067000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200307 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1057010400 AND 1059688799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">32</td><td valign=3D= "top">0.000497000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200308 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1059688800 AND 1062367199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">33</td><td valign=3D= "top">0.000535000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200309 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1062367200 AND 1064959199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">34</td><td valign=3D= "top">0.000500000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200310 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1064959200 AND 1067641199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">35</td><td valign=3D= "top">0.000707000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200311 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1067641200 AND 1070233199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">36</td><td valign=3D= "top">0.000496000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200312 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1070233200 AND 1072911599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">37</td><td valign=3D= "top">0.000632000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200401 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1072911600 AND 1075589999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">38</td><td valign=3D= "top">0.000578000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200402 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1075590000 AND 1078095599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">39</td><td valign=3D= "top">0.000507000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200403 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1078095600 AND 1080770399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">40</td><td valign=3D= "top">0.000693000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200404 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1080770400 AND 1083362399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">41</td><td valign=3D= "top">0.000696000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200405 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1083362400 AND 1086040799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">42</td><td valign=3D= "top">0.000713000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200406 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1086040800 AND 1088632799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">43</td><td valign=3D= "top">0.000535000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200407 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1088632800 AND 1091311199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">44</td><td valign=3D= "top">0.000574000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200408 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1091311200 AND 1093989599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">45</td><td valign=3D= "top">0.000508000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200409 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1093989600 AND 1096581599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">46</td><td valign=3D= "top">0.000501000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200410 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1096581600 AND 1099263599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">47</td><td valign=3D= "top">0.000533000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200411 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1099263600 AND 1101855599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">48</td><td valign=3D= "top">0.000519000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200412 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1101855600 AND 1104533999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">49</td><td valign=3D= "top">0.000509000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200501 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1104534000 AND 1107212399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">50</td><td valign=3D= "top">0.000540000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200502 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1107212400 AND 1109631599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">51</td><td valign=3D= "top">0.000543000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200503 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1109631600 AND 1112306399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">52</td><td valign=3D= "top">0.000716000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200504 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1112306400 AND 1114898399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">53</td><td valign=3D= "top">0.000511000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_accesslog_200505_200505 ( KEY accesslog_id (accesslog_id), KEY timestamp (timestamp), KEY document_id (document_id), KEY exit_target_id (exit_target_id) ) SELECT * FROM pot_accesslog_200505 WHERE timestamp BETWEEN 1114898400 AND 1117576799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">54</td><td valign=3D= "top"> </td><td valign=3D"top" colspan=3D"1"><pre>DROP TABLE pot_acc= esslog_200505</pre></td></tr></table><table border=3D"1" width=3D"100%"><= tr><td valign=3D"top">55</td><td valign=3D"top"> </td><td valign=3D"= top" colspan=3D"1"><pre>SHOW TABLES</pre></td></tr></table><table border=3D= "1" width=3D"100%"><tr><td valign=3D"top">56</td><td valign=3D"top"> = ;</td><td valign=3D"top" colspan=3D"1"><pre>SHOW TABLES</pre></td></tr></= table><table border=3D"1" width=3D"100%"><tr><td valign=3D"top">57</td><t= d valign=3D"top"> </td><td valign=3D"top" colspan=3D"1"><pre>ALTER T= ABLE pot_accesslog UNION=3D(pot_accesslog_200506,pot_accesslog_200507,pot= _accesslog_200508,pot_accesslog_200509,pot_accesslog_200510,pot_accesslog= _200511,pot_accesslog_200512)</pre></td></tr></table><table border=3D"1" = width=3D"100%"><tr><td valign=3D"top">58</td><td valign=3D"top">0.0011590= 00000</td><td valign=3D"top" colspan=3D"10"><pre>SELECT MIN(timestamp) AS= first_entry, MAX(timestamp) AS last_entry FROM pot_visitors</pre></td></tr><tr><td> </td><td valign=3D"top">id= :<br /><nobr>1</nobr></td><td valign=3D"top">select_type:<br /><nobr>SIMP= LE</nobr></td><td valign=3D"top">table:<br /><nobr>pot_visitors</nobr></t= d><td valign=3D"top">type:<br /><nobr>index</nobr></td><td valign=3D"top"= >possible_keys:<br /><nobr></nobr></td><td valign=3D"top">key:<br /><nobr= >client_time</nobr></td><td valign=3D"top">key_len:<br /><nobr>8</nobr></= td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">rows= :<br /><nobr>448994</nobr></td><td valign=3D"top">Extra:<br /><nobr>Using= index</nobr></td></tr></table><table border=3D"1" width=3D"100%"><tr><td= valign=3D"top">59</td><td valign=3D"top">0.001706000000</td><td valign=3D= "top" colspan=3D"10"><pre>CREATE TABLE pot_visitors_200505_200301 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1041375600 AND 1044053999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">60</td><td valign=3D= "top">0.000540000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200302 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1044054000 AND 1046473199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">61</td><td valign=3D= "top">0.000507000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200303 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1046473200 AND 1049147999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">62</td><td valign=3D= "top">0.000575000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200304 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1049148000 AND 1051739999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">63</td><td valign=3D= "top">0.000507000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200305 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1051740000 AND 1054418399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">64</td><td valign=3D= "top">0.000509000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200306 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1054418400 AND 1057010399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">65</td><td valign=3D= "top">0.000667000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200307 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1057010400 AND 1059688799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">66</td><td valign=3D= "top">0.000505000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200308 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1059688800 AND 1062367199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">67</td><td valign=3D= "top">0.000549000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200309 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1062367200 AND 1064959199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">68</td><td valign=3D= "top">0.000506000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200310 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1064959200 AND 1067641199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">69</td><td valign=3D= "top">0.000535000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200311 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1067641200 AND 1070233199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">70</td><td valign=3D= "top">0.000596000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200312 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1070233200 AND 1072911599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">71</td><td valign=3D= "top">0.000584000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200401 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1072911600 AND 1075589999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">72</td><td valign=3D= "top">0.000505000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200402 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1075590000 AND 1078095599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">73</td><td valign=3D= "top">0.000513000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200403 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1078095600 AND 1080770399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">74</td><td valign=3D= "top">0.000542000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200404 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1080770400 AND 1083362399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">75</td><td valign=3D= "top">0.000517000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200405 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1083362400 AND 1086040799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">76</td><td valign=3D= "top">0.000506000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200406 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1086040800 AND 1088632799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">77</td><td valign=3D= "top">0.000546000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200407 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1088632800 AND 1091311199;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">78</td><td valign=3D= "top">0.000509000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200408 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1091311200 AND 1093989599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">79</td><td valign=3D= "top">0.000515000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200409 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1093989600 AND 1096581599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">80</td><td valign=3D= "top">0.000546000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200410 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1096581600 AND 1099263599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">81</td><td valign=3D= "top">0.000624000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200411 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1099263600 AND 1101855599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">82</td><td valign=3D= "top">0.000518000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200412 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1101855600 AND 1104533999;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">83</td><td valign=3D= "top">0.000546000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200501 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1104534000 AND 1107212399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">84</td><td valign=3D= "top">0.000548000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200502 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1107212400 AND 1109631599;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">85</td><td valign=3D= "top">0.000527000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200503 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1109631600 AND 1112306399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">86</td><td valign=3D= "top">0.000673000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200504 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1112306400 AND 1114898399;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">87</td><td valign=3D= "top">0.000710000000</td><td valign=3D"top" colspan=3D"10"><pre>CREATE TA= BLE pot_visitors_200505_200505 ( PRIMARY KEY (accesslog_id), KEY client_time (client_id, timestamp) ) SELECT * FROM pot_visitors_200505 WHERE timestamp BETWEEN 1114898400 AND 1117576799;</pre></td></tr><tr><td= > </td><td valign=3D"top">id:<br /><nobr>1</nobr></td><td valign=3D"= top">select_type:<br /><nobr>SIMPLE</nobr></td><td valign=3D"top">table:<= br /><nobr></nobr></td><td valign=3D"top">type:<br /><nobr></nobr></td><t= d valign=3D"top">possible_keys:<br /><nobr></nobr></td><td valign=3D"top"= >key:<br /><nobr></nobr></td><td valign=3D"top">key_len:<br /><nobr></nob= r></td><td valign=3D"top">ref:<br /><nobr></nobr></td><td valign=3D"top">= rows:<br /><nobr></nobr></td><td valign=3D"top">Extra:<br /><nobr>Impossi= ble WHERE noticed after reading const tables</nobr></td></tr></table><tab= le border=3D"1" width=3D"100%"><tr><td valign=3D"top">88</td><td valign=3D= "top"> </td><td valign=3D"top" colspan=3D"1"><pre>DROP TABLE pot_vis= itors_200505</pre></td></tr></table><table border=3D"1" width=3D"100%"><t= r><td valign=3D"top">89</td><td valign=3D"top"> </td><td valign=3D"t= op" colspan=3D"1"><pre>SHOW TABLES</pre></td></tr></table><table border=3D= "1" width=3D"100%"><tr><td valign=3D"top">90</td><td valign=3D"top"> = ;</td><td valign=3D"top" colspan=3D"1"><pre>SHOW TABLES</pre></td></tr></= table><table border=3D"1" width=3D"100%"><tr><td valign=3D"top">91</td><t= d valign=3D"top"> </td><td valign=3D"top" colspan=3D"1"><pre>ALTER T= ABLE pot_visitors UNION=3D(pot_visitors_200506,pot_visitors_200507,pot_vi= sitors_200508,pot_visitors_200509,pot_visitors_200510,pot_visitors_200511= ,pot_visitors_200512)</pre></td></tr></table> --------------060900020703000902080905--