* Rajeev Prasad rp.ne...@yahoo.com [2014-09-01 17:55]:
I have a column in a table which is epoch time including milliseconds.
e.g. = 1409304102153
now i want to display all fields in the table but this field as: 2014-8-29
Fri 09:21:42: GMT (whatever comes in )
and i am
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
+--+--+--+--+
| File
On 8/29/2014 5:11 PM, wagnerbianchi.com wrote:
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
It was not, I reconfigured and restarted mysql and...
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
after a more complex transaction;
There's a duplicate key on the audit table, 18699. Delete it and restart
slave (start slave). Check slave status again, might be more rows in there
duplicated.
You might want to compare the row to master to ensure it's a duplicate
before deleting from slave.
On Aug 30, 2014 7:52 AM, william
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously ) global var, below
+--+--+--+--+
|
Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you
check what the application is doing, understand *why* the application is
violating the PK of the table information_server.audit, repair the possible
application problem and the, reconfigure the replication.
It seems that
On 30/08/14 09:39, william drescher wrote:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on
Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
Master:
On 8/29/2014 7:40 PM, Suresh Kuna wrote:
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
mysql show global variables like 'log_bin%';
+-+---+
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position,
and restarted the slave.
Now all works fine and I am much better equipped next time to
debug the loss of the link.
When is the Last Error data deleted from the show slave
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next time to debug the
loss of the link.
When is the
On 8/30/2014 12:53 PM, Jose Julian Buda wrote:
On 30/08/14 12:56, william drescher wrote:
Thanks for pointing out the importance of the last error
I resynced the slave to the master, reset the master position, and
restarted the slave.
Now all works fine and I am much better equipped next
Geetanjali,
There is a difference between next-key locking, gap locking and locking
reads.
Next-key locking and gap-locking are used with normal Selects statement in
Innodb, whereas locking reads wont release a lock on the whole column until
transaction completed, and not just selected values.
Could you please answer these questions also. What does data_free field
from SHOW TABLE STATUS shows?
When should we run optimize table for innodb tables?
I read various blogs. They said data_free shows free space inside the
innodb tables. But after doing *optimize table*, the value inside
On 08/29/2014 08:15 AM, geetanjali mehra wrote:
But after doing *optimize table*, the value inside
data_free is still the same. If there is no change in the value of
data_free, then what *optimize table* does here?
Without seeing actual values I can only give an educated
guess:
* If you are
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Am I the only one worried about that line, then?
--
Unhappiness is discouraged and will be corrected with kitten pictures.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On 8/29/2014 5:51 AM, Johan De Meersman wrote:
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Am I the only one worried about that line, then?
yes.
I welcome help from anyone willing. Expertise and willingness
both are important.
--bill
--
MySQL General Mailing
Whilst there are a few possibilities, check on the master that your binary
logs are being written to. Another possible reason could be filtering.
On 29 Aug 2014 21:36, william drescher will...@techservsys.com wrote:
Replication novice
I have a master server at the office and a replication
Hello guys, some points to check here:
1-) Is the master server configured with sync_binlog=1 ?
2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading
events from master, is the Exec_Master_Log_Pos incrementing or not?
3-) Why are you reconfiguring all the replication just
You can paste the show slave status\G here for us to review and on Master,
show global variables like 'log-bin%'; show master status ( 3 to 4 times
continuously )
On Fri, Aug 29, 2014 at 5:11 PM, wagnerbianchi.com m...@wagnerbianchi.com
wrote:
Hello guys, some points to check here:
1-) Is
Thanks for your reply.
I read those docs. Still my doubt is at the same stage. Please clarify the
same to me.
Should not other sessions be allowed to insert the rows beyond that
range.?
As far as I understand, Innodb brought the concept of next-key locks so as
to prevent phantom problem. So,
Hello Geetanjali,
On 8/26/2014 1:16 AM, geetanjali mehra wrote:
I want to understand how to tune innodb_max_purge_lag
http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_max_purge_lag
when history list length is high.
Could anyone explain me.
Best Regards,
Hello Geetanjali,
On 8/26/2014 1:11 AM, geetanjali mehra wrote:
Hello to all,
I want to know whether my innodb index is fragemented. Is it possible to
know?
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Specialist
Just like every other
On 8/26/2014 1:12 AM, geetanjali mehra wrote:
Hello to all,
In repeatable read isolation level, when we issue:
Select * from new where c1 between 12 and 17 for update;
this range will be locked by innodb by using next-key locks.
But, why is is preventing any other session to insert any
Am 22.08.2014 um 19:40 schrieb Lentes, Bernd:
i've been already reading the documentation the whole day, but still confused
and unsure what to do.
We have two databases which are important for our work. So both are stored
hourly. Now I recognized that each database has a mixture of
XTrabackup can handle both InnoDB and MyISAM in
a consistent way while minimizing lock time on
MyISAM tables ...
http://www.percona.com/doc/percona-xtrabackup/2.1/
--
Hartmut Holzgraefe, Principal Support Engineer (EMEA)
SkySQL - The MariaDB Company | http://www.skysql.com/
--
MySQL General
- Original Message -
From: Larry Martell larry.mart...@gmail.com
Subject: Stored procedure debuggers
Does anyone know of any debuggers for stored procs that run on Mac and/or
Linux?
Not aware of native ones, but I seem to remember that I managed to get the one
that occasionally
Hello Larry,
Subject: Stored procedure debuggers
Does anyone know of any debuggers for stored procs that run on Mac and/or
Linux?
Although all our tools are Windows tool, we have customers running Database
Workbench
under Wine without major problems.
We have a standalone debugger tool
Am 20.08.2014 um 16:39 schrieb Augori:
However, it's been 12 hours now and the thing is still restarting in safe
mode and I can't tell if it's making progress. The command I typed was
/usr/bin/mysqld_safe --skip-grant-tables
I think I forgot to include the ampersand () at the end which
Thanks! But if it's running in the background, how will I know when it has
completed?
On Wed, Aug 20, 2014 at 11:04 AM, Reindl Harald h.rei...@thelounge.net
wrote:
Am 20.08.2014 um 16:39 schrieb Augori:
However, it's been 12 hours now and the thing is still restarting in safe
mode and I
Well,
Try to start checking the IOPs vs Disc. Check your iowait and the cache
size.
Could you send a create table and the query for us?
Atenciosamente,
*Eduardo Fontinelle*
*Chief Technology Officer | G**erencianet*
Phone: +55 (31) 3603-0812
2014-08-20 12:04 GMT-03:00 Jim
Am 20.08.2014 um 18:55 schrieb Augori:
Thanks! But if it's running in the background, how will I know when it has
completed?
completed what?!
http://www.catb.org/esr/faqs/smart-questions.html#beprecise
what did you not understand in the paragraph below?
mysqld_safe has *nothing* to do
Jim/Jaime
What engine are you implementing?/
Qual mecanismo de MySQL que você está implementando?
Saludos desde Sud America
Martín
Date: Wed, 20 Aug 2014 13:54:46 -0300
Subject: Re: inconsistent optimization
From: edua...@gerencianet.com.br
To: j...@lowcarbfriends.com
CC: mysql
innodb
On 8/20/2014 1:22 PM, Martin Gainty wrote:
Jim/Jaime
What engine are you implementing?/
Qual mecanismo de MySQL que você está implementando?
Saludos desde Sud America
Martín
Date: Wed, 20 Aug 2014 13:54:46 -0300
Subject: Re: inconsistent optimization
From: edua...@gerencianet.com.br
Hi Jim,
On 8/20/2014 11:04 AM, Jim wrote:
Without going into specific details on queries...
Using mysql 5.1 as provided with CentOS6, I've noticed some queries
providing what I can best explain as inconsistent optimization. The
database can be quieted to just controlled queries and at times
Hi Wybo,
On 8/20/2014 3:47 PM, Wybo wrote:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
phpMysqlAdmin. When I do that, the only host that appears is localhost.
However, when I browse
Yes, that worked - thank you very much!
On 2014-08-20 22:51, shawn l.green wrote:
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
Hi All,
when I use the bg command, it says
1 job already in background
and continues to run in the foreground.
On Wed, Aug 20, 2014 at 11:04 AM, Reindl Harald h.rei...@thelounge.net
wrote:
Am 20.08.2014 um 16:39 schrieb Augori:
However, it's been 12 hours now and the thing is still
Am 21.08.2014 um 01:05 schrieb Augori:
when I use the bg command, it says
1 job already in background
and continues to run in the foreground.
*bullshit* if it is running in foreground you can't enter
anything because your terminal would be blocked, the bg
command only works if you
Maybe it's because I'm accessing it through a C Panel SSH Shell that it
acts differently than you expected. It doesn't matter anyway… I was able
to exit the shell and regain control of my shell. I'm giving up on the
upgrade approach for now, so let's consider this conversation concluded.
On
Wouldn't you run mysql_upgrade *before* upgrading? (ie: copy new stuff
onto old DB, *then* mysql_upgrade *then* start running new software?)
So I went to google, and realised that I’d probably upgraded without
running mysql_upgrade. So I try..
[~] john@server% (872) mysql_upgrade -u root -p
- Original Message -
From: florent larose florent.lar...@hotmail.com
Subject: sql syntax error
near ''membres2' WHERE
[...]
FROM 'espace_membre2'.'membres2' WHERE
You were on the right path - mysql is wibbly about quotes. Either remove the
quotes entirely (
Hi,
Le 08/08/2014 17:48, Johan De Meersman a écrit :
As your code is french, I'll assume you're on Azerty; the backtick is Alt-Gr
plus the rightmost key (right next to return) on the middle row. Enjoy
spraining your fingers :-p
/johan
Alt-GR plus '7' for French keyboard layout ;)
I cannot author a UDF using MySQL. I use the MySQL provided udf_example.cc
and compile it using the following command:
sudo gcc -shared -fPIC -I /usr/include/mysql -o
/usr/lib/mysql/plugin/udf_example.so udf_example.cc
Next, I login to mysql, connect to my database, and author one of the
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber '2118806';
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber,
Il 24/07/14 11:57, Chris Knipe ha scritto:
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be
wrote:
- Original Message -
From: Chris Knipe sav...@savage.za.org
To: mysql@lists.mysql.com
Sent: Thursday, 24 July, 2014 11:17:50 AM
Subject: Avoiding table scans...
Try this
SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE
ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e
WHERE ArtNumber2118806)
+---+---+
| ArtNumber | MessageID
|
Hi Chris,
-Original Message-
From: Chris Knipe [mailto:sav...@savage.za.org]
Sent: Thursday, 24 July 2014 19:18
To: mysql@lists.mysql.com
Subject: Avoiding table scans...
mysql SELECT MIN(ArtNumber) AS ArtNumber, MessageID FROM
78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber
Hello Surya,
Part of the problem may be that you are so focused on the details that
might have lost sight of the purpose.
On 7/12/2014 8:24 AM, Surya Savarika wrote:
Hi,
I have two query series that I wonder whether they can be compacted
into a single query:
FIRST QUERY SERIES
Am 19.07.2014 13:45, schrieb Arup Rakshit:
Here is my simple table
MariaDB [tutorial] select * from prices;
++--+--+
| id | name | cost |
++--+--+
| 1 | A| 1200 |
| 2 | A| 2500 |
| 3 | A| 3000 |
| 4 | B| 5000 |
| 5 | B| 7000 |
| 6 | C
On Saturday, July 19, 2014 02:56:24 PM Reindl Harald wrote:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MariaDB server version for the right syntax to
use
near 'DISTINCT sum) THEN sum(cost) ELSE NULL END AS cost_sum
from prices
Am 14.07.2014 12:48, schrieb Satendra:
Hi there, I'm struggling to find the total time taken by a database query
on the disk? As I understand when a database query start execution it takes
some time inside the database engine some time to seek the result from
disk (if that is not in
I would second what m. dykman says. There is no reason I can think of that
you would even be doing the order by clause.
keith
On Sun, Jul 13, 2014 at 11:16 PM, yoku ts. yoku0...@gmail.com wrote:
Would you try this?
CREATE PROCEDURE `reset_sortid` (IN category INT(11))
BEGIN
SET @a
Satendra,
Google show profile as it may give you all the information that you need.
There is a lot more details in the performance_schema if you want to dig
into it, but it can be quite difficult to get out. Here is one place to
start if you want to pursue that angle:
The order makes quite a big difference, actually. In this case it
ensures that the ordering of the values in the sort_id column is
maintained, even though the numbers are different.
Say this is your data (I have ignored the category thingy for now):
SELECT id, sort_id FROM documents;
Hi Satendra,
On Jul 14, 2014, at 3:48 AM, Satendra stdra...@gmail.com wrote:
Hi there, I'm struggling to find the total time taken by a database query
on the disk? As I understand when a database query start execution it takes
some time inside the database engine some time to seek the result
Hi Satendra,
On 7/14/2014 5:48 AM, Satendra wrote:
Hi there, I'm struggling to find the total time taken by a database query
on the disk? As I understand when a database query start execution it takes
some time inside the database engine some time to seek the result from
disk (if that is not
Anders,
I didn't see that at first, but now. I'd agree. Maybe I should read
up on stored procedures.
On Mon, July 14, 2014 16:25, Anders Karlsson wrote:
The order makes quite a big difference, actually. In this case it
ensures that the ordering of the values in the sort_id column is
Workbench provides some migration features and supports SQL Server
http://www.mysql.com/products/workbench/migrate/
On Mon, Jul 14, 2014 at 4:47 PM, Felipe Coutinho felipelcouti...@gmail.com
wrote:
Hello,
I'm a web developer and I'm developing a web application on Rails. I'm
gonna use
maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don Wieland d...@pointmade.net wrote:
I am trying to create this stored procedure, but can't understand why my
editor is chocking on it. Little help please:
DELIMITER //
CREATE PROCEDURE `reset_sortid` (IN category
why do you need the 'order by' in your update at all? The statement, if
innodb, will certainly be atomic; the order in which they are updated means
nothing.
On Jul 13, 2014 11:46 PM, kitlenv kitl...@gmail.com wrote:
maybe try 'order by sort_id desc'?
On Mon, Jul 14, 2014 at 12:42 PM, Don
Would you try this?
CREATE PROCEDURE `reset_sortid` (IN category INT(11))
BEGIN
SET @a = 0;
UPDATE
documents SET sort_id = (@a := @a + 1)
WHERE
document_category = category
ORDER BY
sort_id;
END
//
2014-07-14 11:42
On Thu, Jul 10, 2014 at 10:33:04AM +0800, 娄帅 wrote:
In the C API, we can call mysql_query(select 1; select 2);
which just send the command once to the server, and server
return two result sets, So i want to know if there is a command in the
mysqltest framework to do the job?
I want to write a
Hi Johan,
I wanted to love mysql-proxy for so many years, so I understand you :)
I have two main questions:
* am I remembering right that MySQL Proxy provides transparent failover ?
You need to use/create a lua failover script, I've never seen or tried one.
What kept me from investing too
Johan,
I don't think there's any need for the heavyness (and ugliness ;) ) of
MySQL Proxy. We're using haproxy for a similar setup (just with galera
behind it, but that shouldn't really matter. Have a look at this blog post
that explains most of it:
I like HAProxy as well as it simplifies many of the things you seem to be
looking for.
--
Wagner Bianchi
Mobile: +55.31.8654.9510
Em 09/07/2014, às 07:48, Heck, Walter walterh...@olindata.com escreveu:
Johan,
I don't think there's any need for the heavyness (and ugliness ;) ) of
MySQL
CC: vegiv...@tuxera.be; mysql@lists.mysql.com
From: wagnerbianch...@gmail.com
Subject: Re: Proxy / connected failover question
Date: Wed, 9 Jul 2014 08:31:05 -0300
To: walterh...@olindata.com
I like HAProxy as well as it simplifies many of the things you seem to be
looking
can't change the application itself, so I find
myself
looking for options that allow the heathen contraption to not notice
it's
connection has switched.
MGhow could a proxy server re-route a downed DB connection to another
server?
MGdoes Proxy have a heartbeat on 3306 and reroute
The AND in your UPDATE clause makes this a logical operator instead
of being a SQL keyword.
Your syntax is wrong:
UPDATE ...
SET mycol = value,
mycol2 = value
[WHERE ... ]
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL
don't use GTID is my suggestion :)
2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com:
Hi, all,
I want to use MySQL 5.6.18 in production, so i want to get all known bugs
on this version. Now i check the bugfix section in MySQL 5.6.19 and above
version. Am i doing the right thing? Or Do
Hi,
I was checking MySQL performance ... Sometimes my database could be working
slow. I have some queries that spend 9-10 seconds updating some columns by
primary key. I'm not sure if is a data base problem ...
Moreover, I have checked tuning scripts and appear these variables.
Good sentence!
Why do not use GTID? Just curious...WB
2014-07-07 3:18 GMT-03:00 louis liu yloui...@gmail.com:
don't use GTID is my suggestion :)
2014-07-07 7:42 GMT+08:00 娄帅 louis.hust...@gmail.com:
Hi, all,
I want to use MySQL 5.6.18 in production, so i want to get all known bugs
on this
Am 07.07.2014 12:37, schrieb wagnerbianchi.com:
Why do not use GTID? Just curious...WB
just read the changelogs and endless count of bugreports
it's a new feature and it works as buggy as replication
years ago where you had the rebuild the slave all the
time and maybe still if temporary
- Original Message -
From: Antonio Fernández Pérez antoniofernan...@fabergroup.es
Subject: Re: Doubts tuning MySQL Percona Server 5.5
I was checking MySQL performance ... Sometimes my database could be working
slow. I have some queries that spend 9-10 seconds updating some columns
Hello,
On 7/6/2014 7:42 PM, 娄帅 wrote:
Hi, all,
I want to use MySQL 5.6.18 in production, so i want to get all known bugs
on this version. Now i check the bugfix section in MySQL 5.6.19 and above
version. Am i doing the right thing? Or Do you have a better method?
Any input will be
I'm missing something rather essential in your mail... are you actually
experiencing performance problems, or are you just looking at variables and
randomly deciding you don't like their value?
Always remember the golden rule: if it ain't broken, don't fix it.
On July 4, 2014 8:00:31 PM
Hi Johan,
Thanks for your reply. Theorically the fragmented tables not offer the best
performance to the InnoDB engine, that's correct or not?
I don't know if is a problem or not, is a doubt/question for me. I'm not
sure if is an atypical behaviour.
Thanks in advance.
Regards,
Antonio.
*please* don't use reply-all on mailing-lists
the list by definition distributes your message
Am 30.06.2014 13:14, schrieb Antonio Fernández Pérez:
Thanks for your reply. Theorically the fragmented tables not offer the best
performance to the InnoDB engine,
that's correct or not?
practically
On 28-06-2014 19:11, Tim Dunphy wrote:
Hello,
I'm trying to use a very basic alter table command to position a column
after another column.
This is the table as it exists now:
mysql describe car_table;
+-+--+--+-+-++
| Field | Type | Null |
Cool guys, that did it..
ALTER TABLE car_table MODIFY COLUMN color VARCHAR(10) AFTER model;
For some reason the book I'm following doesn't specify that you have to
note the data type in moves! This helped. and thanks again.
Tim
On Sat, Jun 28, 2014 at 1:24 PM, Carsten Pedersen
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional
statement in a column move based on what you all just taught me:
mysql alter table modify column color varchar(10) sixth;
But I am getting this error:
ERROR 1064 (42000): You have an error in your SQL syntax; check
Hi Tim,
-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 03:45
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
Hey guys,
Sorry to hit you with one more. But I'm trying to use a positional statement
in a column
the book 'Head First SQL' which was
suggesting that you could do something like what this user was trying in
this stack overflow thread:
http://stackoverflow.com/questions/19175240/re-arranging-columns-in-mysql-using-position-keywords-such-as-first-second
But the answer in that thread too
Hi Tim,
-Original Message-
From: Tim Dunphy [mailto:bluethu...@gmail.com]
Sent: Sunday, 29 June 2014 10:09
To: Jesper Wisborg Krogh
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
The syntax sixth is not a supported syntax. You should use the
syntax
Wisborg Krogh
Cc: mysql@lists.mysql.com
Subject: Re: alter table modify syntax error
The syntax sixth is not a supported syntax. You should use the
syntax AFTER column_name where you replace column_name with
the
column name you want to position the modified column after.
Oh
Hi Andre,
Thanks for your reply. I have checked the link and my configuration.
Innodb_file_per_table is enabled and in data directory appears a set of
files by each table.
Any ideas?
Thanks in advance.
Regards,
Antonio.
Am 27.06.2014 09:48, schrieb Antonio Fernández Pérez:
Thanks for your reply. I have checked the link and my configuration.
Innodb_file_per_table is enabled and in data directory appears a set of
files by each table.
Any ideas?
ideas for what?
* which files don't get shrinked (ls -lha)
*
Hi Reindl,
Thanks for your attention.
Following the previous mail, I have checked my MySQL's configuration and
innodb_file_per_table is enabled so, I think that this parameter not
affects directly to fragmented tables in InnoDB (In this case).
I would like to know, if is possible, why after
Hello Antonio,
On 6/27/2014 9:31 AM, Antonio Fernández Pérez wrote:
Hi Reindl,
Thanks for your attention.
Following the previous mail, I have checked my MySQL's configuration and
innodb_file_per_table is enabled so, I think that this parameter not
affects directly to fragmented tables in
- Original Message -
From: Antonio Fernández Pérez antoniofernan...@fabergames.com
Subject: Re: Optimizing InnoDB tables
I would like to know, if is possible, why after execute an analyze table
command on some fragmented table, after that, appears fragmented again.
Simple question
Hi again,
I have enabled innodb_file_per_table (Its value is on).
I don't have clear what I should to do ...
Thanks in advance.
Regards,
Antonio.
- Original Message -
From: Antonio Fernández Pérez antoniofernan...@fabergames.com
Subject: Re: Optimizing InnoDB tables
I have enabled innodb_file_per_table (Its value is on).
I don't have clear what I should to do ...
Then all new tables will be created in their own tablespace now
Have a look at this:
https://rtcamp.com/tutorials/mysql/enable-innodb-file-per-table/
--
Andre Matos
andrema...@mineirinho.org
On Jun 25, 2014, at 2:22 AM, Antonio Fernández Pérez
antoniofernan...@fabergames.com wrote:
Hi again,
I have enabled innodb_file_per_table (Its value is on).
I
I followed the manpage for mysqlimport:
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test
ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using
password: NO)
thufir@dur:~$
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id
Am 24.06.2014 07:08, schrieb thufir:
On Mon, 23 Jun 2014 10:59:48 -0400, Scott Helms wrote:
I generally drop them into /tmp for easy access and cleanup after the
data load, but you can put them any place that the mysql daemon process
has access to read.
Huh, maybe the daemon doesn't
Hi Antonio, como esta?
What's the mysql version you're running? Have you tried to ALTER TABLE x
ENGINE=InnoDB?
-- WB, MySQL Oracle ACE
Em 24/06/2014, às 08:03, Antonio Fernández Pérez
antoniofernan...@fabergroup.es escreveu:
Hi list,
I was trying to optimize the InnoDB tables. I have
Hi Wagner,
I'm running
MySQL Percona Server 5.5.30 64Bits. No, I don't have tried to execute
ALTER TABLE (Analyze with InnoDB tables do that, or not?).
Thanks in advance.
Regards,
Antonio.
I think it's apparmor:
thufir@dur:/tmp$
thufir@dur:/tmp$ nl /etc/apparmor.d/usr.sbin.mysqld
1 # vim:syntax=apparmor
2 # Last Modified: Tue Jun 19 17:37:30 2007
3 #include tunables/global
4 /usr/sbin/mysqld {
5#include abstractions/base
6#include
901 - 1000 of 101064 matches
Mail list logo