Tag: Access

Feed: Planet MySQL; Author: Marco; I think that very often we are so focus in analyzing internals, or specific behaviours/situations/anomalies that we tend to forget the simple things. It happened to me that last week a couple of customers raise the same question:  "How ProxySQL manage the default schema, or the ones declared inside a FROM/JOIN?"I was a bit surprise because I was given that for granted, and my first thought was, 'well read the documentation', but then I realize we do not have a clear section in the documentation about this. Given that and also because I realize I ... Read More

Feed: Planet MySQL; Author: Marco; This article is the spin-off of the article How ProxySQL deal with schema (and schemaname) 1 How ProxySQL differes from MySQL in managing explicit default schema declaration? does it respect the -D or USE MySQL and ProxySQL will behave the same when passing the default schema, setting it as default. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 MySQL mysql -uuallworld -ptest -h192.168.1.107 -P 3306 -D test select database(); ... Read More

Feed: Big Data Made Simple - One source. Many perspectives.. Author: Baiju NT. Big data has been advertised as a panacea for corporate problems. Everything from marketing to HR or logistics to the sales funnel can be solved by AI algorithms which feed on Big Data. Yet, only a third of the respondents from a recent Forbes survey had seen revenue boosts of over 3% after implementing Big Data, showing there is still room to grow and the processes are still not entirely understood.  Why are the numbers so small, what makes projects fail and  what causes CEOs to lose ... Read More

Feed: R-bloggers. Author: hrbrmstr. I’ve blathered about my crawl_delay project before and am just waiting for a rainy weekend to be able to crank out a follow-up post on it. Working on that project involved sifting through thousands of Web Archive (WARC) files. While I have a nascent package on github to work with WARC files it’s a tad fragile and improving it would mean reinventing many wheels (i.e. there are longstanding solid implementations of WARC libraries in many other languages that could be tapped vs writing a C++-backed implementation). One of those implementations is JWAT, a library written in ... Read More

Feed: Planet MySQL; Author: Peter Gulutzan; MySQL has thrown away the mysql.proc table for version 8.0 Development Releases. The best explanation that I've seen is the one that Dmitry Lenev gave at a conference last October. To summarize it: mysql.proc and its ilk are non-transactional, redundancy is bad, and MySQL can fix some known bugs by moving over to information_schema tables backed by InnoDB. Of course I approve for a separate reason: mysql.proc is non-standard and therefore it is a mistake. On the other hand, programmers that have invested some time in using mysql.proc will have some trouble changing them ... Read More

Feed: Planet big data. Author: 9Clouds. Using a virtual machine while working in the Deep Web and Dark Web is key to obtaining information safely and securely. At BrightPlanet, we’ve communicated the benefits of using a virtual machine while working in the traditionally “unsafe” Deep Web and Dark Web.Before business leaders make important decisions, they should have access to all relevant information leading up to the decision. In addition to helping navigate Deep Web and Dark Web search, virtual machines are also helpful in harvesting open source data from public websites, allowing you to obtain all the relevant information you ... Read More

Feed: SAS Blogs. Author: Emanuela Sferco. Amazon’s foundation in 1994 was the start of big changes in the retail world. It may have taken 20 years for the full effects to trickle down into every sector of retail, but it is now obvious that shopping habits have been turned upside down by the rise of online retail. The real question is perhaps whether well-established retailers have a chance to reinvent themselves, and capitalise on their brand recognition. I caught up with David Cosgrave , who leads SAS’s Customer Intelligence team in South EMEA, to discuss the link between customer experience ... Read More

Feed: R-bloggers. Author: R Views. This example groups stocks together in a network that highlights associations within and between the groups using only historical price data. The result is far from ground-breaking; you can already guess the output. For the most part, the stocks get grouped together into pretty obvious business sectors. Despite the obvious result, the process of teasing out latent groupings from historic price data is interesting. That’s the focus of this example. A central idea of the approach taken here comes from the great paper of Ledoit and Wolf, “Honey, I Shrunk the Sample Covariance Matrix” (http://www.ledoit.net/honey.pdf) ... Read More

Author: . Originally published by CIO. Cloud data centers are not static environments, pre-provisioned to run a known, finite set of workloads to support predictable demand. They are highly dynamic environments in which everything is changing all the time. At scale. Which makes automation critical to success. At least it will be when we have figured out how to do it... Behind the cloud: administration and management Cloud users see the Cloud as a set of services, SLAs and invoices. That is surely the point: I click on my Netflix movie or fire up a server on AWS, and I ... Read More

Feed: Planet big data. Author: Curt Monash. August 22, 2017 I talked recently with the folks at Imanis Data. For starters: The point of Imanis is to make copies of your databases, for purposes such as backup/restore, test/analysis, or compliance-driven archiving. (That’s in declining order of current customer activity.) Another use is migration via restoring to a different cluster than the one that created the data in the first place. The data can come from NoSQL database managers, from Hadoop, or from Vertica. (Again, that’s in declining order.) As you might imagine, Imanis makes incremental backups; the only full backup ... Read More