Garey: One sec. checking through PHPMyAdmin
Filipek: Please wean yourself off phpmyadmin
Hauschildt: Lol. I’m not the MySQL admin. personally, I hate SQL servers.
Suri: It looks like its a varchar13, and it’s the primary key
Filipek: Primary key is an index in mysql
Filipek: Then select data from bookinfo where isbn=’090604882X’;
Macculloch: You can do = on varchar too, in case you just need to divide the data into batches
Filipek: Crazy publishers use the same isbn for the second edition etc
Werlinger: From what I understand how the program works is it take a random number from the range, then looks up the record to see if it’s been checked. if the flag is not set, then it requests the data from the external API, and updates the record
Filipek: My most crazy example was a different cover and size http://www.collection.Filipek.info/searchv13.php?searchstr=6502+***embly+language+programming
Trentman: Filipek, they use a -x as the delimitor between major reqrites
Filipek: No the last character is a checksum
Couvillier: Sorry, I’ve had a bottle of wine, and I don’t know the programming. I’m just looking for information to beat into this guy to speed up this lookup. 6-8 months is NOT acceptable for lookups
Filipek: Give him a bottle of the sack and get a new guy
Bramall: Lol. problem is he’s one of my best friends. lazy, but.
Filipek: You need to educate him
Patenaude: I’m going to. with a baseball bat.
Regula: If you can point me in the right direction on how to rewrite this mess, then I will give it to him.
Bourg: We started this last Sept, and he’s had a lot of excuses father dying, getting married, buying a house, etc
Dutro: Maybe these are truth.
Schindewolf: Jeeves_Moss, you might add index on that “flag” column to get not-flagged-yet records fast
Niceswander: Hummm. ok, let me look to see if I can do it in phpmyadmin
Rumburd: Is there a way to do it via the CLI?
Filipek: Yes, use the mysql client
Spatz: I am running MySQL v5.6 on Windows Server 2012 R2. I am having 64 GB of RAM but MySql is utilizing only 16 GB of RAM. My engine is innoDB. Please suggest me how ca I increase my memory utilization
Slyter: Filipek, ok, what would the command be?
Dambrozio: Luckymurali: what should it do and why
Huxford: I need MySQL should utilize 50 GB of Memory
Filipek: Jeeves_Moss, http://dev.mysql.com/doc/refman/5.6/en/programs-client.html
Guy: So that my query execution can run faster
Wride: Jkavalik, 8589934592 is the output
Dambrozio: Luckymurali: and how would the memory usage increase that?
Ratliff: Luckymurali:I think. if you don’t see many phisical reads. you don’t need more buffer. if you use innodb ,try innodb_buffer_pool_size
Dambrozio: See, the thing is that your system is faster if it has disk cache. Using all the memory for an application doesn’t make much sense
Roux: Luckymurali, thats 8GB so you probably want to change that
Gwathney: Luckymurali, how big is your database? is it bigger than 8GB?
Hackleman: Dambrozio, I am just thinking that memory may work better in select statements
Mcanaw: Dambrozio, that works for MyISAM but not so straight for InnoDB
Dambrozio: Luckymurali: are you currently having problems in latency?
Jempty: No, but in executon of queries
Merling: I created all the indes
Yeager: Shall i Paste the Show status results?
Cossano: Luckymurali: This is loosely true: For planning – competent hardware, competent mysql server config as to buffers and caches, normalized schema design, correct table storage engine choice, proper data types, adequate indexing, competent queries. For troubleshooting – reverse the order. :-