MySQL : Open-Source, Relational Database Management System

learn more… | top users | synonyms

0
votes
0answers
1 views

How to filter maximum results entries

I have a mysql table table name 'results' Reg.No SubjectCode Attempt Grade Marks 112108 CMIS 1113 1 D 17 112110 CMIS 1114 1 A 85 112119 CMIS 1114 1 D ...
2
votes
1answer
16 views

MySQL WHERE if NULL select another column

This is my mysql table id date_created date_active 1 2014-06-07 18:24:38 NULL 2 2014-06-07 18:24:38 2014-06-07 18:24:38 3 2014-06-07 18:24:38 ...
1
vote
1answer
11 views

How to take backups of MySQL databases, explicitly based on PyMySQL

I am looking for a purely Python solution to take backups of every MySQL database on localhost. I already use PyMySQL to run queries on these databases. Any ideas on how to do that? Any help is highly ...
1
vote
1answer
16 views

Finding out the exact size of the database after inserting records?

I have this query: SELECT table_schema "db.name" , Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" FROM information_schema.tables GROUP BY table_schema; Does this ...
1
vote
1answer
22 views

MYSQL query to find records between two date range

I am working in a web application using PHP and MySQL. I have two tables Employee employee_id email_id 3 tl1@jasmine.com 4 agent1@jasmine.com 5 ...
1
vote
1answer
9 views

Upgrading mysql percona server from 5.5.40 to 5.6.71

2014-12-26 05:18:20 13215 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure 2014-12-26 05:18:20 13215 [ERROR] Native table ...
2
votes
1answer
22 views

What is the difference between select and fetch time?

In this article MySql vs MongoDB performance benchmark, they defined two measurements: select time run time (select + fetch) I do not understand what the difference is between these two. Can ...
1
vote
1answer
33 views

SP how can I sum the amount of all leftchild in parentid

I have this data and table structure,I am creating MySQL stored procedure to sum all the amount in the leftchild of the parentid, I don't have enough knowledge in stored procedure.and I need some help ...
1
vote
1answer
8 views

MySQL replicated tables for Cognos BI

the Business Intelligence guy is asking for faster machines, latest software etc. and some of his customers are complaining of query times in excess of an hour. The tool is Cognos/Insight and the DB ...
1
vote
1answer
13 views

Only InnoDB databases locking up

I'm trying to troubleshoot my MYSQL in a LAMP and have an interesting situation. At first I thought MYSQL itself was locking up, but it turns out to be ONLY innodb databases that are locking up. ...
1
vote
1answer
19 views

mysql query from 1st domain and insert in 2nd domain

i have data in one of my website and i want to print these data in other site.these two are in same server.at present i have to export mysql data and import into other then do this code to insert in ...
2
votes
1answer
29 views

Sorting Table and get Position of row

I have a Table with 3 rows. Player, Time, Server. Now, I want 2 things and I don't know how. For Server there are 3 worths available. 1, 2 and 3. Server and Player are a Primary Key together. User ...
1
vote
1answer
17 views

Mysql binlogs exists, show binary logs is empty

I am working on a replication setup and have turned on bin-logs. I have moved my mysql datadir to a new location as well as the binlog path From my.cnf datadir = /vol/data/mysql ...
0
votes
0answers
12 views

Maximum function nesting level of '100' reached, aborting! in C:\wamp\www\installation\framework\database\driver\mysqli.php on line 134 [on hold]

I try to restore my backup joomla site from live server into local site. I using akeeba and kickstart. in local, I use whamserver 2.5 Anyway, at the stage: Database restoration, there is an error. ...
1
vote
2answers
21 views

How to get the sum of a particular item id in a column

Item ItemName PackageID Specifics brandname GRNQty UnitPric GRNValue 102814742801 ALL BRAN FLAKES 1PKT Bran. KELLOGS 7 15.9 111.3 102814742801 ALL BRAN ...
1
vote
0answers
13 views

What's the advantage of thread pool in MySQL/MariaDB?

MariaDB thread pool MySQL thread pool I've read official document of MySQL/MariaDB thread pool,but I'm still confused about it; As I understand, thread pool has two advantages: 1. limit too many ...
-5
votes
1answer
56 views

how to Write a SQL Statement to display EmployeeID from Table1 and EmployeeName from Table2 a [on hold]

how to Write a SQL Statement to display Claim Number, EmployeeID from Table1 and EmployeeName from Table2 above. Write a SQL Statement to display all the Information from Table1 and Table2 for ...
2
votes
2answers
22 views

getting MySQL error 1064 but very (absurdly) simple query in MySQLWorkbench

I'm getting a MySQL 1064 error for the simplest query when run with \G at the end. This works: select * from locations; and this doesn't: select * from locations\G hmmm... is there any way to ...
2
votes
1answer
10 views

MySQL open_files_limit - cannot change this variable

I'm running into issues because my open_files_limit for mysql is only 1024. Centos 7, MySQL Community Server 5.6.22-log It's actually a vps dedicated to mysql for a WHM server (remote mysql), but ...
-1
votes
0answers
12 views

MYSQL PHP slow response from server

I have max 72 connections at a time, normally it is 15 to 20 connections, but my server is response is slow and it is giving 500 internal server errors to users can you please tell me how to get rid ...
0
votes
0answers
7 views

MySQL cluster error: “Got error 4009 'Cluster Failure' from NDB. Could not acquire global schema lock”

I am trying to configure MySQL cluster under three Windows 7 machines with disabled firewall, cluster information is like the following: 2 hosts with each running 1 data node 3rd host running ...
0
votes
1answer
19 views

Hierarcy Query Mysql

I have a table like this... ========================================================================== UID || PARENT ID || SPONSOR ID ...
1
vote
0answers
5 views

Using Netscaler datastream and MySQL

I configured MySQL service on a netscaler 10.5. When I perform some MySQL benchmarks using mysqlslap, the first time it runs correctly, the 2nd time I have an error message: When I run it the first ...
0
votes
1answer
18 views

Changing mysql root password on Windows after removing mysqld-nt.exe

I am trying to change password of MySQL root by following the steps here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html unfortunately the mysqld-nt.exe doesn't exist in Windows ...
0
votes
1answer
14 views

Changing mysql root password on Windows after removing mysqld-nt.exe [duplicate]

I am trying to change password of MySQL root by following the steps here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html unfortunately the mysqld-nt.exe doesn't exist in Windows ...
0
votes
2answers
12 views

creating table syntax error

I have a problem creating the table. It says unexpected parenthesis at line 3 CREATE DATABASE scl_teachers; USE scl_teachers; CREATE TABLE clteacher ( 'id' INT (10) PRIMARY KEY auto_increment, ...
0
votes
2answers
26 views

Get all the users that are managed by a targeted manager

I have the following model: Table user: (id, name, direct_manager_id) Table customer: (id, name, managed_by_id) i.e. users can have another user as their direct manager, Customers can be managed ...
0
votes
1answer
24 views

MySQL InnoDB Deadlock For 2 simple insert queries

I have a deadlock for this two insert queries: insert into PlayerClub (modifiedBy, timeCreated, currentClubId, endingLevelPosition, nextClubId, account_id) values (0, '2014-12-23 15:47:11.596', 180, ...
0
votes
1answer
18 views

#1025 - Error on rename of table errno: 150 : Table was deleted while tried to assign foreign key

When I tried to assign foreign key to a table named mydb.table1 it was deleted from my database, I could not understand the reason and tried to move on. For this tried to create same table with create ...
0
votes
1answer
25 views

Cannot start MySQL service on linux RHEL when pointing datadir to mounted ecryptfs folder

I moved the data directory for MySQL to an ecryptfs encrypted folder. When I run service mysqld start as root, the service will not start. [Warning] Can't create test file ...
1
vote
1answer
20 views

Differences between Authentication Types in MySQL Users and Privileges

I noticed that when I create a new account, that there are three different Authentication Typesavailable to choose from in MySQL Users and Privilegeswindow. What I am wondering is: What is the ...
1
vote
2answers
80 views

Is there a more efficient way to set up this table

I'm looking to add a new feature in our production site that will show users 25 items they most recently viewed. I already record every view into various tables based on the item type, but querying ...
0
votes
2answers
41 views

Minimizing database size (Many small tables)

Our database is interesting in that we have a large amount of tables that take up a correspondingly large amount of space, but when we do a MySQL dump of said database, it is surprisingly small. ...
0
votes
1answer
35 views

Pagination, check number of selected records

I am working on pagination for a complex join query and unfortunately I am not sure what's the best way to go... Right now I am thinking about the following solution. Imagine that SELECT id... is the ...
2
votes
1answer
23 views

Grant permissions on views, deny select on tables

I have a MySQL user and I want it to view ONLY the views I want and not any other table in the database. I've granted this user permissions only on certain views as following: GRANT SHOW VIEW ON ...
0
votes
1answer
19 views

Best way to create materialized view in mysql

I am using mysql 5.6, I am not being able to create materialized view here like oracle. I got one or two solution like flexview and all... Can anybody tell me best way to create materialized view in ...
1
vote
1answer
21 views
+100

Converting Heap to MyISAM issue

At work we have a problem that has now occurred more then once. Problem is that query is in state of converting HEAP to MyISAM and it paralyzes our server( query in this state is not able to kill ...
-3
votes
0answers
43 views

SELECT returning NULL always [on hold]

I have small MySQL database with table called user_information. The columns in that table are: uid, firstname, lastname,age,gender and mail. I want to get all information about user with ID.So the ...
0
votes
0answers
25 views

Mysql error code 1452 [on hold]

I'm trying to create a database that will keep information about users. Here is the strucure; I have 3 tables 1. is the users which keeps uid and login info(username and password) 2. is the ...
0
votes
1answer
15 views

Mysql Master-Master Replication Error

Configured Master-Master Replication But both servers slave shows the below error !! Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ...
0
votes
1answer
31 views

How to update a huge MySQL table from a text file

I have a huge MySQL table with 1.3 TB data with InnoDB engine format. Now I have a text file containing updated values of 2.2 GB of records in the 1.3 TB of data. How do I proceed ? I am a newbie ...
0
votes
0answers
10 views

JDBC4/SQL or Hibernate/ORM?

I have an upcoming thesis project that may be used by the school itself if the system proves to be good. It is a web application (Struts2) for an Online Teacher's Performance Evaluation System. The ...
0
votes
1answer
22 views

optimizing a select query of 1.5 million entry

I have the following query: SELECT s0_.id, s0_.lowresimageurl FROM app_instagram_shop_picture s0_ FORCE INDEX ( idx_deleted_shopId ) LEFT JOIN app_instagram_shop s1_ ON s0_.shop_id = s1_.id AND ( ...
0
votes
1answer
27 views

Inserting a lot of big numbers into a mysql database

The tutorials online about inserting images and other binary data into a database have you put it in a character buffer and use mysql_real_escape_string() on it. The thing is, characters are 1 byte. ...
0
votes
0answers
10 views

How can I update the amount on parentid

I'm using MySQL database,This is the first time that i handle this kind of project the Multi-Level Marketing.I am having problem in updating the amount of parentid if he gets paired means he has left ...
0
votes
0answers
8 views

Best mysql database structure for this data

I need to create a MySQL database that can store the following data for many users: General settings (for each user) 10 url's. 10 words of 20 letters for. ...and more fields like these. Sentences ...
2
votes
1answer
36 views

Sorting by two columns conditionally

Column a has category ids, column b has set orders: +-------------+-----------+ | category_id | set_order | +-------------+-----------+ | 80 | null | | 81 | null | | ...
-1
votes
1answer
21 views

Problem in adding foreign key

I'm having an error while adding a foreign key constrain to my database. In my database, I'm having a table named user, student, staff, complaint and review. The table user contains fields such as ...
1
vote
1answer
33 views

database design for simple comment

I have a following given scenario. A user can have zero or more item. A user can comment on the item. (Just simple comment listing with name of people who comment, no need hierarchical structure for ...
0
votes
2answers
14 views

SQL Query Help to get Quiz statistics

I'm coding a quiz web application and i need help. I've got three tables Nicknames : |USER_ID|NICKNAME| that stores USER_ID(auto increment) and NICKNAME registered to my system. Questions : ...