MySQL : Open-Source, Relational Database Management System
0
votes
0answers
4 views
Debugging error report percona 5.6
I'm running percona 5.6 on a new centos 6.4 server. Things seem to work OK. I personally only really use InnoDB tables for my databases, but only the standard 'mysql' table is in MyISAM format.
I ...
0
votes
1answer
17 views
XOR binary values greater than 64bit
I have a binary blob holding the results of a SHA256 hash that I XOR with a script generated SHA256 hash. For testing I am using the values usertokens and methodtoken for the test hashes.
hash1: ...
0
votes
0answers
36 views
SQL queries are very slow
I have noticed that my queries are getting slower.
Some update queries take about 48-50 seconds.
Here's how it looks:
[root@db-1 ~]# tail /var/lib/mysql/mysql-slow.log
# Time: 131113 17:09:48
# ...
0
votes
1answer
22 views
How to copy a table in a production server without WRITE lock and without writing to a file
I'm trying to copy a table in a production table. When I'm performing on InnoDB tables:
INSERT INTO new_table (SELECT * FROM table)
I have a write lock on table. Is it possible to avoid this lock? ...
1
vote
1answer
25 views
How to recover from two queries stuck in kill state causing all the database to not respond?
During a INSERT INTO new_table (f1, f2, ..., fn) (SELECT f1, f2, ..., fn FROM table) I clicked the new_table in php-myadmin which ran a simple SELECT * FROM new_table LIMIT 0, 30 which ofcourse ...
0
votes
2answers
20 views
MySQL Update Trigger that updates multiple columns from values in another table
I have a table PRODUCTS with columns id, name, sku, packaging_type, width, height, weight, case_count.
I want a trigger to fire when packaging_type is updated. packaging_type will be an integer ...
0
votes
1answer
18 views
Mysqld.exe memory usage
I am using mysql 5.6.14, For a long time i got large memory usage by mysqld.exe, i was trying many different solutions and my.ini settings to fix this up but didn't succeed, This is my config ...
1
vote
0answers
32 views
Help with Mysql with 100K+ Table
Hi im trying to develop a database design in which its gonna have 100K+ tables residing in it.
My major concern here is will Mysql be able to hold that much amount of tables with no performance ...
0
votes
1answer
14 views
MySQL: Error while reverse engineering database from a sql file
I'm trying to reverse engineer a DB in MySql with a sql file generated from an OpenOffice database. while trying to import and run the sql file, I get the following error:
ERROR: Line 1: syntax ...
0
votes
2answers
24 views
MySQL getting result using 3 Tables and case statements
I have 3 tables named person,person1, person2. All the 3 table has 2 columns name and phno. Now my requirement is, if i give any particular phno it has to show either yes or no
for the corresponding ...
0
votes
0answers
34 views
Database design to track inventory?
Would this be a good starting point for tracking inventory with several warehouses? If yes what is the best approach to sum quantity when displaying stock by warehouse/type/general?
mysql structure ...
0
votes
1answer
34 views
How to create a query that shows all different row data when joining with a link table?
Currently I am trying to create a HTML table that shows all users and if that user downloaded a certain file.
Tables
One for the users:
CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(8) NOT ...
2
votes
1answer
34 views
Implications of a second index on a timestamp field in a sequential table
I have a MySQL table of a few gigabytes with roughly ~100M rows. I store data sequentially, such that the timestamps increase as the ID also increases. Because ordering and filtering by the timestamp ...
1
vote
1answer
39 views
MySQL InnoDB issue not using indexes correctly [Percona 5.6]
I just installed Percona 5.6 on my new CentOS 6.4 server. It's a fast machine 32 core xenon, 72GB ram, 8x SAS RAID 10 setup. So far so good
My old server is a bit less powerful, and was running ...
1
vote
2answers
24 views
MySQL (InnoDB) UPDATE SET performance with value in WHERE AND clause
If an UPDATE query is performed where the values being SET are also part of the WHERE clause, in the form of an additional AND statement on the column being set's value, is there a significant ...
