mysql table gets hanged after update sql -

-

i having mysql myisam table more 2 million records. running shell script updating each row table , job completed. when opening table in mysql gui tool or try run select query on it, mysql server gets hanged. idea, how proceed on this?

thanks


Comments

Post a Comment

Popular posts from this blog

c# - error executing child request for server.transfer with Handler -

-
i have created handler process .html pages in asp.net c# web application. use url rewriting concepts. handler works fine when html requrest come server/website. coding details follows: web.config handler code: <add verb="*" path="*.html," validate="false" type="myproject.contenthandler,myproject" /> contenthandler.cs code: public void processrequest(httpcontext context) { string strmappage = string.empty; if (context.request.url.tostring().contains("category")) { strmappage = "/links.aspx?id=" + producid; } else { strmappage = context.request.url.tostring(); } context.server.transfer(strmappage); } this method works fine .html request page http://localhost:9111/user-category-1.html when try open page '/js/tinymce/imagemanager/index.html' throws error "error execut...
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl...
Read more

How to read input from STDIN in x86_64 assembly? -

-
i trying learn x86_64 assembly , trying standard input output today , stumbled upon post learning assembly - echo program name how same reading input stdin (using syscall instruction)? if know input integer , want read register? edit: @daniel kozar's answer below helped me understand how stdin , stdout stuff work syscall instruction on linux. attempted write small program, reads number console input , prints ascii character corresponding number. if type 65 input, should output. , new line character. if @ all, helps 1 else :-) section .text global _start _start: mov rdi, 0x0 ; file descriptor = stdin = 0 lea rsi, [rsp+8] ; buffer = address store bytes read mov rdx, 0x2 ; number of bytes read mov rax, 0x0 ; syscall number reading stdin syscall ; make syscall xor rax, rax ; clear off rax mov rbx, [rsp+8] ; read first byte read rsp+8 stdin call rbp sub rbx, 0x30 ; since read character, obtained ascii va...
Read more