MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

-1
votes
1answer
8 views

mysql server is not starting

mysql server is not starting after modifying configurations key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 query_cache_size = 16M after ...
0
votes
3answers
19 views

Last mysql reboot

Is there a way to check the last restart of mysql server, in global variables or something else ? System : redhat Logging : not activated
0
votes
1answer
21 views

Index on 'GROUP BY' with functions

I have a log table. It logs visitor data (time of visit, browser, window size ...). I want to create reports. I use a query like this (MySQL): SELECT COUNT(*) as raw_views ... FROM logs WHERE ...
0
votes
0answers
13 views

PHP My SQL Taking Long time to Insert Record in Table when using Mozilla Browser

Scenario : I am trying to Execute Page which has code to Insert a Record in My SQL Table. Issue : When I am calling this Page from IE/Safari it works well but when I do the same from Mozilla/Chrome ...
0
votes
0answers
11 views

Loading the databases from previous installation mysql

My Windows OS crashed today. Now I have recovered all the files in Program files/MySQL folder.(I don't have the exported .sql file) With the new installation of MySQL 5.6(same as before), can I get ...
2
votes
1answer
13 views

Purge mysql and it's configuration completely from MAC.

I, by mistake messed up with mysql's only user and the situation is I can't create new user or give more privileges to existing one. Access denied is the error. Only visible db is info Schema So I ...
1
vote
0answers
21 views

What could cause waiting for table metadata lock?

I am using a MySQL 5.6 DB with MyISAM tables under FreeBSD 8.3. The main part of code is in PHP, but the problem arises, when I launch the self-written on C++ chat-server. I use the mysql.h for DB ...
0
votes
0answers
21 views

How can I decrease FULLTEXT initialization time?

I'm trying to decrease execution time of the a query. Using SHOW PROFILE, FULLTEXT initialization takes about 0.3, which is too high. Other values are at normal level. How can I decrease FULLTEXT ...
1
vote
0answers
28 views

How can I normalize and optimize this database before I build it?

I was just given the project of creating a database to store and access information that the various engineers involved in design and manufacturing can use to create updated instructions and load ...
0
votes
1answer
20 views

MySQL read/write ratio from information_schema.GLOBAL_STATUS

Could you please help me to construct a query to sum specific rows from a table, basically desired output is: +-----------------+----------------+ | Total reads | Total writes | ...
0
votes
1answer
30 views

How to find n consecutive numbers in MySql

I have numbers starting from 1 to 50 and then 90 to 200 in my database and I want to fetch 100 consecutive numbers then the result should be 90 to 189. Records in my table are more than 10 million.
0
votes
1answer
17 views

Extracting the maximum of several subsets and join all maximums in a new table

I have a big table: What I need is to obtain the maximum value for each testname, with different entry and get a new table such as: And then I want to compute the maximum, the minimum and the ...
0
votes
1answer
26 views

Why is my Mysql Query verry slow when selecting a text field

i have a problem with a left join. Tables are myisam. Tables CREATE TABLE `article` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `force_startpage` tinyint(1) DEFAULT '0', `title` varchar(255) ...
0
votes
0answers
33 views

amazon small instance mysql query too slow

I have mysql database with 1.5 millions records with 2 million categories records. when i do query on categories and city where clause it takes 304989 milliseconds. on localhost it too fast. i tried ...
0
votes
1answer
16 views

pt-table-sync for 3 master servers

We had a mysql multi master with 3 nodes and unfortunately the replication broke. We have some set of tables which has to be in sync with other database servers, so i was looking into Percona-Toolkit ...
1
vote
1answer
19 views

MySQL crashes frequently on a Windows server

I have been facing an issue with MySQL crashes since last week. I don't know what exactly is happening. When I look at the Windows logs, I see the following error message: Faulting application name: ...
0
votes
1answer
25 views

Query to join three tables

I have three tables which I have to join. I'm not a good SQL writer. Can please sombody help me to prepare this using joins: branches ----------------------------------------- branch_id | branch_name ...
0
votes
0answers
19 views

MySQL Dump failure in the middle [on hold]

I have a several GB's of MySQL datas,I want to dump those files,As when I tried to dump,it fails in between. It is impossible to start over the process again,Is there any way to start the dump from ...
1
vote
0answers
19 views

Randomizing the Auto Increment in Mysql

We have a database, where we insert data into table whenever we receive an order from our services. We use auto_increment to generate the ID and assign the order with the same. This is usually same ...
0
votes
1answer
23 views

Duplicate Entry Error with PHP When Trying UPDATE

I am checking if a record exists, creating a new record if it does not already exist, and updating otherwise. The SQL works fine in PHPMyAdmin but not through the PHP page. $check_for_id = ...
1
vote
0answers
31 views

MySQL fulltext selection performance

I have 1.5M rows in a table. Following is the table create code: CREATE TABLE `jobs` ( `id` INT(8) NOT NULL AUTO_INCREMENT, `job_id` VARCHAR(50) NOT NULL DEFAULT '', `title` VARCHAR(255) ...
0
votes
0answers
19 views

DBD::mysql complains “Character set 'latin1' is not a compiled character set”

I think this boils down to "Am I doomed to upgrading mysql hoping the problem goes away?". I've seen a few of the same issues around the internet but with no guidance on a fix other than "Did you turn ...
0
votes
1answer
22 views

MySQL: update field with “x hours xx minutes”using int from another field

We have two fields that hold time data totalTime (int): number of minutes (eg 243) totalTimeDesc (string): normal english representation (eg '4 Hours 3 Minutes') We have a lot of different formats ...
0
votes
1answer
31 views

Last row from a query without Order by

I have something like SELECT var1,var2 FROM table where var3=X AND var4=Y order by var5 desc limit 1; Running this query takes roughly 5 seconds on my database which is far to slow. I was ...
1
vote
1answer
14 views

Can triggers be used to implement automated polymorphic association?

(Apologies for any bad formatting or ignorance of common practices within this community; this is my first question here.) I'm attempting to (re)design a MySQL database for a personal social ...
0
votes
1answer
17 views

Where mysql writes its log seqeunce numbers and last checkpoint at?

I'm working on developing mysql log collecting system. To do that, I have to collect log sequence numbers from mysql LSN and last checkpoint location. But I have no idea where should Which log file ...
1
vote
1answer
54 views

MHA configuration problem with MariaDB10

I am using MHA (MySQL Master High Availability) over a MySQL/MariaDB master-slaves pool. Here is my setup : master1(10.0.0.1:3306) (current master) MySQL 5.1 (log-bin:enabled) ...
0
votes
0answers
16 views

Why does Amazon RDS memory utilization drop and disk space utilization rises?

I encountered a problem with my Amazon RDS(db.m2.2xlarge) where DB connections spiked up and my website started responding slowly. On looking up the metrics I was not sure why my freeable memory shot ...
0
votes
2answers
32 views

How do I allow remote mysql access to all users?

I have setup a mysql server on unbuntu. The server hosts websites for my various clients. Hence, I want all of them(and any new clients) to have remote access to the mysql server. How do I configure ...
-1
votes
0answers
32 views

“Bad SubDomain SQL query” [on hold]

My website shows "Bad Sub Domain SOL query" when i open the site.It's an E-commerce site, platform is PrestaShop(Version: 1.5.5.0) and it worked well in the last 2 years. Now it shows "Bad Sub Domain ...
0
votes
1answer
15 views

MySQL/PHP Returning Blank Error Message

I am using the following code to delete a record. It works fine, but MySQL always returns a blank error message. PHP returns "Error: " instead of "1 Record Dropped". $eventid = ...
0
votes
0answers
12 views

What are the advantages and disadvantages of Sequel Pro over writing on my terminal? [on hold]

I am starting to use MySQL (I am actually learning). What are the advantages and disadvantages of Sequel Pro over writing on my terminal? Where can I find a good quick tutorial to use those advantages ...
0
votes
0answers
15 views

Grouping together values in different columns in MySQL

I have hierarchical data and I'm using the adjacency model. For example my table looks like CREATE TABLE books( book_id INT AUTO_INCREMENT PRIMARY KEY, book_category VARCHAR(100), parent INT ); ...
0
votes
2answers
41 views

MySQL Code Works in PHPMyAdmin but not in PHP Page

When I run this query in PHPMyAdmin it works fine, but when I run it from the PHP page using the $sql command, I get the error: "You have an error in your SQL syntax.....near ')' at line 2" $sql = ...
2
votes
1answer
33 views

Auto-increment ids with multiple inserts in mysql/mariadb

Suppose I have a table with an auto_increment column, and then insert multiple values in a single statement: insert into foo (bar) values ('a'), ('b'), ('c'); From the documentation, ...
1
vote
1answer
25 views

mysqldump drop create use case sensitivity

Dumped sql from MySQL is showing inconsistencies in the name of the database. Using the following bog standard method to dump a database: mysqldump --add-drop-database -u someuser --databases ...
0
votes
3answers
45 views

Master-master Replication with 3 Nodes

I need to configure mysql master/master replication with 3 nodes. Currently I have master/slave setup and I need to move it to master/master with 3 nodes. I have gone through some posts about ...
0
votes
1answer
21 views

Is it possible to uninsall MySQL-5.6 and install MySQL-5.1 on RHEL 5

I have installed MySQL-5.6.x community edition on RHEL5. It was running fine. Since, it is my testing server. To find the differences in execution timing, I have to install the MySQL-5.1 community ...
0
votes
1answer
25 views

MySQL crashing randomly

We have a sever running a website Joomla 2.5. We are facing frequent mysql crashes that occur when website has medium visitor load like a few thousands. It appears that mysql consumes more memory and ...
1
vote
1answer
14 views

add column without metadata lock in mysql 5.6

I am using MySQL Server version: 5.6.15 Homebrew. I need to add new null column. alter table requires no metadata lock. In order to avoid this MySQL 5.6 introduced algorithm=inplace. Here is the ...
2
votes
2answers
42 views

Copy from one MySQL table to another MySQL table of same database

I have around 40 million rows in a MySQL table and I want to copy this table to another table in same database. What is the most efficient way of doing this? How much time will it take (approx.)?
0
votes
1answer
36 views

Pulling from Two Tables with Different Number of Records

I have three tables, one for members with 8 records, one for tasks with 1 record, and one for events with 3 records. The tasks table associates the events with members using one-to-many primary to ...
0
votes
1answer
20 views

Adding a constant IF not in an other table

So I have this query. SELECT * FROM `Comment` WHERE `Target` = '".$_GET['pp']."' AND `Id` NOT IN (SELECT `Target` FROM `Delete` WHERE `Type` = 'comment') ORDER ...
0
votes
2answers
34 views

query execution time in mysql

I have run the query in mysql which consists of approximately 33million records when i have executed the query select population1 < 200000 from city; it shows like this after execution ...
0
votes
1answer
13 views

Mysql Select using Alias

I Need to filter the query that have some conditional column as below: SELECT `c`.`fullname` AS `fullname`, IFNULL(`c`.`new_ic`,`c`.`old_ic`) AS `Ic`, `bla`.`loan_no` AS `Loan_No`, ...
1
vote
1answer
27 views

Merge a table into an existing one

I know how to JOIN two tables as create a new table out of the results, using CREATE TABLE result_table AS ( SELECT * FROM tableA JOIN tableB ). I forgot to include some columns from the JOIN in the ...
0
votes
0answers
15 views

Get tp.address_from and tp.address_to from travel_point table

I'm building a view for get tp.address_from and tp.address_to but I can't get this works. This is the query I'm working on: SELECT `tp`.`address_from` AS `address_from`, `tp`.`address_to` AS ...
0
votes
1answer
15 views

change character set in mysql permanently

I want to change following parameters to utf8mb4 so that mysql can store emoji characters and special language characters. but when i try running following statements one by one SET ...
0
votes
1answer
36 views

Find youtube url

Good afternoon, I need a help, through a select have to locate within a column all the urls from youtube 'https://www.youtube.com/watch?v=cod'* N codes, as necessary to generate a txt with these ...
1
vote
1answer
16 views

Bypassed, Empty Relay Log

We have a simple 1:1 Master-Slave replication configuration. The Master crashed, but we recovered and replication seems fine (confirmed by pt-heartbeat and SHOW SLAVE STATUS) but we've picked up one ...