In previous entrance related to MySQL and MariaDB I wrote one entrance related to why indexing is important, when working with databases (the article is only in spanish, but I will translate into english), and later, how to force MySQL-MariaDB to use a specific index that it is not the one chosen by MySQL (also in spanish). Today’s entrance is related to explain how works the mechanism of an index on MySQL-MariaDB tables, and what important considerations you need in order to get the best performance, and optimize your queries!...read more

The post The mecanism of indexing on MySQL-MariaDB appeared first on Manejando datos.

Related posts: …

I am working a a project in the University and I need to re-create a table. For that task, I’m thinking in two ways: using TRUNCATE, or dropping the table and create it again. TRUNCATE is a SQL sentence that empties a table, and for using it, you need to be granted as using DROP priviledge. autokey is reset to zero. The second option is using DROP a table, and create it again using CREATE TABLE. Para valorar de las dos opciones es más rápida, vamos a utilizar PROFILE, para...read more

The post Faster method: TRUNCATE or DROP a table? appeared first on Manejando datos.

Related posts: …

This entrance is dedicated to a new website for learning #BigData in spanish: SoyData.net. What is SoyData.net It is a collaborative online training platform on all matters relating to data in spanish. It now has 15 fully uploaded and available courses to which they have registered more than five hundred people in just two weeks. These courses address specific high demand technologies like Hadoop, MongoDB, R and cover key areas such as visualization, cloud computing or Structured Query Language (SQL). It also provides an introduction to #BigData concept for those...read more

The post Learning #MySQL at SoyData.Net appeared first on Manejando datos.

Related posts: …

If you are a database administrator, it could be really useful to hava available good tools. When this blog started, I already wrote about frameworks for MySQL DBA, and I’ve read several entrances about common_schema, another useful framework under the MySQL-MariaDB ecosystem. Today it’s time for Sys Schema, a collection of views, functions and procedures to help MySQL administrators get insight in to MySQL Database usage, so let’s install it. Install SYS on Windows The project is available to download on GitHub: https://github.com/MarkLeith/mysql-sys, so, I downloaded it and unzip on...read more

The post Install Sys_Schema on MySQL – MariaDB appeared first on Manejando …

Today’s entrance pretend to give you two good recommendations, after a whole morning busy trying to solve a simple cuestion. The objective is linking a table that lives on a MySQL o MariaDB server on Microsoft Access, using ODBC (using MS Access as a MySQL front-end). This simple task, can be too dramatic if you …

Continue reading »

Esta entrada Linking MySQL-MariaDB under MS Access es contenido original de Manejando datos - Blog de bases de datos y programación. This entrance Linking MySQL-MariaDB under MS Access is created by …

Let’s keep on learning more and more about common-schema, and I execute a query about redundant keys: SELECT * FROM common_schema.redundant_keys; The result to this query informs me that these keys are, literally, redundant, and the optimal solution si to remove them. Also, the query has more interesting information! After this, you think: “Well, if …

Continue reading »

Esta entrada Common-schema: redundant keys on MySQL-MariaDB es contenido original de Manejando datos - Blog de bases de datos y programación. This entrance Common-schema: …