I've been testing the performance between 5.7 and 8.0. We figured out that our application is around 30% slower with 8.0, so I tried to narrow down the issue. I've started running simple sysbench tests and they showed the same…
CREATE TABLE `users`( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` VARCHAR(75) NOT NULL, `password` VARCHAR(255) NOT NULL, `email` VARCHAR(100) NOT NULL, PRIMARY KEY `id` UNIQUE KEY `email` (`email`) )ENGINE = INNODB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci AUTO_INCREMENT =…
I have a old league web site php script with mysql database from 2006. This script not running depends to old php and mysql versions. Thats why I tried to get data from mysql database using django but I have…
$query = "CALL GetAllCategories()"; $stmt = $pdo->prepare($query); $stmt->execute(); $categories = $stmt->fetchAll(); I use this code to get categories from DB using stored procedures, no problems with that, everything works fine. This is GetAllCategories() procedures: DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `GetAllCategories`()…
I built a website with laravel 8. The server is a 6 cores CPU / 6 GB Ram VPS. Server is Linux CentOS with nginx and mysql 8. At peak period, there is about 500 visits online simultaneously. The CPU…
I read many posts that teach how to remove duplicate row. But in my situation, there is relationship between tables. I would like to update the relationship before deleting the duplicate rows. I also read a question in 2013 that…
I have a query, that selects the lowest available id free in a table. It works perfect in my tests, but however I realized, that it always returns 9 in production. So I deleted id number 6 (which is lower)…
this is my proc, and below is my error, apart form the numerous ; missing, what am I Missing on line 2?? CREATE PROCEDURE sp_insertOnReject @id int AS BEGIN START TRANSACTION; UPDATE content_manager.submission SET state = 'Rejected' WHERE id =…
In PhPMyAdmin: Consider a table containing two strings: D:PROJECTSARJ Trans Infinite Galaxy210514Infinite Galaxy-Batch28.xlsx.sdlxliff Infinite Galaxy-Batch28.xlsx.sdlxliff Run the following queries: SELECT * FROM test WHERE name='D:\PROJECTS\ARJ Trans Infinite Galaxy\210514\Infinite Galaxy-Batch28.xlsx.sdlxliff'; SELECT * FROM test WHERE name LIKE '%D:\PROJECTS\ARJ Trans Infinite Galaxy\210514\Infinite Galaxy-Batch28.xlsx.sdlxliff%'; SELECT…
Firstly, please do not link me to any of these posts as I have already read them in their entirety and nothing helped: mysql cannot grant privilege to user, getting error: ERROR 1819 (HY000): Your password does not satisfy the…