From: Johnny Stork [li...@openenterprise.ca]
Sent: Wednesday, May 06, 2009 1:03 PM
Cc: mysql@lists.mysql.com
Subject: Re: Problems After MySql 5.1.34
Typo, moved from 5.0.67 to 5.1.34
Johnny Stork wrote:
I recently upgraded an asterisk/trixbox server to mysql 5.1.34 from
5.64
I have a simple master-slave replication setup. Nothing very interesting
as far as I know, both running identically configured 5.1.31 using
'mixed' replication.
I have a couple of issues which I assume are related, although I suppose
they might not be:
1) When the monitoring showed that
Hi Roland,
I wanted to know if you face the sae problems that i've faced or u get
somethng else.
@ Ian
I've already done that. I will do what Roland told me to, lets hope i have
some luck this time around.
On Wed, Mar 25, 2009 at 2:15 AM, Rolando Edwards redwa...@logicworks.netwrote:
Ever
for the server configuration wizard. i typed the password
required and the problems started.
1. It couldnot install mysql as a service, named MySQL, although there is no
service with that name. i checked with the service option in control panel.
2. I went back and installed it with the service name MySQL5
redwa...@logicworks.net
-Original Message-
From: Manish Gupta [mailto:manish.in@gmail.com]
Sent: Tuesday, March 24, 2009 4:05 PM
To: mysql@lists.mysql.com
Subject: Installation Problems
I had MySQL 4.0.
Today i downloaded the recent version, mysql5.12.32-Win32 installer.
I deleted
Hello there guys,
Latelly our database server is going into a very big problem, our current
configuration (is in an attachment file), is having huge load of leak memory
and a variable *innodb_log_file_size *is off cause when i up it the mysqld
doesn't start, our server is having this
Claudio,
http://www.mysqlperformanceblog.com/2007/10/29/hacking-to-make-alter-table-online-for-certain-changes/
Your mileage may vary, use at your own risk, etc.
Basically: convince MySQL that the indexes have already been built but
need to be repaired, then run REPAIR TABLE. As long as the
Hi Baron,
I need to try some trick like that, a sort of offline index building.
Luckily I have a slave on that is basically a backup server.
Tomorrow I am going to play more with the dude.
Do you think that there would be any improvement in converting the table
to InnoDB
forcing to use multiple
Be careful with using InnoDB with large tables. Performance drops
quickly and quite a bit once the size exceeds your RAM capabilities.
On Mar 1, 2009, at 3:41 PM, Claudio Nanni wrote:
Hi Baron,
I need to try some trick like that, a sort of offline index building.
Luckily I have a slave on
Subject: MyISAM large tables and indexes managing problems
Hi,
I have one 15GB table with 250 million records and just the primary key,
it is a very simple table but when a report is run (query) it just takes
hours,
and sometimes the application hangs.
I was trying to play a little with indexes
experience problems in managing a simple MyISAM table with
250
million records and a primary key?
I tried also to duplicate the table, add indexes and insert into it
(also
using INNODB for the new table) but it is really
taking ages everytime. And I had to move the 'tmpdir' to the data
anybody experience problems in managing a simple MyISAM table with 250
million records and a primary key?
I tried also to duplicate the table, add indexes and insert into it (also
using INNODB for the new table) but it is really
taking ages everytime. And I had to move the 'tmpdir' to the data
experience problems in managing a simple MyISAM table with 250
million records and a primary key?
I tried also to duplicate the table, add indexes and insert into it (also
using INNODB for the new table) but it is really
taking ages everytime. And I had to move the 'tmpdir' to the data partition
because
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Friday, February 27, 2009 4:43 PM
To: mysql@lists.mysql.com
Subject: MyISAM large tables and indexes managing problems
Hi,
I have one 15GB table with 250 million records and just the primary key,
it is a very
This is a known bug, Ive installed MySQL 4 client binaries as a work
around...
_
From: Andy Smith [mailto:[EMAIL PROTECTED]
Sent: 2008-10-30 18:26
To: 'mysql@lists.mysql.com'
Subject: mysql dump problems, no data dumped
Im having an issue using mysqldump to dump a DB from comercial
Hi Rick,
ok sorry, heres a bit more detail, and I see some more useful stuff I
didn't see before too (I still duno whats wrong but guess will be helpful to
those more knowledgeable!).
I believe its using InnoDB for the tables, previously I was seeing an error
24 which from digging around can
Hi,
Im having an issue using mysqldump to dump a DB from comercial app which
includes mysql 4.0.18-pro. It doesnt however include mysql dump for online
backups so Im using the one installed by default in my linux dist which as
you can see below is version 10.11. My problem is that the dump is
Hi,andy.
Can you show me the details about the options of mysqldump to be used ?
On Fri, Oct 31, 2008 at 1:25 AM, Andy Smith [EMAIL PROTECTED] wrote:
Hi,
Im having an issue using mysqldump to dump a DB from comercial app which
includes mysql 4.0.18-pro. It doesnt however include mysql
what command are you using to do the dump? I mean the entire command,
including all the options.
On Thu, Oct 30, 2008 at 12:25 PM, Andy Smith [EMAIL PROTECTED] wrote:
Hi,
Im having an issue using mysqldump to dump a DB from comercial app which
includes mysql 4.0.18-pro. It doesnt however
Hi there,
We've installed a MySQL NDB Cluster which is running fine.
There are two Cisco CSM loadbalacer which shall distribute the workload over
the query nodes.
The loadbalancers also are doing TCP probes to the MySQL Ports (3306) on both
querynodes.
Each such probe generates a
I'm loading the data through the command below mysql -f -u root -p
enwiki enwiki.sql
The version is MySQL 5.0.51a-community
I've disabled the primary key, so there are no indexes. The CPU has 2
cores and 2 Gigs memory.
The import fell over overnight with a table full error as it hit 1T (I
Simon,
Why dont u split the file and use LOAD DATA INFILE command which would
improve the performance while loading into an empty table with keys
disabled.
regards
anandkl
On 6/5/08, Simon Collins [EMAIL PROTECTED] wrote:
I'm loading the data through the command below mysql -f -u root -p
You could load the data into several smaller tables and combine them
into a merged table which would have no real effect on the schema.
Ade
Simon Collins wrote:
I'm loading the data through the command below mysql -f -u root -p
enwiki enwiki.sql
The version is MySQL 5.0.51a-community
I've
I can do - if the load data infile command definitely improves
performance and splitting the file does the same I have no problem with
doing this. It just seems strange that it's problems with the way the
import file is configured. I thought the problem would be somehow with
the table getting
PROTECTED]gt; wrote:
From: Simon Collins lt;[EMAIL PROTECTED]gt;
Subject: Re: Large import into MYISAM - performance problems
To: mysql@lists.mysql.com
Date: Thursday, June 5, 2008, 3:05 PM
I#39;m loading the data through the command below mysql -f -u root -p
enwiki lt; enwiki.sql
The version
] wrote:
I can do - if the load data infile command definitely improves
performance and splitting the file does the same I have no problem with
doing this. It just seems strange that it's problems with the way the
import file is configured. I thought the problem would be somehow with
the table
At 10:30 AM 6/5/2008, you wrote:
Simon,
In my experience load data infile is a lot faster than a sql file htrough
the client.
I would parse the sql file and create a csv file with just the columns of
your table and then use load data infile using the created csv file
Olaf
Olaf,
Using
Olaf, Mike
Thanks for the input, the blob data is just text, I'll have a go at
using the load data command
Regards
Simon
mos wrote:
At 10:30 AM 6/5/2008, you wrote:
Simon,
In my experience load data infile is a lot faster than a sql file
htrough
the client.
I would parse the sql file
Even more when you compare to a script executing the inserts, instead the
mysql client...
Olaf
On 6/5/08 12:06 PM, mos [EMAIL PROTECTED] wrote:
At 10:30 AM 6/5/2008, you wrote:
Simon,
In my experience load data infile is a lot faster than a sql file htrough
the client.
I would parse
Dear all,
I'm presently trying to import the full wikipedia dump for one of our
research users. Unsurprisingly it's a massive import file (2.7T)
Most of the data is importing into a single MyISAM table which has an id
field and a blob field. There are no constraints / indexes on this
table.
Hi Simon,
How ur doing this import into ur table.
On 6/4/08, Simon Collins [EMAIL PROTECTED] wrote:
Dear all,
I'm presently trying to import the full wikipedia dump for one of our
research users. Unsurprisingly it's a massive import file (2.7T)
Most of the data is importing into a single
Simon,
As someone else mentioned, how are you loading the data? Can you
post the SQL?
You have an Id field, so is that not the primary key? If so, the
slowdown could be maintaining the index. If so, add up to 30% of your
available ram to your key_bufer_size in your my.cnf file
Hi,
Break up the file into small chunks and then import one by one.
On Wed, Jun 4, 2008 at 10:12 PM, Simon Collins
[EMAIL PROTECTED] wrote:
Dear all,
I'm presently trying to import the full wikipedia dump for one of our
research users. Unsurprisingly it's a massive import file (2.7T)
Hmmm...
no more ideas or suggestions anybody? :(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I can connect to a SQL server in the following way from my windows OS machine:
Start -- control Panel -- Administrative tools --- Data Sources(ODBC)
and provide the necessary input. This works for me without problems.
I have installed xamp sw on this window machine. The SW version
Padiyath Sreekumaran schrieb:
?php
$dsn=asi_qms;
$username=asi_qms_2006;
$password=something;
$server=xxx;
if(!$handle = odbc_connect($dsn, '$username', '$password')) die('Keine
Verbindung möglich!');
?
I got the following error when I execute the previous script:
Warning: odbc_connect()
Padiyath Sreekumaran schrieb:
Hello Sebastian,
Thanks for your mail. But I donot see any difference in my $username and yours
except
'().
what surprise, yes, thats it!
you have to use no quotes at all (or doublequotes) around variables, RTMF is
this case the one from PHP
but what has
problems on Windows XP
Hello,
I can connect to a SQL server in the following way from my windows OS
machine:
Start -- control Panel -- Administrative tools --- Data
Sources(ODBC)
and provide the necessary input. This works for me without problems.
I have installed xamp sw on this window machine
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 24, 2008 10:01 AM
To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com
Subject: RE: Php-mssql connection problems on Windows XP
When using odbc_connect, you don't use the DSN you've previously
created
Eric Bergen schrieb:
TCP checksums aren't as strong as encryption. It's rare but corruption
can happen.
But it happens every other day? that means at least one error in 4GB of
data (I have around 2GB of binlogs/day)?
Every DVD-ISO you download would be corrupt (statistically)?
Where are
Eric Bergen schrieb:
Hi Jan,
You have two separate issues here. First the issue with the link
between the external slave and the master. Running mysql through
something like stunnel may help with the connection and data loss
issues.
I wonder how any corruption could happen on a TCP
TCP checksums aren't as strong as encryption. It's rare but corruption
can happen.
Where are you reading the positions from and how are you taking the
snapshot to restore the slave?
On Mon, Apr 21, 2008 at 12:30 AM, Jan Kirchhoff [EMAIL PROTECTED] wrote:
Eric Bergen schrieb:
Hi Jan,
.
As this server has no other problems like crashing programs, kenrel
panics, corrupted files or such, I am pretty sure that the hardware is OK.
the slave's log:
Apr 15 06:39:19 db-extern mysqld[24884]: 080415 6:39:19 [ERROR] Error
reading packet from server: Lost connection to MySQL server during
hangs once every two days.
As this server has no other problems like crashing programs, kenrel
panics, corrupted files or such, I am pretty sure that the hardware is OK.
the slave's log:
Apr 15 06:39:19 db-extern mysqld[24884]: 080415 6:39:19 [ERROR] Error
reading packet from server: Lost
Hi all,
I am having problems with the following issue.
Since couple of days ago, we got signs from our customers that website
'feels' very slow.
One of our tests is IQ test. For this one, timing is crucial and it is
unacceptable that test takes longer (because of slow site) - as it working
2008/3/28 Aleksandar Skodric [EMAIL PROTECTED]:
Hi all,
I am having problems with the following issue.
Since couple of days ago, we got signs from our customers that website
'feels' very slow.
One of our tests is IQ test. For this one, timing is crucial and it is
unacceptable
Howdy -- new to the list.
BigCorp has a Bugzilla database that uses version 4.1.7-standard.
We've been taking backups using mysqldump. I thought to verify a
backup, in essence by
mysqldump bugzilla B
mysql test B
mysqldump test T
diff B T
Everything is the same, except that
I had a bit of BFOTO and tried simple inserts.
mysql create table t (f timestamp);
Query OK, 0 rows affected (0.00 sec)
mysql insert into t values ('2008-03-04 16:17:00');
Query OK, 1 row affected (0.00 sec)
mysql select * from t;
+-+
| f
[snip]
I had a bit of BFOTO and tried simple inserts.
mysql create table t (f timestamp);
Query OK, 0 rows affected (0.00 sec)
mysql insert into t values ('2008-03-04 16:17:00');
Query OK, 1 row affected (0.00 sec)
mysql select * from t;
+-+
On Tue, 4 Mar 2008, Jay Blanchard [EMAIL PROTECTED] wrote:
[snip]
I had a bit of BFOTO and tried simple inserts.
mysql create table t (f timestamp);
Query OK, 0 rows affected (0.00 sec)
mysql insert into t values ('2008-03-04 16:17:00');
Query OK, 1 row affected (0.00 sec)
[snip]
The column type needs to be DATETIME.
Thank you for pointing me at TIMESTAMP versus DATETIME. I'll read
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-types.html
thoroughly when I can.
Can you give a little more detail as to why DATETIME is necessary?
[/snip]
It was much too
On Tue, 4 Mar 2008, Jay Blanchard [EMAIL PROTECTED] wrote:
It was much too quick a reply on my part but it is my understanding
that a TIMESTAMP field is updated according to server time and you
cannot actually insert a value. I may be wrong as I have never
tested this.
Even in pre-4.1
glenn
Union is 4.0 feature.
david
Notwithstanding end-of-life status, is there an issue in MySQL
v3.23 r.e. the union operator?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with the sample queries provided in the documentation:
mysql SELECT REPEAT('a',1) UNION SELECT
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote:
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with the sample queries provided in the
Jim Winstead wrote, On 1/11/2008 12:54 PM:
On Fri, Jan 11, 2008 at 12:28:05PM -0800, Glenn Gillis wrote:
Notwithstanding end-of-life status, is there an issue in MySQL v3.23
r.e. the union operator?
My installation returns a syntax error on any query containing the union
operator, even with
hi, i got a problemas in mysql with suse 10 enterprise server, the error:
#1064 - 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.
when i treat to create a new data base, appears this message.
mario henriquez wrote:
hi, i got a problemas in mysql with suse 10 enterprise server, the error:
#1064 - 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.
when i treat to create a new data
?
Regards,
Amit Sharma
E: [EMAIL PROTECTED]
M: +91 9971 490 700
W: www.affle.co.uk
-Original Message-
From: Victor Subervi [mailto:[EMAIL PROTECTED] ]
Sent: 20 December 2007 22:57
To: mysql@lists.mysql.com
Subject: Problems Adding User
Hi
Hi;
I can create the following just fine:
grant all on data1.* to myuser IDENTIFIED BY 'pass';
grant all on data2.* to myuser IDENTIFIED BY 'pass';
...but when I try this:
CREATE USER myuser IDENTIFIED BY 'pass';
ERROR 1396 (HY000): Operation CREATE USER failed for 'myuser'@'%'
...and this:
:57
To: mysql@lists.mysql.com
Subject: Problems Adding User
Hi;
I can create the following just fine:
grant all on data1.* to myuser IDENTIFIED BY 'pass';
grant all on data2.* to myuser IDENTIFIED BY 'pass';
...but when I try this:
CREATE USER myuser IDENTIFIED BY 'pass';
ERROR
: Problems Adding User
Hi;
I can create the following just fine:
grant all on data1.* to myuser IDENTIFIED BY 'pass';
grant all on data2.* to myuser IDENTIFIED BY 'pass';
...but when I try this:
CREATE USER myuser IDENTIFIED BY 'pass';
ERROR 1396 (HY000): Operation CREATE USER
Hello,
I'm using CentOS 4.5 with MySQL 4.1.20. I've got 2G RAM on the system,
and am running an x86_64 kernel (2.6.9-55.0.9.EL). When I try to use
mysqldump, MySQL crashes (then restarts). Here is the output from
mysqldump, and what happens in /var/log/mysql.log.
From mysqldump:
Ken,
You should probably be specifying the socket for both the startup
commands and the connect commands just to be sure. Without seeing your
config files, it's hard to say much else.
Rich(ard)
On Nov 6, 2007 9:37 PM, tech user [EMAIL PROTECTED] wrote:
Hello members,
I have two mysqld run on
Marc
ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or
READS SQL DATA in its declaration and binary logging is enabled (you *might*
want to use the less safe log_bin_trust_function_creators variable)
It has to do with whether the fnc is deterministic and how its results
Hi
I'm working with mysql 5.0.24a-log trying to create a procedure as is
indicated at mysql web page
and i get the following error before delimiter ;
mysql delimiter //
mysql CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
- RETURN CONCAT('Hello, ',s,'!');
- //
Query OK, 0 rows
Run this SQL Query
mysql select Host,User from user;
Make sure the output has this record values:
+---+--+
| Host | User |
+---+--+
| localhost | usuario1 |
+---+--+
If your mysql error message were to say this:
Access denied for user
in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
View this message in context:
http://www.nabble.com/Account-Problems.-Can%27t-register-server-with-new-account-tf4744425.html
Hello members,
I have two mysqld run on the same host (redhat linux OS with 2.4 kernel).
the two mysqld are in different versions, one is 4.0.20,another is 5.0.45.
the mysql 4.0.20 uses /etc/my.cnf as its config file,listening on default
3306 port.
the mysql 5.0.45 uses /etc/mysql5.cnf as its
select User from user;
+--+
| User |
+--+
| mysql|
| root |
| usuario1 |
| |
| mysql|
| root |
+--+
Thanks in advance
--
View this message in context:
http://www.nabble.com/Account-Problems.-Can%27t-register-server-with-new-account-tf4744425
Hi,
I keep getting the below in the error log. I can't see any problems (no
other errors and replication is working) and the master DB is available
the whole time.
070928 12:07:31 [Note] Slave: received end packet from server, apparent
master shutdown:
070928 12:07:31 [Note] Slave I/O thread
Hi all,
I've a server where between 1-2 there comes a high load from less than
1k queries there's a jump to 60+k queries. It all started after adding
more RAM to the server.
Anyone seen this before ?
Regards,
Toke Herkild
--
MySQL General Mailing List
For list archives:
Hi all,
First sorry my bad english :)
I having a problem with a large join with 10 tables with 70Gb of text data,
some joins executed by index but some others not.
I´m work with HP SERVER (Proliant NL-150) a 2 Xeon 2 Duo with 3Gb Ram and
RAID 0.
When executed to a client with small datasets
Hi,
Your English is fine :) Your queries don't look too bad. It could be
there are no good indexes. Have you tried running EXPLAIN on them?
What version of MySQL are you using? You can also try profiling the
queries (by hand with SHOW STATUS, or more easily with MySQL Query
Profiler) to
Hi,
We've recently upgrade from MySQL 4.0.18 to 4.1.20 and our applications
(Websphere) its not displaying the character as its supposed to do.
But when i do a select... from comand , the results from the old server and
the new are the same, also for mysql-query-browser.
Thanks
We solved it here,
There was a problem in the query, we removed the t1 at the 'group by'
section. The problem was really a sintax error in the code not in the
server.
Thanks,
Douglas
2007/7/19, Michael Dykman [EMAIL PROTECTED]:
instead of leaving it in PHP, please print out your fully
Hello everydoby,
I'm having a problem executing a query in the MySQL server version 4.1, the
same query works fine in my other server with MySQL version 4.0.
My PHP code is attached, and the query is one on the line 13.
Please somebody help me,
Thanks,
Douglas
dbFlashDadosSonabra.php
the mysqld daemon with:
/usr/local/mysql/libexec/mysqld --skip-grant
and use the command line tool
/usr/local/mysql/bin/mysql to connect to the mysql
database and look at the grant tables:
shell /usr/local/mysql/bin/mysql -u root mysql
mysql show tables
Try 'mysqld --help' if you have problems
mysql show tables
Try 'mysqld --help' if you have problems with paths. Using --log
gives you a log in /usr/local/mysql/var that may be helpful.
---
And then, when I do /usr/local/mysql/libexec/mysqld --skip-grant as
suggested in the above error message
hello,
first, some settings : MySQL 5.0.32, under Linux debian etch
the problem is the bad alignment :
mysql select nom,id from t2;
+--++
| nom | id |
+--++
| aàb | 1 |
| été| 2 |
| cçoôeêeèeëi | 3 |
| c'est tout
I recompiled my sql with nocona instead of k8 and the problem persists.
Now, I found this:
http://bugs.mysql.com/bug.php?id=17329
which definitely sounds similar to my problems.
I'm gonna give a shot to disabling delayed_key_write.
On 6/6/07, Quentin Gouedard [EMAIL PROTECTED] wrote:
Hello
(although i don't
know what that means).
4 - never do that without shutting mysql down first
5 - I'm using a somewhat recent version so if it was this it'd be really
curious.
The software I use is a popular one for which no such problems have been
reported before, so I doubt it's query/PHP related
problems under high load but
will appear fine otherwise. Cheers.
Mike
--
NMMN - New Media Markets Networks GmbH
Geschäftsführung: Kfm. Michael Schütt
Finanzamt HH-Altona UStID DE 812 699 852 HRB 71102 Hamburg
HypoVereinsbank - BLZ 200 300 00 - Konto-Nr. 156 29 82
http://www.nmmn.com
Mike,
I had the same failures without network.
And it is a onboard-controller :-)
Christoph
Christoph,
Have you tried replacing the network card with the one from the
working machine? Network cards can cause problems under high load but will
appear fine otherwise
On Tuesday 15 May 2007 14:36:45 Mathieu Bruneau wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory is allocated for the OS so you don't even have the full
4GB of ram you can technically adressesed.
The 64 bits os would increase this limit to 64gb++
On Tuesday 15 May 2007 14:36:45 Mathieu Bruneau wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory is allocated for the OS so you don't even have the full
4GB of ram you can technically adressesed.
The 64 bits os would increase this limit to 64gb++
-
From: Christoph Klünter [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, May 18, 2007 6:15 AM
Subject: Broken Tables, was:Memory Problems
On Tuesday 15 May 2007 14:36:45 Mathieu Bruneau wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory
and don't get any errors from mysql which say
that there might be problems with filesize.
Some is more info:
After doing 1000 inserts , I get the following:
mysql check table community_msgin;
+-+---+--+--+
| Table
, it
doesn't mean the user accounts are permitted to.
There are no big databases:
sql:~# du -hs /var/lib/mysql
1,4G/var/lib/mysql
I am using ext3 as Filesystem and don't get any errors from mysql which
say that there might be problems with filesize.
Some is more info:
After doing 1000
and access large memory/file
configurations, it doesn't mean the user accounts are permitted to.
There are no big databases:
sql:~# du -hs /var/lib/mysql
1,4G/var/lib/mysql
I am using ext3 as Filesystem and don't get any errors from mysql which
say that there might be problems
.
Cheers,
Christoph
Christoph,
Have you tried replacing the network card with the one from the
working machine? Network cards can cause problems under high load but will
appear fine otherwise. Cheers.
Mike
On Friday 18 May 2007 16:48:36 mos wrote:
Christoph,
I don't
Hi List,
We have a mysql-Server with 8G of Ram. But mysql doesn't use this ram.
But we get following error:
May 14 22:56:11 sql mysqld[5875]: 070514 22:56:10 [ERROR] /usr/sbin/mysqld: Got
error 12 from storage engine
May 14 22:56:11 sql mysqld[5875]: 070514 22:56:10 [ERROR] /usr/sbin/mysqld:
Christoph Klünter a écrit :
Hi List,
We have a mysql-Server with 8G of Ram. But mysql doesn't use this ram.
But we get following error:
May 14 22:56:11 sql mysqld[5875]: 070514 22:56:10 [ERROR] /usr/sbin/mysqld:
Got error 12 from storage engine
May 14 22:56:11 sql mysqld[5875]: 070514
On 5/15/07, Christoph Klünter [EMAIL PROTECTED] wrote:
I have set the sort_buffer_size to 1G but even this doesn't help.
Any hints ? Should we try a 64Bit-OS ?
setting sort_buffer_size to 1GB is not recommended. it is a thread specific
configuration parameter which means each thread will
On 5/15/07, Mathieu Bruneau [EMAIL PROTECTED] wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory is allocated for the OS so you don't even have the full
4GB of ram you can technically adressesed.
The 64 bits os would increase this limit to 64gb++
I think you may be able to get around this by using multiple key
buffers? (MySQL 4.1 or later)
-Micah
On 05/15/2007 01:24 AM, Christoph Klünter wrote:
Hi List,
We have a mysql-Server with 8G of Ram. But mysql doesn't use this ram.
But we get following error:
May 14 22:56:11 sql
On 5/15/07, Micah Stevens [EMAIL PROTECTED] wrote:
I think you may be able to get around this by using multiple key
buffers? (MySQL 4.1 or later)
key buffers caches only index data and they dont help with sorting like
sort_buffer. they dont impact innodb engine. even while using multiple key
using mysqlhotcopy and snapshotting the
tables to disk either on the master or the slave.
Has anyone done this and have they had any problems?
Kevin
--
Founder/CEO Tailrank.com
Location: San Francisco, CA
AIM/YIM: sfburtonator
Skype: burtonator
Blog: feedblog.org
Cell: 415-637-8078
Bgs a écrit :
Greetings,
We have regular problems with mysql replication when there is a db
change. This is mostly ALTER TABLE. The sync breaks and we either have
to do the changes manually or either shut down the whole system for a
new sync from zero. Is there a way to sync alter table
Greetings,
We have regular problems with mysql replication when there is a db
change. This is mostly ALTER TABLE. The sync breaks and we either have
to do the changes manually or either shut down the whole system for a
new sync from zero. Is there a way to sync alter table commands
101 - 200 of 2763 matches
Mail list logo
