> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben:
>
>
> 2019/02/08 10:32 ... Walter Harms:
> > Hello list,
> > i run into an unexpected problem with mysqldump:
> >
> > mysqldump --version
> > mysqldump Ver 8.0.12 for Lin
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben:
>
>
> 2019/02/08 10:32 ... Walter Harms:
> > Hello list,
> > i run into an unexpected problem with mysqldump:
> >
> > mysqldump --version
> > mysqldump Ver 8.0.12 for Lin
Hello list,
i run into an unexpected problem with mysqldump:
mysqldump --version
mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL)
when i try it results in:
mysqldump: Error: 'Lost connection to MySQL server during query' when trying to
dump tablespaces
mysqldump:
Am 02.12.2014 18:31, schrieb Johan De Meersman:
- Original Message -
From: wharms wha...@bfs.de
Subject: signal handling in mysql cli
when i use CTRL-C to break a query that works fine in interactive mode.
but when i use the noninteractive mode
i looks like that but show full
hi list,
when i use CTRL-C to break a query that works fine in interactive mode.
mysql select sleep(10) ;
^CCtrl-C -- sending KILL QUERY 24289 to server ...
Ctrl-C -- query aborted.
+---+
| sleep(10) |
+---+
+---+
1 row in set (0.86 sec)
but when i use the noninteractive
hi,
does the value change at all like below ?
mysql show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372404355 |
+---++
1 row in set (0.00 sec)
mysql show global
Am 12.06.2013 12:33, schrieb Manuel Arostegui:
2013/6/12 walter harms wha...@bfs.de
Hi list,
i am trying to understand the incredible use of filepointers in our mysql
server (5.1.53).
under normal condition the server reports 10k-15k open files pointer.
I run a 'flush tables' every 2h
Am 13.06.2013 12:07, schrieb Hartmut Holzgraefe:
On 06/13/2013 09:41 AM, walter harms wrote:
Hello Manuel,
thx for your tip. We caught the problem when we moved to partitions.
Strange is that
while testing the problem did not show up and even now we no clue why
we experience
the sudden
Am 05.04.2013 07:56, schrieb Keith Keller:
On 2013-04-05, Nitin Mehta ntn...@yahoo.com wrote:
We're trying to upgrade our existing MySQL 5.1.26 to MySQL 5.1.68 but the
installation gives error:libc.so.6(GLIBC_2.4) is needed by
MySQL-server-community-5.1.68-1.rhel5.i386 rtld(GNU_HASH) is
Am 02.02.2013 01:34, schrieb Larry Martell:
On Mon, Jan 28, 2013 at 5:01 AM, walter harms wha...@bfs.de wrote:
hi list,
i am using mysql 5.1.53.
after a crash i have the follwing error in my log:
130128 10:45:25 InnoDB: Error: page 61 log sequence number 0 2871649158
InnoDB
or is there more ?
re,
wh
On Mon, Jan 28, 2013 at 2:21 PM, walter harms wha...@bfs.de wrote:
Am 28.01.2013 15:01, schrieb Manuel Arostegui:
2013/1/28 walter harms wha...@bfs.de
hi list,
i am using mysql 5.1.53.
after a crash i have the follwing error in my log:
130128 10:45:25 InnoDB
Am 28.01.2013 15:01, schrieb Manuel Arostegui:
2013/1/28 walter harms wha...@bfs.de
hi list,
i am using mysql 5.1.53.
after a crash i have the follwing error in my log:
130128 10:45:25 InnoDB: Error: page 61 log sequence number 0 2871649158
InnoDB: is in the future! Current system log
, rsync
do you know is it possible only certain files ?
re,
wh
On Mon, Jan 28, 2013 at 12:01 PM, walter harms wha...@bfs.de wrote:
hi list,
i am using mysql 5.1.53.
after a crash i have the follwing error in my log:
130128 10:45:25 InnoDB: Error: page 61 log sequence number 0
perhaps you are looking for something like
select entry,timestamp from table A where A.timestamp=(select max(B.timestamp)
from table B where a.entry=b.entry);
also this oage may be helpful:
http://www.artfulsoftware.com/infotree/queries.php
re,
wh
Am 30.11.2012 02:39, schrieb h...@tbbs.net:
can you reduce the UDF just to return 1; ?
that should give you a clue what is going on. Random
values usualy point to two suspects
1. mixing 32bit and 64bit
2. using void instead of int
re,
wh
Am 04.11.2012 23:23, schrieb Stefan Kuhn:
Hi all,
I have a weired (for me at least) problem with a
All of MySQL (not just InnoDB) needs tmp space for _some_ queries. It is
normally not be this same directory, but it is probably harmless if it is.
-Original Message-
From: walter harms [mailto:wha...@bfs.de]
Sent: Sunday, October 28, 2012 2:05 PM
To: mysql@lists.mysql.com
hi list,
does someone know under what circumstances ''optimize tables'' will
create a tmpfile ?
we had a strange case of out of space that seems related to an optimize
table
but i was unable to replicate that case exactly as that no tmpfile appeared.
(The table has a lot of partitions if that
Am 29.10.2012 13:17, schrieb Reindl Harald:
Am 29.10.2012 12:48, schrieb walter harms:
hi list,
does someone know under what circumstances ''optimize tables'' will
create a tmpfile?
under all if it is MyISAM and for select id from table order by rand(); too
interessting, i
Am 29.10.2012 14:55, schrieb Reindl Harald:
Am 29.10.2012 14:54, schrieb walter harms:
Am 29.10.2012 13:17, schrieb Reindl Harald:
Am 29.10.2012 12:48, schrieb walter harms:
hi list,
does someone know under what circumstances ''optimize tables'' will
create a tmpfile?
under all
hi list,
on my system this this directory contains ib_logfile0/ib_logfile1, so far no
problem.
From the documentation i had the impression that this is everything and
the files size should not change.
but it seems that immodb also uses this space for temp space, do they make
a copy of
Am 28.10.2012 21:50, schrieb Reindl Harald:
Am 28.10.2012 21:29, schrieb walter harms:
hi list,
on my system this this directory contains ib_logfile0/ib_logfile1, so far no
problem.
From the documentation i had the impression that this is everything and
the files size should
Hi list,
is there a switch where i can restrict the connect/execution time for a query ?
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
, 2012 at 6:18 PM, walter harms wha...@bfs.de wrote:
Hi list,
is there a switch where i can restrict the connect/execution time for a
query ?
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
--
MySQL
information_schema.processlist where state like 'executing' and
time 1000 ;
unfortunately time i cumulative and i would kill long running processes that we
have also.
i guess i will make some assumptions about the statement and kill the rest.
re,
wh
On Mon, Jul 23, 2012 at 7:38 PM, walter harms wha
, walter harms wha...@bfs.de wrote:
Am 23.07.2012 16:10, schrieb Ananda Kumar:
you can check the slow query log, this will give you all the sql's which
are taking more time to execute
Yes but you will see the results only when the query is finished.
my first idea was to use something like
, walter harms wha...@bfs.de wrote:
Am 23.07.2012 16:37, schrieb Ananda Kumar:
why dont u setup a staging env, which is very much similar to your
production and tune all long running sql
They are tuned and they are fast :) but the never logout and therefore
the time get accumulated.
re,
wh
Am 23.07.2012 17:38, schrieb Reindl Harald:
Am 23.07.2012 17:35, schrieb walter harms:
Am 23.07.2012 16:58, schrieb Ananda Kumar:
so. its more of inactive connections, right.
What do you mean by NEVER LOGOUT
The programms watch certain states in the database,
the connect automatic
Am 26.01.2012 18:45, schrieb HalXsz SXndor:
20120126 10:34 AM +0200, a bv
Database contains
tables (structures?) which gets montly data , and these tables are
named as
name1_name2_ yearmonth . I only want to have the whole database system
for last 2 years, and automaticly clean the data
It is some time since i used AIX but maybe this help.
So far i know has IBM moved to gnu-tools if not do it,
it will ease the pain. I assume that you have gcc etc running.
after downloading the latest version of mysql source.
1. unpack
2. ./configure
if it complains try to fix it
/* hope for the
Am 10.09.2011 16:07, schrieb a.sm...@ukgrid.net:
Ok, this is pretty odd but I have found the problem.
Today I have repointed all applications to a different DB server, so I
have been free to do any testing on the problem server.
I started by dropping the databases one by one, dropped em
Am 10.09.2011 16:25, schrieb a.sm...@ukgrid.net:
Quoting walter harms wha...@bfs.de:
What i found odd that your mysqld actualy restarts.
Do you have it in some runlevel ? if yes stop and see
what happens.
If this does not work simple move the mysqld out of he way
and replace
Am 10.09.2011 17:32, schrieb a.sm...@ukgrid.net:
Quoting walter harms wha...@bfs.de:
I still do not see why it is restarting ... there must be something
watching is disappear.
Just to be sure, you do from a remote host: mysql -hHOST -ume -e show
tables ?
long shot: Do you have LDAP, NIS
hi list,
i have a very strange effect.
I have two boxes with the same DB ( same version, same tables, same my.cnf, etc)
I was trying to optimise an sql statement and used desc to see what is going on
and found to my surprise two different results.
Can this be the result of the optimizer ? (the
Am 31.08.2011 13:51, schrieb Johan De Meersman:
Exactly the same data, too? Different index leaf distribution might account
for something
like this, and it does look like you're retrieving different datasets.
same data
think of it as a backup.
re,
wh
--
MySQL General Mailing List
For
maybe its is obvoius but
did you look at the statistics ?
did you try optimize table ?
re,
wh
Am 18.07.2011 18:40, schrieb A F:
[Process:]
Importing
delimited text files from a Windows based server to a MySQL 5.1.41 instance
(multiple databases) on a single Ubuntu 10.04.2 host.
The
from:http://dev.mysql.com/doc/refman/5.0/en/time-zone-support.html
SET GLOBAL time_zone = timezone;
from:http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_utc-timestamp
* UTC_TIMESTAMP, UTC_TIMESTAMP()
I have the same results, according to the docs timezone is the
Am 19.06.2011 21:06, schrieb sono...@fannullone.us:
On Jun 19, 2011, at 11:11 AM, Claudio Nanni wrote:
just a quick debug:
Thanks, Claudio. It turned out to be that NOW() was using the server's
time and my timestamp was based on my timezone. After fixing that, the
SELECT
with qemu, or
simply buy a 32bit box is more maintainable than mixing 32 und 64 bit
application. They can run
perfectly until some random momentum.
re,
wh
Alex
On Sat, Jun 4, 2011 at 10:06 AM, walter harms wha...@bfs.de wrote:
It is basicly a not clever solution to run 32bit libs with a 64bit
It is basicly a not clever solution to run 32bit libs with a 64bit system.
You have to compile -m32 and all sort of things.
It is *way* better to compile with pure 64bit.
re,
wh
Am 04.06.2011 02:18, schrieb Alex Gaynor:
I've got a 64-bit Linux system, with a 32-bit libmysqlclient (and a
maybe but what is mysql 11.4 ?
re,
wh
Am 27.04.2011 03:33, schrieb Sharl.Jimh.Tsin:
very useful tool,is it free?
Best regards,
Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**)
2011/4/26 SQL Maestro Team sql.maes...@gmail.com:
Hi!
SQL Maestro Group announces the release
You are missing the libmysqlclient.
I guess the problem is your makefile. make != shell
You CFLAGS should have something like this:
-L/usr/lib/mysql -lmysqlclient
(Actualy it should be LDFLAGS and LOADLIBES)
something like $(shell pkg-config --cflags $(packages) ) should work
further reading:
Carlos Mennens schrieb:
I have a database called 'gaming' and with in that database there are
several tables and data. I was asked to find a module called 'ako
ldap' and disable it (setting it from 1 to 0). My question is how in
MySQL do I search for a string if I don't even know what table
PRATIKSHA JAISWAL schrieb:
Hi List,
Can somebody please help me if they have a script using which we can get an
idea for installed mysql server, backup, created databases, indexes, tables,
engines, replication etc...
I will appreciate your help in advance
You can find tons of
you can circumvent the problem by using stdout.
just drop the INTO OUTFILE '/tmp/result.txt'.
the result should look something like that:
mysql -BAN database -e select ... filename
you can also pipe truh gzip to compress the file and save
a lot of space.
re,
wh
note: i found ; is not a good
Huib schrieb:
Hello,
I hope that this is the right list.
I have a database that has been running for years in latin1 but a
software update changed it in to utf8 that would be no big deal if we
know it right away so we could change the database.
The big problem is that the database
Nathan Harmston schrieb:
Hi everyone,
I am currently working on an application where I have a very large
table called intervals ( atm its 80 000 000 records and growing ), and
a smaller table ( token ) which join with it.
interval is just an id, start, end, word
token is id,
Krishna Chandra Prajapati schrieb:
Hi list,
I want to insert 1 records/sec into table. There can be n number of
tables with unique data in each. What are the possible ways to do ?
i prefer mysqlimport. just sort your output into a file that is named like the
table
you wish to
Jerome Macaranas schrieb:
im trying to setup mysql slave but the things is it wont start because of
this errror:
-- ERROR 1200 (HY000): The server is not configured as slave; fix in config
file or with CHANGE MASTER TO
after some testing.. i saw the server-id = 0
through show
hi list,
is it possible to get a list of all tables with a certain type in one statement
?
for now i collect all tables (show tables) and search for the type (show
columns).
Any way to circumvent that ? make it one statement ?
re,
wh
--
MySQL General Mailing List
For list archives:
I do know thw internals,
but i guess having select only would be enough if you drop the auto-repair
feature.
a repair always requires changes (=write).
maybe you can use mysqlldump instead ?
re,
wh
René Fournier schrieb:
Just wondering what they are. I'd rather not use the MySQL root user for
Manasi Save schrieb:
Hi All,
I am needing to access a sub databases through main database.
I have one main database and serveral sub databases. For accessing those
databases I am using mysql prepared statements, But the performance I am
getting because of this is very low.
Can anyone
Sydney Puente schrieb:
Hello,
I want to log all sql queries made against a mysql db.
Googled and found I should add a line to my.cnf.
However I cannot find a my.cnf file
[r...@radium init.d]# ps -ef | grep mysql
root 13614 1 0 Sep24 ?00:00:00 /bin/sh /usr/bin/mysqld_safe
Jaime Crespo Rincón schrieb:
2009/10/29 Michael Dykman mdyk...@gmail.com:
mysqldump is not really a data manipulation tool.. as the name
implies, it is a dumper.
What you are trying to accomlish can be done rather elegantly via the
SELECT .. INTO OUTFILE syntax
Do your realy need to know the differenz ? take everything as string.
(breaks with pics/geodata but helps a lot).
re,
wh
sangprabv schrieb:
Hi,
I found no built in function in mysql to check whether a record is
numeric or string. Is there any trick to do so? Many thanks.
Willy
Krishna Chandra Prajapati schrieb:
Hi list,
I have two tables send_sms and alt_send_sms. Users are inserting records
into send_sms @ 500/sec ie 3/min. After applying some updates to
send_sms data are transferred to alt_send_sms and deleted from send sms. The
same thing is happening
Simon Kimber schrieb:
Hi Everyone,
I'm having a very simple query often take several seconds to run and
would be hugely grateful for any advice on how i might spped this up.
The table contains around 500k rows and the structure is as follows:
The letter is directed to EU based companies. deadline is 13.08.2009.
Maybe some more are interessted to participate.
http://blog.thinkphp.de/archives/416-A-letter-from-the-European-commission-regarding-the-OracleSun-merger.html
re,
wh
disclaimer:
i have nothing to do with that stuff. i only
the corresponding select
statements ?
re,
wh
peng yao schrieb:
you also can do this:#sudo -u mysql mysqldump command
or
#su - mysql -c mysqldump command
2009/7/24 walter harms wha...@bfs.de
muhammad subair schrieb:
On Thu, Jul 23, 2009 at 10:10 PM, walter harms wha...@bfs.de wrote:
Hi list
muhammad subair schrieb:
On Thu, Jul 23, 2009 at 10:10 PM, walter harms wha...@bfs.de wrote:
Hi list,
i use mysqldump --tab to create database dumps. this will produce txt and
sql files.
the resulting sql files is owned by the user but the resulting datafile is
owned by mysql.mysql
Hi list,
i use mysqldump --tab to create database dumps. this will produce txt and sql
files.
the resulting sql files is owned by the user but the resulting datafile is
owned by mysql.mysql
is there any way to change that ?
re.
wh
--
MySQL General Mailing List
For list archives:
st...@edberg-online.com schrieb:
At 11:10 AM +0530 6/13/09, Krishna Chandra Prajapati wrote:
Hi guys,
I'm working in a telecom company. I have table called deliverylog in which
30 million records gets inserted per/day. The table has grown to 0.5TB I
have to keep 60days record in the table.
bharani kumar schrieb:
Hi All ,
This is one general question ,
How to write the safe query , which prevent the site from hijacker ,
Share your idea's
pull the plug for the mains and save energy.
there is no silver bullet. take a lecture in security and you will scream
who much simple
hi Olaf,
in unix you have small programms that do one thing and not more.
What you want to archive is a compressed output files.
the most easy way is:
send to stdout | gzip -c outfile
depending on your data replace gzip with zoo,lha,bzip2,compress,.
re,
wh
Olaf Stein schrieb:
Or even
hi list,
i am wondering if there is a way to reduce the number of open files.
The database has InnoDB and MyISAM. I have a lot a partitions is that a problem
?
(To many open files causes problems for mysqldump)
running is vanilla 5.1.34
show status like '%open%' ;
Ravi raj schrieb:
Dear walter Harms,
Thanks for your valuable solution, but in the code which
you provided is printing only one row , if i try to print whole table,
or 2, or 3, columns fully means its giving segmentation fault, kindly
check the below code for furthur
there is nothing you can make.
Any (major)upgrade of mysql client requires the dependent subsystem to upgrade
also.
Anything else would be careless since you do not know if the interface has
changed.
basicly you can install both version of libraries and hope for the best. i
would do this only
hi ravi,
this works for me. it should help
you to get a starting point
re,
wh
/*
simpple DB connect test
gcc -L/usr/lib/mysql -lmysqlclient connect.c
*/
#define _GNU_SOURCE
#include stdio.h
#include stdlib.h
#include mysql/mysql.h
int main()
{
MYSQL *MySQL;
MYSQL_ROW
Didier Godefroy schrieb:
Hello all,
I've been having troubles building mysql on Tru64 v5.1b.
I tried several versions and there are always some kind of issues with
undefined symbols and things to be changed in the source to allow the build
to continue.
Lately I've been trying to get
most likely a missing include it should have at least:
#include sys/time.h
#include sys/resource.h
Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem
schrieb:
make all-am
Making all in mysql-test
Making all in lib/My/SafeProcess
g++ -DHAVE_CONFIG_H -I.
you may like to try mytop
or
watch -n10 mysql -BNA databasename -e show full processlist
add user,host,databasename as needed
Sven schrieb:
Hi folks
I am searching for a generic command to monitor that MySQL instance is
up and running. I don't have any know-how about the schema of the DB.
Kunal Jain schrieb:
How we can configure Mysql in such a way so that i start using all the cores
of CPU. I Have a QuadCore server but somehow mysql use only single core
whose usage percentage goes upto 99% while other three cores remains idle.
Any Idea or Multiple Core/CPU is wastage.
Kevin Stevens schrieb:
ello,
I am encountering a problem I just can't seem to figure out and I am out of
ideas. I can compile and run fine on one linux box running Mysql 5.1.23-rc,
but as soon as I scp the binary and its required libs to another machine
which has identical hardware and
-
From: walter harms [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2008 5:06 AM
To: 'mysql'
Subject: select ... into outfile=stdout ?
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would
like
to send the output to stdout to further processing
hi ronaldo i tried and failed.
it seems that mysql has no option to specify a select statement.
did i mis something ?
re,
wh
walter harms schrieb:
hi ronaldo,
iadmit i was mysql (the command) fixated :)
thx a lot,
wh
Rolando Edwards schrieb:
Try mysqldump !!!
On this web page
hi list,
i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would
like
to send the output to stdout to further processing.
unfortunately i found no proper way to force the output to stdout. for now i use
the redirection of the mysql -NB output but the interface lacks the
Mike Aubury schrieb:
Excellent - this seems to be the issue - the show create table shows :
mysql show create table a\g
+---++
| Table | Create
Table
you mail like to find it by your self. simply use : explain query
re,
wh
Yong Lee schrieb:
All,
Just curious as to which query would be better in terms of performance:
select * from (select * from a union select * from b) as c;
versus
select * from a union select * from b;
or would
Hi list,
I need to store what is basically a key-value pair. A few years ago i would
have choosen
an integer as key and used a translation table to get the name (char[]) for the
key.
Since diskspace is plenty i thinking about to use the name directly. does
anyone has any idea
what is the
thx,
the results support my suspect
re,
wh
Perrin Harkins schrieb:
On Fri, Aug 29, 2008 at 4:57 AM, walter harms [EMAIL PROTECTED] wrote:
Since diskspace is plenty i thinking about to use the name directly. does
anyone has any idea
what is the performance penalty ?
http
Vicente Moreno schrieb:
Hi all I have a little question, have you ever work C MYSQL??? all about that
is new for me, if anybody has some info, help me!!!
yes,
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Keith Spiller schrieb:
Hi Johnny,
Yeah. Sadly I missed the fact that the zip codes were hacked in our original
Works to MySQL conversion until long after I had imported the data into our
current MySQL table. Now we have to fix the numbers in our MySQL table and
guarantee that we can
Kandy Wong wrote:
Hi Saul,
I need to use C++ and I'm not writing a web application.
Thanks anyway.
you can do something like:
select min(abs(timediff(targettime,timestamp))) from table where
condition ;
if you use the libmysql you can get the result as strings back (the method i
Waynn Lue wrote:
Out of curiosity, is it generally faster to do a sub query or do it in
code for something like this.
Schema of Settings table, where the PK is (ApplicationId, SettingId):
ApplicationId, SettingId, SettingValue
Select SettingValue from Settings where SettingId = 10 and
that is a shell question using bash/ksh stuff you can use this:
mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' 1.txt 21
Ananda Kumar wrote:
The problem with below statement is that, if i there is any error in sql
statements it does not get written to 1.txt. So, even if
hi list,
i have a simple question:
does the constraint id need to be numeric ?
re,
wh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
David Ruggles wrote:
I may be approaching this all wrong, but I need to know a percentage of
total sales within a select statement.
So I can do something like this:
Select company, state, sales, sum(sales) / sales as percent
From Sales
mmh, you want
sum(sales where
hi list,
i have tables that look like this( 10.000 entries) :
id,
timestamp,
value
to get the latest value for each id i have queries like:
select * from tab A where timestamp = (select max(timestamp) from tab B where
B.id=A.id) group by id ;
on a fast system it takes round 4 sec to complet,
Peter Brawley wrote:
to get the latest value for each id i have queries like:
select * from tab A where timestamp = (select max(timestamp) from tab
B where B.id=A.id) group by id ;
See Within-group aggregates at
http://www.artfulsoftware.com/infotree/queries.php.
PB
hi peter,
txh
88 matches
Mail list logo