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 102 Next 12 Older Entries

Displaying posts with tag: mysql server (reset)

How to get colored output from ‘ls’ on Solaris10
+0 Vote Up -3Vote Down

For all of those linux users out there that have moved over to, or tried out, Solaris10 or OpenSolaris because they heard the tales of how MySQL is faster on Solaris… or perhaps you wanted to learn how to use Sol10 for the great features of Zones or the ZFS filesystem? Regardless of why you’re on it you are probably wondering why Linux has colored output of filenames and directories but Solaris does not. The question of ‘why?’ isn’t important, but how to enable colors is. It’s very simple, and here’s how I fixed it. This is a result of digging through multiple semi-related links on Google.

  • Download all packages from SunFreeware.com
    • dependency: libintl-3.4.0-sol10-x86-local
    • dependency: libiconv-1.13.1-sol10-x86-local
    • dependency: gmp-4.2.1-sol10-x86-local
    • dependency: gcc-3.4.6-sol10-x86-local or
      [Read more...]
  • Kontrollkit – new version available for download
    +0 Vote Up -0Vote Down
    Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are some required bug fixes to the formerly new python backup script and some Solaris compatible changes to the various my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads, or here: http://code.google.com/p/kontrollkit/
    Reviewed: Python Testing by Daniel Arbuckle
    +0 Vote Up -0Vote Down

    I’ve recently had the pleasure of reading “Python Testing: An easy and convenient approach to testing your python projects” from Packt Publishing. It’s been a quick read but a solid set of instructions on the different methods for the subject.

    The book starts out very quickly with details about the various methods that are available, the means of automation for testing, and of course the environment you’d want to be in for working on the subjects that the book covers. It then, in the second chapter, moves into the guts of testing by describing the basics of doctest via syntax and some simple examples, and then moves on to a real world example via the AVL tree. It’s all very basic

      [Read more...]
    Kontrollbase – revision 297 fixes Reporter-CLI “alert_22″ sub-routine
    +0 Vote Up -0Vote Down
    Quick note to let our users know that there was an XML tag closure error on the “alert_22″ subroutine in the “bin/kontroll-reporter-cli.pl” script. This does not affect the webapp portion of Kontrollbase – only reports generated via the command line reporter script. It is not a fatal error but will cause the XML file to […]
    Kontrollkit – new backup script is partition space aware
    +0 Vote Up -0Vote Down
    I’ve been wanting to write a backup script for a while now that does the following: reads the partition information for the directory that you are backing up into and computes the used/available/percentage-available space. Then it reads the total data size from the MySQL tables and ensures that you have enough space on disk (for [...]
    Kontrollbase – graph “no data to display” on new install has been fixed
    +0 Vote Up -0Vote Down
    If you have been wondering why the overview and graphs pages say “no data to display” on the graphs when you first install Kontrollbase, it’s because there’s no data in the database being returned from the queries that generate the graphs – this is because a new install has no data to graph. This has […]
    Having an issue with a Kontrollbase upgrade?
    +0 Vote Up -0Vote Down
    If you’ve noticed that your recent upgrade did not go as planned and now the application does not load – please check this page: http://wiki.kontrollsoft.com/wiki/UpgradingReleases for notes on upgrades between versions. Typically you need to execute a SQL file against the current schema to bring it up to date. If you have any questions please [...]
    Kontrollcomm – remote database and system command execution webapp
    +2 Vote Up -0Vote Down
    I’m pleased to announce the first release of Kontrollcomm – “The Server Command Automation Interface” is a web-based application that automates remote command execution on linux and unix based servers. There are three main areas of the application: Hosts, Templates, and Commands. The use is very simple: all of your hosts are setup in the [...]
    Kontrollbase rev292 gets important UI layout fixes
    +0 Vote Up -1Vote Down
    This is a small revision and will only be available through SVN. However, it is an important one to speak about as it solves a former issue when running the application on a screen smaller than 1024px wide. While most users may not have noticed this since they have larger monitors it has been noticed [...]
    Reviewed: Managing Software Development with SVN and Trac
    +0 Vote Up -0Vote Down

    I’ve recently been migrating my wiki/documentation for Kontrollbase to Trac. For those that are not aware, Trac is a web-based documentation/wiki/Subversion tool that is used by countless number of software projects. Subversion, of course, is a software collaboration and code management repository that manages branches/tags/trunk files with revision control. It’s one of the most heavily used open-source code repositories available. Given that I use SVN (subversion) for all of my software applications and am now using Trac, the book “Managing Software Development with Trac and Subversion” by David J Murphy comes as a useful and great

      [Read more...]
    Kontrollbase wiki being migrated to Trac
    +0 Vote Up -1Vote Down
    Just a quick bit of news to let you all know that additions to the standard Kontrollbase and Kontrollkit userguides are being halted while we migrate the documentation to a new wiki system run by the very nice Trac software. You will be able to access the Kontrollbase and Kontrollkit documentation at http://wiki.kontrollsoft.com when it [...]
    Kontrollsoft’s uptime checks now managed by Pingdom
    +0 Vote Up -0Vote Down
    Website health checks are a crucial service to an operations team. In addition to in-house monitoring and service state reporting it’s also important, even critical, to have an impartial third party to run checks to test your customer facing services. There are a lot of companies in this arean that would be glad to have [...]
    Kontrollsoft is using Eventum for your support needs
    +0 Vote Up -2Vote Down
    After some testing and setup we have decided to use Eventum for our support ticketing needs. This featureful system will be in use for all of your support questions related to Kontrollbase – the MySQL analytics and performance tuning web application, as well as Kontrollkit – the collection of server automation scripts. You can read [...]
    Kontrollkit – new version is available for download!
    +0 Vote Up -0Vote Down
    Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are two new scripts included as well as some good updates to the my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads kt-mysql-systemcheck – generates a report for point-in-time system status that is useful for troubleshooting MySQL [...]
    Kontrollbase – queries to update your max_connections alert
    +0 Vote Up -1Vote Down
    If you have been reading the Kontrollbase performance reports and noticed that one alert says your connection usage vs max connections ration is too high but then recommends you to decrease the max_connections variable, then you will find this fix handy. Its two simple queries that execute on the Kontrollbase schema to update the max_connections [...]
    Kontrollbase receives sponsorship from Network Redux
    +0 Vote Up -0Vote Down
    It is a pleasure to announce that Kontrollbase – the MySQL analytics and performance monitoring webapp for MySQL servers – has a new sponsor. Network Redux is located in Portland, Oregon and offers enterprise quality dedicated and managed hosting as well as cloud services. Thomas Brenneke contacted me to discuss his interest in utilizing the [...]
    MySQL 5.5.0-M2: A Milestone Ready To Download
    Employee +11 Vote Up -0Vote Down

    Good news: As you read this, you can very soon start downloading the first version of MySQL 5.5 from http://dev.mysql.com/downloads/.

    Some things are the same as before, others are different. Let’s start by looking at the version string, SELECT VERSION();

    mysql> SELECT VERSION();
    +--------------+
    | version()    |
    +--------------+
    | 5.5.0-m2-log |
    +--------------+
    1 row in set (0.00 sec)
    mysql>

    And let’s look at the highlights of the release notes, or better still,

      [Read more...]
    Notes for installing MySQL 5.4.2 on OSX 10.5.8 PPC
    +0 Vote Up -0Vote Down

    Some notes from my recent installation of MySQL 5.4.2-beta on a PPC G5 box running OSX 10.5.8. Hopefully these notes will save someone a bit of time when they begin the “I want to make my mac a development box” process. I’m not going to cover installing/configuring Apache and PHP since the web is full of those articles already.  So, first things first,  I downloaded the pkg file  – not the tarball – from the MySQL downloads site and installed the following files in the following order:

  • mysql-5.4.2-beta-osx10.5-powerpc-64bit.pkg
  • MySQLStartupItem.pkg
  • MySQL.prefPane
  • CNF File Settings

    Here are some interesting settings that you may want to be aware of with 5.4 and OSX

    • Do not set innodb_flush_method=fdatasync – it’s not a valid option, and the default after install is actually
      [Read more...]
    Tool of the day: inotify
    +2 Vote Up -0Vote Down

    I was actually exploring inotify-tools for something else, but they can also be handy for seeing what goes on below a mysqld process. inotify hooks into the filesystem handlers, and sees which files are accessed. You can then set triggers, or just display a tally over a certain period.

    It has been a standard Linux kernel module since 2.6.13 (2005, wow that’s a long time ago already) and can be used through calls or the inotify-tools (commandline). So with the instrumentation already in the kernel, apt-get install inotify-tools is all you need to get started.

     # inotifywatch -v -t 20 -r /var/lib/mysql/* /var/lib/mysql/zabbix/*
    Establishing watches...
    Setting up watch(es) on /var/lib/mysql/mysql/user.frm
    OK, /var/lib/mysql/mysql/user.frm is now being watched.
    [...]
    Total of 212 watches.
    Finished
      [Read more...]
    Another solution to an error
    +0 Vote Up -0Vote Down


    install_driver(mysql) failed: Can't load '/usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so) at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
    at (eval line 3

    After a lot of mucking around I noticed that the MySQL-shared-community RPM was installed, not the MySQL-shared-compat RPM like my usual installs. So…


    rpm -Uvh MySQL-shared-compat-5.1.33-0.rhel5.x86_64.rpm

    perl-DBD-MySQL errors
    +0 Vote Up -0Vote Down

    Quick post here for a problem that other people might run into and wonder how to fix. Let’s say you have the following error:

    install_driver(mysql) failed: Can't load '/usr/lib64/perl5/vendor_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 230.
    at line 3
    Compilation failed in require at line 3.
    Perhaps a required shared library or dll isn't installed where expected
    at ./kontroll-client-5.0.x_linux-x86-2.0.1.pl line 193

    Well, you probably need to symlink “libmysqlclient.so.14″ to the existing one that is most likely of a newer version.

    > find / -name "libmysqlclient*"










      [Read more...]
    A quick rundown of per-thread buffers
    +2 Vote Up -0Vote Down

    I saw something interesting today when helping out someone on the #mysql IRC channel. It was a cnf file that was designed to destroy a server. Before I get into the why-not, here are the goods:

    ...snip...
    read_buffer = 128M
    join_buffer = 128M
    key_buffer = 512M
    max_allowed_packet = 200M
    thread_stack = 192K
    thread_concurrency = 8
    thread_cache_size = 64
    query_cache_limit = 256M
    query_cache_size = 256M
    table_cache = 8192
    query_cache_type = 1
    sort_buffer = 128M
    record_buffer = 128M
    myisam_sort_buffer_size = 128M
    thread_cache = 64
    max_user_connections = 500
    wait_timeout = 200
    max_connections = 4096





















      [Read more...]
    Karen’s Commitments to the MySQL Community
    Employee +7 Vote Up -0Vote Down

    A new start always provides an opportunity to reassess your way of doing things:

    • “Am I doing the right things with my life?”
    • “Which habits could I change — in order to be a better neighbour?” 

    Since Karen Tegan Padir took over the MySQL product from Mårten Mickos, we at Sun have taken a thorough look in the mirror.  The result of this introspection allows us to publish our conclusions and new community commitments this week in conjunction with the MySQL Conference & Expo in Santa Clara. 

    For those who don’t yet know Karen, let me state a few facts: 

    • Karen is VP of Sun’s newly-founded MySQL & Software Infrastructure group
    • She describes herself as a geek and a
      [Read more...]
    Why be vendor specific?
    +0 Vote Up -0Vote Down

    I just read about the release of Honey Monitor for MySQL. I read through the features. I looked at the screenshots. Then I read about the licensing. Then I read about the fact that it only runs on windows XP or Vista. So, my questions for the ages…

    1. Why, in this age of multiple OSes battling each other for market share, would you write an application that is OS specific? Every app should run in a vendor neutral web browser unless there’s a really really good reason. Monitoring software, are you kidding? Monitoring software must be vendor neutral and web-based. I will never use anything that ties me to windows or linux or osx, it has to be cross platform. End of story.
    2. Why, when MySQL is so heavily used on Linux and Solaris, would you write an application for MySQL

      [Read more...]
    Why be vendor specific?
    +0 Vote Up -0Vote Down

    I just read about the release of Honey Monitor for MySQL. I read through the features. I looked at the screenshots. Then I read about the licensing. Then I read about the fact that it only runs on windows XP or Vista. So, my questions for the ages…

    1. Why, in this age of multiple OSes battling each other for market share, would you write an application that is OS specific? Every app should run in a vendor neutral web browser unless there’s a really really good reason. Monitoring software, are you kidding? Monitoring software must be vendor neutral and web-based. I will never use anything that ties me to windows or linux or osx, it has to be cross platform. End of story.
    2. Why, when MySQL is so heavily used on Linux and Solaris, would you write an application for MySQL that can only be

      [Read more...]
    FOSDEM Sunday 13:15-14:15: Q&A on recent developments at Sun, MySQL Roadmap
    Employee +0 Vote Up -0Vote Down

    Given the changes announced this week, I have updated my original plans for my presentation on Sunday. I was going to talk about Social networking, but am now changing it to a very interactive Q&A session.

    I expect people are asking themselves

    • What has changed?
    • What will happen now?
    • What are the consequences for the MySQL roadmap?
    • Are there other consequences for the MySQL community?

    and I will attempt at answering these questions interactively during FOSDEM.

      [Read more...]
    Monolith DBA Toolkit 0.4.3 Released
    +0 Vote Up -0Vote Down

    The Monolith Toolkit of scripts for DBA routines. 0.4.3 has been released. You can download it here: http://code.google.com/p/monolith-toolkit/

    Some information on the toolkit and what it contains:

    • mt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features
    • mt-check-replication -> script to report on replication status for slave servers
    • mt-rhcluster-check-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering)
    • mt-rhcluster-script-wrapper -> wrapper script for running any of these scripts on a redhat cluster, chooses the active node to run the script on
    • mt-connections-log -> logs connections to mysql to disk, reports on threshold overages
    • mt-flush-tables-sequence -> runs through
      [Read more...]
    Seeking volunteer test machines for Monolith
    +0 Vote Up -0Vote Down

    Monolith: MySQL server monitoring. I only have servers that run Redhat/Debian/Ubuntu Linux x86 and x86_64. I don’t have machines to test MySQL monitoring for the following OSes. Perhaps you would like to be a test candidate for the new version of Monolith? If so, let me know and you’ll be on the list, as well as get beta testing credit.

    OSX Server: PPC and Intel

    AIX

    FreeBSD / OpenBSD / NetBSD

    Windows Server

    Solaris: Intel & Sparc

    Linux servers that are NOT Intel based.

    What this involves: testing the client script, perl modules, snmp stats, and other functions that may require a custom client script for that architecture.

    MySQL 5.1 Use Case Competition: Position 1
    Employee +0 Vote Up -0Vote Down

    MySQL 5.1 is here! It’s announced! And it’s time for the overall winner, Position 1 in the MySQL 5.1 Use Case Competition.

    1. Greg Haase (Lotame Solutions Inc., Elkridge, Maryland, USA): Using Partitioning and Event Scheduler to Prune Archive Tables. See Greg’s DevZone article, and his blog.

    Thanks and congratulations,

      [Read more...]
    MySQL 5.1 Use Case Competition: Positions 5 to 10
    Employee +0 Vote Up -0Vote Down

    With the GA announcement of MySQL 5.1 coming up, we have picked the winners in the MySQL 5.1 Use Case Competition.

    To keep you in suspense, let me first announce those on positions 5 to 10:

    5. Fourat Zouari (TriTUX.com, Tunis, Tunisia): Using Partitioning for Data Warehousing. See Fourat’s DevZone article, and

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