Re: Oracle , what else ?
At 07:13 PM 4/21/2009, you wrote: It will great if the MYSQL guys were to buy mysql from Oracle for half the price that Sun paid. Yeah, I'm sure Widenous is writing a check as we speak. rofl He is busy working on Maria, a stripped down branch of MySQL. http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html They would come out making lots of money and back controlling their own destiny. Anyone can have control of the MySQL code because it is GPL. The only thing stopping them is time and $$$ to organize another company, maybe call it MySQL CD?? Mike :-) On Tue, Apr 21, 2009 at 4:47 PM, Arthur Fuller fuller.art...@gmail.comwrote: I hereby bet the farm that this shall not occur. I have $10 to say that this shall not occur. a) Who is going to challenge the deal? b) What possible purpose would it serve to interr MySQL? c) Assuming there is some reason for b) above, why incur the wrath of the MySQL community and their possible bail-outs? Nothing gained and everything lost, in such a move. d) If we know anything, we know that Scott and Larry are not fools. e) In the grand scheme of things, the MySQL piece of this pie is peanuts and perhaps less. This acquisition is about the big picture (hardware platform + existing Sparc base + Java, etc.). MySQL, as much as we love it, is a tiny teensy part of this acquisition, and my guess is that Scott and Larry are much more focussed on the other parts (e.g. end-to-end solutions extending from the hardware to the middleware to the Oracle apps, etc.) and in this ballpark MySQL is an interesting tidbit but not at all the focus of their efforts. Think big, baby. MySQL in this context is a tiny little ripple in the pond, having little or nothing to do with Scott/Larry's plans. Viewed from this perspective, MySQL becomes a viable alternative to such offerings as SQL Express from MS. If for no other reasons than marketing imperatives, I am confident that Scott and Larry will choose not to kill MySQL but rather regard it as both an entry platform and a position from which to upgrade to Oracle. Make no mistake about this. There are very sound reasons to upgrade to Oracle. Cost is of course a serious issue. But Oracle can do things, and has various top-end vehicles, that MySQL cannot approach. Consider, to take just one example, Trusted Oracle, upon which numerous banks bet their bottom dollar. Add to this the numerous Oracle Apps. I am no champion of Oracle in particular, but I do rtheecognize what platforms X and Y can do. If the game is defined as retrieval amongst several GB of data, then MySQL has a chance. If the game is retrieval amongst several PB of data, with security, then I bet on Oracle. Granted, this move requires a team of DBAs etc., but if you are dealing with PetaBytes then I suggest that you think carefully about which vendor is prepared to take you there. Just my $0.02 in this debate. I don't see MySQL and Oracle as competitive products. In fact I see the opposite: Oracle gets to occupy a space in the open-source community while simultanwously offering an upgrade path to multi-petabyte solutions, serious security, and so on. I don't think that Scott and Larry are out to hurt the MySQL community, and I'm prepared to bet that they will invest in the next version of MySQL, You might disagree but I challenge you to answer Why? Sheer rapaciousness? That doesn't make sense. MySQL has garnered numerous big-time players, and in what possible interest would Oracle jeapordize these investments? As several writers on this thread have said, if Oracle muddies the waters then they are prepared to move to PostGres and/or several other alternatives, not least to take the MySQL sources to a new playpen. It is clearly not in the interests of Oracle to let this happen. Far more interesting is to fold the MySQL project into Oracle's overall Linux project. Continue to offer MySQL for free, work on transport vehicles that let MySQL people migrate effortlessly to Oracle, etc. I don't mean to pretend to read Scott and Larry's minds here. But I think that the MySQL part of this acquisition, while interesting, is a small part of the rationale for buying Sun. The serious interest is in acquiring an end-to-end solution, as yet offered by nobody, including IBM and MS. This is the most significant part of this acquisition. Imagine being the salesperson of said stack. We have the hardware and the operating system and the middleware and the front-end. Click and go. IMO this is a truly formidable argument. In practice, it could be delivered as an appliance and/or a blade. And if you don't think this is formidable, then wake up and smell the coffee. This could well leap-frog certain other competitors -- which is not to say they won't catch up eventually, but it is to say that Oracle has raised the bar and it's time for competitors such as MS to jump through several flaming hoops. On
Re: Oracle , what else ?
It will great if the MYSQL guys were to buy mysql from Oracle for half the price that Sun paid. Yeah, I'm sure Widenous is writing a check as we speak. rofl He is busy working on Maria, a stripped down branch of MySQL. http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html They would come out making lots of money and back controlling their own destiny. Anyone can have control of the MySQL code because it is GPL. The only thing stopping them is time and $$$ to organize another company, maybe call it MySQL CD?? The MySQL name is not free though, it's owned by MySQL AB (or Sun nowadays). So even if a fork happens, it cannot take the mysql name, having to rename tools/filenames in order to work. And after that, it has to stick with the community public. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download FREE Database Workbench Lite for MySQL! Database questions? Check the forum: http://www.databasedevelopmentforum.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: Oracle , what else ?
i agree with you, Since mysql code is GPL anyone can start developing further wither another name say 'MySQL NEW' I don't understand how any company can own since mysql code is GPL. On Wed, Apr 22, 2009 at 11:48 AM, mos mo...@fastmail.fm wrote: At 07:13 PM 4/21/2009, you wrote: It will great if the MYSQL guys were to buy mysql from Oracle for half the price that Sun paid. Yeah, I'm sure Widenous is writing a check as we speak. rofl He is busy working on Maria, a stripped down branch of MySQL. http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html They would come out making lots of money and back controlling their own destiny. Anyone can have control of the MySQL code because it is GPL. The only thing stopping them is time and $$$ to organize another company, maybe call it MySQL CD?? Mike :-) On Tue, Apr 21, 2009 at 4:47 PM, Arthur Fuller fuller.art...@gmail.com wrote: I hereby bet the farm that this shall not occur. I have $10 to say that this shall not occur. a) Who is going to challenge the deal? b) What possible purpose would it serve to interr MySQL? c) Assuming there is some reason for b) above, why incur the wrath of the MySQL community and their possible bail-outs? Nothing gained and everything lost, in such a move. d) If we know anything, we know that Scott and Larry are not fools. e) In the grand scheme of things, the MySQL piece of this pie is peanuts and perhaps less. This acquisition is about the big picture (hardware platform + existing Sparc base + Java, etc.). MySQL, as much as we love it, is a tiny teensy part of this acquisition, and my guess is that Scott and Larry are much more focussed on the other parts (e.g. end-to-end solutions extending from the hardware to the middleware to the Oracle apps, etc.) and in this ballpark MySQL is an interesting tidbit but not at all the focus of their efforts. Think big, baby. MySQL in this context is a tiny little ripple in the pond, having little or nothing to do with Scott/Larry's plans. Viewed from this perspective, MySQL becomes a viable alternative to such offerings as SQL Express from MS. If for no other reasons than marketing imperatives, I am confident that Scott and Larry will choose not to kill MySQL but rather regard it as both an entry platform and a position from which to upgrade to Oracle. Make no mistake about this. There are very sound reasons to upgrade to Oracle. Cost is of course a serious issue. But Oracle can do things, and has various top-end vehicles, that MySQL cannot approach. Consider, to take just one example, Trusted Oracle, upon which numerous banks bet their bottom dollar. Add to this the numerous Oracle Apps. I am no champion of Oracle in particular, but I do rtheecognize what platforms X and Y can do. If the game is defined as retrieval amongst several GB of data, then MySQL has a chance. If the game is retrieval amongst several PB of data, with security, then I bet on Oracle. Granted, this move requires a team of DBAs etc., but if you are dealing with PetaBytes then I suggest that you think carefully about which vendor is prepared to take you there. Just my $0.02 in this debate. I don't see MySQL and Oracle as competitive products. In fact I see the opposite: Oracle gets to occupy a space in the open-source community while simultanwously offering an upgrade path to multi-petabyte solutions, serious security, and so on. I don't think that Scott and Larry are out to hurt the MySQL community, and I'm prepared to bet that they will invest in the next version of MySQL, You might disagree but I challenge you to answer Why? Sheer rapaciousness? That doesn't make sense. MySQL has garnered numerous big-time players, and in what possible interest would Oracle jeapordize these investments? As several writers on this thread have said, if Oracle muddies the waters then they are prepared to move to PostGres and/or several other alternatives, not least to take the MySQL sources to a new playpen. It is clearly not in the interests of Oracle to let this happen. Far more interesting is to fold the MySQL project into Oracle's overall Linux project. Continue to offer MySQL for free, work on transport vehicles that let MySQL people migrate effortlessly to Oracle, etc. I don't mean to pretend to read Scott and Larry's minds here. But I think that the MySQL part of this acquisition, while interesting, is a small part of the rationale for buying Sun. The serious interest is in acquiring an end-to-end solution, as yet offered by nobody, including IBM and MS. This is the most significant part of this acquisition. Imagine being the salesperson of said stack. We have the hardware and the operating system and the middleware and the front-end. Click and go. IMO this is a truly formidable argument. In practice, it could be delivered
mysqldump.exe gives Access Denied for user
Gurus, I'm running a Windows Server 2003 cmd shell script to backup my databases using: %mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% %bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql @ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql It's been running fine until I've had to change the password for this dbuser due to it being hijacked to drop our tables. My problem is, mysqldump now keeps giving me Access denied for this user and the backup job doesn't go through. I can log into MySQL Query Browser and even Administrator fine with the new password however. Any clues/pointers is greatly appreciated! Please cc my email! Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I thin'k MySQL will be the 'Oracle Personal Edition'
The main question is: Will Oracle permits a cheaper DB in his portfolio with almost the same reliability than his main and expensive DB? Ok. MySQL is the main database in a wide 'open source' community. That people never will bought Oracle to build a phpBB forum or to install Joomla, but what happen with Flirk, Amazon.com, Digg, CNET, Craiglist, Nokia, Wordpress, Wikipedia, YouTube, FaceBook, ... and other 'big fishs'? Will they invited to buy Oracle? Most of the end medium-small firms uses MySQL because know that successful cases and they rely on MySQL. But what happens if those 'big fishs' abandon MySQL and migrates to Oracle? Will the actual rely in a enterprise environment maintains? I'm sure that Oracle won't abandon MySQL, but will use this influence to invite to that big end users to migrate to Oracle. I suppose that will made them an offer they can't refuse. First reducing the actual rate of patches, slowing the developing of the connectors (.NET connector, ODBC, J/Connector) and in a prudential time offering Oracle to a ridiculous part of this prize and supporting them in the migration with a huge quantity of hours in experts. But only to that 'big fishs'. When there's no 'big fish' in the MySQL ocean, the CEOs in the small-medium enterprise will think No big project is using MySQL. I have doubts and fear about using MySQL in my enterprise. I'll call to Oracle to paid a huge quantity of money and all my doubts and fears will disappears. And I think, the same strategy will use them with Glass Fish (http://java.sun.com/javaee/community/glassfish/). Oracle has 2 JAVA EE application servers: OAS (will be deprecated in short) and Weblogic. I think in a few years MySQL will be only the database for phpBB and Joomla and in 5 years MySQL will replace to Oracle Personal Edition. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: I thin'k MySQL will be the 'Oracle Personal Edition'
José I. Merino schrieb: The main question is: Will Oracle permits a cheaper DB in his portfolio with almost the same reliability than his main and expensive DB? It already has, it's called Oracle Express Edition. Ciao, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: I thin'k MySQL will be the 'Oracle Personal Edition'
The revenue that MySQL has accrued to date comes (obviously) from the support contracts. Oracle has no interest in derailing this revenue stream. It may well slow down the version cycle, which may be a good thing, but that aside, I cannot see Oracle killing the MySQL stream. There's no argument that I can see in favor of it, and abundant arguments against. Why kill a revenue stream unless you're some sort of neo-Marxist? The large players all buy support contracts and that's the revenue stream. Why kill that? A.
Re: I thin'k MySQL will be the 'Oracle Personal Edition'
XE store up to 4GB of user data, use up to 1GB of memory, and use one CPU on the host machine. On Wed, Apr 22, 2009 at 3:51 PM, Thomas Pundt mli...@rp-online.de wrote: José I. Merino schrieb: The main question is: Will Oracle permits a cheaper DB in his portfolio with almost the same reliability than his main and expensive DB? It already has, it's called Oracle Express Edition. Ciao, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=franks1...@gmail.com -- - Lin Chun
Creating / Lookup Users For Database
This seems to be a simple beginer question for MySQL and I have searched online but I wanted to ask before I really confuse myself. I have MySQL running on Linux and right now I have created a 2nd production database: mysql show databases; +-+ | Database| +-+ | information_schema | | cal | | forums| | mysql | +-+ I know when I created 'cal' I also created a specific user to have permissions to this database as I was told root was not a good idea. I don't remember who or what user I created so can someone please tell me how I am able to look up the user who has permissions to 'cal' database and I would also like to have that same user permissions to the new database I created called 'forums'. Sorry for my ignorance but I greatly appreciate any and all assistance to my question above! -- Carlos W. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
1064 errors
Hi, I have several procedures that I have taken from an old Microsoft database, and I have tired to use them in a MySQL 5.1.32 database, but I am getting errors when trying to input them. There are three in total that I am struggling with and would appreciate some guidance... This is a cross selling query: CREATE PROCEDURE 'x'.'CrossSelling' () BEGIN SELECT TOP 5 OrderDetails.ProductID, OrderDetails.ProductName, Count(OrderDetails.ProductID) AS CountOfProductID FROM OrderDetails WHERE (((OrderDetails.OrderID) In (select OrderID from OrderDetails where ProductID=[pid]))) GROUP BY OrderDetails.ProductID, OrderDetails.ProductName HAVING (((OrderDetails.ProductID)[pid])) ORDER BY Count(OrderDetails.ProductID) DESC; END Error is: 1064 '5 OrderDetails.ProductID, OrderDetails.ProductName, Count(OrderDetails.ProductID' at line 3 If somebody could give me an idea of what is wrong here with regards to it working with MySQL, I might be able to make the other two problem functions work with out too many tears. Thanks. Mat
Re: 1064 errors
Matthew, CREATE PROCEDURE 'x'.'CrossSelling' () BEGIN SELECT TOP 5 OrderDetails.ProductID, OrderDetails.ProductName, Count(OrderDetails.ProductID) AS CountOfProductID FROM OrderDetails WHERE (((OrderDetails.OrderID) In (select OrderID from OrderDetails where ProductID=[pid]))) GROUP BY OrderDetails.ProductID, OrderDetails.ProductName HAVING (((OrderDetails.ProductID)[pid])) ORDER BY Count(OrderDetails.ProductID) DESC; END MySQL syntax != MSSQL syntax. No TOP in MySQL---use LIMIT (and it's slower). Also IN(SELECT...) is abysmally slow. For alternatives see The unbearable slowness of IN() at http://www.artfulsoftware.com/infotree/queries.php. PB - Matthew Stuart wrote: Hi, I have several procedures that I have taken from an old Microsoft database, and I have tired to use them in a MySQL 5.1.32 database, but I am getting errors when trying to input them. There are three in total that I am struggling with and would appreciate some guidance... This is a cross selling query: CREATE PROCEDURE 'x'.'CrossSelling' () BEGIN SELECT TOP 5 OrderDetails.ProductID, OrderDetails.ProductName, Count(OrderDetails.ProductID) AS CountOfProductID FROM OrderDetails WHERE (((OrderDetails.OrderID) In (select OrderID from OrderDetails where ProductID=[pid]))) GROUP BY OrderDetails.ProductID, OrderDetails.ProductName HAVING (((OrderDetails.ProductID)[pid])) ORDER BY Count(OrderDetails.ProductID) DESC; END Error is: 1064 '5 OrderDetails.ProductID, OrderDetails.ProductName, Count(OrderDetails.ProductID' at line 3 If somebody could give me an idea of what is wrong here with regards to it working with MySQL, I might be able to make the other two problem functions work with out too many tears. Thanks. Mat No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.12.2/2074 - Release Date: 04/22/09 08:49:00
my final 1064 error
Here is my final problem that I am struggling to overcome...
SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
FROM Vouchers
WHERE (((DateDiff('d',[StartDate],Date()))=0) AND ((DateDiff('d',
[EndDate],Date()))=0));
Basically, the error is on the WHERE line of the query, and I assume
it is something to do with the DateDiff, but I don't know if there is
a MySQL equivalent. Also, is Date() valid MySQL?
Thanks.
Mat
Re: my final 1064 error
Matthew
SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
FROM Vouchers
WHERE (((DateDiff('d',[StartDate],Date()))=0) AND
((DateDiff('d',[EndDate],Date()))=0));
Square brackets and your DateDiff syntax are MSSQL, not MySQL.
PB
-
Matthew Stuart wrote:
Here is my final problem that I am struggling to overcome...
SELECT Vouchers.VoucherID, Vouchers.VoucherCode, Vouchers.StartDate,
Vouchers.EndDate, Vouchers.Discount, Vouchers.VoucherTypeID
FROM Vouchers
WHERE (((DateDiff('d',[StartDate],Date()))=0) AND
((DateDiff('d',[EndDate],Date()))=0));
Basically, the error is on the WHERE line of the query, and I assume
it is something to do with the DateDiff, but I don't know if there is
a MySQL equivalent. Also, is Date() valid MySQL?
Thanks.
Mat
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.238 / Virus Database: 270.12.2/2074 - Release Date: 04/22/09 08:49:00
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote: All user information is stored in the mysql database. If you want to see a list of users that have been created, query the user information table. select User, Host from mysql.user Then to see what access each user has, view the grants. show grants for usern...@hostname So I should do the following or am I missing something? == mysql use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db | | func | | help_category | | help_keyword | | help_relation | | help_topic | | host | | proc | | procs_priv | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---+ 17 rows in set (0.00 sec) == Now I have searched the Internet to find out how I can query that 'user' table. How can I find the command that will show my what is in the 'user' table?
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 2:40 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 11:53 AM, Brent Baisley brentt...@gmail.com wrote: All user information is stored in the mysql database. If you want to see a list of users that have been created, query the user information table. select User, Host from mysql.user Then to see what access each user has, view the grants. show grants for usern...@hostname So I should do the following or am I missing something? == mysql use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show tables; +---+ | Tables_in_mysql | +---+ | columns_priv | | db| | func | | help_category | | help_keyword | | help_relation | | help_topic| | host | | proc | | procs_priv| | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name| | time_zone_transition | | time_zone_transition_type | | user | +---+ 17 rows in set (0.00 sec) == Now I have searched the Internet to find out how I can query that 'user' table. How can I find the command that will show my what is in the 'user' table? Is this what you mean? SELECT * FROM user; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 2:45 PM, George Larson george.g.lar...@gmail.com wrote: Is this what you mean? SELECT * FROM user; Yes. That was exactly what I was looking for. Thank you for that info. Still learning these commands so pardon my ignorance. Now I did create that new database called 'forums' and would like to create a new user who has access only to that specific database from localhost. I can't seem to find the command via Google on how I create the user and grant access to just that one specific 'forums' database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote: Now I did create that new database called 'forums' and would like to create a new user who has access only to that specific database from localhost. I can't seem to find the command via Google on how I create the user and grant access to just that one specific 'forums' database. Is this correct assuming I already created the 'forums' database? mysql CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'p...@$$w3rd'; mysql GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' - WITH GRANT OPTION; I don't know if the above is correct way to create a new user in MySQL and grant privileges only to access the 'forums' database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Creating / Lookup Users For Database
On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams carlosw...@gmail.com wrote: On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams carlosw...@gmail.com wrote: Now I did create that new database called 'forums' and would like to create a new user who has access only to that specific database from localhost. I can't seem to find the command via Google on how I create the user and grant access to just that one specific 'forums' database. Is this correct assuming I already created the 'forums' database? mysql CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'p...@$$w3rd'; mysql GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' - WITH GRANT OPTION; I don't know if the above is correct way to create a new user in MySQL and grant privileges only to access the 'forums' database. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=george.g.lar...@gmail.com I've got one foot out the door, so I'm just going to shoot some links for now: http://dev.mysql.com/doc/refman/5.1/en/create-user.html http://www.databasef1.com/tutorial/mysql-create-user.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Mysql on Ultrasparc T2 and floating point performance
Hi, I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point capability on these systems has been a disappointment. Recently, I got my hands on a Sunfire T5420 system and I've been comparing the floating point performance on this system with the T1000, and was expecting to see a significant improvement in floating point by virtue of the fact that the Ultrasparc T2 processor has 1 FPU per core as opposed to 1 FPU per CPU. However, I'm only seeing a marginal improvement for floating point calculations, for example, a select benchmark(1, 1.0 + 2.0) takes roughly 50 seconds to run on both of these systems, however I was expecting a lot better performance from the T2 processor. I've already explored the coolstack mysql builds from Sun, and they don't seem to have any additional optimizations that I'm not already using for my tests. So I'm a bit taken aback by this. I was considering going with the T2 processor as an upgrade to my current servers, but if the floating point is still this poor, I'm strongly considering going back to some multiprocessor/multicore X86 box. Has anyone had any similar experiences with this hardware? -Rod
Re: Mysql on Ultrasparc T2 and floating point performance
In the last episode (Apr 22), Rod Heyd said: I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point capability on these systems has been a disappointment. Recently, I got my hands on a Sunfire T5420 system and I've been comparing the floating point performance on this system with the T1000, and was expecting to see a significant improvement in floating point by virtue of the fact that the Ultrasparc T2 processor has 1 FPU per core as opposed to 1 FPU per CPU. However, I'm only seeing a marginal improvement for floating point calculations, for example, a select benchmark(1, 1.0 + 2.0) takes roughly 50 seconds to run on both of these systems, however I was expecting a lot better performance from the T2 processor. If you are running just one command, then you are only using one of the 8 FPUs on the T2. Try comparing 8 parallel select benchmark(1, 1.0 + 2.0) runs at once on each server. -- Dan Nelson dnel...@allantgroup.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: Mysql on Ultrasparc T2 and floating point performance
On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson dnel...@allantgroup.com wrote: In the last episode (Apr 22), Rod Heyd said: I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point capability on these systems has been a disappointment. Recently, I got my hands on a Sunfire T5420 system and I've been comparing the floating point performance on this system with the T1000, and was expecting to see a significant improvement in floating point by virtue of the fact that the Ultrasparc T2 processor has 1 FPU per core as opposed to 1 FPU per CPU. However, I'm only seeing a marginal improvement for floating point calculations, for example, a select benchmark(1, 1.0 + 2.0) takes roughly 50 seconds to run on both of these systems, however I was expecting a lot better performance from the T2 processor. If you are running just one command, then you are only using one of the 8 FPUs on the T2. Try comparing 8 parallel select benchmark(1, 1.0 + 2.0) runs at once on each server. Hi Dan, Yes, actually, I already know that parallel performance will be much improved, however, I was expecting more improvement on single threads as well, since the specs say that it takes 40 clock cycles just to access the FPU on the T1, but something like 6 clock cycles on the T2. So just from that perspective it seems like there should be a significant improvement for single threads, not just parallel performance. At least that's the way I read the docs from Sun on this. At any rate, my expectations here are clearly wrong, and I guess I'd just like a better understanding of why I'm getting it wrong. Thanks, Rod
Re: Mysql on Ultrasparc T2 and floating point performance
At 03:49 PM 4/22/2009, you wrote: On Wed, Apr 22, 2009 at 1:27 PM, Dan Nelson dnel...@allantgroup.com wrote: In the last episode (Apr 22), Rod Heyd said: I've been running mysql on a T1000 (Ultrasparc T1) system for several years now, and while I've been happy with the performance overall, the poor floating point capability on these systems has been a disappointment. Recently, I got my hands on a Sunfire T5420 system and I've been comparing the floating point performance on this system with the T1000, and was expecting to see a significant improvement in floating point by virtue of the fact that the Ultrasparc T2 processor has 1 FPU per core as opposed to 1 FPU per CPU. However, I'm only seeing a marginal improvement for floating point calculations, for example, a select benchmark(1, 1.0 + 2.0) takes roughly 50 seconds to run on both of these systems, however I was expecting a lot better performance from the T2 processor. If you are running just one command, then you are only using one of the 8 FPUs on the T2. Try comparing 8 parallel select benchmark(1, 1.0 + 2.0) runs at once on each server. Hi Dan, Yes, actually, I already know that parallel performance will be much improved, however, I was expecting more improvement on single threads as well, since the specs say that it takes 40 clock cycles just to access the FPU on the T1, but something like 6 clock cycles on the T2. So just from that perspective it seems like there should be a significant improvement for single threads, not just parallel performance. At least that's the way I read the docs from Sun on this. At any rate, my expectations here are clearly wrong, and I guess I'd just like a better understanding of why I'm getting it wrong. Rod, Have you noticed any significant improvement with floating point calculations with *any* software running on the Sunfire, not just MySQL? For example, can you run some 3rd party benchmark to confirm that the FPU will operate faster compared to your Ultrasparc? If you can't verify this, then there is no point blaming MySQL. If it does show a significant improvement, then maybe MySQL has to be recompiled to take advantage of the faster FPU? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Oracle , what else ?
On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote: Hey Gilles, After MySQL bought by the java maker, and now Sun bought by Oracle, what are we gonna run as RDBMS ? How about PostgreSQL? Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
