You might want to comment
bind-address= 127.0.0.1
in your my.cnf and restart mysql server.
On 12/10/13 10:49, Jørn Dahl-Stamnes wrote:
Hello,
I got a strange problem related to a production server. It has been working OK
for months, but yesterday it start to fail. There are
Hi guys,
Did you have any experience running MyLSQ or in my case MariaDB 5.5.31
on FreeBSD on top of zfs?
We are using Samsung Pro 840 SSD drives and experiencing temporary stalls.
Our workload very much skewed towards inserts into big InnoDB tables
(70-100Gig) the dataset overall 1.5T.
I have
of this being big enough: myisam_sort_buffer_size = 526M
-Original Message-
From: nixofortune [mailto:nixofort...@gmail.com]
Sent: Monday, June 24, 2013 12:35 PM
To: mysql@lists.mysql.com
Subject: Re: space gone after MyISAM REPAIR TABLE
On 24/06/13 19:57, Reindl Harald wrote:
Am 24.06.2013
...@netrogenic.com wrote:
On 2013-06-26 18:31, nixofortune wrote:
What would be the best way to convert BIG MyISAM table into InnoDB?
We do not
have SLAVE.
I would do it on another computer. Then copy the table to the server
and then add the data that has been added from the original table
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165 Gig to 70 Gig. I
understand that during repair process MySQL creates temp file and remove
it after the job done. Or removal process executes on the server
On 24/06/13 19:57, Reindl Harald wrote:
Am 24.06.2013 18:47, schrieb Johan De Meersman:
- Original Message -
From: nixofortune nixofort...@gmail.com
Hi guys,
any suggestions? I just repaired 90G MyISAM table with REPAIR TABLE
command. the space on the hard drive gone down from 165
Hi guys,
I'm trying to use pt-query-digest on one of our Prod servers.
The problem our slow log is disabled, no tcpdump is installed and I
decided to use --processlist parameter which I never tried before.
pt-query-digest version 2.2.2
I run to connect to remote node:
pt-query-digest
Hi Claudio,
Thanks for reply. Great. I was sure you can't enable slow log
dynamically on 5.0 and 5.1.
That solves my issue for 5.1 at least.
Many thanks,
Igor
On 06/06/13 13:06, Claudio Nanni wrote:
Hi,
First of all I discourage you to use --processlist, I don't think it
is enough an
Hello everybody.
I'm trying to create a backup of mysql database:
mysqldump --all-databases --routines --master-data=2 all_databases_`date
+'%y%m%d-%H%M'`.sql
It looks like backup has been created but I've got this Warning:
Warning: mysqldump: ignoring option '--databases' due to invalid value
You might run out of file desciptors. Check your open file limits, open
table limits vars and corresponding syatus values
On 8 May 2012 15:05, abhishek jain abhishek.netj...@gmail.com wrote:
Hi
I am facing a strange problem, from the last few days in one of my projects
in production, i find
Few more things. You can't have a deadlock on Mylsam table. You can check
status of your tables in use with: SHOW OPEN TABLES WHERE IN_USE !=0 you
might check mysqld error log ad well
On 8 May 2012 18:42, nixofortune nixofort...@gmail.com wrote:
You might run out of file desciptors. Check your
Hi guys,
I'm am experiencing strange behaviour with the replication.
Our replication Setup looks like this:
Master1(5.1.46-log)
=Master2(5.1.46-log)
/ |\
Slave1(5.1.46-log) Slave2(5.1.52) Slave3(5.1.52)
from zero ground?
Many thanks
On 20 April 2012 12:31, Reindl Harald h.rei...@thelounge.net wrote:
Am 20.04.2012 13:17, schrieb nixofortune:
So far I found :
binlog_format different:
Masters (MIXED)
Slaves (STATEMENT)
sync_binlog different on one of the slaves: 1024 against 0
PRIMARY KEY (recipient_id);
That should fix it.
Many thanks,
Egor
On 20 April 2012 12:51, shawn green shawn.l.gr...@oracle.com wrote:
Hello Egor,
On 4/20/2012 7:17 AM, nixofortune wrote:
Hi guys,
I'm am experiencing strange behaviour with the replication.
Our replication Setup looks
tried to fix the errors by skipping
or any other ways, now it solid for 2 month with no major issued.
Thanks,
Egor
On 20 April 2012 13:09, Reindl Harald h.rei...@thelounge.net wrote:
Am 20.04.2012 13:44, schrieb nixofortune:
Thanks,
So the actions should be:
1. Stop slaves
2. On Slaves: SET
Hi Shaw,
I have two more question here.
1. Why those rows hasn't been deleted on slaves?
2. Why no slow logs entries were created?
Many thanks for your time and effort.
Egor
On 20 April 2012 12:51, shawn green shawn.l.gr...@oracle.com wrote:
Hello Egor,
On 4/20/2012 7:17 AM, nixofortune
by row?)
- Original Message - From: nixofortune
nixofort...@googlemail.com
To: mysql@lists.mysql.com
Sent: Wednesday, September 22, 2010 5:29 PM
Subject: Swap data in columns
Hi all.
Sorry for very simple question, just can't figure out the solution.
I need to swap data
Hi all.
Sorry for very simple question, just can't figure out the solution.
I need to swap data in column1 with data in column2.
++-+-+
| id | column1 | column2 |
++-+-+
| 1 | a | z |
| 2 | b | y |
| 3 | c | x |
| 4
:
rolandologicworxredwa...@logicworks.nethttp://www.linkedin.com/in/rolandoedwards
-Original Message-
From: nixofortune [mailto:nixofort...@googlemail.com
nixofort...@googlemail.com]
Sent: Wednesday, September 22, 2010 12:30 PM
To: mysql@lists.mysql.com
Subject: Swap data in columns
Hi ALL,
I just start using Workbench 5.2.26 CE and this is a problem I have.
When I try to run a query with a case statement, columns with datetime Type
shown as BLOB in output window.
To see the output data I have to right click inside of the cell, choose
Open Value in Viewer and see text.
Hi ALL,
You will find all the details you need to set up debian-sys-maint account
under /etc/mysql/debian.cnf
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE
TEMPORARY TABLES, LOCK TABLES, EXECUTE,
21 matches
Mail list logo