Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 930 Next 30 Older Entries

Displaying posts with tag: sun (reset)

Life at Oracle
Employee +0 Vote Up -0Vote Down
It's now been 12 months since Oracle absorbed Sun. A lot has happened in that time, and the good news is that Sun's technology has a new lease on life. Reviewing my blog entries over the last 2 or 3 years, most of them were focussed on MySQL and T-series systems. Lots of good things are happening with both product lines.

As for me, I've been working on SPARC Supercluster. More on this topic later... ;-)

Spring saving time: watch your TIMESTAMPs
Employee_Team +0 Vote Up -0Vote Down

Every March we have a lot of bug reports and support issues about Daylight Saving Time changes.


General rule here is to remember 1 hour at March, 27 night will be missed in most of European countries: for example in Moscow after 01:59:59 next time will be 03:00:00. And yes, I am too late for America =)


MySQL handles such timestamps properly, therefore expect no such time and date will be inserted in STRICT mode and next valid date will be inserted for not existent time in forgiving mode. For Moscow '2011-03-27 03:00:00' will be inserted if you try to insert timestamps in '2011-03-27 02:00:01' - '2011-03-27 02:59:59' range.


You can see how Europe switch to DST at http://www.timeanddate.com/news/time/europe-starts-dst-2011.html Please note some






  [Read more...]
Spring saving time: watch your TIMESTAMPs
Employee_Team +0 Vote Up -0Vote Down

Every March we have a lot of bug reports and support issues about Daylight Saving Time changes.


General rule here is to remember 1 hour at March, 27 night will be missed in most of European countries: for example in Moscow after 01:59:59 next time will be 03:00:00. And yes, I am too late for America =)


MySQL handles such timestamps properly, therefore expect no such time and date will be inserted in STRICT mode and next valid date will be inserted for not existent time in forgiving mode. For Moscow '2011-03-27 03:00:00' will be inserted if you try to insert timestamps in '2011-03-27 02:00:01' - '2011-03-27 02:59:59' range.


You can see how Europe switch to DST at http://www.timeanddate.com/news/time/europe-starts-dst-2011.html Please note some






  [Read more...]
Oracle Solaris Cluster 3.3 available
Employee +2 Vote Up -2Vote Down
On September 8, 2010 Oracle announced the availability of Oracle Solaris Cluster 3.3

Oracle Solaris Cluster 3.3, built on the solid foundation of Oracle Solaris, offers the 
most extensive Oracle enterprise High Availability and Disaster Recovery solutions for the 
largest portfolio of mission-critical applications.

Integrated and thoroughly tested with Oracle's Sun servers, storage, connectivity 
solutions and Solaris 10 features, Oracle Solaris Cluster is now qualified with Solaris 
Trusted Extensions, supports Infiniband for general networking or storage usage, and can 
be deployed with Oracle Unified Storage in Campus Cluster configurations. It extends its 
applications support to new Oracle applications such as Oracle Business Intelligence, 
PeopleSoft, TimesTen, and MySQL Cluster.

The single, integrated HA and DR solution enables multi-tier deployments in virtualized 
environments.
  [Read more...]
Oracle Solaris Cluster 3.3 available
Employee +0 Vote Up -0Vote Down
On September 8, 2010 Oracle announced the availability of Oracle Solaris Cluster 3.3

Oracle Solaris Cluster 3.3, built on the solid foundation of Oracle Solaris, offers the 
most extensive Oracle enterprise High Availability and Disaster Recovery solutions for the 
largest portfolio of mission-critical applications.

Integrated and thoroughly tested with Oracle's Sun servers, storage, connectivity 
solutions and Solaris 10 features, Oracle Solaris Cluster is now qualified with Solaris 
Trusted Extensions, supports Infiniband for general networking or storage usage, and can 
be deployed with Oracle Unified Storage in Campus Cluster configurations. It extends its 
applications support to new Oracle applications such as Oracle Business Intelligence, 
PeopleSoft, TimesTen, and MySQL Cluster.

The single, integrated HA and DR solution enables multi-tier deployments in virtualized
  [Read more...]
Oracle Solaris Cluster 3.3 available
Employee +0 Vote Up -0Vote Down
On September 8, 2010 Oracle announced the availability of Oracle Solaris Cluster 3.3

Oracle Solaris Cluster 3.3, built on the solid foundation of Oracle Solaris, offers the 
most extensive Oracle enterprise High Availability and Disaster Recovery solutions for the 
largest portfolio of mission-critical applications.

Integrated and thoroughly tested with Oracle's Sun servers, storage, connectivity 
solutions and Solaris 10 features, Oracle Solaris Cluster is now qualified with Solaris 
Trusted Extensions, supports Infiniband for general networking or storage usage, and can 
be deployed with Oracle Unified Storage in Campus Cluster configurations. It extends its 
applications support to new Oracle applications such as Oracle Business Intelligence, 
PeopleSoft, TimesTen, and MySQL Cluster.

The single, integrated HA and DR solution enables multi-tier deployments in virtualized
  [Read more...]
Developer Week in Review
+0 Vote Up -1Vote Down

Here's your weekly helping of developer info:

The sudden but inevitable Apple news

Several pieces of news on the Apple front this week. First up: the Gold Master seed (which either sounds like something you plant to get nice apples, or something out of a bad SF eugenics novel) for iOS 4.2 dropped, signaling the green light for iPad/iPhone/iPod developers to submit 4.2-ready applications to the App Store. Traditionally, the pre-release to developers is followed about a week later by the general release, and is identical.

Meanwhile, continuing to muddy the waters about what is and isn't allowed on the iPhone, Adobe gave a

  [Read more...]
Into the sunset
Employee +13 Vote Up -1Vote Down

After four years working with the MySQL team, under three different companies, it's time for me to pursue a new career.

Tomorrow is my last working day at Oracle. (Working? But it's Sunday! So, ehm, kind of, anyway, you got the point.)

You may look at my personal blog in the coming days to know what I am going to do next.

Right now, I would like to just say thank you to all my colleagues in the MySQL Team, and to all the community people with whom I have shared the wonderful experience of these four years.

And also, thanks to all the ones who have offered me a job. Really. There were many offers. I am sorry I could not take them all and I had to choose one in the end, but thanks,

  [Read more...]
Into the sunset
Employee +0 Vote Up -0Vote Down

After four years working with the MySQL team, under three different companies, it's time for me to pursue a new career.

Tomorrow is my last working day at Oracle. (Working? But it's Sunday! So, ehm, kind of, anyway, you got the point.)

You may look at my personal blog in the coming days to know what I am going to do next.

Right now, I would like to just say thank you to all my colleagues in the MySQL Team, and to all the community people with whom I have shared the wonderful experience of these four years.

And also, thanks to all the ones who have offered me a job. Really. There were many offers. I am sorry I could not take them all and I had to choose one in the end, but

  [Read more...]
Into the sunset
Employee +0 Vote Up -0Vote Down

After four years working with the MySQL team, under three different companies, it's time for me to pursue a new career.

Tomorrow is my last working day at Oracle. (Working? But it's Sunday! So, ehm, kind of, anyway, you got the point.)

You may look at my personal blog in the coming days to know what I am going to do next.

Right now, I would like to just say thank you to all my colleagues in the MySQL Team, and to all the community people with whom I have shared the wonderful experience of these four years.

And also, thanks to all the ones who have offered me a job. Really. There were many offers. I am sorry I could not take them all and I had to choose one in the end, but

  [Read more...]
Rackspace Rookie-O (in Hong Kong!)
+0 Vote Up -0Vote Down

I’d meant to finish writing this way back in July… but I failed at that. Now is a good time to talk about Rookie-O as my again new colleague Andrew Hutchings (Buy his and Sergei’s book on MySQL 5.1 Plugin Development!) just went through the same thing (but in London instead of Hong Kong) given by the same trainer (Hi Eddie!).

Rackspace is the second employer I’ve had that has some kind of new hire training (the first being Sun). I am, of course, not quite counting Salmiakki as new-hire training for MySQL (although I probably should). To quote from the

  [Read more...]
Translation of "Methods for searching errors in SQL application" just finished
Employee_Team +0 Vote Up -0Vote Down

Translation of "Methods for searching errors in SQL application" just finished, epilogue is at http://sql-error.microbecal.com/en/concl.html


It contains list of methods which had been discussed.




Epilogue


Finally I'd like to repeat methods which we discussed. Unfortunately
there are several problems left. I will be glad to know your opinion
about what else to descuss. I will be waiting your notes at sveta_dot_smirnova_at_oracle_dot_com or sveta_at_js-client_dot_com



List of methods.


...


Rest of the text is here

Translation of "Appendix. Methods of copying and moving of MySQL databases." of "Methods for searching errors in SQL application" just published
Employee_Team +0 Vote Up -2Vote Down

Translation of appendix about methods of copying and moving MySQL databases just published. This is just short overview of possible methods and does not pretend to be detailed guide. It starts as:




Appendix. Methods of copying and moving of MySQL databases.


In this application I'd like to shortly discuss general methods of backup and moving of mySQL databases.



Easier and recommended way of data moving is mysqldump utility. You can copy data with help of following command:





$mysqldump dbname [tblname ...] >dump.sql


...


and continues here


Log Buffer #203, A Carnival of the Vanities for DBAs
+1 Vote Up -0Vote Down

Welcome to Log Buffer. The weekly roundup of posts, and news of what’s happening in the database world.

At Pythian, we’re pretty much recovered from a hectic Oracle OpenWorld 2010, and I’m no longer an OOW virgin. What an experience! I had the pleasure of meeting many of you Log Buffer readers and contributors at the Annual Blogger’s Meetup at Jillian’s. Great to put faces to names. And I now officially feel like “Vanessa from Log Buffer”, as many of your t-shirts will show.

Many thanks to Marc Fielding for providing the hot items for this week’s post,

  [Read more...]
Translation of Summary of Part 4 of "Methods for searching errors in SQL application" just published
Employee_Team +0 Vote Up -1Vote Down


Translation of summary of last part, "Techniques, used for debugging of Production applications" just published. This is almost end, only appendix about backup techniques and epilogue left.




Summary.


In the last chapter we discussed methods of testing problems which can happen only on production server. Lets repeat them:


Method #25: if something unexpected happens check error log first.


Method #26: turn InnoDB Monitor to on to have information about all InnoDB transactions in the error log file.


Method #27: use slow query log to find all slow queries.


Method #28: use MySQL Sandbox for fast and convenient testing of your application using several versions of MySQL server.


Method #29: use part of data




















  [Read more...]
Wishing good luck to SkySQL
+6 Vote Up -3Vote Down

One of many things I really enjoyed working as a Sales Engineer back at MySQL Ab and Sun was that I was paid full time to encourage companies to use open source for their database layer. While Linux has already become the norm for the operating system on servers, and open source alternatives exist for app servers, it wasn't until a few years ago we really started seeing major traction of that in the database layer. And I was happy to be a small part of it!

I'm not really a salesy person. I mean I'm good at evangelizing something I believe in, addressing customer business needs and such. But you couldn't get me to lift a finger just to meet a quota, if I didn't really believe in the product. Which is what good sales guys can do. (Also known as "selling what you have in the truck".)

But thinking back at my time selling MySQL, I felt it was a great privilege to be paid a

  [Read more...]
Translation of "Chapter 11. Techniques, used for debugging of Production applications" of "Methods for searching errors in SQL application" just published.
Employee_Team +0 Vote Up -0Vote Down


English translation of first and only chapter of last part 4 "Techniques, used for debugging of Production applications" just published.



Chapter 11. Techniques, used for debugging of Production applications.


Unfortunately is not always possible to find error while testing. Often they only happen when high load.


How do you know about such problems?


One of most important sources of information about problems is error
log file. There you can find information such as server crashes,
connection errors (if option log-warnings=2 turned on), about options
which were specified in the configuration file, but had not turned on
because error and some others. There is a rule for working with error
log file: if something unexpected happens check error log first. Error
log file

















  [Read more...]
Farewell CHM, hello EPUB!
Employee +8 Vote Up -1Vote Down

For a long time, the MySQL Documentation Team has been providing CHM files for most MySQL documentation we publish. Like many other formats, CHM-format docs can be downloaded from http://dev.mysql.com/doc. CHM (Compiled HTML Help) has been the de facto standard help file format on Windows since 1997, but the technology behind it is outdated and has all kinds of quirks. The successor format introduced with Windows Vista is AP Help, but it hasn't taken off in practice so far. So, with CHM being outdated and AP Help spread anything but widely, lots of vendors have started providing documentation on Windows in PDF or HTML format.

Building CHM-format documentation is a challenge of its own. I'll not go into details here, so let me just state that it requires a dedicated Windows box (or VM), and while it can be automated using Power

  [Read more...]
Farewell CHM, hello EPUB!
Employee +0 Vote Up -0Vote Down

For a long time, the MySQL Documentation Team has been providing CHM files for most MySQL documentation we publish. Like many other formats, CHM-format docs can be downloaded from http://dev.mysql.com/doc. CHM (Compiled HTML Help) has been the de facto standard help file format on Windows since 1997, but the technology behind it is outdated and has all kinds of quirks. The successor format introduced with Windows Vista is AP Help, but it hasn't taken off in practice so far. So, with CHM being outdated and AP Help spread anything but widely, lots of vendors have started providing documentation on Windows in PDF or HTML format.

Building CHM-format documentation is a challenge of its own. I'll not go into details here, so let me just state that it requires a dedicated Windows box (or VM), and while it can be automated using

  [Read more...]
Farewell CHM, hello EPUB!
Employee +0 Vote Up -0Vote Down

For a long time, the MySQL Documentation Team has been providing CHM files for most MySQL documentation we publish. Like many other formats, CHM-format docs can be downloaded from http://dev.mysql.com/doc. CHM (Compiled HTML Help) has been the de facto standard help file format on Windows since 1997, but the technology behind it is outdated and has all kinds of quirks. The successor format introduced with Windows Vista is AP Help, but it hasn't taken off in practice so far. So, with CHM being outdated and AP Help spread anything but widely, lots of vendors have started providing documentation on Windows in PDF or HTML format.

Building CHM-format documentation is a challenge of its own. I'll not go into details here, so let me just state that it requires a dedicated Windows box (or VM), and while it can be automated using

  [Read more...]
Translation of Summary of Part 3 of "Methods for searching errors in SQL application" just published
Employee_Team +1 Vote Up -0Vote Down

Not much new this time: just summary of part 3 published and fixed mistake in chapter 10 (thanks, Shane!).

Summary.

In the third part we discussed methods of application debugging in cases when query plays secondary role in the problem.

I'd like to bring your attention we only discussed most frequent cases while MySQL server has a lot of parameters which of them can affect application. Analyze parameters which you use. One of the methods is run problematic query using MySQL server running with option --no-defaults and examine if results are different for MySQL server run with parameter which you use. If results are different analyze why parameter affects it and solve the problem.

...

Rest of the chapter is here.

Translation of "Chapter 10. Lost connection to MySQL server during query." of "Methods for searching errors in SQL application" just published.
Employee_Team +1 Vote Up -0Vote Down

This chapter is about possible reasons of "Lost connection to MySQL server" error not discussed in previous one.



Chapter 10. Lost connection to MySQL server during query


You can see error "Lost connection to MySQL server" not only because
too small connect_timeout, but because other reasons too. In this
chapter we discuss these reasons.




$php phpconf2009_4.php

string(44) "Lost connection to MySQL server during query"


Most likely error log will show what happened:


...


Rest of the chapter is here


451 CAOS Links 2010.08.10
+0 Vote Up -0Vote Down

Compliance. Funding. Financial results. Copyright assignment. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Compliance
# The Linux Foundation launched the Open Compliance Program, including tools, training, and consulting.

Funding
# VentureBeat reported that Joyent has raised $7m in a second round of funding.

# Basho Technologies secured $2m from angel investors in a Series C preferred equity financing.

# StatusNet




  [Read more...]
Translation of "Chapter 9. Misterious vanishing of the server." of "Methods for searching errors in SQL application" just published
Employee_Team +1 Vote Up -0Vote Down

In this chapter we discuss timeouts which can lead to "MySQL server has gone away" and "Lost connection to MySQL server" errors.


 Extract here is short, because there are a lot of code quotes which I can not properly format here.




Chapter 9. Misterious vanishing of the server.


Often this looks like:




$php phpconf2009_3.php

string(26) "MySQL server has gone away"


Code:


...


Rest of the chapter is here

A tale of a bug…
+3 Vote Up -2Vote Down

So I sometimes get asked if we funnel back bug reports or patches back to MySQL (http://mysql.com) from Drizzle. Also, MariaDB adds some interest here as they are a lot closer (and indeed compatible with) to MySQL. With Drizzle, we have deviated really quite heavily from the MySQL codebase. There are still some common areas, but they’re getting rarer (especially to just directly apply a patch).

Back in June 2009, while working on Drizzle at Sun, I found a bug that I knew would affect both. The patch would even directly apply (well… close, but I made one anyway).

So the typical process of me filing a MySQL bug these days is:

  • Stewart files bug
  • In the next window of Sveta being awake, it’s verified.

This happened within a

  [Read more...]
Translation of "Chapter 8. Large amount of data." of "Methods for searching errors in SQL application" just published
Employee_Team +0 Vote Up -0Vote Down

I started translation of Part 3 "Other cases". In this part I mostly describe how wrong settings can lead to misterious errors. First chapter in this part about large amount of data.



Part 3. Other cases.


Chapter 8. Large amount of data.


There are cases when query is just symptom of wrong behavior, but true reason is wrong settings.



One of the cases is too small max_allowed_packet for data sent. MySQL
server variable max_allowed_packet defines maximum possible amount of
data which MySQL server can receive or send. Amount of
max_allowed_packet is specified in bytes.



Error usually looks like:





$mysql51 test <phpconf2009_1.sql

ERROR 1153 (08S01) at line 33: Got a packet bigger than
























  [Read more...]
451 CAOS Links 2010.07.16
+0 Vote Up -0Vote Down

SugarCRM. Funding for EnterpriseDB and Morphlabs. Even more core. And more

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Bittersweet
# OStatic asked whether SugarCRM has violated open source principles.

# Larry Augustin clarified SugarCRM’s approach to open source and openness.

# Savio Rodrigues advised anyone considering SugarCRM not to get hung-up on source code availability.

Funding round
# EnterpriseDB has reportedly raised $7.5m of a planned $12m round of funding.



  [Read more...]
Translation of "Chapter 7. Concurrent transactions. " of "Methods for searching errors in SQL application" just published.
Employee_Team +0 Vote Up -0Vote Down

This is short chapter which gives some clue what to do with concurrent transactions.



Chapter 7. Concurrent transactions.


Yet another frequent example of similar problem is "Lock wait timeout
exceeded" error while you use InnoDB tables. Most often running query
SHOW ENGINE INNODB STATUS is enough to find the problem, because it
will show last transactions. But output of this command does not
contain information about all queries in the same transaction, but only
about last one. What to do if SHOW ENGINE INNODB STATUS doesn't provide
all information?


...


 Rest of the chapter is here

Translation of "Chapter 6. Locks and deadlocks." of "Methods for searching errors in SQL application" just published.
Employee_Team +1 Vote Up -2Vote Down

This is new part which contains information about what to do if problem is repeatable only when queries run concurrently.




Chapter 6. Locks and deadlocks.


In the last part we discussed how to find cause of the problem in case
if it is always repeatable. But there are cases when problem occurs
only under particular circumstances.



For example, such easy query can run long enough:





mysql> select * from t;

+-----+

| a   |

+-----+

|   0 |

| 256 |

+-----+

2 rows in set (3 min 18.71 sec)


...


Rest of the chapter is here


Translation of Summary of Part 1 of "Methods for searching errors in SQL application" just published
Employee_Team +1 Vote Up -0Vote Down

There is not much new content this week. Just summary of what was written before.




Summary.


In the summary of this part I'd want to recommend following:



Try to find a query which causes inconsistent behavior



Use log files:



  • General query log

  • Log files in your application

  • MySQL Proxy or any other suitable proxy

  • Others



  • Analyze what is wrong, then solve the problem using your findings



    Below I place a list of methods which we studied in the first part.


    Method #1: use output operator to output query in exactly same way in which RDBMS gets it.



    Method #2: use general query log if you





























      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 930 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.