mysql-5 : Version of MySQL Starting with MySQL 5.0
0
votes
0answers
42 views
Mysql query is very slow
I am developing a website like any other social networking site using mysql.
I wish it give people suggestion to my users, and I have implemented this functionality in my application, but It is ...
0
votes
0answers
56 views
UPDATE / SELECT incredibly slow in MySQL InnoDB
I have 1 table with 2.5 billion records(2.5 Cr.) and I am trying to get count of records based on indexed column. it takes 115 seconds to execute same.
Query : Select count(1) from table1 where ...
0
votes
0answers
23 views
MySQL becomes unresponsive because user reached its OS quota
In CentOS 6.3/MySQL 5.1.67 I had an user that runs wordpress reaching its OS space quota (mostly files, the DB is less than 100Mb). When the user tried to create a post it triggered an [ERROR] ...
-4
votes
1answer
55 views
where can I get mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz? [closed]
I need mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz, but I can not find them anywhere, who can give me a link to find them, thank you very much!!!
0
votes
0answers
19 views
Maximum storage limit for mysql using Windows 7 ,32 bit NTFS system? [duplicate]
I would like to know the maximum size limit for mysql server running in windows 7,32 bit NTFS System.I have 8 tables
1
vote
1answer
67 views
Is it okay to have different lower_case_table_names value on master and slave?
I have a OSX MySQL master with lower_case_table_names set to 2. I have just setup a Linux MySQL slave with lower_case_table_names=1.
I haven't started replication on the slave, but everything looks ...
0
votes
0answers
41 views
Returning multiple resultset from the same table
i am working with mysql procedure. final result set i have got in to one table.
now i need to return for each set i need to return the value.
example:
like this is contents in my the table.
i need ...
1
vote
2answers
55 views
Should master and slave have same mysql version?
I have a master database running mysql 5.5.11, and I am planning to setup a new slave. I am planning to use the 5.5.30 as it is the latest version. For setting up new slave, I am copying files from ...
0
votes
2answers
59 views
Indexing is not working
Following is the table and index information for which I have the queries at the end.
Create Table: CREATE TABLE `food` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`page_no` int(11) DEFAULT ...
0
votes
2answers
90 views
Autosync master and slave when master goes offline
I have a master slave setup using MySQL 5.0.
I have very frequent writes to the master and slave is used only for backup purpose (no explicit writes).
In my current configuration, the slave database ...
1
vote
1answer
114 views
Why would mysql “show global status” query be taking 15 minutes?
I'm reviewing the slow log, and on one of my slaves the average time for SHOW GLOBAL STATUS is 914s.
Any idea how to determine the cause of this?
0
votes
1answer
121 views
mysql duplicate entry error 1062 when restoring backup
Sorry, I seen similar threads but I still couldn't find it addressing my issue plus, I needed some more info on this.
Requirement: To create an exact replica 'db4' of an existing DB 'db3'.
Procedure ...
1
vote
1answer
212 views
How soon after updating expire_logs_days param and restarting sql will old binlogs get deleted?
MySQL 5.1.x | InnoDB | Windows
My mysql data directory is starting to fill up with bin logs.
I currently have the following settings configured in my windows mysql server:
[mysqld]
log-bin
...
1
vote
1answer
200 views
Where is the MySQL variable - innodb_flush_method?
I would like to tweak the value of innodb_flush_method to find out its performance impact on a database server. That variable is listed when I run the command SHOW VARIABLES.
But I could not find it ...
0
votes
2answers
60 views
MySQL query slow even with indexes
Structure of my table
mysql> show create table t_group_tag_relation\G
*************************** 1. row ***************************
Table: t_group_tag_relation
Create Table: CREATE TABLE ...
1
vote
2answers
414 views
MySQL not responding, Writing to net status
I just had to reboot MySQL to regain access to some of my website. It had under 300MB of RAM used. Another product was working fine though, accessing it's own tables which are InnoDB.
Here's the show ...
1
vote
1answer
170 views
How to write signal function in MySQL that can be called from Triggers and Stored Functions?
In my Database I have a table: Employee with recursive association, an employee can be boss of other employee.
The Table Description:
mysql> DESC Employee;
...
1
vote
1answer
207 views
How to know the current log sequence number in 5.0.X
I would like to test the optimal value for iblog files on my mysql which is 5.0.77
I found the below procedure in mysqlperformance blog:
...
0
votes
0answers
107 views
how to improve performance of my query it was taking more than one hour in my environment
How can I improve performance of below query? It was running more than one hour to execute in my production environment. Query plan:
mysql> explain
SELECT transaction_detail.trans_id,
...
0
votes
1answer
54 views
How to removing or reduce the size of redo logs in MySQL cluster
Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we ...
0
votes
2answers
171 views
Insert ignore with conditional
I need to insert some records which might have duplicates. Column to overwrite/skip is mytable.email and mytable.fooFlag should be 1.
I came up with something like this:
INSERT IGNORE INTO mytable ...
1
vote
1answer
341 views
Retrieve double data type value in non exponential form
Is it possible to retrieve non-exponential value in double data type column? After the width of the column is increased to 15 it shows the values in exponential form.
Now I get the following:
...
2
votes
3answers
399 views
MySQL optimization - year column grouping - using temporary table, filesort
I have a transactions table which is having 600,000 records, I need to list the count for the dashboard on financial year basis. The table used is MyISAM. I tried adding index for the transaction date ...
0
votes
1answer
293 views
How can I enable my-huge file on windows server?
I installed Windows Server 2008 and MySQL 5.5.
Now I need configure MySQL for huge InnoDB tables and a lot of connections.
I see that on my Windows Server, there is a my-huge file(configs files that ...
1
vote
1answer
145 views
Mysql 5.0 on Windows 2008
I have a problem with MySQL on Windows Server 2008 x64.
This is the first time I've installed MySQL 5.5 with performance problems. I decided to go back to the older version that worked well with ...
1
vote
1answer
186 views
MySQL Master-Slave Replication Cross Database
I am setting up Replication for cross Database as i have set 2 variables in Slave' s my.cnf as replicate-do-db=database_name and
Replicate-wild-do-table=database_name.% ,But i am not able to get ...
2
votes
1answer
716 views
Change existing datadir path in mysql
I want to change the datadir path in the my.ini file.
The existing datadir path is C:/ProgramData/MySQL/MySQL Server 5.1/Data/
The size of my C: drive is 30GB and the MySQL data folder is occupying ...
2
votes
1answer
422 views
Migrating MySQL 5.0 to 5.5 - simple databases
I have a LAMP server on my LAN running a very old version of RedHat with MySQL 5.0, and I'm trying to migrate it to Ubuntu 12.04 to update it.
I know the advice is to migrate MySQL 5.0 to 5.1 then ...
1
vote
1answer
279 views
procedure is not executing
Problem I am getting when I execute this proc:
call `sp_frm4_px_prc_calc`();
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version ...
4
votes
1answer
745 views
Setting up MySQL Cluster on Two Systems
I am attempting to setup a MySQL Cluster.
I have the folllowing setup
one management node
two data nodes
another machine on which two more nodes reside
Below is the config.ini file:
[ndbd ...
2
votes
2answers
137 views
MySQL - How much physical space will be reduced by changing the column type?
Lets say I have the following table:
CREATE TABLE `my_table` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`relationship_status` varchar(48) CHARACTER SET utf8 COLLATE ...
1
vote
1answer
752 views
How to log logon logoff and user activity on mySQL server for audit?
My boss wants to have some kind of log on the server running mysql which would log user activity.
Kind of like:
User blah logged in
User blah ran some query
User blah logedd off
User asdf ...
2
votes
2answers
87 views
How to see what was executed in the database via binlogs for specific date?
I am trying figure out how to "query" binlogs to see what was exectued in the database for a specific date. For example, if I execute mysqlbinlog binlog then the thing just runs forever and it is had ...
2
votes
1answer
227 views
query generate the information one column in two columns in one query
I have a question related with a query in sql. I have the next table:
id name
1 name1
2 country1
3 name2
4 country2
I need to call the results so:
...
3
votes
1answer
909 views
Deleting bin logs in replication environment
I have a question about deleting binary logs in the replication environment:
We have an environment with 1 master and 2 slaves (running mysql 5.5). Sometimes, we run into a space issues during heavy ...
3
votes
1answer
1k views
PostgreSQL 9.1 vs MySQL 5.6 with InnoDB ? Which is better for scaling?
PostgreSQL 9.1 vs MySQL 5.6 with InnoDB. I do know that PostgreSQL offers better SQL features.
I am currently using MySQL 5.6 lab release (the one with InnoDb full text search feature)(not in ...
5
votes
3answers
995 views
Maximum table size for MySQL database server running on Windows (NTFS) Table type InnoDB
I need to design database to store information contained in millions of log files generated by devices on trial on network.
I have designed 5 different tables to store log file information. But, as ...
1
vote
1answer
255 views
decreased performance of stored procedure when migrated from mysql server 5.0 to 5.5
i recently testing the move of our db from one server to another.
as part of this process i copied all the data to the new db and started testing it.
as a comparison i run a store procedure whose ...
1
vote
0answers
138 views
How to speed up this query
MySQL doesn't have nearest neighbor search so. So I try to come up with a "distance" that's reasonable so the number of returned query is around 20-200. That way innodb doesn't have to compute ...
1
vote
1answer
234 views
Change in datatype?
I have a table on which rows are inserted on hourly basis. The row contains id, installation, product_id and hit_allowed. all of them were mediumint in the beginning. but few days back id reached it ...
1
vote
1answer
512 views
Error in login in with root user in new mysql server
I've installed a MySQL server in CentOS 6.2 machine
+-------------------------+---------------------+
| Variable_name | Value |
...
2
votes
2answers
510 views
Can we assign mysql Key_buffer_size value for particular table?
In some documents I found that we can assign key_buffer_size to myisam table. This also includes the following steps:
SET GLOBAL myisam_table.key_buffer_size = 4194304;
CACHE INDEX test.myisam_table ...
1
vote
1answer
101 views
Help Optimizing Query
For the following table structure in MySQL 5.1.49:
CREATE TABLE `leads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`institution_id` int(10) unsigned NOT NULL,
`lender_id` int(10) unsigned ...
3
votes
0answers
97 views
MySQL 1264 warning from libmysql
I'm using the libmysql.dll library to connect to my database from a 3rd party application (metatrader).
I managed to connect and things are going almost fine. I use mysql_real_connect and ...
1
vote
0answers
378 views
Tables don't exist after MySQL restart
I recently made changes to optimize performance for InnoDB engine-based DB and soon after when restarting I encounter into the following strange behavior:
I have some tables with data in them
I made ...
0
votes
0answers
182 views
Mysql 5.5 hangs from time to time with ubuntu 12.04
I am using Mysql 5.5 from ubuntu 12.04 64 Bits with both MyIsam and Innodb engines : From time to time, when I do some 'big' requests like dropping a database, altering a table, adding an index on a ...
1
vote
1answer
148 views
some InnoDB settings in My.cnf are messing up everything, why?
When I edit my.cnf in MySQL 5.0 in filemanager and add the following settings, I get logged out automatically from Kloxo and when I remove these line and restart server everything is ok then:
...
1
vote
1answer
287 views
For 768M RAM server is 617M allocation in my.cnf good or bad?
I have a write-intensive web app, and I bought a VDS with 768M RAM
Is this my.cnf good for my purposes?
I specified bulk_insert_buffer_size to 126M and some other parameters as below:
...
0
votes
1answer
267 views
Is there a way to skip errors in procedures and resuming procedure
When there is a unique key in a table (not PRIMARY KEY) and procedure is running, on duplicate key error the whole process will be halted. I want to resume on error and call the procedure again.
...
3
votes
1answer
221 views
why is mysql still writing data two hours after all transactions have stopped
I have a mysql server used mostly as data warehouse. It loads about 4-5GB of data per day (actual database size, not the size of the source data).
Lately, I noticed something peculiar. After I ...
