Tagged Questions
1
vote
2answers
37 views
MySQL user without SUPER privilege
This may be a simple question and may not be the right place to ask but I couldn't find any useful information from Google. Here is my question.
When creating users in mysql using grant all ...
1
vote
2answers
605 views
MySql InnoDB tables are missing after restarting
I had a MySql database with a few InnoDB tables. After restarting the server, and starting MySql Server again, I connected to the MySql Server using MySql Workbench, and couldn't see the database at ...
0
votes
2answers
33 views
MySQL - HOWTO speed up slave replication on large database / Quickly spawn slave?
We have a large mysql database (about 100GB on disk) that we would like to spawn a slave for.
Our typical process for creating a slave is:
Create a slave server
Load in a mysql dump of the master
...
0
votes
2answers
88 views
Large RAM use after import database - ubuntu server
My new vps has 4 GB of RAM. Before importing database system use about 1,2 GB of RAM. When I import database, about 250 MB sql file, 25000 tables use of RAM goes to 97%. Htop showing 3302 mb in cache.
...
0
votes
2answers
52 views
Mysql 5.5.25 must be restarted to connect
We have MySQL v5.5.25 running on Windows Server 2008 R2. Occasionally people are unable to connect, and the only way we have found to fix this is to restart the mysql service. This happens every 2-3 ...
3
votes
1answer
1k views
Take individual MySQL database offline
MySQL does not have any SQL commands or internal mechanisms for
making an individual database unavailable / offline
moving an individual database
Thtis being the case, how can you take an ...
1
vote
1answer
89 views
Optimizing large MySQL SELECT WHERE IN clauses
How can the following SELECT WHERE IN case be optimized?
I have a table with over 100 million rows with only 3 columns. The primary key (col1) is a 127 varchar. I am performing a SELECT col1 WHERE ...
0
votes
1answer
22 views
How can I perform this database backup/sanitization task?
I have a 3-node MariaDB/Galera cluster. I need to do two things:
Back up the database regularly (multiple gigs in size) for a normal, in-case-everything-crashes-I-can-restore-from-this backup.
Have ...
0
votes
1answer
47 views
MySQL slave database wont start
I have a MySQL master slave configuration and the slave is not working anymore. When trying to stop and start again the slave db, I am getting this error:
140530 14:21:23 [Warning] Slave I/O: ...
0
votes
1answer
64 views
What is the strategy of query evaluation in DBMS when Limit is used in query?
I have following tables in database
post(post_id , user_id , post_text , parsed_text) ;
Comment(comment_id , post_id , user_id , comment_text) ;
friend(id , user_id , friend_id ) ;
group (id , ...
0
votes
1answer
79 views
Update table from calculated temporary table
I have two tables, one containing a set of user ID's, vote direction (-1 or 1) and ID of the object they voted on (casted votes table). In the other table, the object id, upvotes, downvotes and ...
0
votes
1answer
275 views
Table is marked as crashed and should be repaired
I have MySQL and Nagios installed Linux PC (Centos5.5)
I have wrote some script to fetch the data from Nagios to Mysql DB (Exactly fetch data in Table)
The data fetching working properly (confirmed ...
0
votes
1answer
97 views
InnoDB Failure of some kind
I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked.
InnoDB is listed under SHOW ENGINES;
Any idea ...
1
vote
0answers
92 views
Recover innodb database from ibdata1 and *.frm files only
I have a problem on my server.
I had a hard disk error on my server, and I restarted it. After that, I started wamp server software, but mysql services were not started.
I checked all mysql data, ...
1
vote
0answers
404 views
Analyzing MySQL crash due to corrupt InnoDB page. Failed page checksum
Lately we have been pestered by infrequent sporadic database crashes on one of our MySQL instances. Each time it is due to a failed page checksum.
It happens on a specific database but spans multiple ...
1
vote
0answers
158 views
Database instance keeps restarting
From the past few days, our MySQL database instance has crashed and had to be restarted a few times. My MySQL version is 5.1.57-log. The CPU and memory usage was way below 50% during the crash time. I ...
0
votes
0answers
51 views
Error Code: 1133. Can't find any matching row in the user table
Im reading O'Relly "Learning MySQL" and it says that you can create a user in MySQL by doing just this:
mysql> GRANT ALL ON *.* TO 'jill'@'%.invyhome.com' IDENTIFIED BY 'the_password';
Query OK, 0 ...
0
votes
0answers
28 views
How to skip already created table while importing dump file in MySql
Is there any way to skip already created tables while importing ? I am trying to import 2GB of database using command prompt but the operation is aborted by mistake. Now if i will do the import again ...
0
votes
0answers
27 views
I need a way to implement an incremental Backup/Recovery on mysql client
I need to be able to do a point-time recovery in mysql client from the mysql server. For example I need to Download only the information that have change since last backup. I can do that using log,but ...
0
votes
0answers
25 views
How to recover data in a MySQL DB?
Log file says:
Recently disk space on my VPS got filled up.
Now my DB looks corrupted, MySQL error log says:
140319 01:28:57 mysqld started
140319 1:28:57 InnoDB: Started; log sequence number 0 ...
0
votes
0answers
56 views
how to archive old entries from mysql on rds
I have an AWS RDS MySQL DB.
I have ec2 instances and an s3. What I would like to do is only retain 60days old data and archive the rest.
I'm still new at this so I'm not really sure what to do. What ...
0
votes
0answers
45 views
MySQL beginner in troubles
My MySQL knowledge isn't really good. However, I tried to move my websites media folder to an other location and afterwards wanted to update the links in my database:
UPDATE wp_posts
SET ...
0
votes
0answers
47 views
Best practices for ranking records in flexible way
Suppose we have 10000 records of any product.
User search on our website with his given criteria. so we output search results based on given criteria.
Now Admin want to rank products in search.
so ...
0
votes
0answers
171 views
Drupal database doesn't work after MySQL restart
I've installed Drupal 7x on my local XAMPP 1.8.3 Server. Everything went fine but after adding some modules, changing the drupal theme and restarting the MySQL Server, the MySQL Server is dropping ...
0
votes
0answers
286 views
How much RAM for a large database on a dedicated MySQL InnoDB server?
Hereunder my hardware config:
CPU: 1x Intel Xeon X3470 Quad core @ 2.93GHz
RAM: 4x 8GB DDR3
Disks: 2 x SATA 320GB for the system & 4 x SAS 300GB for the DB
I've upgraded from 12Gb to 32Gb and ...
