> 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: Couldn't
No, he's the one who already receives a ton of email and could do without
"conversations" like this. I'm also in that boat.
sent from my mobile
On Oct 19, 2015 7:41 PM, "Ryan Coleman" wrote:
> You’re the one in grade school that always reminded us the teacher might
> be coming back soon and we s
Am 02.12.2014 18:31, schrieb Johan De Meersman:
> - Original Message -
>> From: "wharms"
>> 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 ful
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 noninteracti
coinhangout.com - coins!
> http://www.brooklyn-living.com
>
> Being so tracked is for FARM ANIMALS and and extermination camps,
> but incompatible with living as a free human being. -RI Safir 2013
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists
u, Oct 30, 2014 at 11:39 AM, Johan De Meersman
wrote:
>
>
> - Original Message -
> > From: "Walter Heck"
> > Subject: Re: Which replication solution should I choose?
> >
> > If you happen to be at the Percona Live conference next week in London
&
Hi Rafal,
On Wed, Oct 29, 2014 at 3:16 PM, Rafał Radecki
wrote:
> Thanks for the info, Walter.
> I checked some basic info about Galera and it looks very promising. Can
> you tell what is preferable for loadbalancing of requests? HAProxy/Galera
> loadbalancer or maybe something el
ice benefits. The one thing is that with Galera
your data generally lives on 3 or more servers (2 is possible, but not
recommended). If that is a good idea to you, then Galera would be my
personal preference.
--
Best regards,
Walter Heck
CEO / Founder OlinData
<https://t.yesware.com/
.
>
>
> Thank you for any and all suggestions and information,
> Johan
>
> --
> What's tiny and yellow and very, very dangerous?
> A canary with the root password.
>
--
Best regards,
Walter Heck
CEO / Founder OlinData <http://olindata.com/?src=wh_gapp> - Open Source
Training & Consulting
Check out our upcoming trainings <http://olindata.com/training/upcoming>
Hi all,
I'm speaking at the Percona Live conference next week. I'd like to stay in
the conference hotel but the room rates are a tad steep for yours truely.
Is there anyone who'd be willing to share a room from Monday-Friday?
let me know,
--
Best regards,
Walter Heck
CEO / Fo
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 varia
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 w
Am 12.06.2013 12:33, schrieb Manuel Arostegui:
> 2013/6/12 walter harms
>
>>
>> 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
Am 05.04.2013 07:56, schrieb Keith Keller:
> On 2013-04-05, Nitin Mehta 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 needed by
Am 02.02.2013 01:34, schrieb Larry Martell:
> On Mon, Jan 28, 2013 at 5:01 AM, walter harms 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 n
ables)
only they ibdata1-file or is there more ?
re,
wh
>
> On Mon, Jan 28, 2013 at 2:21 PM, walter harms wrote:
>
>>
>>
>> Am 28.01.2013 15:01, schrieb Manuel Arostegui:
>>> 2013/1/28 walter harms
>>>
>>>> hi list,
>>>>
&
>
For now i tend to solution 3, rsync
do you know is it possible only certain files ?
re,
wh
>
> On Mon, Jan 28, 2013 at 12:01 PM, walter harms wrote:
>
>> hi list,
>>
>> i am using mysql 5.1.53.
>> after a crash i have the follwing error in my log:
>>
Am 28.01.2013 15:01, schrieb Manuel Arostegui:
> 2013/1/28 walter harms
>
>> 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
&
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
(why can a failed optimisation cause a table
corruption ?)
re,
wh
> 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-
>> Fr
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,
>&g
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 MyISA
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 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 impres
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 ib_logfi
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
>>>
&g
2 at 8:17 PM, walter harms 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 ar
3, 2012 at 8:02 PM, walter harms 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
select * from 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 a
gt;
> On Mon, Jul 23, 2012 at 6:18 PM, walter harms 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
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
ng OT, but every now and then it's worthwhile to share also some
OT knowledge.
Walter Tross
>Regards,
>--
>Shawn Green
>MySQL Principal Technical Support Engineer
>Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
>Office: Blountville, TN
>
>
&g
http://bugs.mysql.com/bug.php?id=27877
W.T.
> - Original Message -
>> From: "Rick James"
>>
>> A warning about β -- There was a change in the collation at 5.1.24.
>> Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is
>> a brief discussion near the end.
>
> Aha, also
On 06/08/2012 01:55 AM, Claudio Nanni wrote:
Hi,
you guys don't like the official API?
http://dev.mysql.com/downloads/connector/c/
That's C isn't it? I think there is also a C++ connector. I'm interested
to hear how that performs. It seems like a waste of time to write a
bunch of wrappers
On 06/07/2012 12:29 PM, Lars Nilsson wrote:
On Wed, Jun 6, 2012 at 10:41 PM, Simon Walter wrote:
However, memory leaks are not acceptable. So I am open to suggestions. What
do other c++ programmers use?
I've been happy using SQLAPI++ (http://www.sqlapi.com/) where I work.
Commercia
What is the most stable and performant way to connect to a MySQL server
from a c++ application?
I've been using libmyodbc via unixODBC running under Debian squeeze.
Suffice it to say, I am sorely disappointed. First of all the libmyodbc
driver that's included with Debian is quite old. Howeve
ent for
MySQL with much better performance for any query optimiser related
things (which I'm pretty sure the nested joins are also part of).
--
Walter Heck
--
Check out my startup: Puppet training and consulting @ http://www.olindata.com
Follow @olindata on Twitter and/or 'Lik
Harald,
keep in mind that
a) this mailing list is badly set up: unless you do a "reply all", the reply
goes only to the poster (happened to me too)
b) Microsoft products have made inline (bottom) answering almost impossible. I,
like many others, am forced to used Outlook at the office, and theref
mn) values ('\xE2\x9C\x94'),
('\xE2\x9C\x98')");
Inside double quotes PHP replaces the hex escape sequences with the bytes that
form the correct UTF-8 encoding of your characters (see the above web pages).
ciao
Walter
At 19.14 23/03/2012 -0500, Halász Sándor wrote:
>How d
Well, the problem is that this is a server owned by a client and I
can't just go and build from source or use alien. It is really
ridiculous that a tool that aims to be a mysql replacement has no
packages for the latest version of one of the major linux distro's :(
Walter
On Wed, Mar 2
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
Relational databases are not very suitable for representing
graph-style data. You might want to look into graph databases, or the
OQGraph engine for MySQL: http://openquery.com/products/graph-engine
good luck!
Walter
On Fri, Jan 20, 2012 at 13:54, bruce wrote:
> Hi.
>
> Got a major
Am 10.09.2011 17:32, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>> 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&quo
Am 10.09.2011 16:25, schrieb a.sm...@ukgrid.net:
> Quoting walter harms :
>
>>
>> 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 ou
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, droppe
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 be
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
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 bo
python-paramiko is needed by mysql-workbench-gpl-5.2.34-1el6.x86_64
> [root@ws-test Desktop]#
>
> Is there is a any detailed link to install it with dependencies.
>
> Thanks
>
> Walter Heck - OlinData.com wrote:
>
> You can try MySQL Workbench instead. It's FOSS t
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.
>
loop construct. If I were in your position, I wouldn't use MySQL to do
this.
ciao
Walter
> Dear all,
>
> I have million of sites stored in url column of a mysql table.
>
> Some few examples are :-
>
> www.facebook.com/home
> adelaide.yourguide.com/news/local/news/entert
should use UTC time zone or you will run into trouble with DST.
>>>
>> [JS] If you do that, you can't use an automatic timestamp field. You have to
>> set the field yourself.
>
> Thanks Walter and Jerry.
>
> Is there a way to get NOW() to use
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
> SELEC
a vitual machine
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 wrote:
>
>> It is basicly a not clever solu
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 64-bit
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 :
>> Hi!
>>
>> SQL Maestro Group announces the release of PHP
Take a look at mmm for mysql. Easy and robust.
sent from my mobile phone
On Mar 22, 2011 12:07 PM, "Adarsh Sharma" wrote:
> Dear all,
>
> I researched on a link that describes that Mysql to use with scalr for
> fault-tolerance and high availability.
>
>
http://scottmartin.net/2009/07/11/creating-
d have much better advice that is not limited to this scope.
Other companies that do similar services include Percona, SkySQL and
FromDual to name a few :)
Have fun!
--
Walter Heck
Engineer @ Open Query (http://openquery.com)
Exceptional services for MariaDB and MySQL at a fixed budget
--
Follow @openquery on Twitter to stay up to date
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:
h
for the quick response
>
> just to answer one of the things here, the load is mostly reads as
> writes only happen in batches every so often.
>
> When I am saying reads I am talking of up to 2000-5000 concurrently at
> any given time during high load.
--
Walter Heck
Engine
ave it in use at many of our
customers and wouldhave a much harder time managing them (and
failures) without it. Don't try to do failovers by hand, use MMM
instead.
Cheers,
--
Walter Heck
Engineer @ Open Query (http://openquery.com)
Exceptional services for MariaDB and MySQL at a fixed budget
, so it's a combination of
> stuff I read and an understanding of how things work - or don't.
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--
Walter Heck
F
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 tab
Unless you have a very good reason, you probably shouldn't go with
cluster in the first place. If it is HA you want to have, check out
other options like MMM for MySQL (http://mysql-mmm.org), DRBD
+Heartbeat and others.
Can you tell us a bit more about your goals/desires?
Walter Heck
Eng
hance?
Walter Heck
Engineer @ Open Query (http://openquery.com)
On Fri, Aug 6, 2010 at 02:43, Евгений Килимчук wrote:
> Hello!
>
> I use CentOS 5.4 with LAMP. On the server runs heavy cgi-programs. MySQL use
> 75% (100% = 8GB) of memory. When cgi programs use more than 25% of memory
&g
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 t
VM's, you put your masters on different
physical machines
3. make sure that ARP traffic can flow freely between your machines.
EC2 doesn't support thatfor instance, so you'll either have to stick
with MMM 1 or patch MMM 2.
That's the most important part I think :)
Walter H
master-master is probably more like what you want to
achieve. For that, you can use a tool like MMM (http://mysql-mmm.org)
for instance, which will make your life much easier.
hope this helps!
===
Walter Heck
Engineer @ Open Query (http://openquery.com)
--
MySQL General Mailing List
For lis
This kind of error usually means you ran out of disk space on your
tmp_dir drive.
Walter
On Mon, May 31, 2010 at 13:30, Manasi Save
wrote:
> Hi All,
>
> I am getting following error when I am trying to run one stored procedure on
> table which has 30 rows in it. Table Ty
Carl,
if you want to be secure, do not use the internet to transfer your
data. SSH, VPN and SSL can not give you the kind of security a private
line can give you. That is a tad expensive though :)
Walter
On Mon, May 24, 2010 at 15:33, Carl wrote:
> John,
>
> I am familiar with the PCI
sql.com/doc/refman/5.1/en/replication-solutions-ssl.html
cheers,
Walter Heck
Engineer @ Open Query (http://openquery.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 -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 se
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
est environment first. But I know many environment where it
is "okay" to just run the upgrade, as long as it is a minor version
upgrade. I guess it depends on the type of production environment you
are running in.
be careful though!
Walter
On Mon, Apr 5, 2010 at 11:17, Rob Wultsch wrot
Ah, if you are single-user and updating really is a special occasion
that is completely in your control, you could even use compressed
MyISAM. That makes the table read-only though, but it does give
performance benefits:
http://dev.mysql.com/doc/refman/4.1/en/myisampack.html
good luck!
Walter
Take a look at haProxy. It can be combined with some scripts to
loadbalance mysql.
http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/
We use it at Open Query for a similar case.
Cheers,
Walter Heck
Engineer @ Open Query
http://openquery.com | http
That message usually means you ran out of space in your temp folder location.
cheers,
Walter Heck
--
Engineer @ Open Query
http://openquery.com | http://openquery.com/blog
On Thu, Mar 11, 2010 at 02:16, Zakai Kinan wrote:
> Is there a way to know exactly which table is corrupted with such
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, int
Bad idea. Sotring images is what a file system is for. Create an NFS
or other networked storage and store your images there. I don't see
the problem?
good luck,
Walter Heck
Engineer @ Open Query (http://openquery.com)
On Sat, Jan 30, 2010 at 18:54, Vikram A wrote:
> Hi,
>
> I
ght?
cheers,
Walter Heck
Engineer @ Open Query (http://openquery.com)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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 i
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
Random shot in the dark: I've seen this happen with some monitoring
tools that just check to see if the database is up.
Walter
On Wed, Dec 30, 2009 at 17:13, Jeetendra Ranjan
wrote:
> Hi,
>
> My MySQL server Aborted_connects status is showing 8692 and is rapidly
> increas
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: http://
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 use
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.
>
> Ca
take a look at mysqlslap: http://dev.mysql.com/doc/refman/5.1/en/mysqlslap.html
Walter
On Fri, Nov 13, 2009 at 22:33, Johan De Meersman wrote:
> Hey all,
>
> I'm looking for a Mysql benchmarking/stresstesting tool that can generate a
> workload based on standard Mysql full que
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/mysql
Sudhir: do yourself a favr and split the blobs (=body) off to a
different table. Most fo the time bodies are not used, only when the
actual email needs to be shown. That means that you can keep the
frequently used fields together in a table for much quicker access.
cheers,
Walter
On Mon, Nov 2
Jaime Crespo Rincón schrieb:
> 2009/10/29 Michael Dykman :
>> 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
>>
>>http://dev
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.
>
>
>
>
> Wi
loads/workbench/5.1.html
Walter
On Tue, Oct 13, 2009 at 12:59, Michael Dykman wrote:
> http://dev.mysql.com/downloads/gui-tools/5.0.html
>
> On Mon, Oct 12, 2009 at 7:23 PM, Marcelo de Assis wrote:
>> Hi people!
>>
>> Can anyone suggest a query manager on linux envi
And an answer to 2): http://www.maatkit.org/doc/mk-query-digest.html
On Tue, Oct 6, 2009 at 02:59, Brown, Charles wrote:
> Questions Folks:
> (1) What do you about un-index searches. How can one report and monitor them?
> (2) What do you do with the slow-query log. Are there any utilities or
> s
stopped with a copy from a fresh install. That will
wipe all users in your database though, and might have unforeseen
consequences depending on what you had defined before.
Backup first though!
Walter
On Wed, Aug 26, 2009 at 03:33, Joe wrote:
> I'm trying to get back to an earlier state
Hey Joe,
stop the server, start it with --skip-grant-tables, change the root
entry in mysql.user to your liking, and then restart the server
without --skip-grant-tables.
viola!
Walter
On Wed, Aug 26, 2009 at 02:12, Joe wrote:
> We have an inaccessible MySQL v5.0.45 DB (w/Innodb) we rea
Check out replication.
On Sun, Aug 23, 2009 at 09:00, m. zamil wrote:
> Hello all,
> due to connection state, I need to keep an updated copy of the database on
> the client.
> How can I accomplish this?
> TIA
> Mos
--
Walter Heck, Engineer @ Open Query (http://openque
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 happeni
1 - 100 of 243 matches
Mail list logo
