Luckymurali: This is.

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***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,

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. :-