Em Andamento

MySQL Copying to tmp table - too slow , and site crash

MySQL :: Copying to tmp table - too slow and sites when gets more users online site load to slow

| 8262445 | razibineuser | [url removed, login to view] | fotohd_wow | Query | 0 | Copying to tmp table | select tag_id, count(*) as nr from ws_tags_files group by tag_id order by RAND() | 0 | 0 | 0 |

| 8262446 | razibineuser | [url removed, login to view] | fotohd_wow | Query | 0 | Copying to tmp table | select * FROM ws_files WHERE (type = 'video' OR type = 'image') AND approved='1' and date_live<='1 | 0 | 0 | 0 |

| 8257534 | razibineuser | [url removed, login to view] | fotohd_wow | Query | 0 | Sorting result | select * FROM ws_files WHERE type = 'image' AND approved='1' and date_live<='1384376882' order by ra | 0 |

Habilidades: MySQL, PHP

Ver mais: mysql sorting result slow, ra, query table, copying, php mysql load table, php load table, image table, slow video, table video, mysql query slow, php mysql users group, online order php mysql, mysql slow, mysql users online, image copying, php mysql select table, group type site, count mysql, online order mysql, type video site, php mysql count, mysql online order, users online site, select table php mysql, select select mysql

Acerca do Empregador:
( 16 comentários ) Las Palmas de Gran Canaria, Spain

ID do Projeto: #5125691

Premiar a:

brylu

Hello, Whats your server hardware spec? How much traffic does it handle? I can tweak your MySQL server for improved performance which hopefully be enough to ensure stable operations assuming you're not running out Mais

$30 USD em 1 dia
(6 Avaliações)
3.9

4 freelancers estão ofertando em média $68 para este trabalho

elboukharimu

Aucune proposition n'a encore été fournie.

$105 USD in 3 dias
(11 Comentários)
4.1
b1m2c6

Hi, I am 7 years experienced in PHP/Mysql I have understand problem . I have make a game site where approx 5000 user play every time and in this site user approx 10 luck . please check my site : --------- Mais

$111 USD in 2 dias
(2 Comentários)
0.0
imaginationstech

hello i have good experience in php,mysql,joomla,wordpress so i can do this work if you want to i work for you then plz pm me thanks

$25 USD in 3 dias
(0 Comentários)
0.0