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 seve
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
potable tablespaces.
I suggest having a good hard look at pt-online-schema-change or
whatsitcalled.
Jay Ess 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 t
bably got
'sort' because 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 18:47, schrieb Johan De Meersman:
- Original Message -
From: "nixofortune"
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
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
resta
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 accur
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 --process
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
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" wrote:
> You might run out of file desciptors. Check you
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" wrote:
> Hi
>
> I am facing a strange problem, from the last few days in one of my projects
> in production, i find that one of my table f
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 wrote:
> Hello Egor,
>
>
> On 4/20/2012 7:17 AM, nixofortune wr
as we 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 wrote:
>
>
> Am 20.04.2012 13:44, schrieb nixofortune:
> > Thanks,
> > So the actions should be:
> > 1. Stop sl
b_name add PRIMARY KEY (recipient_id);
That should fix it.
Many thanks,
Egor
On 20 April 2012 12:51, shawn green wrote:
> Hello Egor,
>
>
> On 4/20/2012 7:17 AM, nixofortune wrote:
>
>> Hi guys,
>> I'm am experiencing strange behaviour with the replication
to to start from zero ground?
Many thanks
On 20 April 2012 12:31, Reindl Harald wrote:
>
>
> Am 20.04.2012 13:17, schrieb nixofortune:
> > So far I found :
> > binlog_format different:
> > Masters (MIXED)
> > Slaves (STATEMENT)
> >
> > sync_binlo
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)
pdate (or row by row?)
>
> - Original Message - From: "nixofortune" <
> nixofort...@googlemail.com>
>
> To:
> Sent: Wednesday, September 22, 2010 5:29 PM
>
> Subject: Swap data in columns
>
>
> Hi all.
>>
>> Sorry for very simple question
-+
> | id | column1 | column2 |
> ++-+-+
> | 1 | z | a |
> | 2 | y | b |
> | 3 | x | c |
> | 4 | w | d |
> | 5 | v | e |
> ++-+-+
> 5 rows in set (0.00 sec)
>
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
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.
Exa
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, REPLIC
21 matches
Mail list logo
