0
votes
0answers
12 views

Can we use mysql database for crore of data available in tables? Which database is better to use for huge data and more number of joins are used? [on hold]

Kindly give answer with explanation? I used mysql database for 2 crores of data present in mysql table. And my application needs more analysis on this data with join queries and string matches. How ...
1
vote
2answers
28 views

Give every user 3 default 'bookmark' entries

I've got a table users and a table bookmarks. The table bookmarks obviously contains pages the user wants easy access too. But, there's a new requirement now: every user gets 3 unmutable bookmarks. ...
1
vote
0answers
29 views

call id of a table to a new table and insert values to this new table [migrated]

I have recently started to write server scripts. Although the question may seem to be very basic but i am not able to get a solution. I have two tables one is PRODUCTS and the other is DEALS. ...
0
votes
1answer
55 views

Inserting data into multiple tables

For my system, students are required to create a user account by completing a registration form (personal, contact and course details; also username and password). I need to collect registration data ...
1
vote
1answer
73 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
26 views

Large NOT IN Statement vs Creating/Populating Temp Table

I have a large daily data feed which can contain up to around 5,000 ID's. I need to delete all pre-existing records in the DB that are not referenced in the new feed. Should I create a temporary table ...
0
votes
1answer
21 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
0answers
29 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 ...
1
vote
1answer
19 views

How to create trigger with NOT FOR REPLICATION

I tried adding "NOT FOR REPLICATION " in many parts in the below code but ended up in the below code. I searched a lot for an example where I can see how its done with a trigger. Can any one show me ...
1
vote
2answers
36 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 ...
0
votes
0answers
23 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
1answer
38 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: ...
1
vote
3answers
67 views

Mysql to Oracle communication

I have a website running with php and mysql on Centos(Amazon instance). The newly brought ERP(to be integrated with existing system) uses Oracle as db(located on a separate Windows Server). The orders ...
3
votes
1answer
35 views

“zip” a mySQL (phpMyAdmin) database [duplicate]

I've created a large database on my local WAMP webserver. I would like to send that database with all tables and table data to another computer. Is this possible? mySQL ver: 5.5.15 PHP ver: ...
0
votes
1answer
63 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 , ...
1
vote
0answers
83 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, ...
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
1answer
77 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
2answers
83 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
0answers
35 views

Every 30 minutes mysql stuck for 20-30 seconds [closed]

I have very strong mysql 5.5 computer (Windows server / AWS) . My CPU ~8% ,Disk IO - 0.5% , ~Connection - 800 binlog_format=MIXED, innodb_read_io_threads=64, innodb_write_io_threads=64, ...
0
votes
1answer
123 views

How should I config the my.ini(or my.cnf) file for mysql?

Thanks for taking your time to look at my question, and I hope that you can help me with this. I have a Windows Server 2012 server, it has: Memory : 3840MB Ram Processor: Intel(R) Xeon(R) CPU ...
0
votes
1answer
38 views

Immigrate to file-per-table mode in MySQL

I have 20 MySQL databases and in each there are about 20 tables. All the data is saved in a file called ibData1. Now I discovered about the file per table mode but if I change the value in the my.ini ...
0
votes
0answers
24 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 ...
2
votes
1answer
108 views

Is there any way MySQL can list relationship cardinality between two entities?

I am working on the project where I have to analyse the MySQL schema. As a part of schema information, I want to list down relationship cardinality between different relations. Does MySQL stores ...
0
votes
2answers
79 views

Recovering mysql innodb table from table.ibd backup file

Just practising DB disaster recovery. As per our back up policy, we do complete disk image back ups every half an hour (on our slave server). Now for a scenario, where some how a table has been ...
0
votes
1answer
101 views

how many 'text' column a table could have in mysql? I have this error “Row size too large (> 8126).”

I'm working on a application which is kinda complex to explain how it works. But this is the situation I'm in, ------------------------------------------------------------------------------ FIELD1 ...
0
votes
0answers
54 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 ...
1
vote
5answers
268 views

How to determine why a MySQL server has become slow and requests sometimes time out?

I'm working on my first project that makes heavy use of a MySQL database and am struggling to understand performance issues I'm having. Most of the time, responses are returned quickly from the ...
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
2answers
67 views

How to store a database table in multiple disks with assigned ratio?

I am going to deploy database tables to multiple disks. My database layout would be like following example: There are 3 tables (Customer, Order, Product) and 4 disks (disk_A, B, C, D). Customer: 5% ...
1
vote
2answers
704 views

Optimize a MySQL Database using MySQL Workbench

I actually have a few issues. First, I found this information about optimizing: MySQL OPTIMIZE all tables? The problem is, I don't seem to have a mysqlcheck program anywhere. I'm using MySQL ...
1
vote
2answers
565 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 ...
4
votes
2answers
961 views

mysql multi threading for a single query

I have big db of size 8GB and having 9 million contacts in this db. When we try to retrieve all contacts, it takes nearly 1 or 2 hour (in some cases result in timeout) to retreive all contacts for the ...
0
votes
0answers
9 views

Multiple requests shut down MySQL [duplicate]

I have some problems with my MySQL database. I configured a server with the database and other services (apache, php) and put run multiple applications. There are two problems: Every day at the ...
0
votes
2answers
144 views

Getting table definitions on the command line in MySQL [closed]

I am new to MySQL. I am trying to get table definitions from the database server (4.0.26). I tried below steps to get information, running cmd as an administrator: c:\> cd mysql\bin\ ...
0
votes
0answers
46 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
2answers
45 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 ...
1
vote
0answers
388 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 ...
3
votes
1answer
83 views

How to upgrade MySQL (5.5) production DB to 5.6 with minimal downtime

Our existing Database size around 200GB. We want to use consistent, parallel backups methods. For testing, I migrated my Development DB from 5.5 to 5.6 by running mysqldump with option ...
-1
votes
1answer
30 views

prepare stmt is not working

set @sqlt = concat("select", @rowname_date," from syslog_data.syslogs_index_1 "); prepare stmt from @sqlt; execute stmt; deallocate prepare stmt; gives me a eeror 1064 in the prepare statement? Any ...
0
votes
2answers
66 views

moving database from old disk to new disk

I need to move a database from an old disk which is no longer bootable to a new bootable disk. I have been able to mount the old disk. Now I need to move the database from there to a new disk. Can ...
0
votes
0answers
170 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 ...
1
vote
3answers
1k views

Proper MySQL database maintenance

I hope this isn't too broad of a question. I'm certain it'll be able to help me and any future dba noobs that stumble upon it. I'm a systems admin that got put into the roll of DBA (because I helped ...
0
votes
3answers
295 views

MySQL Large DELETE with JOINs

I have a large table players with ~20MM rows which joins to a table stats with ~300MM rows, among others (photos, ...). I want to DELETE all records for players that were born_on before 1950. I ...
4
votes
2answers
338 views

Why monitor bytes sent and received on mysql

I want to know why we should monitor bytes sent and received on mysql ? I hope I have not asked a vague question. Thanks.
0
votes
1answer
262 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
1k views

ERROR 13 (HY000) When Creating Database

I'm trying to create a database and when I type in CREATE DATABASE epik; I get the error ERROR 13 (HY000): Can't get stat of './epik' (Errcode: 13) I am running kubuntu 13.04 with mysql 5.5.31.
0
votes
0answers
279 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 ...
0
votes
1answer
95 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 ...
0
votes
1answer
1k views

Plugin 'FEDERATED' is disabled

Im trying to start Mysql using easyPHP : the response is an alert window to a log file. The main error is <-- Plugin 'FEDERATED' is disabled -->. Through my research on internet i found that the ...