What happened to the 5.1.31 release announcement?
I've just read someone's troubles about getting 5.1.31 installed on Solaris, and I thought 5.1.30 was the latest stable release. So, I went onto the website and found that 5.1.31 was released on 19th Jan, but the only announcement notices I received about that time was for 6.0.9 alpha. Did anyone else receive an announcement for the release of 5.1.31? Was it actually made? Thanks, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: non-relational engine for mySQL?
I believe such things already exist, for example the Nitro storage engine. There is a presentation about it at the coming MySQL conference... http://en.oreilly.com/mysql2009/public/schedule/detail/6984 Regards, Antony On 6 Feb 2009, at 14:50, Daevid Vincent wrote: When our database reaches the 10-100TB range, we may need to consider non-relational databases. Relational databases like MySQL tend to heavily rely on random access, which is governed by the slow disk seek rates. On the other hand, non-relational database pioneered by Google's Map/Reduce framework operate at much faster disk transfer rates. Open source solutions incorporating these ideas exist, such as Yahoo's Hadoop and CouchDB. Are there currently (or plans for) any mySQL engines with this type of database? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
What ever happened to NitroEDb engine for MySQL
NitroEDB was suppose to be shipped Q2 2007. Whatever happened to that? When can I expect it? TIA Mike http://solutions.mysql.com/engines.html * http://www.mysql.com/news-and-events/news/article_1181.htmlNitroEDB NitroEDB for MySQL is a high speed relational storage engine from NitroSecurity, originally developed to address the growing demand for real-time analysis within the network security event management market. NitroEDBs focus is on high volume databases. Utilizing unique indexing techniques, data management methods and query processing algorithms, the technology enables multiple order of magnitude increases in relational data management and query performance with multi-billion record volumes running on commodity hardware. The technology is currently deployed in NitroView Enterprise Security Manager, the industrys highest performance network security monitoring and analysis solution. The General Availability for NitroEDB for MySQL is scheduled for Q2 2007. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Solid State Drives and mySQL / RDBMS?
On Fri, Feb 6, 2009 at 5:53 PM, Daevid Vincent dae...@daevid.com wrote: While SSD's (Solid State Disks) have traditionally not been the best hardware to use for rewrite-intensive operations like databases, over the last few months, some leading Linux kernel engineers have been raving about next generation Intel SSD's that are close to 20x faster than the fastest disk drives for random access. If robust enough, these next generation SSD's may greatly improve relational database performance. You are confusing me here. What is an SSD by your definition? (I'll be on Wikipedia right after I make this post.) If you mean a purely RAM-based device, it should work fine with great performance. If you mean a FLASH/EEPROM-based device, you might have a RAM front end to it, but there would be limits to how much data you can change how quickly. What is your definition of an SSD? Got a typical manufacturer and model number?
Curious Error, anyone have a guess?
Hello mysql, On one of my sites, I have a query that logs attempts to access the site by potential bad guys. It has been working for more than a year with out a problem. Today, I got a database error because an unescaped ' in one of the arrays that I collect. When I check the error I found a very curious condition in the useragent log entry. Here is the excerpt: ,\'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6', Notice the backslash in front to the quote delimiter. How did that get there? Anybody have a guess? The database comes from a call to $_SERVER['HTTP_USER_AGENT']; -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Curious Error, anyone have a guess?
Are you attempting to escape that string? If not, you should be The UserAgent header can't be trusted because every browser vendor has the liberty to do pretty much what they want to it (there is no consistent standard) and some browsers (ie. Opera) allow users to set the UserAgent to any arbitrary string, so it si inevitable that you will get unsafe input sooner or later. - michael dykman On Sun, Feb 8, 2009 at 12:31 AM, mik...@qualityadvantages.com wrote: Hello mysql, On one of my sites, I have a query that logs attempts to access the site by potential bad guys. It has been working for more than a year with out a problem. Today, I got a database error because an unescaped ' in one of the arrays that I collect. When I check the error I found a very curious condition in the useragent log entry. Here is the excerpt: ,\'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6) Gecko/2009011913 Firefox/3.0.6', Notice the backslash in front to the quote delimiter. How did that get there? Anybody have a guess? The database comes from a call to $_SERVER['HTTP_USER_AGENT']; -- Best regards, mikesz mailto:mik...@qualityadvantages.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Solid State Drives and mySQL / RDBMS?
At 04:53 PM 2/6/2009, you wrote: While SSD's (Solid State Disks) have traditionally not been the best hardware to use for rewrite-intensive operations like databases, over the last few months, some leading Linux kernel engineers have been raving about next generation Intel SSD's that are close to 20x faster than the fastest disk drives for random access. If robust enough, these next generation SSD's may greatly improve relational database performance. Is anyone using SSD drives currently and can share their experiences? Also, even if they are currently poor for writing, they would make a fantastic slave drive for mega-fast access I would think right? Our current DB is about 80GB and over 1/2 billion rows in each of two of the tables. Reports are starting to take as long as 20 seconds to generate. ...and don't get me started on export/import (it can take DAYS to import). There are Flash SSD's and DDR SSD's. I assume you mean DDR SSD's. You may want to try something like HyperDrive and use Raid to increase the size of the volume. See http://www.hyperossystems.co.uk/. It was reviewed at http://www.techreport.com/articles.x/16255/9. For random access, these solid state devices are extremely fast. But sequential access they are slightly faster than the fastest hard drive. These devices are also getting quite cheap compared to what they cost 5 years ago. I haven't tried it, but would love to get my hands on a few of these. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org