https://siftrss.com/f/pNxzaGJoRNb Geeksww.com is based on the idea of a global community for geeks, worldwide. en-us Fri, 17 Feb 2023 12:40:44 UT Fri, 17 Feb 2023 12:40:44 UT webmaster@geeksww.com (Shahryar Ghazi) webmaster@geeksww.com (Shahryar Ghazi) http://www.geeksww.com/tutorials/database_management_systems/mysql/monitoring/monitored_on_a_busy_databasemysql_server.php On a busy MySQL server, some key metrics that should be actively monitored include: Fri, 20 Jan 2023 23:43:35 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/monitoring/monitored_on_a_busy_databasemysql_server.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/how_to_speed_up_a_mysql_replica.php There are several ways you can try to speed up a MySQL replica. Here are some ideas: Mon, 09 Jan 2023 03:22:40 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/how_to_speed_up_a_mysql_replica.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/the_server_requested_authentication_method_unknown_to_the_client_phpmyadmin.php It looks like you are trying to connect to a MySQL server using phpMyAdmin and you are encountering an error message saying that the server requested an authentication method unknown to the client. Mon, 09 Jan 2023 02:21:14 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/the_server_requested_authentication_method_unknown_to_the_client_phpmyadmin.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/default-values-for-mysql-json-columns.php MySQL has been making huge progress on the JSON/NoSQL front as well ie. supporting many of the JSON access and manipulation features and operations. In this how-to tutorial, I am going to show you how to add a new JSON column with default value in an existing MySQL table using the ALTER TABLE statement. And, how to create a new table using CREATE TABLE with JSON column along with its default value. Mon, 11 May 2020 00:00:00 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/default-values-for-mysql-json-columns.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/delete_rows_table_when_pk_referred_table.php Before data insertion, updates, deletes etc, database management systems that support foreign keys (like MySQL) make sure you do not introduce any inconsistencies. So, you need to make sure you're not leaving orphan records behind in child tables. Mon, 09 May 2016 02:19:33 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/delete_rows_table_when_pk_referred_table.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/unique_primary_keys_pks_for_mysql_using_redis.php MySQL provides an auto increment feature (AUTO_INCREMENT attribute) that can be used to generate unique identities for new rows/records. However, this may become a problem when you are writing to more than one MySQL databases and merging them, since all of them will be generating their own unique keys. Thu, 21 Apr 2016 17:15:24 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/unique_primary_keys_pks_for_mysql_using_redis.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/how_to_rename_mysql_db_name_by_moving_tables.php RENAME DATABASE statement was removed from MySQL because it was found to be dangerous. However, MySQL still supports the RENAME TABLE command. Thu, 21 Apr 2016 16:45:37 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/how_to_rename_mysql_db_name_by_moving_tables.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/is_mysql_56_slower_than_mysql_55_.php MySQL 5.6 is believed to be the best MySQL release ever. In order to find out if it is true or not I ran some benchmarks and I am going to share the results with you in this tutorial. Please note that I only tested with default settings (in both cases) and using sysbench as a benchmarking tool, so its a pretty basic test. I highly recommend that you test on your particular workload before upgrading and share your results. Fri, 22 Feb 2013 13:13:22 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/is_mysql_56_slower_than_mysql_55_.php http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/download_configure_compile_and_install_mysql_56.php MySQL 5.6 is the latest production-ready release of the most popular opensource database management system on the planet ie. MySQL. Wed, 06 Feb 2013 13:10:35 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/download_configure_compile_and_install_mysql_56.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/fast_parallel_restore_from_sql_dumps_mysqldump_for_mysql.php I have used the technique that I am going to describe below on several occasions to restore from a SQL dump generated using mysqldump. In some cases, the restore that had taken 2 days and still could not finish successfully was completed in 5-6 hours using this simple technique. Please keep in mind that this is not a pure parallel method but I'd say it is almost parallel and have proven to be faster than regular single-threaded restore. Fri, 29 Jun 2012 00:48:09 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/fast_parallel_restore_from_sql_dumps_mysqldump_for_mysql.php http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/how_to_download_and_install_mysql_on_mac_os_x.php MySQL is the most popular open source database management system. It allows you to quickly download and install and run a powerful database system on almost any platform available including Linux, Windows, and Mac OS X etc. Wed, 23 May 2012 05:32:57 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/how_to_download_and_install_mysql_on_mac_os_x.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/mysql_dateformat_function_and_order_by.php An interesting scenario that I came across today was the fact that if you use the same alias as the column name in a formatted string (using DATE_FORMAT) and you also use same alias in ORDER BY or GROUP BY clause then MySQL uses the string output of DATE_FORMAT to sort records rather than the actual date column. Mon, 12 Dec 2011 02:29:39 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/mysql_dateformat_function_and_order_by.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/mysql_query_cache_not_necessarily_a_bad_thing.php After reading about the query cache mutex contention, scalability issues on multi-cores, and several people recommending disabling query cache on multi-core machines. I decided to give it a try and disable it to improve performance and since I was also seeing a lot of "freeing items" states for my queries (mysql works on query cache for part of the time query is in that state). Mon, 03 Oct 2011 19:18:24 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/mysql_query_cache_not_necessarily_a_bad_thing.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/mysql_error_while_dropping_databases.php A few months back I was trying to drop some unnecessary test and archived databases from MySQL servers and while dropping a database I got the following error message. Thu, 06 Jan 2011 20:33:13 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/mysql_error_while_dropping_databases.php http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/download_configure_compile_and_install_mysql_558_on_linux.php MySQL 5.5 is the latest production-ready release of the most popular opensource database management system on the planet ie. MySQL. Tue, 21 Dec 2010 02:15:38 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/download_configure_compile_and_install_mysql_558_on_linux.php http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/mysql_open_files_limit_openfileslimit_vs_openfileslimit_on_linux.php Did you think that underscores and hyphens in MySQL server option names can be used interchangeably in configuration file? Read this tutorial to find out about an exception to this general rule. Mon, 29 Nov 2010 16:37:25 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/mysql_open_files_limit_openfileslimit_vs_openfileslimit_on_linux.php http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/downloading_compiling_and_installing_mysql_server_from_source_code.php Have you ever tried compiling MySQL server from source code? If you have not but want to, here are some easy steps to do so on a Debian/Ubuntu Linux machine. These instructions should work on other Linux distributions e.g. SUSE, RedHat, CentOS etc. Sun, 28 Nov 2010 21:20:09 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/downloading_compiling_and_installing_mysql_server_from_source_code.php http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/allschemas_tool_to_run_multiple_sql_queries_on_a_mysql_database_server.php all-schemas is a powerful that helps developers/administrators run multiple SQL statements on all or selected databases on a MySQL db server. Sun, 03 Oct 2010 04:02:42 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/allschemas_tool_to_run_multiple_sql_queries_on_a_mysql_database_server.php http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/mysql_tablecache_informationschema_and_open_files_limit.php Recently, on our production servers we started seeing strange behavior by MySQL server while running queries on information_schema. Before getting into the gory details, I'd first explain the environment then the problem and its solution. Tue, 07 Sep 2010 18:16:19 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/mysql_tablecache_informationschema_and_open_files_limit.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_find_all_tables_of_a_particular_storage_engine.php MySQL supports several storage engines with different features and functions. If you want to find out what tables are using a particular storage engine in MySQL then can run these simple queries in a MySQL command line interface. Sun, 15 Aug 2010 01:06:52 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_find_all_tables_of_a_particular_storage_engine.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_check_mysql_version_number.php MySQL provides some features for particular version numbers and on particular platforms only. So, in some situations it gets really important to find the MySQL version number installed. If you are faced with such a problem you can use any of the following techniques to find MySQL version number. Fri, 01 Jan 2010 00:00:00 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_check_mysql_version_number.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/mysql_tables_statistics_size_engine_no_of_rows_etc.php MySQL provides statistical data for users to get more knowledge about the tables in databases. The command to get this useful information is \"mysql table status\". Tue, 27 Oct 2009 14:37:04 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/mysql_tables_statistics_size_engine_no_of_rows_etc.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tools/mysql_gui_tools__query_browser.php MySQL Query browser is a freely available client tool to run queries and commands on MySQL servers. It comes as part of the MySQL GUI tools package, which can be installed on several platforms. Tue, 27 Oct 2009 13:49:19 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tools/mysql_gui_tools__query_browser.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_find_mysql_server_uptime.php Use mysqladmin utility to find MySQL server\'s uptime. Run the following command from command line. Fri, 25 Sep 2009 16:28:11 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_find_mysql_server_uptime.php http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/initializing_mysql_database_after_installation.php If you have an empty data folder or you want to initialize/reinitialize MySQL server from scratch (possibly after dropping all existing databases) then use these instructions. Fri, 25 Sep 2009 15:30:43 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/configuration/initializing_mysql_database_after_installation.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/seeing_indexes_in_a_mysql_table.php To show indexes on a MySQL table execute any of the commands mentioned in the tutorial in a MySQL client. Fri, 25 Sep 2009 15:06:25 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/seeing_indexes_in_a_mysql_table.php http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/mysql_performance_optimization_part_ii.php You can speed up index scans if you periodically perform a void ALTER TABLE operation, which causes MySQL to rebuild the table. Fri, 25 Sep 2009 14:49:30 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/administration/mysql_performance_optimization_part_ii.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_see_table_definition_statements_in_mysql.php Use the command described in the tutorial to find complete CREATE TABLE SQL statements for MySQL tables. Tue, 27 Jan 2009 16:13:17 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_see_table_definition_statements_in_mysql.php http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_find_if_mysql_supports_partitioning_or_not.php If you are faced with a situation where you need to find if your MySQL Database server supports partitioning or not then follow the instructions described in this tutorial. Tue, 27 Jan 2009 16:10:48 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_find_if_mysql_supports_partitioning_or_not.php http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/installing_mysql_client_tools_binaries_and_library_on_ubuntu_linux.php This short tutorial shows you how to install MySQL Client tools, binaries, and library on Ubuntu Linux Server. The process is very simple. For this tutorial, I'll be installing MySQL Client tools, binaries, and library version 5.0.45. Linux kernel is 2.6.15-26-powerpc. I have used a Mac Mini (powerpc/ppc architecture). GCC version number is 4.0.3. Your configuration may be different from mine but the installation steps below should work fine for most configurations with little or no change at all (including other Linux distributions and even unixes e.g. MacOS x). Thu, 15 Jan 2009 17:57:13 UT http://www.geeksww.com/tutorials/database_management_systems/mysql/installation/installing_mysql_client_tools_binaries_and_library_on_ubuntu_linux.php