Our product historically used an Oracle backend, and after implementing simple date based range partitioning we got 20-30 time performance increase in our queries. We had used MySQL in other more minor products we had developed, but we couldn't move to it until partitioning was implemented. In Dec 05 we started to test MySQL partitioning, where partitioning syntax was supported but the optimisations were not in place. As soon as the optimisations we put in, we were able to run a side by side comparison against unpartitioned tables and Oracle partitions. Not only did we get in MySQL a 30+ times performance increase, but the MySQL version ran nearly twice as fast as the same Oracle configuration in a like for like test.
Hello,
we got a high security network which is completely offline.
We want to use a Sync Host like described here in the Redhat documentation for Sattelite 6.
I have the following Questions:
- We need the complete Repository not only the main one how much space we need for this ?
- Can... (2 Replies)
Can anyone point me towards a list that shows which Satellite versions roughly align with which Spacewalk versions, in terms of functionality?
Thanks in advance,
Akbar. (2 Replies)
Hi all,
We have been using Satellite to patch our RedHat servers for a while but up until recently these have only been virtual machines. Now we have a requirement to install a few physicals and I am trying to setup a sync a custom channel for the HP reository.
Our setup is that the... (2 Replies)
I am getting ready to install RHEL6 server. I have to create these partitions:
/ 10GB
SWAP 3GB
/opt/kent 10GB
/opt/kent/logs
/backup 20 GB
Will Gparted do this? or whats the easiest way? or even a tutorial?I am so new to this (4 Replies)
Ten movies have been nominated as best motion picture by the International Press Academy, presentation of the 2012 Satellite Awards will be held on 16th December at Los Angeles, CA.
Place your bits here on one of the below nominated movie of your choice:-
Argo
... (0 Replies)
Wild shot in the dark as both are exactly ubiquitous technologies, but here it goes: Anybody have any experience using a Dell KACE to PXE boot to a Red Hat Satellite kickstart install? I've set up the kickstart by itself before but I'm not sure there's a way to configure the KACE so that it will... (0 Replies)
Hi,
I'd like to know more about RHN and their RHN PROXY.
- If I will buy PROXY, do I need to get licenses for all my RHELs to have them updated? What are benefits of proxy?
- If I will buy (doubt it) Satellite, will I be able to connect all my boxes to Satellite and have them upgraded... (5 Replies)
Hi folks,
Ubuntu 10.04-1 64-bit
HD - 1T SATA3
I ran graphic installation installing Ubuntu-10.04-1 desktop from Live CD
The partition on the new HD is as follow;
/root
/home
/kvm
(kvm is for keeping the guests of KVM, the virtualizer)
Installion went through without problem abd... (0 Replies)
Hi all,
I have a bit of an inexplicable problem....
Up until today, on my Toshiba Satellite A30 Laptop running SuSE 8.2 Professional, I had a dual mouse (USB Mouse / Touchpad) configuration in X and everything was running fine.
I booted the laptop today, and for some reason unbeknownst to... (3 Replies)
MYSQLD(8) MySQL Database System MYSQLD(8)NAME
mysqld - the MySQL server
SYNOPSIS
mysqld [options]
DESCRIPTION
mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to
the MySQL data directory that contains databases and tables. The data directory is also the default location for other information such as
log files and status files.
Note
Some installation packages contain a debugging version of the server named mysqld-debug. Invoke this version instead of mysqld for
debugging support, memory allocation checking, and trace file support (see Section 28.5.1.2, "Creating Trace Files").
When MySQL server starts, it listens for network connections from client programs and manages access to databases on behalf of those
clients.
The mysqld program has many options that can be specified at startup. For a complete list of options, run this command:
shell> mysqld --verbose --help
MySQL Server also has a set of system variables that affect its operation as it runs. System variables can be set at server startup, and
many of them can be changed at runtime to effect dynamic server reconfiguration. MySQL Server also has a set of status variables that
provide information about its operation. You can monitor these status variables to access runtime performance characteristics.
For a full description of MySQL Server command options, system variables, and status variables, see Section 5.1, "The MySQL Server". For
information about installing MySQL and setting up the initial configuration, see Chapter 2, Installing and Upgrading MySQL.
COPYRIGHT
Copyright (C) 1997, 2018, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.7 06/07/2018 MYSQLD(8)