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 61 to 90 of 218 Next 30 Older Entries

Displaying posts with tag: solaris (reset)

Olio on 6-core Opterons (Istanbul) based Sun Systems
Employee +0 Vote Up -0Vote Down

Sun is launching systems with multisocket  6-core Opterons (Istanbul) today. Last week I got access to  Sun Fire X4140 with 2 x 6-core Opterons with 36GB RAM. It is always great to see such a 1RU system packaged with so many x64 cores.

# psrinfo -vp The physical processor has 6 virtual processors (0-5)   x86 (chipid 0x0 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435 The physical processor has 6 virtual processors (6-11)   x86 (chipid 0x1 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435


I decided to take the system for a test drive with Olio. Olio is a Web 2.0 toolkit consisting on a web 2.0 event calendar application  which can


  [Read more...]
Olio on 6-core Opterons (Istanbul) based Sun Systems
Employee +0 Vote Up -0Vote Down

Sun is launching systems with multisocket  6-core Opterons (Istanbul) today. Last week I got access to  Sun Fire X4140 with 2 x 6-core Opterons with 36GB RAM. It is always great to see such a 1RU system packaged with so many x64 cores.

# psrinfo -vp The physical processor has 6 virtual processors (0-5)   x86 (chipid 0x0 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435 The physical processor has 6 virtual processors (6-11)   x86 (chipid 0x1 AuthenticAMD family 16 model 8 step 0 clock 2600 MHz)     Six-Core AMD Opteron(tm) Processor 8435


I decided to take the system for a test drive with Olio. Olio is a Web 2.0 toolkit consisting on a web 2.0 event calendar application  which can


  [Read more...]
MySQL Performance: Why Ahead Flushing for InnoDB?...
Employee +2 Vote Up -0Vote Down

Recently I've done several performance studies to find the most optimal way to fix the "furious flushing" observed during all my benchmarks with InnoDB. The initial report about this work you may find here including initially proposed patches. But analyzing test workloads with the latest MySQL performance build I think there is a need to go more far...

First of all let's me present you the result I've got on the Read+Write workload @dbSTRESS - first part of graph represents the TPS level obtained with MySQL 5.4, and the second part - with the latest MySQL performance build (#46):

  [Read more...]
MySQL Performance: Once again about InnoDB thread concurrency...
Employee +2 Vote Up -0Vote Down

Even this topic was covered several times already, the question is still open - use or not to use InnoDB thread concurrency?.. And the only true answer here - "It depends" :-) and I'll try to make a short summary about the current state here.

The main current InnoDB bottlenecks are all mostly due to a high contention on internal locks. As all multi-threaded (as well multi-process) applications giving a concurrent access to its resources, InnoDB have to guarantee there is only one thread may modify a given resource on the same time. This guarantee is achieved by locking a resource in exclusive mode and implemented with mutexes. Depending on implementation, some locks may become very hot with a growing access concurrency. And it's exactly what's happening with InnoDB...

  [Read more...]
What’s new in MySQL 5.4.1
+0 Vote Up -0Vote Down

Absolutely nothing?

5.4.0 was released with a change in the MySQL Binary distributions, delivering only 1 64bit Linux platform and two Sun Solaris platforms. This was officially announced on April 21 2009 (http://www.mysql.com/news-and-events/generate-article.php?id=1602) however the 5.4.0 Release Notes state 05 April 2009. So it’s not a big deal, but consistency would be nice.

I’ve seen in a few posts 5.4.1, so I decided to try it out. Spending the time to read what’s changed in 2 months with the 5.4.1 Release Notes before I go downloading and installing, you read.

This release does not differ from 5.4.0

  [Read more...]
MySQL Performance: 5.4 and new Performance builds
Employee +1 Vote Up -0Vote Down

Recently new performance builds were made by our MySQL Team, and it seems to me reaching now a new milestone with the build #45 - within this single build Mikael joined several previously tested performance builds showed a positive performance improvement. So, how well it's comparing now to the default 5.4 ?..

Here are my results obtained on M5000 (quad-cores)/ Solaris10 update7 and db_STRESS.

Solaris 10 update7

Special note about update7: I was pleasantly surprised the kernel locks issue was gone! CPU Spinlocks within a similar workload are devided by 4(!) - very positive improvement, and

  [Read more...]
Business Intelligence Using Open Storage
+0 Vote Up -0Vote Down

Sun recently rolled out a new Business Intelligence (BI) solution that uses Open Storage at its core. There are several things that are different about this solution that make it stand out from the crowd.

1) It is based on Open Source software.

This solution uses the commercial versions of open source software from Pentaho and Infobright to provide the BI and Datawarehouse (DW) functions respectively and both use the MySQL database. Also, this solution uses Sun's Open Storage products as the core storage component which are built using Open Source software and industry standard components. Combine those with an Open Source operating system like Solaris or

  [Read more...]
Business Intelligence Using Open Storage
+0 Vote Up -0Vote Down

Sun recently rolled out a new Business Intelligence (BI) solution that uses Open Storage at its core. There are several things that are different about this solution that make it stand out from the crowd.

1) It is based on Open Source software.

This solution uses the commercial versions of open source software from Pentaho and Infobright to provide the BI and Datawarehouse (DW) functions respectively and both use the MySQL database. Also, this solution uses Sun's Open Storage products as the core storage component which are built using Open Source software and industry standard components. Combine those with an Open Source operating system like Solaris

  [Read more...]
Business Intelligence Using Open Storage
+0 Vote Up -0Vote Down

Sun recently rolled out a new Business Intelligence (BI) solution that uses Open Storage at its core. There are several things that are different about this solution that make it stand out from the crowd.

1) It is based on Open Source software.

This solution uses the commercial versions of open source software from Pentaho and Infobright to provide the BI and Datawarehouse (DW) functions respectively and both use the MySQL database. Also, this solution uses Sun's Open Storage products as the core storage component which are built using Open Source software and industry standard components. Combine those with an Open Source operating system like Solaris

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

Governments. Governance. Customers wins. And more.

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

Governments
The Examiner provided a two part interview with Daniel Risascher, Office of the CIO, Department of Defense, on open source at the DoD, while Government Technology Magazine reported on how open source software and cloud computing can save government money. Similarly, The UK Conservative party delivered a paper on the future of open standards, open source, SOA and cloud for UK Government, while it was reported that Vienna to teach its public servants


  [Read more...]
MySQL Performance: InnoDB Purge Lag and Ahead Flushing
Employee +1 Vote Up -0Vote Down

After publishing in May a benchmark report about InnoDB Dirty pages & Log size impact I received several very interesting comments, and one of them pointed to the purge lag problem and InnoDB innodb_max_purge_lag parameter created specially for such purpose! So, I was very curious to know how it may help me in my workload...

The following study is about how innodb_max_purge_lag is working now and what may be done to make things better :-))

I'm not pretending here on any absolute truth :-) My goal is to understand what's going on with purge on my workload and see if there is something else possible to improve..

  [Read more...]
Using OpenSolaris SMF for managing MySQL Cluster
Employee +0 Vote Up -0Vote Down
One of the things I really like about Solaris (and OpenSolaris) is the Services Management Framework (SMF). And one of the things I like about my job is the opportunity to learn and work with new stuff. And, of course, the best way to learn something "non-lethal" is to try it yourself and do something with it.
So, how about using SMF for managing a MySQL Cluster setup? Something simple like two data nodes, one mgmt node, and one MySQL server node running on one OS instance? Sounds like a good exercise and, from a quick search, I couldn't find where it had been done before. Loaded up the latest release of OpenSolaris (2009.06) into a Virtual Box VM, downloaded the latest tar ball of
  [Read more...]
Changing process.max-file-descriptor using 'ulimit -n' can cause MySQL to change table_open_cache value
Employee +0 Vote Up -0Vote Down

Before I get into details here is the bottom line. If you start MySQL on Solaris as a non-root (ie, mysql) user and for some reason you need to adjust the file descriptor resource limit for the parent shell, never use 'ulimit -n'. This will set both the soft and hard limit and may cause MySQL to adjust the max_connections and table_open_cache configuration variables upon next startup.

Use either:

 ulimit -S -n 1024

or something like:

  prctl -n process.max-file-descriptor -t basic -v  1024 -r -i process $$



The Details

The default 'basic' privilege value for the resource control process.max-file-descriptor is 256. This control represents the soft ulimit for file descriptors per process. The default 'privileged' privilege is set to 65535, which represents the hard ulimit. A non-root



  [Read more...]
Changing process.max-file-descriptor using 'ulimit -n' can cause MySQL to change table_open_cache value
Employee +0 Vote Up -0Vote Down

Before I get into details here is the bottom line. If you start MySQL on Solaris as a non-root (ie, mysql) user and for some reason you need to adjust the file descriptor resource limit for the parent shell, never use 'ulimit -n'. This will set both the soft and hard limit and may cause MySQL to adjust the max_connections and table_open_cache configuration variables upon next startup.

Use either:

 ulimit -S -n 1024

or something like:

  prctl -n process.max-file-descriptor -t basic -v  1024 -r -i process $$



The Details

The default 'basic' privilege value for the resource control process.max-file-descriptor is 256. This control represents the soft ulimit for file descriptors per process. The default 'privileged' privilege is set to 65535, which represents the hard ulimit. A



  [Read more...]
Changing process.max-file-descriptor using 'ulimit -n' can cause MySQL to change table_open_cache value
Employee +0 Vote Up -0Vote Down

Before I get into details here is the bottom line. If you start MySQL on Solaris as a non-root (ie, mysql) user and for some reason you need to adjust the file descriptor resource limit for the parent shell, never use 'ulimit -n'. This will set both the soft and hard limit and may cause MySQL to adjust the max_connections and table_open_cache configuration variables upon next startup.

Use either:

 ulimit -S -n 1024

or something like:

  prctl -n process.max-file-descriptor -t basic -v  1024 -r -i process $$



The Details

The default 'basic' privilege value for the resource control process.max-file-descriptor is 256. This control represents the soft ulimit for file descriptors per process. The default 'privileged' privilege is set to 65535, which represents the hard ulimit. A



  [Read more...]
MySQL Performance: MySQL 5.4 and other InnoDB engines on 32cores AMD server & dbSTRESS
Employee +1 Vote Up -0Vote Down

Currently several probe InnoDB code improvements were done by our MySQL Team. I was happy to test them with db_STRESS workloads but on Solaris/SPARC server (M5000). Then discussing with Mikael  I was surprised he saw much less improvement from the latest probe builds on his Linux/AMD64 box... And it was unclear why the performance improvement gap is more important on SPARC: due SPARC itself? due Solaris? due a test case?.. To bring more lights and understand better what's going differently on an AMD box I've preferred to avoid to change too many things on the same time :-) So, once one of the latest 32cores AMD server (X4600-M2) was available, I was curious to test it under Solaris10 and connected to the same storage box as M5000 before. And here are my results...

My intention is

  [Read more...]
MySQL Performance: Some results comparing InnoDB log size impact @dbSTRESS benchmark
Employee +1 Vote Up -0Vote Down

Following my previous post (where I've also told about a significant performance gain by using a bigger InnoDB log size ), I'd like to present you some results obtained on the Read+Write workload and log size equal to 1024MB. I've labeled it on graphs as "FF" (Fast & Furious :-)) as within a such configuration MySQL server may go very fast until it'll meet a "furious flushing" to free some space within a log file... :-)

However, the speed-up is quite important, so if you don't worry too much if time to time your production activity may have a short drop on performance - you have to consider this option as one of the first to test to improve your

  [Read more...]
Announcing Open HA Cluster 2009.06
Employee +1 Vote Up -0Vote Down

We are pleased to announce the release of High Availability Cluster software for OpenSolaris 2009.06! If you've been following along, this release is the fruit of project Colorado. Open HA Cluster 2009.06 is based on Solaris Cluster 3.2, including many of the features from the most recent update. Additionally, Open HA Cluster 2009.06 contains the following new features:

  [Read more...]
Announcing Open HA Cluster 2009.06
Employee +0 Vote Up -0Vote Down

We are pleased to announce the release of High Availability Cluster software for OpenSolaris 2009.06! If you've been following along, this release is the fruit of project Colorado. Open HA Cluster 2009.06 is based on Solaris Cluster 3.2, including many of the features from the most recent update. Additionally, Open HA Cluster 2009.06 contains the following new features:

  [Read more...]
Announcing Open HA Cluster 2009.06
Employee +0 Vote Up -0Vote Down

We are pleased to announce the release of High Availability Cluster software for OpenSolaris 2009.06! If you've been following along, this release is the fruit of project Colorado. Open HA Cluster 2009.06 is based on Solaris Cluster 3.2, including many of the features from the most recent update. Additionally, Open HA Cluster 2009.06 contains the following new features:

  [Read more...]
MySQL 5.1 in OpenSolaris
+1 Vote Up -0Vote Down

If you’ve attended just one of my recent talks, either at the UC, LOSUG or MySQL University, you should know that MySQL 5.1.30 will be in the next official drop of OpenSolaris.

In fact, you can find MySQL 5.1 in the current pre-release builds – I just download build 111 of the future 2009.06 release.

Key things about the new MySQL 5.1 in OpenSolaris:

  • Contains the set of DTRACE probes that also exists in MySQL 5.4 (see DTrace Documentation)
  • Like the 5.0, we have SMF integration, so you can start, stop, monitor and change some of the core configuration through SMF
  • Directory layout is similar to 5.0, with a version specific directory (/usr/mysql/5.1), and the two can coexist if you want to handle a migration from 5.0 to 5.1
  • To install MySQL 5.1, use

      [Read more...]
    MySQL Performance: InnoDB Dirty Pages & Log Size Impact
    Employee +3 Vote Up -0Vote Down

    The beginning of this story is coming from the first weeks of the last year - seeking for the most optimal MySQL config parameters I've discovered a strange thing:

    • my dirty pages percentage setting 15 was completely ignored by InnoDB during my tests!...
    • once the test workload was finished it still took 30 minutes yet to flush dirty pages!...

    I've told about a lot of people on that time, but everybody were just surprised and did not really believe such case is possible... Agree, it's hard to believe ;-)

    So, to refresh the story, let me first to show you the following picture:

      [Read more...]
    Quick Access to CommunityOne Deep Dives
    +0 Vote Up -0Vote Down

    So the CommunityOne conference is coming soon, and earlier this week I finished up the final part of the MySQL/DTrace presentation and preparation so I’m all ready to go.

    Want to come along? Get quick access to the Deep Dives:


    Online Event RegistrationPowered by www.eventbrite.com
    So, Why finally PostgreSQL is slower on db_STRESS Benchmark comparing to MySQL ?...
    Employee +2 Vote Up -0Vote Down

    Last month when I've published my results obtained with PostgreSQL 8.3.7 on db_STRESS benchmark I was surprised they were much lower comparing to MySQL, as well some signs alarmed me there is something goes wrong with PostgreSQL... So, once it was possible, I took my time and prepared another testing on the same M5000 server I published MySQL results last week.

    I would say I discovered a lot of new things benchmarking PostgreSQL ! I'm not kidding :-) And without going too much in detail, the main gain seems to me of MySQL over PostgreSQL was a lower cost on executing a single query. The query in question was the second SELECT in db_STRESS.

    SELECT-2 execution time:

    • MySQL 5.4: 0.44ms
    • PostgreSQL 8.4:
      [Read more...]
    Speaking at CommunityOne West
    +1 Vote Up -0Vote Down

    Sorry for the (relatively) short notice, but I will be talking at Sun’s CommunityOne conference in San Francisco on June 1st.

    I’ll be talking about, and demonstrating, the DTrace probes we have put into MySQL in a joint presentation with Robert Lor who will be doing the same for Postgres.

    CommunityOne West Badge

    Our presentation is on the Monday afternoon.

    Check out the CommunityOne West Conference Site for more details and registration.

    MySQL Performance: MySQL 5.4, XtraDB-5 and others @dbSTRESS Benchmark
    Employee +2 Vote Up -0Vote Down

    Here are my new db_STRESS results obtained on the latest Sun M5000 server (SPARC64-VII 8CPU quad-core / bi-thread 2400Mhz). I was very curious to retest the "official" MySQL 5.4 on this machine as well other versions and InnoDB engines. But on the same time the new XtraDB version 5 was announced. As well Google shipped their v3 patch. How to resist? :-) (I'll try to be short :-))

    MySQL 5.0 & 5.1

    There is no more performance gap between 5.0 and 5.1 as I observed before , both versions are having near the same performance and both are way slower comparing to others :-) So, honestly, if you have any performance problem - why do not migrate to 5.4, XtraDB, or at least the

      [Read more...]
    A quick test with MySQL 5.4
    +1 Vote Up -0Vote Down


    Louis ILouis II Louis IIILouis IVLouis VLouis VILouis VIILouis VIIILouis IXLouis X (dit le Hutin)(the Quarrelsome)Louis XILouis XIILouis XIIILouis XIVLouis XVLouis XVILouis XVIILouis XVIIIet plus personne plus rien..and nobody, nothing more…qu'est-ce que c'est que ces gens-làwhat’s with those peoplequi ne sont pas foutuswho can’t evende compter jusqu'à vingt?count up to twenty?
    Jacques Prevert


    I did a quick test with the last version on the same testbed environment that I used for my previous blog and here is my finding.
    MySQL 5.4 worked as I expected with sysbench. Performance up to 32 threads are basically the same of my build, but whilst 64 concurrent threads show a degradation in performance of the standard build and my build, with 5.4 they increase significantly, showing a pretty linear scalability - see table and graph.








      [Read more...]
    Dear Oracle,
    +1 Vote Up -0Vote Down

    A couple of weeks ago I wrote a post titled Dear IBM , I was too late .. I was on holliday last week when people started sending me text messages , such as .. "Game Over MySQL , Long live Ingress" or "No Eclipse for IBM", etc ...

    I had ideas regarding the future of certain Sun products at IBM, now the game has changed .. it'ss how they will live on at Oracle :)

    Similar Questions arise .. like indeed the future of MySQL, the future of Solaris etc ...

    So regarding the future of MySQL , I don't worry at all, on the contrary ..
    Oracle tried buying mysql before they already have Innodb .. they didn't kill it .. the MySQL offering is complementary to the Oracle offering, now they can tackle both markets.
    And as already mentionned when writing my IBM letter ..


    As for MySQL, Jeremey has some



      [Read more...]
    Solaris Cluster + MySQL Demo at a Exhibition Hall near you
    Employee +0 Vote Up -1Vote Down

    Hi,

    If by any chance you are at the MySQL user conference in Santa Clara conference center, there are some great possibilities to see MySQL and Solaris Cluster in action. We have a demo at the exhibition hall, where you can see MySQL with zone cluster and MySQL with SC Geographic Edition.

    I will host a birds of a feather at Wednesday 4/22/09 evening in meeting room 205 at 7 pm. The Title is "Configuring MySQL in Open HA Cluster, an Easy Exercise" check out the details here.  I will give a presentation at Thursday 4/23/09 morning 10:50 in Ballroom G, the title is "Solutions for High Availability and

      [Read more...]
    Solaris Cluster + MySQL Demo at a Exhibition Hall near you
    Employee +0 Vote Up -0Vote Down

    Hi,

    If by any chance you are at the MySQL user conference in Santa Clara conference center, there are some great possibilities to see MySQL and Solaris Cluster in action. We have a demo at the exhibition hall, where you can see MySQL with zone cluster and MySQL with SC Geographic Edition.

    I will host a birds of a feather at Wednesday 4/22/09 evening in meeting room 205 at 7 pm. The Title is "Configuring MySQL in Open HA Cluster, an Easy Exercise" check out the details here.  I will give a presentation at Thursday 4/23/09 morning 10:50 in Ballroom G, the title is "Solutions for High

      [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 218 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.