Devam Ediyor

mysql troubleshooting select statement search tuning $10

hi

i recently loaded data in a table in mysql 150,000 rows added using script with load data infile

after that currently i can not do select * from table-name; it hangs. i can do select count(*) from table-name;

if some one want to take a look let me know.

it is only happening on 1 table everything else is fine.

let me know i have $10.00 for this.

Beceriler: MySQL, SQL

Daha fazlasını görün: TUNING, troubleshooting, sql mysql, select, mysql select statement, mysql search table, sql select select, sql select, sql script mysql, select name, mysql load data infile, sql select script, load data infile, mysql statement, name select, select select, search mysql, mysql fine tuning, count mysql, mysql tuning, script troubleshooting, ssomu007, tuning, select select mysql, mysql table count

İşveren Hakkında:
( 29 değerlendirme ) bear, India

Proje NO: #707324

13 freelancer bu iş için ortalamada 32$ teklif veriyor

Zeldaze

MySQL expert here, let's get started, I think I already know what the problem is ;)

in 0 gün içinde30$ USD
(32 Değerlendirme)
5.7
kopila123

please view pm

1 gün içinde 30$ USD
(20 Değerlendirme)
4.5
exitsol

Lets get started. Pls see Pm for more details

in 0 gün içinde30$ USD
(30 Değerlendirme)
4.5
botzkobg

Problems ... the only way is to fix them ...

1 gün içinde 30$ USD
(4 Değerlendirme)
2.8
Licg

MySQL expert here, let's get started.

in 2 gün içinde30$ USD
(1 Değerlendirme)
1.0
shonjeo

i can help you. just email me. thanks

1 gün içinde 30$ USD
(1 Değerlendirme)
0.0
atifmajid

PHP MySQL expert. I can look at it and fix. Please provide me with details to check and fix the issue.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
Anirudha1122

Respected Sir/Madam My Company Having 8-10 [url removed, login to view] you having requirements we have Solution. My company name is Zen Software Solution. We are one year old in Development. "Hay you Have to kn Daha fazlası

in 2 gün içinde30$ USD
(0 Değerlendirme)
0.0
manoj25285

Hi, I am interested to work on this project . Please find more details in your PMB. Thanks, Manoj.

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0
kyd19781014

Dear sir, I am interesting in your project. Thanks.

in 0 gün içinde30$ USD
(0 Değerlendirme)
0.0
sumit1636

I can solve this problem as I have an idea on why this is happening. Thanks

in 5 gün içinde30$ USD
(0 Değerlendirme)
0.0
maneeshsingh

Hi, you trying to fetch all data at a time, that's why getting hanged. We should use limit to get data in parts. Use SELECT TOP 1000 * FROM table_name ORDER BY id

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
kebomix

let's take a look , i think i can do it :) , you should edit bid range , it doesn't accept less than 30$

1 gün içinde 30$ USD
(0 Değerlendirme)
0.0