I have an production MySQL-Max -3.23.54a server running innodb databases.
I've migrated the server and data from an older Linux installation (with
max filesize 2GByte). The new server is running Linux 2.4 and can deal
with larger files.
I have three in innodb_data files and the last one is autoex
On Fri, 15 Nov 2002, Admin-Stress wrote:
> I tried --skip-networking, but then mysqld could not be started. I got this from
>google.com. Is it
> the correct way?
It's correct. Put this in your /etc/my.cnf and restart mysql.
[mysqld]
skip-networking
/Lars
---
At 13:47 2002-11-13 -0500, Rick Root wrote:
[root@frodo MySQL]# rpm --install MySQL-3.23.53a-1.i386.rpm
error: failed dependencies:
MySQL conflicts with mysql-3.23.41-1
MySQL-server conflicts with mysql-server-3.23.41-1
[root@frodo MySQL]# rpm -U MySQL-3.23.53a-1.i386.rpm
error: fa
Hi,
Today I had a crash on my production server running Max-3.23.53a
It has the following specifications
MySQL-Max3.23.53a
RedHat 7.3
Kernel 2.4.18-SMP
Glibc-2.2.5-42
2GB of memory
When I resolv my stack_dump I get the following. Can anyone make something
useful out of this? I
n Thu, 31 Oct 2002, Jan Steinman wrote:
> >From: Lars Andersson <[EMAIL PROTECTED]>
> >
> >Thanks for your advices, but I don't want to solve this problem on the
> >OS/shell level.
>
> Assuming MySQL is installed properly, with its own user and group, I do
I can stop the users from filling up the
disks.
-- lars
On Thu, 31 Oct 2002, gerald_clark wrote:
> You may have a malformed join that is giving you a very large result set.
> These would be the temporary tables.
>
> Lars Andersson wrote:
>
> >Hi,
> >
> >I manage
usr/local/bin/perl
> use strict;
> my @files=(`/bin/ls /tmp/sql*.M*`);
> for (@files) {
> unlink;
> }
> exit 0;
>
>
> shell> crontab -e
>
> 0 2 * * * /usr/local/bin/perl /path/to/delete/program
>
> :wq
>
> :)
> -Original Message-
> From:
Hi,
I manage a mysql server with a few hundred users. All of a sudden mysql
has started to put large files in /tmp
I've never noticed this behavior before. The files looks like this
-rw-rw1 mysqlmysql3788431360 Oct 31 17:49 #sql420e_36b82b_1.MYD
-rw-rw1 mysqlmysql
he size it would
have if it had grown to it maximum size.
/Lars
On Fri, 18 Oct 2002, Lars Andersson wrote:
> I have a question about innodb, some of my users get an error code 1114
> saying that a table on an innodb database is full.
>
> When I do a show table status i get the follow
I have a question about innodb, some of my users get an error code 1114
saying that a table on an innodb database is full.
When I do a show table status i get the following size comments (all
tables display one or another of these two).
Comment: InnoDB free: 5849088 kB; InnoDB free: 3072 kB
Commen
I wonder if anyone knows when 3.23.53a will be released? I don't need an
exact time, just if it's due today, tomorrow or next week.
Regards
/Lars
-anti-spam-workaround sql query
-
Before posting, please check:
http://www.m
I had the same problem with 4.0.4, I downgraded to 3.23.52 because I
thought it was something with the unstable version. Is 4.0.4 also built
against the same static glibc?
regards
/Lars
>This problem is due to the glibc used by mysql AB for building binary ...
>
>Have a look to mysql 3.23.53 c
Wed, 16 Oct 2002, Lars Andersson wrote:
> I'm managing two database servers, one 3.23.52 and one 3.23.52-Max
> (using innodb tables on that one).
>
> They are both running along fine until they suddently start to
> accumulate a lot of treads (a lot ~= 200-300), the state o
I'm managing two database servers, one 3.23.52 and one 3.23.52-Max
(using innodb tables on that one).
They are both running along fine until they suddently start to
accumulate a lot of treads (a lot ~= 200-300), the state of these
threads is mostly "closing" and "opening" tables. This drives up t
My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries
per second avg: 0.700) the last time it acted up. By the way, it is a dual
CPU machine. On another machine with only one CPU running exactly the same
code and relese of FreeBSD I havent seen this problem.
/Lars Andersson
I have experienced the same problems on a dual processor machine running
4.2-STABLE and mysql 3.23.36 from the ports tree.
regards,
Lars Andersson
At 16:03 2001-04-09 -0400, Andrew Schmidt wrote:
>Have you tried this under a 'stable' version of freebsd?
>
>In FreeBSD 4.
I´ve got a problem. If I try to change max_connections in /etc/my.cnf the
server refuses to start? Isnt I supposed to put startup variables to MySQL
in this file?
A file looking like this works
[mysqld]
#max_connections=200
log
log-bin
log-slow-queries
server-id=1
but as soon as I remove the c
I want your comments regarding a replication and high-availability setup.
This is the setup:
Load balancer
+---+
| Foundry |
| ServerIron |
| |
+---+
/ \
/ \
18 matches
Mail list logo