Skip to content

Tag: mysql

install mysql 5.7 purely from bash script on Ubuntu

I want a bash script that installs a MySQL 5.7 instance without needing any manual input. I was following the tutorial on Digital Ocean and it says for 5.7 you have to run the following commands and then put commands into a prompt (screenshot below). How can I automate the installation if it requires me to us…

Improve MySQL Performance

Info: MySQL Community 5.7.12 64 bits Programming Language: Python 3.5 mysqld.cnf: Mysqld.cnf result of “show variables” show variables Description: – I have 200 000 tasks. – I process these tasks with 500 threads, one per task, when a thread finishes, another task start. The point of t…

MySQL code causes PHP script to crash at popen/exec

I have the following PHP 5.6.19 code on a Ubuntu 14.04 server. This code simply connects to a MySQL 5.6.28 database, waits a minute, launches another process of itself, then exits. Note: this is the full script, and it’s purpose is to demonstrate the problem – it doesn’t do anything useful. …

Improve mysql Speed?

I have mysql/php script running on my linux machine. Its basically migrating files content to MySql table. there are about 4400,000 Files, Account files each file`s content is places in a table in one row. It have been 14 hours and so far it have only done 300,000 Accounts. At first it was very fast and was d…

improperly configured at /accounts/login/

In order to simulate sdn networks i downloaded the mini net 64 bit version and imported it in vmware Workstation pro 12 and through github all the project related stuff have been installed but the thing is when i wanna run it i encounter an error , do you think it’s because of the mysql not being config…