I already wrote that since a few months ago I am working with #Anaconda, a scientific Python version, because this version includes several tools for working with data. However, I ws a little bit confuse because there is no MySQL package to work with. So, if you need to connect with a MySQL database, you …
The post Anaconda and MySQL appeared first on Manejando datos.
Ya os conté que trabajo con la versión #Anaconda de Python, ya que facilita mucho el disponer de todas esas herramientas para trabajar con datos. Sin embargo, me ha extrañado un poco que no incluyan el paquete para trabajar con MySQL, ni siquiera en sus repositorios. Así que, para trabajar con MySQL hay que instalar …
The post Anaconda y MySQL appeared first on Manejando datos.
On previous post, I already wrote about how to create a database backup, how to unistall a MySQL version, ad how to install a new MySQL version, in this case, MySQL 5.6.10. If you are new to MySQL, you can think … “Well, I have installed MySQL server, now .. what can I do?“. Starting …
The post Moving from MySQL 5.5 to 5.6. Step 4: Starting with MySQL 5.6.10 appeared first on Manejando datos.
[…] el paso 2 se comentó la importancia de hacer una copia del fichero my.ini, que incluye las opciones de […]
[…] los pasos anteriores hemos comentado cómo hacer copias de seguridad (#backup), desinstalar una versión de #MySQL, instalar una nueva y comprobar que funciona la nueva […]
Al instalar una base de datos deberemos tener en consideración las variables de MySQL de acuerdo con el sistema en concreto y los datos. En el Percona Toolkit podemos encontrar la herramienta pt-variable-advisor que nos puede ayudar a ajustar las variables.
Si únicamente queremos usar dicha herramienta la podemos descargar mediante:
wget percona.com/get/pt-variable-advisor
Para usarla deberemos indicar el host y los datos de acceso:
# perl pt-variable-advisor localhost -p $(cat /var/mysql/.mysql.root.pass) # WARN delay_key_write: MyISAM index blocks are never flushed until necessary. # WARN innodb_log_file_size: The InnoDB log file size is set to its default value, which is not usable on production systems. # NOTE log_warnings-2: Log_warnings must be set greater than 1 to log unusual events such as aborted connections. # NOTE max_binlog_size: The …[Lea más]
In previous steps, I have explained how to create backups of your MySQL-MariaDb databases and how to unistall MySQL, including all configuration files (very important!!). Now, let’s install the new version of MySQL that you can download from here:dev.mysql.com/downloads/mysql/5.6.html. In my case, I downloaded the Microsoft MySQL Installer. I think this installer has been a …
The post Moving from MySQL 5.5 to 5.6. Step 3: Install MySQL 5.6.10 appeared first on Manejando datos.
I already wrote about the less information I got from migrating from version 5.0, 5.1 or 5.5 to version 5.6 on Windows, so … I’ll write about the way I do it. Yesterday you could read about creating backups and export your databases. Firts of all, backup The first step of every migration should be …
The post Moving from MySQL 5.5 to 5.6. Step 2. Uninstall MySQL 5.x appeared first on Manejando datos.
Today I start a serie of post dedicated to #MySQL database, one of the most used databases on Internet sites. Apart from this, I must say that I found less information than I imagine for moving from MySQL 5.0, 5.1 or 5.5 to versin 5.6 on Windows. So, I will tell you my way! First, …
The post Moving from MySQL 5.5 to 5.6. Step 1: Backup appeared first on Manejando datos.
Original post: http://anothermysqldba.blogspot.com/2014/01/use-your-index-even-with-varchar-char.html
Hace poco me di cuenta de un post en el forums.mysql.com sitio: Cómo búsqueda rápida en 3 millones de
registro?
El ejemplo que utiliza un LIKE '% eed'
Eso no será aprovechado de un índice y …