I am having an issue with mysql 5.1.52 and using mysqlbinlog. Essentially I
am running the command piped into mysql and all is working well until I am
getting to a huge BINLOG command and I get:
121002 16:09:03 [ERROR] /usr/libexec/mysqld: Out of memory (Needed
3759556332 bytes)
Small versions
On Wednesday 19 April 2006 11:10, Lucas Vendramin wrote:
Hi all.
I am creating a trigger that update the some table witch call it.
Ex:
create table t1 (
id int, name varchar(50), c int default 0, father int,
primary key(id),
index (father),
foreign key (father) references t1(id) on
On Friday 04 November 2005 08:06 am, Chris Wells wrote:
/usr/lib/chkrootkit/chkproc -v -v
PID 1230(/proc/1230): not in readdir output
PID 1230: not in ps output
CWD 1230: /var/lib/mysql
EXE 1230: /usr/sbin/mysqld
... (report the same for 1231 - 1238)
You have 9 process hidden for
On Friday 04 November 2005 07:30 am, AESYS S.p.A. [Enzo Arlati] wrote:
Hi, I'm trying to migrate from MySQL 4.1.11 to MySQL 5.0 and I get a
problem with the new release.
I have this table...
provasql
CREATE TABLE `provasql`
`idrow` bigint(20) unsigned NOT NULL default '0',
`descr`
On Wednesday 26 October 2005 04:24 pm, LMS wrote:
Hi,
I have this structure:
---
CREATE TABLE tabla (
id int(10) unsigned NOT NULL auto_increment,
nombre varchar(100) NOT NULL default '',
because your defaulting it to ''.. so null = '' on
On Thursday 27 October 2005 03:51 pm, [EMAIL PROTECTED] wrote:
hy! I've been trying to find this piece of information in the manual, but
seem to have some trouble. so I'm asking it out loud: I'd like to know
whether mysql 4.0.25 supports utf-8 as an internal encoding. Because a
server I like
On Friday 21 October 2005 07:04 pm, Stever wrote:
Is there any reason why there isn't a source rpm for mysql 4.1.15? I
need to compile my own version since (annoyingly), there doesn't seem to
be a binary rpm version that works with glibc 2.2.5.
Anyone out there created a source rpm for mysql?
On Wednesday 19 October 2005 04:34 pm, Mihail Manolov wrote:
It's the way our code is written, and I just changed the table type and
began getting this error. We have lots of data to insert into this
table, therefore the optimal option is to use DELAYED and insert them in
blocks.
Not sure
On Wednesday 19 October 2005 01:15 pm, Olaf Faaland wrote:
The queries in question are:
This query uses the index:
mysql explain
- select itran_log_date, itran_log_actionid from itran_log where
- itran_log_actionid = 170807;
This query performs a table scan:
mysql explain
-
On Thursday 06 October 2005 10:57 am, Ryan Stille wrote:
I am converting some code from MSSQL to MySQL. In one place I need to
have a conditional query depending on if a table exists or not. There
are different versions of this application and the table only exists in
some of them. Here is
On Wednesday 05 October 2005 04:05 am, Rob Hall wrote:
Having a few problems using cursors in 5.0.13 and I don't know wether it's
an 'operator error' :)
Should this work?
when loading a procedure, do show warnings after it.. It tells you what
problems its running into..
So what error are
On Monday 29 August 2005 04:55 pm, Alexey Polyakov wrote:
I'd try setting
innodb_buffer_pool_size=8G
in my.cnf
Then it will run out of memory. You only get 2gig for bufferpools no matter
how much more you have.
--
===
On Monday 01 August 2005 12:43 pm, Jason Pyeron wrote:
On Mon, 1 Aug 2005, Enrique Sanchez Vela wrote:
Most likely you would need to specify the database
server hostname with the -h option.
yes I am aware of this. When you use the native windows mysql.exe it will
default to localhost,
On Thursday 30 June 2005 06:47 am, Patrik Wallstrom wrote:
mysql use testdb;
mysql drop trigger foo;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' at line 1
mysql drop trigger
On Friday 17 June 2005 02:38 pm, Brady Brown wrote:
Have any of you MySQL/FreeBSD cats successfully set
innodb_buffer_pool_size 2G without runing into any of the memory
allocation problems found on Linux platforms?
It has nothing to do with linux.. its an x86 thing.. So no..
However, some
On Tuesday 14 June 2005 11:57 pm, Michael Gale wrote:
Even if I change the value to 2G it still will not load ? Because the
value was 500M before do I not have to remove the ib* files and have
them recreated ?
2g is still to large.. its 2gig for all buffer pools, not just that one..
I
On Wednesday 08 June 2005 10:57 pm, George Sexton wrote:
1)Why can't I declare a datetime field with DEFAULT NOW()
4.1 has options to default timestamps on update/inserts or both..
Jeff
pgp2pHd6mM2jF.pgp
Description: PGP signature
On Thursday 09 June 2005 09:39 am, Jeremiah Gowdy wrote:
I am proposing that when a query is received by MySQL, a timestamp could be
taken immediately, and that timestamp could travel with the query until it
is actually processed. For delayed inserts, the query would still sit in
the insert
On Thursday 09 June 2005 11:47 am, George Sexton wrote:
I'm working in that direction. I first posted to the regular mysql list,
and then I posted again to the internals list. I guess the next step is to
talk to the MySQL people.
We answered you I thought.. Whats the issue you dont know?
On Thursday 09 June 2005 01:26 pm, George L. Sexton wrote:
Another limitation in MySQL is that you can only have one timestamp column
with a default of CURRENT_TIMESTAMP.
How many friggin times do I have to say that this is not an issue with 4.1 and
above? Which, BTW, is production mysql..
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
Subqueries in 4.1 are totally broken. They don't use indexes. They're
evil. We're told we have subqueries but there's no way anyone on earth
could use them. To make matters worse a lot of developers are TRICKED
into using them and
On Wednesday 08 June 2005 10:56 am, you wrote:
In the last episode (Jun 08), Jeff Smelser said:
On Tuesday 07 June 2005 04:22 pm, Kevin Burton wrote:
Subqueries in 4.1 are totally broken. They don't use indexes.
They're evil. We're told we have subqueries but there's no way
anyone
On Wednesday 08 June 2005 11:16 am, you wrote:
[snip]
Thats funny.. looks like it will be added to 5.1.. Dunno why they think
fixing
it is adding a feature..
[/snip]
The best open-source database on the market today? Free
Constant improvements to database? Free
Ability to complain when
On Wednesday 08 June 2005 11:49 am, you wrote:
Easy there boss, I was just responding to the thread and meant no
offense. I saw the whole thing as funny.
Oh.. email sucks that way..
My apologies as well..
Jeff
pgpvHgJLsGjaw.pgp
Description: PGP signature
On Friday 03 June 2005 03:36 pm, Joey wrote:
SET PASSWORD FOR mailto:'user'@'localhost' 'user'@'localhost' =
OLD_PASSWORD('passowordo');
Why not recompile php to work with 4.1?
--old-password
Jeff
pgpEctk2PnMK1.pgp
Description: PGP signature
On Wednesday 01 June 2005 10:40 am, Josh Trutwin wrote:
Just curious - was there a 5.0.5-beta release? The last beta I had
was 5.0.4 unless I missed a release announcement...
You need to read that email.. it says it was never released.
Jeff
pgpk9pJzWINTK.pgp
Description: PGP signature
On Monday 23 May 2005 02:01 pm, Dayakar wrote:
I want a solution to implement the views in mysql 4.12 version. It is
urgent. Earlier our database was oracle and our search of database is done
using views. I want to implement the same in mysql 4.12 version.
You need version 5.0.4..
On Friday 08 April 2005 10:38 am, Chris Scheller wrote:
i have replication going between 2 boxes. the master crashed a few days
ago, and this morning i noticed that the slaves slave thread errored
out. the binary log and offset had changed on the master and the slave
couldn't sync up. i got
On Thursday 24 March 2005 10:27 am, Marc Dumontier wrote:
I had a slave machine (ralph) as backup to a master machine (barney). I
then made ralph the production server, and turned off barney. I now want
to make barney a backup to ralph (so ralph would be the master).
On Tuesday 22 February 2005 09:08 am, Johan Jonkers wrote:
I was wondering if there is a way to specify how verbose the logfile
should be in my.cnf. I've tried searching the manual and google, but
have not yet found anything (besides the -v commandline option but thats
not it). Any helpd
On Friday 18 February 2005 11:28 am, Nestor Florez wrote:
TO back up the databases in Mysql, isn't there a way where you can just
copy somefiles to another directory and in essence you have a backup? I
thought I read this somewhere
mysqlhotcopy does this for myisam tables, there is a hot
On Thursday 17 February 2005 09:41 am, Ian Meyer wrote:
When trying to connect, it fails with the message:
'MySQL Error Number 1045
Access denied for user 'user'@'192.168.2.103' (using password: YES'
The 192.168.2.103 is your tip that its not using a host. grant
[EMAIL PROTECTED] and things
On Thursday 17 February 2005 11:46 am, Ian Meyer wrote:
I wish we could do that, however, it's not an option as we use DHCP.. so
the IP's change, yet the hostname does not. Besides, that's just a cheap
way to avoid fixing the problem when it should work to begin with. Our
access tables are
On Thursday 17 February 2005 12:29 pm, Ian Meyer wrote:
You have a server thats on DHCP? Well, your problem is dhcp I am sure..
But good luck with that horror flick.
Our servers IPs are static, as is the DNS in /etc/resolv.conf
Then you need to make sure its compiled to the right glibc..
On Monday 14 February 2005 03:52 am, Ben Clewett wrote:
I am having a lot of problems deleting a large amount of data. Say 20GB
from a 40GB table. I seem to get failure quite a lot (due NOT to mysql,
but bad hardware), then MySQL roles back the transaction, which takes as
many hours and
On Tuesday 08 February 2005 03:32 pm, Emmett Bishop wrote:
is it possible to force a field to be NOT NULL but not
have any default value (I.E the insert statement must
explicitly provide data for the field in question)?
of course: col1 int not null
Jeff
pgpKRoQG6Ktfo.pgp
Description: PGP
On Friday 04 February 2005 09:51 am, shaun thornburgh wrote:
I have a table where users upload various data items via a web site. Some
fields in the table are named DATA_ENC... to denote that the data should be
encrypted uusing the encode function. This all works fine, however when I
come to
On Friday 04 February 2005 11:00 am, shaun thornburgh wrote:
Apparently not!
mysql SELECT DECODE ( CSV_DATA_ENC_FORENAME, test_password ) FROM
DATA_TABLE_PID_1_DESC_137;
Is it so hard to read directions?
select decode(csv_data_enc_forename) from DATA_TABLE_PID_1_DESC_137;
This assumes
On Friday 04 February 2005 03:31 pm, John Trammell wrote:
In my version of MySQL (4.1.9), your sample code generates an error:
mysql select decode(encode(foo));
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the
On Wednesday 22 December 2004 09:28 pm, Ney André de Mello Zunino wrote:
I have just obtained that conclusive evidence. The MySQL installer is
indeed messing up the type of the /Path/ value on the registry, changing
it from REG_EXPAND_SZ to REG_SZ. The problem will only take place when
you
On Wednesday 22 December 2004 12:02 pm, Philip Barlow wrote:
I am working on a query that was built for Oracle databases but I need
to make it compatible with MySQL. Basically I need to convert or cast an
INT as a CHAR. The Oracle query just uses TO_CHAR() to achieve this but
I am stumped in
On Thursday 23 December 2004 02:01 pm, Bryan Heitman wrote:
Hi Sergio,
All of your suggestions deal with key optimization, I do not believe I have
a key issue here. Remember that select count(*), an index-only query
returns in .06 seconds which is very quick. The real question, is why does
On Thursday 09 December 2004 09:49 am, Patrick Marquetecken wrote:
I have 3 snort sensors logging to a central mySQL database after two weeks
the size of the database is about 3.3GB and the machine is getting slow, as
i'm not used to be working with mySQL is my question how far can i go
On Thursday 09 December 2004 01:06 pm, Patrick Marquetecken wrote:
and for ansewring Jeff Smelser i have installed mysql 4.x on linux and then
dit from the commandline create database and then run the create table
commands from snort.
No idea.. you can do a show create table db.table to find
On Tuesday 07 December 2004 06:41 am, Ronan Lucio wrote:
Hi,
Has anyone any benchmark between 4.0 and 4.1?
MySQL website says that version 4.0 has some performance
improvements but I´ve heard that MySQL-4.0 is 20% faster
than MySQL-4.1.
As far as what? Thats a very general statement. How
On Tuesday 07 December 2004 12:58 pm, Ronan Lucio wrote:
The following thread appeared in the FreeBSD list:
snip
Once I plan to run FreeBSD-5.3 + MySQL-4.1.7 in my server, it can
affect me.
I may have missed it, but myisam, or innodb?
Jeff
pgpSqggIBC6My.pgp
Description: PGP signature
On Tuesday 07 December 2004 01:22 pm, Ronan Lucio wrote:
Both, because I have tables that have few inserts and too few
updates/deletes,
like states, cities and so on, but I plan transform every table in InnoDB
to avoid corruption issues.
Nothing here has slowed down. A few innodb stuff I
On Tuesday 07 December 2004 01:56 pm, Ronan Lucio wrote:
Actually, I´ve never had such problem.
I´m just afraid of it because I´ve read some issues about corruption
in MySQL tables and the own MySQL Manual says that exist a command
just to repair MyISAM tables (myisamchk -
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will kill an
index.
Jeff
pgpsVFJcgS9kp.pgp
Description: PGP signature
On Tuesday 07 December 2004 02:51 pm, you wrote:
mysql explain select * from queryLog where date_format(queryTime,
'%Y-%m-%d') =
'2004-11-16';
mysql explain select * from queryLog where queryTime =
date_format('2004-11-16'
, '%Y-%m-%d');
On Tuesday 30 November 2004 04:44 pm, Greg Macek wrote:
OK, sounds like what I should do is the following:
* Upgrade current mysql install (3.23.49) to latest stable 4.0 series
(4.0.22 according to the website)
* Test out all applications and make sure everything is working as
expected.
*
On Monday 29 November 2004 11:35 pm, Greg Macek wrote:
I was thinking about this as well, but was hoping to minimize the amount
of work I would have to do. However, if this makes the most sense for
upgrading, perhaps this is what I'll do.
Actually, I think you will be minimizing going the 4.0
On Tuesday 30 November 2004 01:36 pm, Steve Grosz wrote:
I had installed MySql on Win2003, and when I check the 'server
information' page, it shows a IP of 127.0.0.1. The IP of the server has
a 192.x.x.x address.
Change the line below in my.cnf to what you need.. Its binding to 127 ip.
#
On Monday 29 November 2004 09:01 am, Greg Macek wrote:
I am actually in the process of planning a similar upgrade for our
database server. None of our databases are that big, but was wondering
about what gotcha's I should be on the lookout for. I planned on
walking through the upgrade pages
On Wednesday 24 November 2004 04:02 am, Heikki Tuuri wrote:
Only two ways to make copies of innodb.. mysqlhotcopy (its not free)
mysqlhotcopy is free, but it works only for MyISAM.
See:
http://dev.mysql.com/doc/mysql/en/Backing_up.html
Sorry, I meant the hot backup tool for innodb.. ;)
On Wednesday 24 November 2004 07:32 am, Hristo Chernev wrote:
How to upgrade from 3.23.58 to 4.1.7? Which is the easiest way with minimal
risk and downtime?
Yeah right.. ;)
Background: Heavy loaded mysql server, only one database but it is huge -
5GB.The database is replicated to another
On Tuesday 23 November 2004 02:12 pm, Titus wrote:
I have converted some tables from MyISAM to INNO
using an ALTER TABLE statement. It seems to work
fine. However, when I copy that database to another
directory for purposes of backup, a subsequent 'use'
statement on the backup directory
On Monday 22 November 2004 04:15 pm, Santino wrote:
I can confirm it anyway: I think we have a bug.. Unless someone else see
something, might want to take this to bugs.mysql.com
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 578 to server version:
On Sunday 21 November 2004 08:38 am, Dayakar wrote:
Can any one help me in creating view using mysql4.1. If we cannot then any
other alternative. It would be great if anyone give me an example for that.
Thats a 5.0 feature.. Your not gonna get to far with 4.1..
Jeff
--
On Tuesday 16 November 2004 02:15 pm, William R. Mussatto wrote:
I had a similar problem with DBI/DBD. The solution I used was to create
the passwords using OLD_PASSWORD('plaintextPassword') function
Look at http://dev.mysql.com/doc/mysql/en/Password_hashing.html for the
details as well as
On Monday 15 November 2004 11:30 am, [EMAIL PROTECTED] wrote:
I am running mysql version 4.1.7 on SuSE professional 9.1.
I run 4.0.22
I have a MyISAM table which I use for syslog messages. This table gets
about 40-70 inserts a second with peaks of over 400 inserts a second. I am
using
On Monday 15 November 2004 03:25 pm, Jeff Smelser wrote:
insert delayed is a myth.. Least in the 4.1 version. 4.1.18 it was taken
out.
Course thats 4.0.18.
pgpBoy3BGuPlh.pgp
Description: PGP signature
On Sunday 14 November 2004 11:34 am, Robb Kerr wrote:
I'm posting to test a new newsgroup client. Please post several replies.
Does it work with mysql?
Just curious.
Jeff
--
===
Jabber: tradergt@(smelser.org|jabber.org)
On Sunday 14 November 2004 05:05 pm, kalin mintchev wrote:
can somebody please explain what is wrong with this command:
select t1.data from table1 as t1 where t1.zip=(select * from table2 as t2
where t2.chain like %carmike%);
If your no usiing 4.1, subselects are not even allowed..
If so..
On Tuesday 09 November 2004 11:49 am, ian douglas wrote:
My bad, I wasn't running START SLAVE to get them going. Seems odd that
this has to be done manually.
I never do.. once its started, it should be fine.. Your just getting errors
making it stop.
Also, overnight, my slaves reported this
On Tuesday 09 November 2004 03:23 pm, ian douglas wrote:
GRANT SUPER,REPLICATION CLIENT to 'syscheck'@'mywebserver.domain.org'
IDENTIFIED BY 'mypasswd' ;
I have no idea how this script is gonna help, but your having permission
problems. The last message you wrote was permission problems as
On Thursday 04 November 2004 02:28 pm, Scott Hamm wrote:
create table account (
ID int auto_increment,
Date date,
Check_Number int(5),
Bank_Match int enum(0,1),
Category varchar(20) no null,
Credit decimal(7,2),
Debit decimal(7,2),
Balance decimal(7,2),
primary key (ID)
);
Its pretty
On Wednesday 03 November 2004 09:59 am, Yves Goergen wrote:
Ehm - what please is the difference between MySQLCC and MySQL
Administrator? And what is Query Browser again? It's confusing to have
three products that all do the same.
No, they are not all the same..
MySQLCC is depricated..
MySQL
On Wednesday 03 November 2004 02:43 pm, Mark Hennessy wrote:
I have three mail servers, on each is a MySQL DBMS. I want to set up a
replication ring between the three MySQL DBMS on these machines so they
will constantly share the same data in near real-time. But, the chance
exists that any
On Thursday 14 October 2004 02:45 pm, Stuart Felenstein wrote:
Apparently, mysql does not like the format
MM/DD/
Then again I tried it around , still no dice.
It's intended to go into a Date column.
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
All, you every need to
On Thursday 14 October 2004 03:12 pm, Stuart Felenstein wrote:
Thanks , I know the page and have the links
bookmarked!
So you got the answer from it right?
Jeff
pgpSsmcBOJscM.pgp
Description: PGP signature
On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote:
No :),. cause it seems that those formats are for
outbound, db -.
I was looking for the other direction.
Huh? It really doesnt matter does it? They work either way..
I use those functions all the time for inbound..
Jeff
On Thursday 14 October 2004 03:46 pm, [EMAIL PROTECTED] wrote:
For values headed into a SQL statement, use whatever functions are
available to you in the language (PHP, PERL, Python, Java, VB Script,...)
you are using to accept the user's input in order to make the commands you
send MySQL
On Thursday 14 October 2004 04:00 pm, Mike Johnson wrote:
It does matter, though. You can't use DATE_FORMAT() to translate
'10/14/2004' into '2004-10-14.'
No, your right, that would be wrong.
It looks like what the poster wants is STR_TO_DATE() (a la
STR_TO_DATE('10/14/2004', '%m/%d/%Y'),
On Wednesday 13 October 2004 10:33 am, Ulrich Seppi wrote:
Hello people,
does anybody know if Foreign keys increase the performance of select
querys? example.
DB1 has only INNODB tables.
DB2 has the same structure as DB1 with all possible foreign keys.
Huh? You might want to read what a
On Monday 11 October 2004 11:57 am, Massimo Petrini wrote:
I my network I have 1 master and 4 slaves. I need to squeeze the innodb on
my master; which is the correct way to execute the squeeze action (now the
innodb files is around 1gb, while in a new db is around 300 mB)
thanks
There isnt
On Wednesday 06 October 2004 02:10 pm, Scott Hamm wrote:
Like I said before it seems to group by threads. Therefore, it is
close enough.
Right! thats why Microsoft thrives. Because as long as it appears to work, its
all good.. :)
Jeff
pgpAXe4d5h6QD.pgp
Description: PGP signature
On Tuesday 05 October 2004 01:14 pm, Ed Lazor wrote:
Does anything need to be done to my data while upgrading the server from
3.23 to 4.0.21?
Whats the deal and this list? No one can ever just hit new message, they
always hit reply and put a new subject in..
Geez.. This list is horrible with
On Tuesday 05 October 2004 01:55 pm, you wrote:
We're not perfectionist like you. :)
Actually its proper email etticate.. look it up if you don't believe me..
Jeff
pgpjB48FEXyL0.pgp
Description: PGP signature
On Tuesday 05 October 2004 01:56 pm, David Brodbeck wrote:
Saves having to retype the list address, or look it up. I don't see what
difference it makes...
Click on the email, on mine, it brings up a nice to empty message with the
email address..
Jeff
pgp50O9uZVT4t.pgp
Description: PGP
On Tuesday 05 October 2004 02:23 pm, David Brodbeck wrote:
Well, that's nice...
Hmm
I just don't see what difference it makes. As far as I can see, the
outcome is identical either way...
Cause your doesnt support threads.. Outlook was the only one I knew off that
did not.
Jeff
On Tuesday 05 October 2004 02:39 pm, Scott Hamm wrote:
If you sort it by conversation topic, then it will seem to group by
threads.
I'm running Outlook 2000.
Seem.. Thats the key word.. Its not true threading support..
These are not there for looks..
References:
[EMAIL PROTECTED]
On Monday 04 October 2004 01:18 am, Batara Kesuma wrote:
I have a cron running this every night.
DELETE message_inbox FROM message_inbox LEFT JOIN message ON message.id
= message_inbox.message_id WHERE message.id IS NULL
Message table also has about the same amount of rows.
I notice that
On Tuesday 28 September 2004 01:02 pm, Ed Lazor wrote:
I usually create an index for each criteria being checked against in the
SQL statements.
For example, for this query
Select * from products where ProductID = 'aeg8557'
I'd create an index on ProductID. The same thing applies if you're
On Thursday 23 September 2004 04:44 am, Patrick Connolly wrote:
Last week, I asked this list had others had problems contacting MySQL
AB. I promptly received a short note from
[EMAIL PROTECTED]
It suggested I could respond to that address which I tried to do, but
I get this:
- The
On Sunday 05 September 2004 11:44 am, Leandro Melo wrote:
Hi,
how can i make a back of the data in my database?
check out mysqldump
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: Nothing fails like prayer. -- Annie
On Saturday 14 August 2004 01:06 am, [EMAIL PROTECTED] wrote:
mysql mysqldump b
- c:/hdump/dump.sql
Do it from the command line, not mysql command prompt.
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: We don't
On Wednesday 04 August 2004 06:44 am, Odhiambo Washington wrote:
Is there hope for me in this situation??? I have googled and googled but
all that I see doesn't seem to help me to recover the data in the table.
This makes me very desparate.
I'd be very thankful for any pointers that would
On Tuesday 03 August 2004 01:11 pm, Jon Drukman wrote:
We were having terrible problems with a master/slave setup. The master
does a huge amount of writes, and the slave simply started lagging
behind, despite both machines being identical hardware-wise. This made
the application basically
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 05 July 2004 06:07 pm, Gary Mack wrote:
Hi there,
I am having trouble converting a timestamp from mySQL to the US Format
mm/dd/. Can someone please help. I am also having trouble converting
-mm-dd into a normal mm/dd/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 12:10 pm, J S wrote:
Hi,
I would like to switch off the logging that creates the large files below
(in the mysql data directory)
Could someone tell me how to do this please?
take out log-bin from my.cnf. But you better
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 12:46 pm, J S wrote:
Thanks for your reply.
By replication do you mean do I have tables with duplicate rows? If that's
the case then I do have one table with duplicate rows.
No.. Replication, meaning, you have the same
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 30 June 2004 01:09 pm, Jeff Smelser wrote:
On Wednesday 30 June 2004 12:46 pm, J S wrote:
Thanks for your reply.
By replication do you mean do I have tables with duplicate rows? If
that's the case then I do have one table
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 24 June 2004 12:15 pm, Jim Shea wrote:
I'm setting up a cron job to run myisamcheck with the options
-Aacmorv. As I have to put in a username and password, for security I
want to create a special account that has the minimum required
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:05 am, Mike Miller wrote:
Unless you have a specific need for it, you could save yourself a lot of
trouble by putting select tables or databases or even clients on each
server. This also means you don't incur the added
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 12:52 pm, Michael McTernan wrote:
Dear Mark,
The best way to fix this is by correctly setting your from address in your
mailer to [EMAIL PROTECTED]
Your email software seems to be wrong. All these people can't be doing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 03:00 pm, Kairam, Raj wrote:
After unzipping and untarring the DBD-mysql-2.9003.tar.gz ( obtained from
CPAN ), in the DBD-mysql-2.9003 directory I tried the following
mkdir /tmp/mysql-static
cp /usr/lib/mysql/*.a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 June 2004 11:48 pm, Tom Williams wrote:
Hi! I'm trying to build MySQL 4.0.20 on RedHat 5.2 (I think) Linux
system with glibc-2.2.5 and gcc-3.4.0 (which I recently upgraded to).
The compile runs smoothly, but make test fails. Here is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 15 June 2004 10:43 am, Carlos Sunden wrote:
I am not completely sure what this is although I've read about it.
www.innodb.com.. Gives you all the info you can handle.
Jeff
- --
Not quite human any longer.
-BEGIN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am trying to prune some bin-logs and noticed:
mysql show master logs;
++
| Log_name |
++
| db-bin.001 |
| db-bin.002 |
| db-bin.003 |
| db-bin.004 |
| db-bin.005 |
| db-bin.006 |
| db-bin.007 |
| db-bin.008 |
| db-bin.009
1 - 100 of 122 matches
Mail list logo