Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 1189 10 Older Entries

Displaying posts with tag: Linux (reset)

Using Cgroups to Limit MySQL and MongoDB memory usage
+0 Vote Up -0Vote Down

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I am interested to see how a database server will perform, say if only 16GB of memory is available.

And while InnoDB usually respects the setting of innodb_buffer_pool_size in O_DIRECT mode (OS cache is not being used in this case), more engines (TokuDB for MySQL, MMAP, WiredTiger, RocksDB for MongoDB) …

  [Read more...]
9 easy performance tips for your Linux environment
+0 Vote Up -0Vote Down

For the majority of us who have grown accustomed to a Windows environment over the years, Linux can seem like another world. In essence, Linux is a free open-source operating system that has gained increasing popularity since its release in 1991. Linux is based on the whole Unix ecosystem of operating systems that grew out of Bell Laboratories in the early 1970s. Linux has been around for almost 25 years and grew immensely in the late 1990s and early 2000s when it became associated with the LAMP web development stack; Linux …

  [Read more...]
MySQL Incremental Backup - Point In Time Backup and Recovery of InnoDB and MyIsam Databases
+0 Vote Up -0Vote Down

Mysql Incremental Backup is a complete incremental backup script for MyISAM and InnodB databases using the MySQL binary log so that the backup process does not affect running databases. This tutorial describes the installation of the MysqlIncrementalBackup script and helps to troubleshoot issues that may arise during setup.

Bash Arrays & Oracle
+0 Vote Up -0Vote Down

Last week, I wrote about how to use bash arrays and the MySQL database to create unit and integration test scripts. While the MySQL example was nice for some users, there were some others who wanted me to show how to write bash shell scripts for Oracle unit and integration testing. That’s what this blog post does.

If you don’t know much about bash shell, you should start with the prior post to learn about bash arrays, if-statements, and for-loops. In this blog post I only cover how to implement a bash

  [Read more...]
Bash Arrays & MySQL
+0 Vote Up -0Vote Down

Student questions are always interesting! They get me to think and to write. The question this time is: “How do I write a Bash Shell script to process multiple MySQL script files?” This post builds the following model (courtesy of MySQL Workbench) by using a bash shell script and MySQL script files, but there’s a disclaimer on this post. It shows both insecure and secure approaches and you should avoid the insecure ones.

  [Read more...]
Add Gedit Plugins
+0 Vote Up -0Vote Down

Fedora comes with vim and gedit installed but the gedit installation is bare bones. You can update gedit to include supplemental Plug-ins with the following yum command as the root user:

yum install -y gedit-plugins

It generates the following log file:

Loaded plugins: langpacks, refresh-packagekit
mysql-connectors-community                                  | 2.5 kB  00:00     
mysql-tools-community                                       | 2.5 kB  00:00     
mysql56-community …
  [Read more...]
fsfreeze in Linux
+0 Vote Up -0Vote Down

The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS.

A filesystem can be frozen using following command:

# /sbin/fsfreeze -f /data

Now if you are writing to this filesystem, the process/command will be stuck. For example, following command will be stuck in D (UNINTERUPTEBLE_SLEEP) state:

# echo “testing” > /data/file

Only after the filesystem is unfreezed using the following command, can it continue:

# /sbin/fsfreeze -u /data

As per the fsfreeze main page, …

  [Read more...]
Eclipse, Java, MySQL
+0 Vote Up -0Vote Down

While I previously blogged about installing Netbeans 8, some of my students would prefer to use the Eclipse IDE. This post shows how to install and configure Eclipse IDE, include the mysql-connector-java.jar, and write Java to access the MySQL.

You can download Eclipse IDE and then open it in Fedora’s Archive Manager. You can use the Archive Manager to Extract the Eclipse IDE to a directory of your choice. I opted to extract it into my student user’s home directory, which is /home/student.

  [Read more...]
MySQL, Percona, MariaDB long running processes clean up one liner
+0 Vote Up -1Vote Down

There are tools like pt-kill from the percona tool kit that may print/kill the long running transactions at MariaDB, MySQL or at Percona data instances, but a lot of backup scripts are just some simple bash lines.
So checking for long running transactions before the backup to be executed seems to be a step that is missed a lot.

Here is one line that might be just added in every bash script before the backup to be executed
Variant 1. Just log all the processlist entries and calculate which ones were running longer than TIMELIMIT:

$ export TIMELIMIT=70 && echo "$(date) : check for long …


  [Read more...]
Netbeans 8 – Fedora
+0 Vote Up -0Vote Down

Some of my students want to use the Fedora image that I built for my database classes in my Java software development life cycle course. As a result, they wanted a Java development environment installed. I examined JDeveloper 11g (11.1.1.7.0) and 12c (12.1.3) but resolved on the more generic Netbeans 8 (8.0.2) IDE.

JDK 7 with Netbeans 8 Download

You can download the generic Netbeans 8 IDE, the JDK 7 with Netbeans, or the …

  [Read more...]
Showing entries 1 to 10 of 1189 10 Older Entries

Planet MySQL © 1995, 2015, 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.