Re: Need help with mysql prob
Hi,
abdulazeez alugo wrote:
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an auto_increment value in tbl1, mysql is actually generating the values for it automatically.
Ah, I see your point. I'm guessing by your code you're using PHP? If
so call mysql_insert_id() after you've inserted your record into tbl1.
That will give you the ID of the auto increment column - see the note in
the below link about bigint columns if your data type is bigint.
http://uk3.php.net/mysql_insert_id
Hope this helps,
Andy
Yes I'm using PHP. Can it be something like
function newPost_tbl1($id, $entry, $text)
{
$conn;
$result= mysql_query(INSERT INTO tbl1 (tbl1_id, entrytitle, entrytext)
VALUES ('$id','$entry', $text)',
$conn);
$tbl1_id = mysql_insert_id($conn);
}
Yep that's about it. You said that tbl1_id is an auto-increment column,
why are you including it in the insert query? You should just need
entrytitle and entrytext, then $tbl1_id will be the value of the tbl1_id
field.
I hope you've just missed out everything on the $conn line just for
short-hand, because $conn needs to be a valid connection resource
(result from mysql_connect) before passing it to mysql_query. Also on
your MySQL query line, you've started the insert command string with a
quote but terminated it with a single apostrophe, this terminator
should also be a quote. Your $text should also be enclosed with a
single apostrophe, and don't forget to clean your input ($entry and
$text) otherwise you'll be vulnerable to SQL injection and XSS attacks.
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: A good US Hosting Site?
www.awardspace.com I have both free and paid hosting and it is really really good, it has a lot of tools. Claudio 2009/4/20 Pete Wilson pete...@yahoo.com http://www.kionic.com I've been a very active and heavy customer for years and very satisfied. -- Pete Wilson http://www.pwilson.net/ --- On Sun, 4/19/09, Cameron Rogers cameronl...@gmail.com wrote: From: Cameron Rogers cameronl...@gmail.com Subject: A good US Hosting Site? To: mysql@lists.mysql.com Date: Sunday, April 19, 2009, 11:42 PM Hi everyone. I am starting my first web site. I have a temporary contract with godaddy but know there are better options out there. The only problem is, I don't know reliable sources to research which hosting program to use. Any recommendations on a hosting sight or some good resources to find a hosting site. I need a hosting site that allows me to: 1. Use PHP/MYSQL 2. Send 1000 + emails a day -- the mail function has been my greatest limitation with godaddy Thanks in advance, Cameron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: Does mysql support materialized views?
No, you will have to emulate them using triggers or stored procedures. On Mon, Apr 20, 2009 at 12:28 PM, Lin Chun franks1...@gmail.com wrote: Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Does mysql support materialized views?
On Apr 20, 2009, at 11:34 AM, Olexandr Melnyk wrote: No, you will have to emulate them using triggers or stored procedures. Or: 1. Create table this_is_not_a_view and use that as the materialized view 2. Build a new version in the background this_is_not_a_view_pending as per your data freshness requirements 3. Use RENAME TABLE to push the pending table to production so to speak -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Does mysql support materialized views?
On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun franks1...@gmail.com wrote: Hi Olexandr Melnyk That's to say, create the aggregation tables and update them by triggers? I've noticed a update view in Mysql , can it work under the aggretate operation? You're not looking for views, you need to use normal tables. If you will update the table by triggers, it will always be up-to-date but query cache will be cleared on every such update. On the other hand, if you do it periodically, data will not always be accurate, but query cache can be used efficiently. On Mon, Apr 20, 2009 at 11:34 AM, Olexandr Melnyk omel...@gmail.com wrote: No, you will have to emulate them using triggers or stored procedures. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Does mysql support materialized views?
Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun
Re: Does mysql support materialized views?
No On Mon, Apr 20, 2009 at 2:58 PM, Lin Chun franks1...@gmail.com wrote: Hi I am now working with Mondrian , and need tuning the database, as the materialized views can improve the performance and doesn't need to create the fact tables cheers -- - Lin Chun -- Krishna Chandra Prajapati
Fwd: Does mysql support materialized views?
Query cache stores select query together with its results. When the same query is sent again, result from the cache is returned. Whenever some table is modified, all cache entries referencing it are deleted. That happens even when modification doesn't affect cached rows, eg.: SELECT a FROM a_table WHERE id = 1; # Result gets cached UPDATE a_table SET a = 2 WHERE id = 2; # Result is removed from the query cache SELECT a FROM a_table WHERE id = 1; # Query cache can't be used On Mon, Apr 20, 2009 at 12:56 PM, Lin Chun franks1...@gmail.com wrote: Hi I don't know very well MySQL, the query cache is something like the Snapshotone of the s mod listed in the query is modified, the in Oracle, so we can get the result immediately? On Mon, Apr 20, 2009 at 11:47 AM, Olexandr Melnyk omel...@gmail.com wrote: On Mon, Apr 20, 2009 at 12:41 PM, Lin Chun franks1...@gmail.com wrote: Hi Olexandr Melnyk That's to say, create the aggregation tables and update them by triggers? I've noticed a update view in Mysql , can it work under the aggretate operation? You're not looking for views, you need to use normal tables. If you will update the table by triggers, it will always be up-to-date but query cache will be cleared on every such update. On the other hand, if you do it periodically, data will not always be accurate, but query cache can be used efficiently. On Mon, Apr 20, 2009 at 11:34 AM, Olexandr Melnyk omel...@gmail.com wrote: No, you will have to emulate them using triggers or stored procedures. -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- - Lin Chun -- Sincerely yours, Olexandr Melnyk http://omelnyk.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: Need help with mysql prob
Date: Mon, 20 Apr 2009 08:06:05 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi,
abdulazeez alugo wrote:
Date: Sun, 19 Apr 2009 23:19:56 +0100
From: andy-li...@networkmail.eu
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: Need help with mysql prob
Hi Alugo,
Hi Andy,
Thanks for your prompt response. However, since tbl1_id has an
auto_increment value in tbl1, mysql is actually generating the values for
it automatically.
Ah, I see your point. I'm guessing by your code you're using PHP? If
so call mysql_insert_id() after you've inserted your record into tbl1.
That will give you the ID of the auto increment column - see the note in
the below link about bigint columns if your data type is bigint.
http://uk3.php.net/mysql_insert_id
Hope this helps,
Andy
Yes I'm using PHP. Can it be something like
function newPost_tbl1($id, $entry, $text)
{
$conn;
$result= mysql_query(INSERT INTO tbl1 (tbl1_id, entrytitle, entrytext)
VALUES ('$id','$entry', $text)', $conn);
$tbl1_id = mysql_insert_id($conn);
}
Yep that's about it. You said that tbl1_id is an auto-increment column,
why are you including it in the insert query? You should just need
entrytitle and entrytext, then $tbl1_id will be the value of the tbl1_id
field.
I hope you've just missed out everything on the $conn line just for
short-hand, because $conn needs to be a valid connection resource
(result from mysql_connect) before passing it to mysql_query. Also on
your MySQL query line, you've started the insert command string with a
quote but terminated it with a single apostrophe, this terminator
should also be a quote. Your $text should also be enclosed with a
single apostrophe, and don't forget to clean your input ($entry and
$text) otherwise you'll be vulnerable to SQL injection and XSS attacks.
Andy
Hi Andy,
Thank you very much you have been really very helpful. All those mistakes you
pointed at in the script about the apostrophe and others, are simple mistakes I
just made in the rush of typing the message; and yes $conn is the result from
mysql_connect. In my original script I clean my script to avoid mysql injection.
However, if you look at the code very well, you'll realize that I have stored
the result of the mysql_insert-id($conn) in a php variable $tbl1_id and this is
defined within a function newPost_tbl1($id, $entry, $text). My problem now is
how to access that variable in the function that inserts into the child table
so that I'll have the same value for tbl1_id in tbl1 and tbl1_id in tbl2.
Thanks in advance.
Alugo.
_
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
Re: Need help with mysql prob
Hi Alugo, abdulazeez alugo wrote: Hi Andy, Thank you very much you have been really very helpful. All those mistakes you pointed at in the script about the apostrophe and others, are simple mistakes I just made in the rush of typing the message; and yes $conn is the result from mysql_connect. In my original script I clean my script to avoid mysql injection. No worries, just thought I'd point it out in case ;-) However, if you look at the code very well, you'll realize that I have stored the result of the mysql_insert-id($conn) in a php variable $tbl1_id and this is defined within a function *newPost_tbl1($id, $entry, $text).* My problem now is how to access that variable in the function that inserts into the child table so that I'll have the same value for tbl1_id in tbl1 and tbl1_id in tbl2. Why not just return it from the function? $tbl1_id = mysql_insert_id(); return $tbl1_id; Then in the code that calls newPost_tbl1 ... $tbl1_id = newPost_tbl1($id, $entry, $text); newPost_tbl2($tbl1_id, ); Regards, 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: Need help with mysql prob
Date: Mon, 20 Apr 2009 13:03:14 +0100 From: andy-li...@networkmail.eu To: defati...@hotmail.com CC: mysql@lists.mysql.com Subject: Re: Need help with mysql prob Hi Alugo, abdulazeez alugo wrote: Hi Andy, Thank you very much you have been really very helpful. All those mistakes you pointed at in the script about the apostrophe and others, are simple mistakes I just made in the rush of typing the message; and yes $conn is the result from mysql_connect. In my original script I clean my script to avoid mysql injection. No worries, just thought I'd point it out in case ;-) However, if you look at the code very well, you'll realize that I have stored the result of the mysql_insert-id($conn) in a php variable $tbl1_id and this is defined within a function *newPost_tbl1($id, $entry, $text).* My problem now is how to access that variable in the function that inserts into the child table so that I'll have the same value for tbl1_id in tbl1 and tbl1_id in tbl2. Why not just return it from the function? $tbl1_id = mysql_insert_id(); return $tbl1_id; Then in the code that calls newPost_tbl1 ... $tbl1_id = newPost_tbl1($id, $entry, $text); newPost_tbl2($tbl1_id, ); Regards, Andy Thank you very much Andy, Now my problem is solved. Cheers. Alugo Abdulazeez. _ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us
RE: A good US Hosting Site?
-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 10:28 To: p...@pwilson.net Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com Subject: Re: A good US Hosting Site? www.awardspace.com I have both free and paid hosting and it is really really good, it has a lot of tools. Claudio http://www.free-webhosts.com/reviews/AwardSpace.php Maximum file size limit 500 KB Please, tell me that's a joke. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Sun bought by Oracle
I've just been made aware by a client that Oracle have purchased Sun Microsystems. The article below on Sun's website mentions that Oracle are committed to Linux and other open platforms and mentions the fact that Java touches practically every business system around. http://www.sun.com/third-party/global/oracle/index.jsp I wonder what Oracle's plans are when it comes to MySQL? There is no mention of MySQL in the above article. Will it eventually come under the Oracle umbrella, much like BerkeleyDB did? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
Whats the future of 'MySQL' under Oracle ? On Mon, Apr 20, 2009 at 6:45 PM, Andy Shellam andy-li...@networkmail.euwrote: I've just been made aware by a client that Oracle have purchased Sun Microsystems. The article below on Sun's website mentions that Oracle are committed to Linux and other open platforms and mentions the fact that Java touches practically every business system around. http://www.sun.com/third-party/global/oracle/index.jsp I wonder what Oracle's plans are when it comes to MySQL? There is no mention of MySQL in the above article. Will it eventually come under the Oracle umbrella, much like BerkeleyDB did? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati
Re: Sun bought by Oracle
Only time will tell what will happen, but I have read a few articles saying Oracle had been interested specifically in buying MySQL from Sun as it gives them an open source DB offering (which they dont have now right?), and that brings with it contact with potential customers for support or non-free solutions etc... However that was from the internet press so its all just rumours and supositions ;) cheers Andy. Quoting Krishna Chandra Prajapati prajapat...@gmail.com: Whats the future of 'MySQL' under Oracle ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A good US Hosting Site?
On Sun, Apr 19, 2009 at 23:42, Cameron Rogers cameronl...@gmail.com wrote: Hi everyone. I am starting my first web site. I have a temporary contract with godaddy but know there are better options out there. The only problem is, I don't know reliable sources to research which hosting program to use. Any recommendations on a hosting sight or some good resources to find a hosting site. I need a hosting site that allows me to: 1. Use PHP/MYSQL 2. Send 1000 + emails a day -- the mail function has been my greatest limitation with godaddy Actually, Cam, you can just contact GoDaddy to lift the limit, depending on your arrangement. Their dedicated servers had a limit of 3,000 emails per month, at least as recent as 2007, and all that was required was sending them a request and agreeing to a statement that said you would not send SPAM. There are probably other reasons why not to use them, but if that was your biggest issue, it's one that may well be easy to fix. -- /Daniel P. Brown daniel.br...@parasane.net || danbr...@php.net http://www.parasane.net/ || http://www.pilotpig.net/ 50% Off All Shared Hosting Plans at PilotPig: Use Coupon DOW1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Small InnoDB table with many concurrent queries
Hi there. I've a small table with my daily banner hits. 1. version was with myisam but with a lot of concurrent queries (all SELECTs) i get too many table locks. so i changed it to an innodb table. works great most of the time. sometimes it seems to be too much, starting at about 500 concurrent queries i see a huge amount of processes taking about 3 minutes to finish 'sending data'. the SELECT queries use the correct index and data returned is small (2 integers). the table has only 4MB and about 35000 rows. it can't be the size of the table... mysql server is connected with a 1G switch. so i don't think it's network related. mysql server is a dual xeon 2,3GHz with 8G ram and SCSI disk RAID5. did i hit a innodb limit with this server configuration? or is my my.cnf bad? my.cnf --- key_buffer = 750M max_allowed_packet = 32M table_cache = 1 sort_buffer_size= 4M join_buffer_size= 4M read_buffer_size= 2M read_rnd_buffer_size= 4M myisam_sort_buffer_size = 128M query_cache_size= 750M query_cache_limit = 16M thread_cache= 32 thread_concurrency = 16 tmp_table_size = 700M max_heap_table_size = 700M net_buffer_length = 16K skip-external-locking innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 8M innodb_lock_wait_timeout= 120 innodb_log_file_size= 256M innodb_log_files_in_group = 3 -- thanks for any info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
At 08:31 AM 4/20/2009, you wrote: Only time will tell what will happen, but I have read a few articles saying Oracle had been interested specifically in buying MySQL from Sun as it gives them an open source DB offering (which they dont have now right?), and that brings with it contact with potential customers for support or non-free solutions etc... However that was from the internet press so its all just rumours and supositions ;) cheers Andy. Quoting Krishna Chandra Prajapati prajapat...@gmail.com: Whats the future of 'MySQL' under Oracle ? A lot depends on whether MySQL can make money for Oracle and not encroach on their Oracle sales. Will they continue developing MySQL cluster as open source? I hope so. But I worry about the fact that they have competing products and they could fork MySQL into open source (community supported) and their own maintained MySQL version like Borland did with Interbase and Firebird. I think IBM would have been a much better partner than Oracle. 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: Small InnoDB table with many concurrent queries
change connect timeout to 10sec flatly use skip-name-resolve whats the total size of your database. On Mon, Apr 20, 2009 at 7:58 PM, living liquid | Christian Meisinger c.meisin...@livingliquid.com wrote: Hi there. I've a small table with my daily banner hits. 1. version was with myisam but with a lot of concurrent queries (all SELECTs) i get too many table locks. so i changed it to an innodb table. works great most of the time. sometimes it seems to be too much, starting at about 500 concurrent queries i see a huge amount of processes taking about 3 minutes to finish 'sending data'. the SELECT queries use the correct index and data returned is small (2 integers). the table has only 4MB and about 35000 rows. it can't be the size of the table... mysql server is connected with a 1G switch. so i don't think it's network related. mysql server is a dual xeon 2,3GHz with 8G ram and SCSI disk RAID5. did i hit a innodb limit with this server configuration? or is my my.cnf bad? my.cnf --- key_buffer = 750M If not using myisam table, you it to 400mb max_allowed_packet = 32M table_cache = 1 big (5000 to 6000) sort_buffer_size= 4M join_buffer_size= 4M read_buffer_size= 2M read_rnd_buffer_size= 4M myisam_sort_buffer_size = 128M query_cache_size= 750M query_cache_limit = 16M if the query result set is small change it between 1 to 3 mb thread_cache= 32 thread_concurrency = 16 tmp_table_size = 700M max_heap_table_size = 700M net_buffer_length = 16K skip-external-locking innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G too big can also be an issue innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 8M innodb_lock_wait_timeout= 120 innodb_log_file_size= 256M innodb_log_files_in_group = 3 -- thanks for any info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com -- Krishna Chandra Prajapati
Re: A good US Hosting Site?
Well, not a joke for free hosting. But it is, for me, by far the best hosting site. Compleat, easy to use, five subdomains, and also mysql included. Paid hosting is outstanding. Cheers Claudio 2009/4/20 Mark ad...@asarian-host.net -Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 10:28 To: p...@pwilson.net Cc: mysql@lists.mysql.com; Cameron Rogers; step...@kionic.com Subject: Re: A good US Hosting Site? www.awardspace.com I have both free and paid hosting and it is really really good, it has a lot of tools. Claudio http://www.free-webhosts.com/reviews/AwardSpace.php Maximum file size limit 500 KB Please, tell me that's a joke. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
Re: Sun bought by Oracle
I figure that they'll either kill mysql or they'll limit the commnunity version in ways that will make you purchase a commercial version if you want to continue to use it. I figure there will be heavy migrations to open source alternatives. --C Andy Shellam wrote: I've just been made aware by a client that Oracle have purchased Sun Microsystems. The article below on Sun's website mentions that Oracle are committed to Linux and other open platforms and mentions the fact that Java touches practically every business system around. http://www.sun.com/third-party/global/oracle/index.jsp I wonder what Oracle's plans are when it comes to MySQL? There is no mention of MySQL in the above article. Will it eventually come under the Oracle umbrella, much like BerkeleyDB did? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A good US Hosting Site?
I haven't had a problem with Hostgator yet. Prices are fair and reasonable Also I've installed web apps through their portal and on my own and haven't had a problem yet. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
At 08:22 AM 4/20/2009, Krishna Chandra Prajapati wrote: Whats the future of 'MySQL' under Oracle ? Here is a blog on ZDNet in case anyone is interested. http://blogs.zdnet.com/BTL/?p=16598tag=nl.e539 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: Sun bought by Oracle
I think that you'e being paranoid. IMO, Oracle will continue to support and develop mySQL. Further, I think that these concerns about the future of mySQL overlook the points behind the purchase: 1. To obtain the Sun hardware and thus provide a complete hardware and software solution. 2. To further optimize Oracle to take full advantage of the Solaris OS. 3. To continue to support Linux. 4. To get Java and thus penetrate the mobile device marketplace. 5. And finally, to grow Oracle revenues by $1B+ a year and growing. Given the purchase price, the acquisition will pay for itself within 5 years. Compared to all these reasons, the mySQL part of the acquisition is small potatoes. Arthur On Mon, Apr 20, 2009 at 11:44 AM, Curtis Maurand cur...@maurand.com wrote: I figure that they'll either kill mysql or they'll limit the commnunity version in ways that will make you purchase a commercial version if you want to continue to use it. I figure there will be heavy migrations to open source alternatives. --C Andy Shellam wrote: I've just been made aware by a client that Oracle have purchased Sun Microsystems. The article below on Sun's website mentions that Oracle are committed to Linux and other open platforms and mentions the fact that Java touches practically every business system around. http://www.sun.com/third-party/global/oracle/index.jsp I wonder what Oracle's plans are when it comes to MySQL? There is no mention of MySQL in the above article. Will it eventually come under the Oracle umbrella, much like BerkeleyDB did? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=fuller.art...@gmail.com
Re: A good US Hosting Site?
I've been using www.host45.com for some years. linux and they've always been reliable. :-) -- unheralded genius: A clean desk is the sign of a dull mind. - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
... the points behind the purchase: 1. To obtain the Sun hardware and thus provide a complete hardware and software solution. 2. To further optimize Oracle to take full advantage of the Solaris OS. 3. To continue to support Linux. 4. To get Java and thus penetrate the mobile device marketplace. 5. And finally, to grow Oracle revenues by $1B+ a year and growing. Given the purchase price, the acquisition will pay for itself within 5 years. An optimist wrote that. A pessimist, Larry Dignan at http://blogs.zdnet.com/BTL/?p=16598tag=nl.e539, wrote point six: Oracle gets to kill MySQL. There's no way Ellison will let that open source database mess with the margins of his database. MySQL at best will wither from neglect. In any case, MySQL is MyToast. We ought to know who's right within half a year. PB - Arthur Fuller wrote: I think that you'e being paranoid. IMO, Oracle will continue to support and develop mySQL. Further, I think that these concerns about the future of mySQL overlook the points behind the purchase: 1. To obtain the Sun hardware and thus provide a complete hardware and software solution. 2. To further optimize Oracle to take full advantage of the Solaris OS. 3. To continue to support Linux. 4. To get Java and thus penetrate the mobile device marketplace. 5. And finally, to grow Oracle revenues by $1B+ a year and growing. Given the purchase price, the acquisition will pay for itself within 5 years. Compared to all these reasons, the mySQL part of the acquisition is small potatoes. Arthur On Mon, Apr 20, 2009 at 11:44 AM, Curtis Maurand cur...@maurand.com wrote: I figure that they'll either kill mysql or they'll limit the commnunity version in ways that will make you purchase a commercial version if you want to continue to use it. I figure there will be heavy migrations to open source alternatives. --C Andy Shellam wrote: I've just been made aware by a client that Oracle have purchased Sun Microsystems. The article below on Sun's website mentions that Oracle are committed to Linux and other open platforms and mentions the fact that Java touches practically every business system around. http://www.sun.com/third-party/global/oracle/index.jsp I wonder what Oracle's plans are when it comes to MySQL? There is no mention of MySQL in the above article. Will it eventually come under the Oracle umbrella, much like BerkeleyDB did? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=fuller.art...@gmail.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.238 / Virus Database: 270.12.1/2069 - Release Date: 04/20/09 10:36:00
UNIX_TIMESTAMP - Can anyone explain this behavior?
Hi all,
Does anyone know what is going on here:
//Query:
select UNIX_TIMESTAMP(TIMESTAMP('2003-01-01 00:00:00')) as first,
UNIX_TIMESTAMP(TIMESTAMP('2003-10-05 00:00:00')) as second,
UNIX_TIMESTAMP(TIMESTAMP('2004-01-01 00:00:00')) as third;
++++
| first | second | third |
++++
| 1041400800 | 106533 | 1072936800 |
++++
// Converting timestamps to UTC using linux date command (could also use
http://www.4webhelp.net/us/timestamp.php)
$ date -u -d @1072936800
Thu Jan 1 06:00:00 UTC 2004
$ date -u -d @1041400800
Wed Jan 1 06:00:00 UTC 2003
$ date -u -d @1064984400
Wed Oct 1 05:00:00 UTC 2003
MySQL seems to treat the local time as being UTC -6 hours in the first two
cases but as UTC -5 in other cases. The system local time appears to be
UTC-5 (EST):
// Attempting to determine MySQL's timezone offset:
select UNIX_TIMESTAMP(UTC_TIMESTAMP()) - UNIX_TIMESTAMP(now()) as offset:
++
| offset |
++
| 18000 |
++
which is consistent with the last result, but not the first two.
I have not yet tested more dates throughout the year to see when the change
occurs, and if there is a pattern, but I though I'd ask first to see if
anyone else has either
encountered this before, or knows what is going on?
I would like to be able to store some UTC datetimes in a system that uses
localtime, and then extract them as UTC timestamps again, which is why I'm
trying to figure
out the proper offset. On this particular system I also do not have the
ability to change the default timezone (e.g. to UTC/GMT), so I'm stuck with
using local dates.
Any suggestions? Any help would be greatly appreciated :)
Thanks!
-Keith
RE: Sun bought by Oracle
From: Peter Brawley [mailto:peter.braw...@earthlink.net] An optimist wrote that. A pessimist, Larry Dignan at http://blogs.zdnet.com/BTL/?p=16598tag=nl.e539, wrote point six: Oracle gets to kill MySQL. There's no way Ellison will let that open source database mess with the margins of his database. MySQL at best will wither from neglect. In any case, MySQL is MyToast. We ought to know who's right within half a year. Is MySQL not Open Source? Heck, I'd love to help with that. We would just have to change the name to something befitting the product. MySQL still tickles my MS warning alerts; My Pictures, My Music, My Videos, etc. How about 'GNO', pronounced like 'Know', stands for GNO's Not Oracle? The information contained in this message and any attachment may be proprietary, confidential, and privileged or subject to the work product doctrine and thus protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to this message and deleting it and all copies and backups thereof. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
I don't think the purchase was about MySQL at all. I'm sure Oracle is far more interested in java, zfs, and solaris than they are MySQL. MySQL is just an added bonus that will go well with their acquisition of Innobase Oy a few years ago. Oracle didn't kill InnoDB and it's not very likely that they will kill MySQL. If you walk around the user conference this week you will see why it would be incredibly stupid try to try kill MySQL. Not that companies like Percona would let that happen anyway. After all it is GPL. On Mon, Apr 20, 2009 at 10:02 AM, michael.coll-ba...@verizonwireless.com wrote: From: Peter Brawley [mailto:peter.braw...@earthlink.net] An optimist wrote that. A pessimist, Larry Dignan at http://blogs.zdnet.com/BTL/?p=16598tag=nl.e539, wrote point six: Oracle gets to kill MySQL. There's no way Ellison will let that open source database mess with the margins of his database. MySQL at best will wither from neglect. In any case, MySQL is MyToast. We ought to know who's right within half a year. Is MySQL not Open Source? Heck, I'd love to help with that. We would just have to change the name to something befitting the product. MySQL still tickles my MS warning alerts; My Pictures, My Music, My Videos, etc. How about 'GNO', pronounced like 'Know', stands for GNO's Not Oracle? The information contained in this message and any attachment may be proprietary, confidential, and privileged or subject to the work product doctrine and thus protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to this message and deleting it and all copies and backups thereof. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.com -- Eric Bergen eric.ber...@provenscaling.com http://www.provenscaling.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: Small InnoDB table with many concurrent queries
MyISAM should be fine with many SELECTs running at once. Tables are only locked for INSERTs DELETEs and UPDATEs, and conditionally at that. You can set MySQL to always append INSERTs to the end of the file so you can insert while selecting. What is the whole picture? If you were having locking problems, you are doing more than just a lot of SELECTs. How many inserts, updates, deletes are you doing? If you are doing a lot of updates, even InnoDB will block if you are trying to update the same record across queries. If you have a lot of querying in sending data state, check which ones are in a different state. One of those may be the culprit. Brent Baisley On Mon, Apr 20, 2009 at 10:28 AM, living liquid | Christian Meisinger c.meisin...@livingliquid.com wrote: Hi there. I've a small table with my daily banner hits. 1. version was with myisam but with a lot of concurrent queries (all SELECTs) i get too many table locks. so i changed it to an innodb table. works great most of the time. sometimes it seems to be too much, starting at about 500 concurrent queries i see a huge amount of processes taking about 3 minutes to finish 'sending data'. the SELECT queries use the correct index and data returned is small (2 integers). the table has only 4MB and about 35000 rows. it can't be the size of the table... mysql server is connected with a 1G switch. so i don't think it's network related. mysql server is a dual xeon 2,3GHz with 8G ram and SCSI disk RAID5. did i hit a innodb limit with this server configuration? or is my my.cnf bad? my.cnf --- key_buffer = 750M max_allowed_packet = 32M table_cache = 1 sort_buffer_size = 4M join_buffer_size = 4M read_buffer_size = 2M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 128M query_cache_size = 750M query_cache_limit = 16M thread_cache = 32 thread_concurrency = 16 tmp_table_size = 700M max_heap_table_size = 700M net_buffer_length = 16K skip-external-locking innodb_additional_mem_pool_size = 16M innodb_buffer_pool_size = 2G innodb_thread_concurrency = 16 innodb_flush_log_at_trx_commit = 2 innodb_log_buffer_size = 8M innodb_lock_wait_timeout = 120 innodb_log_file_size = 256M innodb_log_files_in_group = 3 -- thanks for any info -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=brentt...@gmail.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: Sun bought by Oracle
I'm wondering what the DOJ is going to think of that deal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com wrote: I'm wondering what the DOJ is going to think of that deal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kaushalshri...@gmail.com DOJ ? does it mean Department of Justice ? Kaushal
Re: Sun bought by Oracle
We are talking of financial moves here. I think nothing will be touched at least for first years, I don't see product or services overlapping. Oracle is one thing, MySQL another. If they are so crazy to 'shut-down' MySQL, the second after there would be the fork, MySQL could be 'closed', but the community is and will always be open. I, myself, I would stop using MySQL immediately and switch to drizzle or any other fork, or any other open project. Cheers Claudio Eric Bergen wrote: I don't think the purchase was about MySQL at all. I'm sure Oracle is far more interested in java, zfs, and solaris than they are MySQL. MySQL is just an added bonus that will go well with their acquisition of Innobase Oy a few years ago. Oracle didn't kill InnoDB and it's not very likely that they will kill MySQL. If you walk around the user conference this week you will see why it would be incredibly stupid try to try kill MySQL. Not that companies like Percona would let that happen anyway. After all it is GPL. On Mon, Apr 20, 2009 at 10:02 AM, michael.coll-ba...@verizonwireless.com wrote: From: Peter Brawley [mailto:peter.braw...@earthlink.net] An optimist wrote that. A pessimist, Larry Dignan at http://blogs.zdnet.com/BTL/?p=16598tag=nl.e539, wrote point six: Oracle gets to kill MySQL. There's no way Ellison will let that open source database mess with the margins of his database. MySQL at best will wither from neglect. In any case, MySQL is MyToast. We ought to know who's right within half a year. Is MySQL not Open Source? Heck, I'd love to help with that. We would just have to change the name to something befitting the product. MySQL still tickles my MS warning alerts; My Pictures, My Music, My Videos, etc. How about 'GNO', pronounced like 'Know', stands for GNO's Not Oracle? The information contained in this message and any attachment may be proprietary, confidential, and privileged or subject to the work product doctrine and thus protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify me immediately by replying to this message and deleting it and all copies and backups thereof. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=eric.ber...@gmail.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: A good US Hosting Site?
-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 17:22 To: Mark Cc: mysql@lists.mysql.com Subject: Re: A good US Hosting Site? Well, not a joke for free hosting. But it is, for me, by far the best hosting site. Compleat, easy to use, five subdomains, and also mysql included. Paid hosting is outstanding. Yeah, but a Maximum file size limit 500 KB, what can you do with that?? Your average background image is bigger! Not to mention my MySQL databases. Sorry to say, but a 500KB file limit makes hosting there useless, IMHO. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A good US Hosting Site?
I would recommend PilotPig http://www.pilotpig.net/ Good service, good support, reasonably priced, and integrity to boot. David
Re: Sun bought by Oracle
Quite frankly, if MySQL gets neglected in the future, I'll switch to PostgreSQL, as simple as that. However, the acquisition of Sun does place Oracle in an interesting market position - the enterprise Apple as mentioned in the ZDNet article. Let's see and hope the best. Cheers, Michael On 21/04/2009, at 6:16 AM, Claudio Nanni wrote: We are talking of financial moves here. I think nothing will be touched at least for first years, I don't see product or services overlapping. Oracle is one thing, MySQL another. If they are so crazy to 'shut-down' MySQL, the second after there would be the fork, MySQL could be 'closed', but the community is and will always be open. I, myself, I would stop using MySQL immediately and switch to drizzle or any other fork, or any other open project. Cheers Claudio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: A good US Hosting Site?
Mark wrote: Yeah, but a Maximum file size limit 500 KB, what can you do with that?? Your average background image is bigger! Not to mention my MySQL really? you use background images bigger than 500kb? lucky if you get a second visit! mysql database of course has nothing to do with that limit. databases. Sorry to say, but a 500KB file limit makes hosting there useless, IMHO. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: A good US Hosting Site?
-Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: maandag 20 april 2009 22:29 To: Mark Cc: mysql@lists.mysql.com Subject: Re: A good US Hosting Site? Mark wrote: Yeah, but a Maximum file size limit 500 KB, what can you do with that?? Your average background image is bigger! Not to mention my MySQL really? you use background images bigger than 500kb? lucky if you get a second visit! mysql database of course has nothing to do with that limit. Yes, really. :) Besides, it's not just images, also all kinds of data files, like .swf and such: 500KB is just ridiculously small. I have a client here with an elegant photo gallery, and a quick 'find' shows that 13% of all its files are 500KB. Fortunately, it seems that absurd limit just exists for the free hosting. So, I may consider them after all, as there's no such thing as a free lunch, and their paid plans seem very reasonable. And, indeed, looks like their MySQL databases were never included in said limit to begin with. - Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
Yep. In particular the anti-trust division of the DOJ. Kaushal Shriyan wrote: On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com mailto:john.l.me...@gmail.com wrote: I'm wondering what the DOJ is going to think of that deal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kaushalshri...@gmail.com DOJ ? does it mean Department of Justice ? Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Sun bought by Oracle
http://www.sun.com/third-party/global/oracle/ anyone saw this ?? On Tue, Apr 21, 2009 at 2:54 AM, John Meyer john.l.me...@gmail.com wrote: Yep. In particular the anti-trust division of the DOJ. Kaushal Shriyan wrote: On Mon, Apr 20, 2009 at 11:14 PM, John Meyer john.l.me...@gmail.com mailto:john.l.me...@gmail.com wrote: I'm wondering what the DOJ is going to think of that deal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=kaushalshri...@gmail.com DOJ ? does it mean Department of Justice ? Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=manish.in@gmail.com -- Manish Gupta Follow me on twitter: twitter.com/nimbus3000
