clue
what will happen after 5.5.5-m3.
So in short: Is there any chance that a 5.5 or 5.6 GA release will be
ready until end of September, or should I setup a new server with 5.1.x
still?
Kind regards
Marten Lehmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using
LOCK TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got error 1
from storage engine (1030)
mysqldump: Couldn't execute 'show create table `Autor`': Got error 1
from stora
How can I remove a table space from the internal data dictionary? The
documentation doesn't help at all.
Even after a fresh installation and importing all dumps of the databases
from scratch, I get these errors:
Attempting backtrace. You can use the following information to find out
where my
Hello,
our mysql 5.0.67 on a AMD Opteron 2218 with 2 GB RAM is crashing from
time to time.
This what is in the log:
081028 6:37:30 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, impr
Hello,
we are using MySQL 4.1 and 5 on AMD dual core processors, but I can only
see one mysqld process on each machine. Since a process is always tied
to a certain processor, mysqld doesn't seem to make use of the second
core. As far as I know multiple threads of one process would be visible
Hello,
Marten, in my experience, these are most often temporary files leftover
from an incomplete operation.
They might be from a long-running query that was canceled, or from a
table repair operation that errored out or was interrupted.
In my experience it is safe to delete them, provided
Hello,
I was wondering why the partition is almost full, since the databases
aren't very big. Then I noticed these files in the database directory:
-rw-rw 1 mysql mysql4310560 Dec 24 10:13 #sql_10d4_0.MYD
-rw-rw 1 mysql mysql 1024 Dec 24 10:13 #sql_10d4_0.MYI
-rw-rw
Hello,
when we create user accounts on our mysql server, then we strictly
disallow "CREATE TEMPORARY TABLE".
This said, I was a bit shocked that mysql doesn't really care and allows
this command without a problem:
create table x engine = memory;
What is the use to deny users to create a te
Hello,
If I recall that correctly, utf8_swedish_ci is the collation to use for
european/western european languages. Those Swedish people think they can
stand for whole Europe... ;)
Not tested my reply, though.
and doesn't work either.
This is the sorting result with utf8_swedish_ci:
++-
Hello,
default-character-set=latin1_d e
that's not UTF8.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I want to store my data with UTF8, thus I'm using the utf8 charset for
my tables. But which collcation shall I use? I cannot find anything
appropriate.
I cannot use utf8_unicode_ci or utf8_general_ci, because this seems to
treat "Ä" and "A" equally. So I couldn't store the words "ÄBC"
Hello,
today I got this in my logs and mysql stopped working.
InnoDB: http://dev.mysql.com/doc/mysql/en/InnoDB_troubleshooting_datadict.html
InnoDB: how to resolve the issue.
071107 8:46:26 InnoDB: Flushing modified pages from the buffer pool...
071107 8:46:26 InnoDB: Started; log sequence nu
Hello,
I have a table like this:
CREATE TABLE `places` (
`name` varchar(256) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
Then I want to insert two values:
pjöngjang.com and
pjongjang.com
But on the second record I ge
Hello,
thanks. I just wonder why this isn't actually documented in the --help
output of mysqldump.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I couldn't find an option within mysql 5.0.x to get a dump of all rows
of a table with one line per row/record. I always get insert statements
with all rows at once. Has that option been removed since 4.1.x?
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.
Hello,
how can I get the type of a table (MyISAM, InnoDB, Berkeley DB) by a
given table name with sql?
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
mysql was such a reliable and unbreakable database until innodb showed up. All
the time I had problems with mysql it was related to innodb. Today again:
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
070206 09:29:19 mysqld ended
Is there an
Hello,
> If a person forgets to drop temp tables and stays within a connection
for hours or even days, memory resources can be overloaded a lot of temp tables.
Furthermore, loading temp tables with a GB of data is bad practice but is
possible
under such circumstances.
that is the sort of thin
Hello,
if there are not any security impacts, why does the
Create_tmp_table-privilege exist separately to the
create_table-privilege? Or if it has security impacts (maybe
automatically granting other rights), which ones?
The mysql documentation doesn't tell much about this.
Regards
Marten
Hello,
is it safe to give users in s shared hosting environment the
Create_tmp_table_priv privilege? Are any other privileges granted by
this option? Why does mysql store the temporary tables? What happens if
the connection dies before mysql has deleted the temporary table? Does
you user see
Well,
ok, we need to stress this more in the manual. A few users have
misunderstood that ibdata files would no longer be needed if one uses
innodb_file_per_table.
ib_logfiles are always needed. How else can InnoDB recover after a crash.
but how can I repair my existing ib-files so that the
Hello Heikki,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
the complete log is about 50 mb, since a lot of errors occur.
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously corrupt, since the log sequence numb
Hello,
I'm getting this in my errorlog:
060328 18:43:45 mysqld ended
060328 18:43:46 mysqld started
060328 18:43:46 InnoDB: Operating system error number 2 in a file
operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember
Hello,
again, I'm having problems with InnoDB tables. A certain table cannot be
dropped. If I'm issueing the drop table statement, the connection is
lost and I get the following in the logfile:
060327 14:38:11 InnoDB: error: space object of table db15670/mw_pagelinks,
InnoDB: space id 12 did
Hello,
This is spelled out pretty clearly in the manual:
InnoDB always needs the shared tablespace because it puts its
internal data dictionary and undo logs there. The .ibd files are not
sufficient for InnoDB to operate.
well, thats what I found before. But it doesn't explain why InnoDB
Hi,
I had a lot of trouble today because the InnoDB integration in MySQL is
lousy. I read the manual and worked with innodb_per_file_table. So when
I shutdown mysql I should be able to delete ib_logfile0, ib_logfile1 and
ibdata1, because all table-data should be stored in the .idb and .frm
fi
Hello,
http://dev.mysql.com/doc/mysql/en/crashing.html
I decided to create a bug report as this list is rather for resolving
common problems than discussing about the mysql development.
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
MySQL could die during your query. What is in error log?
Oh my god, it's really dieing. I haven't looked in the error log before,
because I though, it's just this connection that got lost. This is the
error-log output:
mysqld got signal 11;
This could be because you hit a bug. It is also possibl
Hello,
the current 4.1.11 implementation of PURGE LOGS doesn't seem to work any
more. I created a script running once each day doing the following
statement:
purge master logs before (select adddate(current_timestamp(), interval
-4 day))
That way, all logs prior to today - 4 days will become d
file.
However, I have a backup of the ibdata file. Is it possible to extract
individual tables of this file manually?
Regards
Marten Lehmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
some weeks ago we switched from mysql 4.0.20 to 4.18 and later to 4.1.9.
A customer now told us, that he can't access his old InnoDB-tables. He gets
#1016 - Can't open file: 'Autor.ibd' (errno: 1)
if he tries to access the table "Autor". This happens to other
InnoDB-tables created with my
Hello,
a server of us with dozends of databases from our customers is running
mysql 4.0.x and some users are using timestamp-columns in their tables.
If we would switch to 4.1.x immediately, there would be no time for our
customers to check their scripts relying on the older timestamp format
wi
Hello,
in 4.0.20 I was happy that German Umlauts are sorted correctly (ä -> ae,
ö -> oe, ü -> ue). With 4.1.4 the configuration stops:
checking "character sets"... configure: error: Charset 'latin1_de' not
available. (Available are: binary ascii armscii8 ascii big5 cp1250
cp1251 cp1256 cp1257 c
Hello,
Is gamme the last step
until the 4.1.4 will be released?
Yes.
Or will rc's follow before?
No.
that's nice to hear. So when will the final version be released? 2 days?
2 weeks?
Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
Hi,
I would never allow anyone except myself to connect to my MySQL server
as the root MySQL user.
I don't want to allow either. That's why I'm asking. From outside, noone
can connect as root directly. And as noone has access to localhost
through ssh or whatever, noone except me can login as root
Hello,
imagine the following setup:
- a mysql-server
- a client on a different host
Privileges on the mysql-server are setup in a manner, that users can
connect from every host, but not from localhost (and they don't even
have access to localhost). root on the other hand is allowed to connect
fr
Hello,
Tell us the OS, the MySQL server and client version and the build information
(custom or binary downloaded from MySQL.com).
Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
This *might* be a problem of resolver in glibc.
I don't see a reason why it should be a resolver
Hello,
4.1 offers some interesting new features like more secure passwords and
subqueries. However, this release is still labeled "a-gamma"; on the
other hand it shall be used for future development. What's that "a" for
(usually for alpha) if it's also stated "gamma"? Is gamme the last step
unt
Hello,
I'm experiencing a strange thing: When bind is running without
"bind-address" everything works fine. But when I'm doing a "bind-address
= ..." the clients get "Lost connection to MySQL server during query". I
don't understand this, because ot worked once before and the ip-address
the cli
Hello,
today one of our caching nameservers failed. Although a second
nameserver was listed in /etc/resolf.conf and mysqld was started with
--skip-name-resolv, mysql struggled and took very long to accept new
connections. It's obvious, that mysql is doing reverse-dns lookups
against what config
Hello,
what are the defaults for the following options?
net_read_timeout
net_write_timeout
Regards
Marten Lehmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
do I need the character sets on the client side or just on the server?
Client and server are different servers, so I want to reduce the
client-package to a minimum:
/usr/bin/mysql
/usr/bin/mysqldump
/usr/bin/mysqlshow
/usr/lib/mysql/libmysqlclient*
I don't need man-pages et cetera. So, if
Hello,
I was reading through the documentation, but I couldn't find anything on
how to bind mysql to a certain ip-address. The only thing I found was
how to bind mysql to a different port:
mysqld_safe --port=port_number
But I don't want mysql to listen on all interfaces.
Regards
Marten
--
MySQL
Hello,
how can I prevent users from creating databases with the type MEMORY
(also known as HEAP)?
Regards
Marten Lehmann
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
regarding --skip-name-resolve: I read, that values in the Host-column of
the mysql-authorization must be localhost or ip-addresses to work. Since
everyone can connect from everywhere, I used 'localhost' and '%'. Is %
treated the same? Is the ip-address-rule obligatory or just a
should-ha
Hello,
this weekend, one of our caching nameservers failed. Since then, all
mysql-connects were running very slow. I removed the failing nameserver
in /etc/resolv.conf. Later, I was setting up another caching nameserver
instead and inserted it in /etc/resolv.conf. I rebooted the
mysql-machine.
46 matches
Mail list logo
