November 2014 - skunkworks - Skunkworks Site

Navision erp
by olie.ndegwa＠gmail.com 18 Nov '14

18 Nov '14

Dear team Who has a navision based ERP ? Contact me on oliver(a)Tpc.co.ke Thanks Oliver TPC. POWERED BY HTC

1 0

Inno db io optimization
by geoffrey gitagia 18 Nov '14

18 Nov '14

Hi all Wanted to know how to improve my io performance on innodb , the situation is like this ,32 bit mysql ,virtualized with hyper-v , the db is on a 200gb vhd and space is not an issue, please note nothing can be changed in the environment unless you suggest putting log files to a different partition, but no changing of the sql server. Regards GG

7 10

GOOGLE inbox
by Kevin Omondi 18 Nov '14

18 Nov '14

Just got my got my Google inbox invite. Anyone interested in an invite please Holla. Kevin

56 80

Re: [Skunkworks] Inno db io optimization
by William Muriithi 18 Nov '14

18 Nov '14

Thanks to all yee skunks, I am now getting a clear picture of what's going on , now as a solution I want to buy an ssd and then attach it to my systems vm such that I avoid the blender effect ,in your opinion will this 'cure' my system? Or will I still face a io bottle neck? It may help. You need to ensure all other mysql settings are right. For SSD, just have the SSD as a separate partition and mount it directly to your vm. I mean, don't access the SSD through your virtualization infrastructure to avoid that overhead Also, DONT use 512 sectors, use the SSD native sector size else you will never see the advertised i/o speed. That mean, read the specifications, and ensure you can set your system to those specifications. Recommend Intel SSD, expensive but fast and reliable Muriithi Regard Geoffrey On Nov 18, 2014 8:14 AM, "john doe" <kuwasiliana(a)hotmail.com> wrote: > Virtualization in a high io environment like a database is never a good > idea. > Google I/O blender effect. > > ------------------------------ > Date: Tue, 18 Nov 2014 05:29:31 +0300 > To: ggitagia(a)gmail.com; skunkworks(a)lists.my.co.ke > Subject: Re: [Skunkworks] Inno db io optimization > From: skunkworks(a)lists.my.co.ke > > Geoffrey, there is this freeware, Spotlight on MySQL, which I have found > very useful for continuous visualisation of that MySQL is upto, in real > time. > > http://software.dell.com/products/spotlight-on-mysql/ > > On Mon, Nov 17, 2014 at 2:08 PM, geoffrey gitagia via skunkworks < > skunkworks(a)lists.my.co.ke> wrote: > > Thanks Adam > I am running on a windows environment so I have 5.5 on it , I noticed > is writes alot of temp files and at times converts to isam tables ,meaning > that my io is going to be high ,from me resource monitor I can see lots of > disk activities, it even at times freezes the server for a few seconds, > another problem is that the tables have many columns of which the dev uses > select * statements, impacting on cache. > > _______________________________________________ > skunkworks mailing list > skunkworks(a)lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke > > > > > -- > Regards, > Peter Karunyu > ------------------- > > _______________________________________________ skunkworks mailing list > skunkworks(a)lists.my.co.ke ------------ List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ > Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ Other services @ http://my.co.ke >

1 0

Google Inbox - what is all the psyche about it?
by Odhiambo Washington 18 Nov '14

18 Nov '14

I don't find it easy to navigate my e-mails both on the browser and using the App on my phone. I am still lost as to why people are praising this Inbox thing. I could be missing something obvious which someone can help me out with. -- Best regards, Odhiambo WASHINGTON, Nairobi,KE +254733744121/+254722743223 "I can't hear you -- I'm using the scrambler."

4 4

E-COMMERCE
by Joseph M. Owino 18 Nov '14

18 Nov '14

Hi, Over the last 1.5 years we have seen the emergene of e-commerce sites in kenya (rupu.co.ke , jumia.co.ke, kaymu.co.ke, sumi.co.ke etc.) I need some information on the following with regards to e-commerce in kenya, if any of you listers has “heard” or “seen” reports on. * · Volume of transactions in a month. * · Average revenue per month. Any information will be highly appreciated. Regards Muga.

7 8

HP Download Site
by Philip Musyoki 18 Nov '14

18 Nov '14

Could anyone check and see if they can download drivers from the HP website? Just to hp.com, support, drivers and check if you can download any driver for any product.

4 3

Re: [Skunkworks] vpn
by William Muriithi 17 Nov '14

17 Nov '14

Original Message hi... i want to create a vpn to an office in town, is it a must i buy another router or vpn client can do the job bila router --------------------------- Either would work. Better to setup an office to office vpn to make access to office resources easier. Otherwise you get user saying file server us done when they forget to start their vpn As others have said, use openvpn if you don't feel like spending Muriithi

1 0

Re: [Skunkworks] Inno db io optimization
by William Muriithi 17 Nov '14

17 Nov '14

Run `iostat -c10` or something like that and confirm that you're near the IO limit of the disk subsystem. You'll also want to run `free` and see what's going on regarding memory usage. You may not be using all of your memory if your InnoDB settings aren't setup to use it. Petty good point. Did you adjust innodb_buffer_size to your system's memory profile. Also, make sure you are using innodb plugin NOT the build in innodb unless you are now on mysql 5.6 Anyway, the first thing is to get onto the latest and greatest Ubuntu/Debian/CentOS or whatever OS you're running and make sure you're on the latest and greatest MySQL from your OS vendor. You should definitely be on 5.5 and ideally 5.6. Doubt it will help. Even if he is using oracle, Ms sql, he would still have the same problem. He is saturating his i/o subsystem A better filesystem may help marginally as ntfs has high overhead than case sensitive filesystem but his problem is deeper. If there is money, he could buy some SSD disk and put the 200gb on SSD. Using hardware to fix software lack of good design. William Then, checkout this whole section: http://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb.html I wonder if it's an Innodb issue though - more likely it's bad queries and indexes - which you may or may not be able to change. To see the hotspots, install New Relic (http://newrelic.com/) -Adam -- Kili - Cloud for Africa: kili.io Musings: twitter.com/varud <https://twitter.com/varud> More Musings: varud.com About Adam: www.linkedin.com/in/adamcnelson On Mon, Nov 17, 2014 at 10:52 AM, geoffrey gitagia via skunkworks < skunkworks(a)lists.my.co.ke> wrote: > Hi all > Wanted to know how to improve my io performance on innodb , the > situation is like this ,32 bit mysql ,virtualized with hyper-v , the db is > on a 200gb vhd and space is not an issue, please note nothing can be > changed in the environment unless you suggest putting log files to a > different partition, but no changing of the sql server. > > Regards > GG > > _______________________________________________ > skunkworks mailing list > skunkworks(a)lists.my.co.ke > ------------ > List info, subscribe/unsubscribe > http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks > ------------ > > Skunkworks Rules > http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 > ------------ > Other services @ http://my.co.ke >

1 0

Re: [Skunkworks] Inno db io optimization
by William Muriithi 17 Nov '14

17 Nov '14

I am running on a windows environment so I have 5.5 on it , I noticed is writes alot of temp files and at times converts to isam tables ,meaning that my io is going to be high ,from me resource monitor I can see lots of disk activities, it even at times freezes the server for a few seconds, another problem is that the tables have many columns of which the dev uses select * statements, impacting on cache. -------------- As others have mentioned, the best way is to reduce select * from table, especially since your tables are very wide. You are maxing your i/o with data that you eventually never use. There is no temporary solution for that and it hurt bad since your disk is the slowest part. You can increase the sort memory size. That will minimize your database using the disk as a sort staging area. And mysql don't use innodb for sorting so what you are seeing is normal If you were on Linux, you could also reconfigure mysql to use tmpfs for sorting. Essentially dressing up ram as a disk. It help a lot to minimize disk activities Muriithi

1 0