Well... It did document it In my wiki... which is gone...
Nils
-Oprindelig meddelelse-
Fra: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sendt: fr 05-05-2006 21:57
Til: Nils Lastein
Cc: mysql@lists.mysql.com
Emne: Re: Determine version of *.frm, *.MYD and *.MYI
No backups?
And you com
Hi, as newbie and with some trubles understanding English language, i have a
question that I dont know howto put on search engines (I dont know
technical keywords for my particular case). This is why I post here.
This is the whole picture:
I have four programs running on my place,
Freeradius
Hi,
you sort of suggest to look further beyond file permission problems
but if I may:
> drwx--x--x 2 mysql mysql 1752 2006-05-01 09:33 mysql
doesn't look quite right, lack of read permissions to group/other.
Thanks,
Michael Izioumtchenko
-Original Message-
From: sheeri kritzer <[EM
Dobromir,
you are running a 32-bit operating system. Then the size of the mysqld
process is limited to 2 GB, or at most to 4 GB. The amount of total RAM 8 GB
does not help here, since 2^32 = 4 G.
You should reduce the key_buffer_size or innodb_buffer_pool_size in my.cnf.
Best regards,
Heikk
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 05, 2006 2:37 PM
> To: Duzenbury, Rich
> Cc: mysql@lists.mysql.com
> Subject: Re: blank user names in user table
>
> Rich,
>
> anonymous access means that ''@host has access. That is,
> "blank"
Bing Du wrote:
> I have two separate databases that I need to query data from. In the
> following SELECT statement, 'title' and 'db_entry_name' are in database1,
> and 'projectID' is in database2. If they were in one database, this
> SELECT should work. How should I tweak it to get data from bo
Hello,
Have you taken a look at the FEDERATED storage engine?
http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html
It is a storage engine that accesses data in tables of remote databases
rather than in local tables.
Thanks,
Jimmy Guerrero
Sr Product Manager
MySQL, Inc
-O
Hello,
I have two separate databases that I need to query data from. In the
following SELECT statement, 'title' and 'db_entry_name' are in database1,
and 'projectID' is in database2. If they were in one database, this
SELECT should work. How should I tweak it to get data from both database1
and
Perhaps it's time to file a bug report, then?
-Sheeri
On 5/3/06, Alex <[EMAIL PROTECTED]> wrote:
This problem is indeed not related to OS / Hardware Problems.
Take a look at this thread:
http://lists.mysql.com/mysql/197542
Read the part about show databases as root vs standard user
+ observ
Ah, I get it.I don't know if there's a way to do that, but why not
just put the SQL statements in the file?
-Sheeri
On 5/5/06, George Law <[EMAIL PROTECTED]> wrote:
I think what he is saying is that be began the "transaction" in a
command line client
session from one location but was not ab
well, you'd still have to use limit and offset with your search table
would you store a different table for each unique query? That sounds
like a lot of [temporary?] tables.
are you doing ore than 3-4 table joins on ths one fulltext search
query? If not, it's probably more work.
If your q
On 5/5/06, John Heim <[EMAIL PROTECTED]> wrote:
In fact, I would not gain clarity by using the 5-char codes that have been
imposed upon me. Freshman='10'. Sophomore='20'. There's even a '00' code
and a '05' for some status less than Freshman.
Imposed upon you? You're the DBA, right, not an e
None from me, sad to say. :(
-Sheeri
On 5/5/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 05, 2006 3:00 PM
> To: Duzenbury, Rich
> Cc: mysql@lists.mysql.com
> Subject: Re: mysqlmanager logging?
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 05, 2006 3:00 PM
> To: Duzenbury, Rich
> Cc: mysql@lists.mysql.com
> Subject: Re: mysqlmanager logging?
>
> su - mysql
> touch /var/lib/mysql/mysqlmanager.log
>
> see if that helps; maybe having th
I think you're thinking of mysqlcheck:
(from the documentation)
-check-upgrade, -g
Invoke CHECK TABLE with the FOR UPGRADE option to check tables for
incompatibilities with the current version of the server. This option
was added in MySQL 5.0.19.
-Sheeri
On 5/5/06, [EMAIL PROTECTED] <[EMAIL PRO
I think the correct way... as planned for the 5.1 release is as follows:
-- -- Start renaming database named "old_db" into "new_db"
CREATE DATABASE new_db;
ALTER TABLE old_db.table_1 RENAME new_db.table1;
ALTER TABLE old_db.table_2 RENAME new_db.table2;
..
This is right off the top of my head so I might be wrong!
Does myisamchk not return the mysql version that the table
was created with, if you use a very verbose option to check
the *.MYI files?
You could make a copy of your tables and experiment with
myisamchk on the copies, see if that throws
su - mysql
touch /var/lib/mysql/mysqlmanager.log
see if that helps; maybe having the file there will kick it into gear.
Is mysqlmanager actually running? Is there a pid file?
-Sheeri
On 5/5/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: sheeri kritzer [
No backups?
And you compiled it yourself with no records of how you compiled it or
what version you used? what if you want to compile a new version with
the same flags, how would you remember how to do that?
If those don't help, trial and error is the only way. And you know
it's not 4.1.19, th
At 01:41 PM 5/5/2006, sheeri kritzer wrote:
The best way to do it is NOT to make new codes. If they're giving you
codes, use theirs -- why make up a new system if you don't have to?
[...]
Well, I made up my own codes before I knew I had to import data from
somewhere else. I was quite happy with
1) See if the DNS on one machine is different. If it's trying to
resolve the host on one and failing, that might be why it's slow.
2) how did you copy the database?
3) what's the data usage like on each machine? If one machine is
used a lot and the other is used very little, then it may be
Well, according to my calculations:
innodb_buffer_pool_size + key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
(I used the default binlog_cache_size value of 32K plus your settings)
MySQL could use up to 4.991913 G of memory. Shouldn'
Hi All,
I submitted this query in Mysql Query Browser forum last month and haven't
got any help to fix this, so here I'm submitting this again.
I tried to install mysql query browser 1.1.20 and previous i had version
1.1.6, but every time i try installing i keep getting the following error.
"Er
Hi Sheeri:
Yes, you are misunderstanding my question. I certainly know how to limit
my resultset to certain rows. I'm asking more about the effiencency of
searching large volumes of data. Is making a search table like vBulletin
does a good mechanism to avoid resource contention on the main tabl
Rich,
anonymous access means that ''@host has access. That is, "blank" at
host, as opposed to [EMAIL PROTECTED]
To see if anonymous access is allowed, at the command prompt type:
mysql -u asdf
if you get a mysql login, you have anonymous access.
Otherwise you'll get:
ERROR 1045 (28000): Acce
LOAD DATA FROM MASTER only works for MyISAM tables. Is
tracking.session an InnoDB table?
-Sheeri
On 5/4/06, Hunter Peress <[EMAIL PROTECTED]> wrote:
Hi. im trying to add a second slave using load data from master ,and
it seems to me that when i run this command on the
new slave that its simply
I don't know what version of MySQL you're using, but a google search
on "mysql croatian" got me:
http://bugs.mysql.com/bug.php?id=16373
and
http://bugs.mysql.com/bug.php?id=6504
which implies you can use CHARACTER SET latin2 COLLATE latin2_croatian_ci
but also shows that it's not quite working y
You are not being honest with us on the list.
Firstly, the error you got:
You have an error in your SQL syntax near 'USING USING
A
RIGHT JOIN B ON B.id = A.sectionid' at line 1
SQL=DELETE FROM A USING A
RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null
indicates that you used the USIN
I think what he is saying is that be began the "transaction" in a
command line client
session from one location but was not able to give the
> mysql> SET FOREIGN_KEY_CHECKS = 1;
> mysql> COMMIT;
commands in the same session. (ie - I owe, I owe, its off to work I go
:) )
This is a good questi
I know it a 4.1... But as I compiled it my self it is not so easy to figure it
out And it might take a while to trial-n-error all 4.1.x
Nils
-Oprindelig meddelelse-
Fra: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sendt: fr 05-05-2006 20:28
Til: Nils Lastein
Cc: mysql@lists.mysql.com
E
On 5/4/06, Luke Vanderfluit <[EMAIL PROTECTED]> wrote:
[snip]
I started this process remotely then went to the site to finish it.
But when the dump finished (several hours later) I was not able to
execute the following commands from my original location.
mysql> SET FOREIGN_KEY_CHECKS = 1;
mysq
The total possible memory MySQL will use is:
innodb_buffer_pool_size + key_buffer_size +
max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
Someone please correct me if I'm wrong.
Are your most heavily used tables innodb? If not, then you're not
looking
John,
You're close -- If a single case-sensitive letter won't help (or isn't
descriptive enough -- is 'S' sophomore or senior or special student?)
The best way to do it is NOT to make new codes. If they're giving you
codes, use theirs -- why make up a new system if you don't have to?
create ta
Sounds like you want LIMIT and OFFSET --
everything after my name and before your post is copied from the doc at
http://dev.mysql.com/doc/refman/4.1/en/select.html
(or am I misunderstanding your question?)
-Sheeri
The LIMIT clause can be used to constrain the number of rows returned
by the SEL
Try looking at the documentation for "groupwise maximum".
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
-Sheeri
On 5/5/06, Ian Klassen <[EMAIL PROTECTED]> wrote:
Hello,
I'm working on using a temporary table to get the group-wise maximum for
a number of items.
You don't have ANY idea what branch it was created with? 3.2x, 4.0,
4.1, 5.0, 5.1 ? I'd recommend finding another similar server in your
dept and see what it's running (assuming there's no standards doc, or
sysadmin to ask, etc).
Do you remember around when the time was that you last
installed/
> -Original Message-
> From: sheeri kritzer [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 04, 2006 3:12 PM
> To: Duzenbury, Rich
> Cc: mysql@lists.mysql.com
> Subject: Re: mysqlmanager logging?
>
> Can the program write to /var/lib/mysql/mysqlmanager.log?
> check permissions.
>
#
You're comparing apples to oranges -- your where clauses are
different. The first query uses the primary key because you're
actually comparing 'account' to something. The second query doesn't
because you're using the 'street' field -- what does SHOW INDEXES
FROM account; show? any indexes on '
On 5/5/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> >Can anyone shed any light on this issue?
> This might shed more light into your problem
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But still, the query returns th
If your server has log-warnings set to ON, you can check the error
logs, and use a script to count how many times for each host, in a
row, this happens.
-Sheeri
On 5/5/06, Kishore Jalleda <[EMAIL PROTECTED]> wrote:
On 5/5/06, Dominik Klein <[EMAIL PROTECTED]> wrote:
> I experience that my slave
Do a "show status like 'uptime'" after the script runs. See if the
server crashed (if so, uptime will be low) -- if the server crashed
you might get that error.
show variables like "%connections" should show you how many
connections you can have per user and total. That shouldn't be the
problem
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> >Can anyone shed any light on this issue?
> This might shed more light into your problem
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But still, the query returns the same data, if I run it alone, or in the
complete sta
http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql/
Is a good article.
-Sheeri
On 4/21/06, Chris White <[EMAIL PROTECTED]> wrote:
I was looking around the list search and didn't find much on this subject
(maybe didn't look back far enough), but I was discussing
On 5/5/06, Dominik Klein <[EMAIL PROTECTED]> wrote:
I experience that my slave gets blocked after a while (a couple of slave
stop and slave start happen in the meantime). In errorlog I see
Slave I/O thread: error reconnecting to master
'[EMAIL PROTECTED]:3306': Error: 'Host 'myhost.mydomain.de'
On 5/5/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
Hi,
I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual
Opteron250 64 bit machine with 4gb memory.
The problem i'm experiencing is that at certain moments, the connection
between my perlscripts and the database gets disconnecte
On Fri, May 05, 2006 at 03:40:10PM +0100, Chris wrote:
> Is mysql 4.0 still supported or EOL, as the recent advisory says users
> of 4.0 should upgrade to 4.1 to patch the security problem.
>
> Subsequently I have noticed a new 5.x release and new 4.1.x release
> and no 4.0.x release.
There are c
Good morning James -
It looks like you have a multi-column index on the startIpNum and
endIpNum columns, but it's not doing you any good, at least not for
this query.
You don't mention how many rows of data you're searching against,
which would give a better idea as to what might be reasonab
Hello All,
I have a next problem. After upgrade from 4.1 branch to 5.0,
the productivity of our applications has decreases too much.
Below is a tipical case.
Table 'account' has primary(department,account) and 40777 records.
Table 'payment' primary(department,account,year,month) and 3831797 reco
Nils Lastein schrieb:
After a disk crash I managed to save the *.frm, *.MYD and *.MYI-files
from the disk. When putting these files into another mysql server I get:
mysql> select * from validate;
ERROR 1033 (HY000): Table './mydb/validate' was created with a different
version of MySQL and canno
Hello,
I'm working on using a temporary table to get the group-wise maximum for
a number of items. I have a table structure like:
CREATE TABLE item (
item_id int not null primary key,
name varchar(100) not null);
CREATE TABLE attribute_a (
index (item_id, time_id),
item_id int not null,
time
After a disk crash I managed to save the *.frm, *.MYD and *.MYI-files
from the disk. When putting these files into another mysql server I get:
mysql> select * from validate;
ERROR 1033 (HY000): Table './mydb/validate' was created with a different
version of MySQL and cannot be read
Unfortunately
Hardi
Have a look at "Rename Database" at
http://www.artfulsoftware.com/queries.php#16
PB
Hardi OK wrote:
Hi,
Anybody know how can i safely and easily rename a database in MySQL
5.0.19.
Have tried some tips from google results (most of them are for MySQL
4.x)
but no luck till now
Hi
Is mysql 4.0 still supported or EOL, as the recent advisory says users
of 4.0 should upgrade to 4.1 to patch the security problem.
Subsequently I have noticed a new 5.x release and new 4.1.x release
and no 4.0.x release.
Thanks
Chris
--
MySQL General Mailing List
For list archives: http://
Hi,
I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual
Opteron250 64 bit machine with 4gb memory.
The problem i'm experiencing is that at certain moments, the connection
between my perlscripts and the database gets disconnected:
| DBI connect('products','beheerv',...) failed: Lo
DOH!
Sorry - I totally misread the question!
A quick google for "rename database" shows Adrian is correct!
-Original Message-
From: Adrian Bruce [mailto:[EMAIL PROTECTED]
Sent: Friday, May 05, 2006 9:51 AM
To: George Law
Cc: Hardi OK; mysql@lists.mysql.com
Subject: Re: How to rename
Stop the server, go to the MySQL data directory and physically change
the name of the directory that corresponds to the database. Restart
MySQL server and SHOW DATABASES to see the change take effect.
George Law wrote:
Hardi
I rotate tables out on a monthly basis. The way I do it is:
ren
Hardi
I rotate tables out on a monthly basis. The way I do it is:
rename table1 to table2
If you need a new copy of table1, you can do :
create table table1 like table2
--
George
-Original Message-
From: Hardi OK [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 04, 2006 11:19 PM
To
another question on this error message:
is it possible to see the count of errors for each host from some table
or file?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Not necessarily. I would think the CREATE SELECT statement would be
> the closest equivalent.
>
> http://dev.mysql.com/doc/refman/4.1/en/create-table.html
>
Thanks much for the reply, John. That surely would help with our future
applications. But this time, we only have read access to the
> The MySQL Stored Procedures and Functions is ready to use on production
> systems ?
>
> or support is very ammature ?
>
> I need to know because is a project desing decision !
>
> Tnks !!
>
> PLEASE I NEED OPINIONS
By the time your project is finished designing, it will be ready ;-)
The MySQL Stored Procedures and Functions is ready to use on production
systems ?
or support is very ammature ?
I need to know because is a project desing decision !
Tnks !!
PLEASE I NEED OPINIONS
i'm crazy to use this ?
Tnks in advance
MySQL , InnoDB and Linux !
--
---
All:
I am developing a search engine and using MySQL as the backend database
management system. Under normal circumstances, when users search through
large volumes of records on a search engine site, the results are broken
down into pages. When a user clicks on the 'Next' link, the system will
r
- Original Message -
From: "Payne" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 05, 2006 12:09 AM
Subject: Output to a file
Hey,
been trying to output a select statment to a file, all the books I have
only show how to input from a file, what is the correct way
I thought I could
I experience that my slave gets blocked after a while (a couple of slave
stop and slave start happen in the meantime). In errorlog I see
Slave I/O thread: error reconnecting to master
'[EMAIL PROTECTED]:3306': Error: 'Host 'myhost.mydomain.de' is
blocked because of many connection errors; unbl
I would approach this in practically the same way as yourself but used
an enum field in the student table (like what you were thinking). When
a user wants to add or remove an enum value you can build an appropriate
MODIFY statement like:
ALTER TABLE my_table MODIFY my_col ENUM('K','X') NOT NU
65 matches
Mail list logo
