Open source SQL database often used on Linux with Apache and PHP (LAMP)
See also: Guide to Tuning MySQL for Performance
Update - New Innodb tuning section added below. See also Common MySQL Queries.
Display network status
# nmcli d
Start network manager
Edit the connection to Automatically connect
# yum group install "GNOME Desktop" "Graphical Administration Tools"
# yum groupinstall "Server with GUI"
Run the following to make the GUI start on reboot
So, here's a simple step to add a swap space (Read more for details):
I got the this error when trying to do a sqldump of my database. To fix this error use the utility mysqlcheck from the command line.
This statment shows that the table is marked as crashed:
# mysqlcheck -uuser -ppass database table
warning : Table is marked as crashed
status : OK
This statement will repair the table:
# mysqlcheck -uroot -pvisitor --auto-repair database table
The 5.1 release was very slow getting released
MySQL 5.1 Sun/Oracle version we now consider it stable
Oracle bought MySQL, and it has gone OK so far.
Use the Innodb Plugin is much better performance than the included version.
Join Optimizations, Stored Procedures, General Scalability Improvements
List all tables in the current database:
=> SELECT tablename FROM pg_tables where tablename not like 'pg_%';
Limit rows returned as in where rownum <= 10
=> select tablename from pg_tables limit 10;
List tables in one schema
=> select tablename from pg_tables where tableowner='qedit';
List running queries
=> select * from pg_stat_activity;
List database activity
Run the command to install procedural languages or you will get: ERROR: language "plpgsql" does not existConnect as the superuserbash-3.2$
Run the commandbash-3.2$ createlang -d movecms1 plpgsql
Login as regular userbash-3.2$ psql -U qedit -d movecms1
Now create the type to return the values