Emile,
thank you for sending the whole .err log directly to me.
This is probably the file i/o starvation bug which I have fixed in 4.0.14.
In this case a big insert buffer merge causes sequential reads which seem to
make requests by other threads to starve. I hope 4.0.14 will be out in two
weeks.
I haven't examined the code of the client in detail, but it appears to
disconnect where it should. The fact that I get a [mysqld defunct]
proces even if I execute a query with the 'mysql' utility, I consider
an implication of the server or the system.
Am I correct in understanding that the b
You are welcome ;-)
Best regards
Nils Valentin
Tokyo/Japan
;-)
> 2003年 7月 3日 木曜日 14:43、Sibananda Sahoo さんは書きました:
> > Thank you sir
> >
> > Rgds,
> > Sibananda
> >
> > --- Nils Valentin <[EMAIL PROTECTED]> wrote:
> > > Dear Sibanada,
> > >
> > > You keep sending e-mails offlist directly t
Dual Xeon 2.8 GHz, hyperthreaded, 533 MHz FSB
2 GB RAM
Red Hat, kernel-2.4.20-18.9 SMP
mysql 4.0.13, InnoDB table holding 32 million+ records, building an index using:
create index BY_NAME on PROFILE_NAMES (LAST_NAME,FIRST_NAME)
my.cnf contains:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/my
> There are two sets of binary downloads at mysql.com for Mac OS X.
> They're different sizes, but both say OS 10.2. Is that a typo? Is one
> of the two for OS 10.1, and could I have downloaded the wrong one and
> could that be the reason I can't get mysql to start?
>
> Todd
I think the word,
> IANAL but IIRC
> publishing means to create a copy of something on a medium and
> distribution means to deliver that medium to someone else.
IAANAL, but IIRC publishing means to place a work in a "public place",
ergo, for people to view, hear, or otherwise become an audience or
witness to. Rou
Dear Sibanada,
You keep sending e-mails offlist directly to me. Are you aware that it might
be much more beneficial for you to send a support request to the mysql
mailing list ?
I might not be available to answer always, but in such a case another person
might answer you perhaps quicker and b
At 20:57 -0400 7/2/03, <[EMAIL PROTECTED]> wrote:
Todd,
It didn't help. Here is the message:
$ cd /usr/local/mysql
$ ./bin/mysqld_safe
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this sc
Hello Peter,
I agree I don't seem to be explaining what I want properly.
Let me offer some data: (hopefully this will come out ok in the message).
hitID sessionID userID timedatepageName
251 2917000 3591528 6:22:17 2003-7-2News Section
250 2917000 3591528 6:22:6
In general, you can simply search for the location of mysqld (perhaps using
a utility like find). Once you find the file, make sure that it has execute
permissions. Then, run mysqld_safe from the directory containing mysqld, as
the error message suggests.
- Original Message -
From: "har
At 14:03 -0400 7/2/03, me wrote:
On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote:
me <[EMAIL PROTECTED]> wrote:
i have a strange thing going on - i'm trying to update privileges on
some databases but it doesn't happened - even after flush privileges -
according to the manual th
At 11:33 -0400 7/2/03, Andrew Pierce wrote:
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
go from the version that came with the distro (version 3.23.54) to the
latest (verion 4.0).
Just thought I'd post to get a heads-up on any known issues or
prerequisites. I just hate
At 14:18 +0100 7/2/03, Idries Hamadi wrote:
Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface f
2003年 7月 3日 木曜日 11:30、Nils Valentin さんは書きました:
> Hi Dan,
>
>
> By default 2 anonymous user accounts are setup in the mysql database. You
> will have to delete them first. you should find that you can login with any
> name (except the specified ones) without password. This will probably allow
> you t
Hi Dan,
By default 2 anonymous user accounts are setup in the mysql database. You will
have to delete them first. you should find that you can login with any name
(except the specified ones) without password. This will probably allow you to
view the databases f.e. with "SHOW DATABASES;", but y
Hi Victoria,
2003年 7月 2日 水曜日 22:05、Victoria Reznichenko さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > Hi Victoria,
> >
> > I enclose a sample.
> >
> > http://www.mysql.com/doc/en/Resetting_permissions.html
> >
> > ...
> > 2. Restart mysqld with the --skip-grant-tables option.
> > ...
I think mysqld_safe is just a shell script, so you might be able to go
through there and see if you can find where /usr/local/mysql is defined.
On the other hand, I just looked, and it looks like it's smart enough
to figure out if you've moved the installation directory. Try cd-ing to
the place
2003年 7月 2日 水曜日 22:57、Sibananda Sahoo さんは書きました:
> Dear Sir
>
> Hope you to be fine. I know MS SQL supports the
> following query to reseed the seed value:
>
> DBCC CHECKIDENT ('tablename',RESEED,new-seed-value);
>
> Is there any support like the above in MySQL 4.0.13 to
> set new seed value ?
>
> A
Uups must have forgotten to copy the list ;-)
Thanks Heikki,
Also I dont fully understand the resulting context yet, I appreciate the
reply.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 3日 木曜日 00:07、Heikki Tuuri さんは書きました:
> Nils,
>
> at the lower level all mini-transactions always succeed
On Wed, Jul 02, 2003 at 02:28:38PM -0700, Kevin wrote:
> Hello,
>
> I have two mysql databases running on different hosts - the database are
> similiar in structure. I would like to copy specific tables from one db to
> another db on a scheduled basis.
>
> Is there a command to replicate a table
Anyone here familiar with the following error:
ADONewConnection: Unable to load database driver ''
Fatal error: Call to a member function on a non-object in
/wwwroot/htdocs/webdev/nubiint/includes/pnAPI.php on line 486
I get this error when trying to configure multisites in my postnuke
site.
I
Todd,
It didn't help. Here is the message:
$ cd /usr/local/mysql
$ ./bin/mysqld_safe
The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/mysqld_safe.
$
-
That's exactly what I had to do as well. I wouldn't even start in
rc.local unless I put in exactly what is shown below.
Ed
On Wed, 2 Jul 2003, Todd O'Bryan wrote:
> Do what it says:
>
> cd /usr/local/mysql
> ./bin/mysqld_safe
>
> and see if that's any better.
>
> Todd
>
> On Wednesday, Jul
For the first query below--if you really run it often enough
to mess with indexes, and it really has a limit 1 or a small
limit--an index on (VoidStatus, InstNum) ought to
avoid having MySQL create a big temporary table and then sort it.
In addition, you could add to the index any of columns in th
I figured out what happened, though I don't know when it happened...
I had screwed up the permissions for the /tmp/ directory, so the mysql
user could not create the socket it needed there. A well-placed chmod
and things are back in working order.
Thanks to all for the suggestions,
Todd
--
MySQ
Make sure the permissions on the file are set to executable. Assuming your
platform is some *nix variant, login as root or owner. Change to the
directory where your mysqld is located (/usr/local/mysql/libexec) and
execute the following command:
chmod 755 *
This will ensure the binaries and script
>> Tim:
>>
>> Assuming that in your ealier posting the 99 was supposed to be 999,
>> then
>> the solution given by Mike Hillyer is excellent and should work.
>> However, when I read your new posting, I seem to get confused. The
>> scenario sounds totally different - excuse me - from the earlier on
> Tim:
>
> Assuming that in your ealier posting the 99 was supposed to be 999, then
> the solution given by Mike Hillyer is excellent and should work.
> However, when I read your new posting, I seem to get confused. The
> scenario sounds totally different - excuse me - from the earlier one and
>
Tim:
Assuming that in your ealier posting the 99 was supposed to be 999, then
the solution given by Mike Hillyer is excellent and should work.
However, when I read your new posting, I seem to get confused. The
scenario sounds totally different - excuse me - from the earlier one and
would there
Do what it says:
cd /usr/local/mysql
./bin/mysqld_safe
and see if that's any better.
Todd
On Wednesday, July 2, 2003, at 05:18 PM, [EMAIL PROTECTED] wrote:
Hi,
I got the following message when trying to start the mysql instance:
$ mysqld_safe &
[1] 22717
$ The file /usr/local
I found that file in /usr/libexec/mysqld hope that helps
--
harsh
http://www.cse.iitb.ac.in/~harsh
--
On Wed, 2 Jul 2003 [EMAIL PROTECTED] wrote
>
> Table name "sti_tracking"
>
> hitID (primary key) (autonumber)
> userID
> sessionID
> date
> time
> pageName
this might work
select userID,sessionID from sti_tracking where userID=999 group by
sessionID;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To un
Alex,
why you do not look with SHOW INNODB STATUS if there are dangling
transactions which could still see the delete-marked rows? Purge cannot
remove them then.
The main InnoDB thread tries to run a full purge even when the server is
active. This snippet is from srv0srv.c of 4.0.14:
"
/
Hello,
I have two mysql databases running on different hosts - the database are
similiar in structure. I would like to copy specific tables from one db to
another db on a scheduled basis.
Is there a command to replicate a table from one db to another on a
different host?
TIA
-roy
--
MySQL G
Hi,
I got the following message when trying to start the mysql instance:
$ mysqld_safe &
[1] 22717
$ The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable
Please do a cd to the mysql installation directory and restart
this script from there as follows:
./bin/
I recently stumbled onto the ability to log into a mysql server from the command line
with any table name, and a blank password. ie:
mysql -u mysql
My root account has a password set, and a few users with limited access but I haven't
done much else as far security goes.
I've tried this on a 3.23
Hi,
I wanted to post a follow-up question to the inquiry below. I've done some more
research since my last post and now think that the performance problem is related to
something other than uncommitted transactions. More specifically, I think the culprit
is the lack of timely synchronization
What you want to do is "reduce" the query. Logic is reduced using
similar rules to algebra.
Think of "or" operations as addition and "and" operations as
multiplication and you can manipulate them using the same rules as you
do in algebra.
select * from t where (a and b) or (a and c);
where a,
Steven,
Don't use NFS, bad idea.
You can do the master writer/multi reader, but it's always been a
problem making sure every reader is up to date. You need to have a way
to verify this manually.
If your really going to max out your platform there's other platforms to
look at, but the costs go
Hello,
Has anyone had success using the mysqld_multi startup script at boot on Solaris
8? I can start mysqld manually, but not automatically at boot time. Any help
or advice is apprciated.
Thanks a lot,
Matt
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
I would recomend reading up on the copyright laws in your country.
publishing and distribution are legally defined terms. IANAL but IIRC
publishing means to create a copy of something on a medium and
distribution means to deliver that medium to someone else. These
concepts get tricky in a legal
select sessionID,userID,date,time from sti_tracking
where userID=99 group by sessionID;
hope that works ,though i didn't clearly got
your question,may be some expert suggest better
regards
harsh
On Wed, 2 Jul 2003, Tim Winters wrote:
> Hello everyone,
>
> I have the following select stateme
Tim Winters wrote:
So what I want to be able to do is single out a user (999) and retrieve
all the sessions he was involved in. But I don't want duplicate session
numbers (one is enough).
Make any more sense?
Yes. The solution I posted earlier should work.
Bruce Feist
--
MySQL General Maili
Hello,
Very sorry to everyone about the confusing message. I should have read
it over again before pressing send.
First of all I'm looking for userID 999. A typo in the message not in
the code.
The table is set up like this.
Table name "sti_tracking"
hitID (primary key) (autonumber)
userID
s
On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote:
me <[EMAIL PROTECTED]> wrote:
i have a strange thing going on - i'm trying to update privileges on
some databases but it doesn't happened - even after flush privileges -
according to the manual the changes with GRANT an REVOKE sh
I think a network filesystem would add a LOT of latency, perhaps you
need a SAN type solution?
This way the data could be off on some other device, possibly
accessible to more than one host.
--s
On Wednesday, July 2, 2003, at 10:11 AM, Mike Hillyer wrote:
Well, if we are talking about a one to
Check your permissions in /usr/local/mysql, I think the package leaves
some incorrectly set.
The exact problem is usually logged in
/usr/local/mysql/data/.err this file is invaluable
Cheers!
--s
On Wednesday, July 2, 2003, at 09:24 AM, Todd O'Bryan wrote:
OK. I've verified that no mysqld is
I have multiple tables and require to retrieve data
from the tables. Though this is quite achieved, what
problem i see is that two of my result sets are stored
in a table as rows and i would like to retrieve them
as columns.
The query that i am executing is...
---
SELECT
u.user_i
> Hello everyone,
>
> I have the following select statement
>
> SELECT DISTINCT sessionID, userID, date, time
> FROM sti_tracking
> WHERE userID = 999
>
> What I want is to have only records with the userID of 99 and where the
> sessionID is distinct (meaning only on of each session id). Neither
Well, if we are talking about a one to one relationship between MySQL
and repository, you can always share the folder the data files will be
stored in using NFS or SMB, and then just adjust the datadir entry in
the my.cnf file appropriately. The performance of such a solution will
probably be degra
Tim Winters wrote:
Hello everyone,
I have the following select statement
SELECT DISTINCT sessionID, userID, date, time
FROM sti_tracking
WHERE userID = 999
What I want is to have only records with the userID of 99 and where the
sessionID is distinct (meaning only on of each session id). Neithe
Well, it is important to remember that SELECT DISTINCT simply restricts
that the WHOLE ROW is distinct, therefore it takes into account all
columns, not just the sessionID column, when deciding if a row is
distinct.
One way to do this would be to do
SELECT sessionID, userID, date, time FROM sti_
Jackson Miller wrote:
I understand that having this many tables is crazy, but I don't understand why
it is not better.
Several reasons. One is complexity, another is administration.
Using one table per user is nasty because it's too complicated. You
have 200 tables to keep track of, each wit
I am wondering if it is possible to run MySQL Server on one computer on a
LAN, but have all the databases be stored on another computer on that LAN
(such that the other machine is like a data repository that the MySQL
server machine can access when needed without having to store any of the
dat
If you want to add another column name, just insert a new record into
Contract Column Lookup
--
col_id
col_name
Regards,
Jake Johnson
[EMAIL PROTECTED]
__
Plutoid - http://www.plutoid.com - Shop Plutoid
I have the wierdest problem an I am at a loss.
The insert function, as for the code underneath, partially works. I say
partially, as I can see that the primary key is actually incremented. But
sometimes the new record fails to show in the table, and when it does
other records are removed. The beha
Hello everyone,
I have the following select statement
SELECT DISTINCT sessionID, userID, date, time
FROM sti_tracking
WHERE userID = 999
What I want is to have only records with the userID of 99 and where the
sessionID is distinct (meaning only on of each session id). Neither
sessionID nor
Well, lets say that you suddenly remember that you need column X in the
user table. In the normalized model you have to do one ALTER TABLE
statement. In the design you have in place you need n ALTER TABLE
statements where n = the number of users. It can also be easier to
program against and manage
I appreciate the idea of normalizing, but those tables wouldn't meet the spec.
There would also have to be a column value table at the very least. Also,
why would you have user_id and cont_id in both the user_table and the
contract table.
Also if you read my post you would see that I am talki
There are two sets of binary downloads at mysql.com for Mac OS X.
They're different sizes, but both say OS 10.2. Is that a typo? Is one
of the two for OS 10.1, and could I have downloaded the wrong one and
could that be the reason I can't get mysql to start?
Todd
--
MySQL General Mailing List
You don't want to have a separate table for each user. That would cause a
maintenance nightmare.
Try normalizing your data
user table
--
user_id
cont_id
user_name
Contract lookup
cont_id
Cont_Name
Contract Column Lookup
--
col_id
col_name
Cont
OK. I've verified that no mysqld is running using Egor's command from
below, and
by using netstat (which someone else suggested) there is nothing
listening on port 3306.
Any new ideas?
Thanks,
Todd
On Wednesday, July 2, 2003, at 09:51 AM, Egor Egorov wrote:
"Todd O'Bryan" <[EMAIL PROTECTED]>
I am working on a program that is essentially a contact management tool for
multiple users. There are currently about 200 users and will be over 1000
eventually. Each user may have between 10 and 500,000 contacts.
Where it gets interesting is that each user needs to have the ability to
contro
Check the error log in your mysql data directory.
This should explain why mysqld ended.
suboh wrote:
Hi,
The following message appeared when I installed mysql server on Linux,,,
[2] 10804
[1] Exit 1 ./bin/mysqld -user-mysql
[EMAIL PROTECTED] mysql]$ Starting mysqld daemon with d
Vitoria,
Thanks for the feedback. I should have done this first but it turns out
that there are actually bad records with: MobileName LIKE ""
Mystery solved...
Thanks,
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in t
Hello dear all,
on MySQL 3.23.54
i have a table that list the number of user-time days like: 35
whellbased on curdate() function
can i able to make a select wich display the sum (150-35)
where 150 is date_format(curdate(), '%j')
in a format like (%d/%m/%y) ?
this kind of query is poss
If your table is MyISAM, then
SELECT COUNT(*) FROM tablename
Will return a rowcount without a major performance hit as the rowcount
is stored and a table scan is not needed.
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From: Roy W [mailto:[EMAIL PROTECTED]
> Sent: Wed
Is there a simple MySQL command that will give a Row Count (# of records)
WITHOUT running a select (huge database)
Thanks!
Roy
Thanks to everyone who has helped and/or made suggestions so far. I'll
try to provide some answers to your further queries and report back on
some testing I've done.
Jeremy asked for explains of some of the problem queries:
Here is a particularly troublesome one that gets ran quite a lot:
mysql> S
I am getting ready to try to upgrade MySQL on my RedHat 9 box. I want to
go from the version that came with the distro (version 3.23.54) to the
latest (verion 4.0).
Just thought I'd post to get a heads-up on any known issues or
prerequisites. I just hate it when I try something like this and screw
Under MySQL 3.23, FLUSH LOGS was replicated. Under 4.0.13, this appears to
no longer be the case.
Was this intentional? Could it be put back the way it was?
We do backups by, at a time of low usage, (1) FLUSH LOGS on the master, (2)
Dump the master database, (3) repeat 1 and 2 until there were
Richard,
Welcome to the wonderful world of FreeBSD. FreeBSD-5.1 is not "release"
code. It is "alpha" quality (thought pretty good quality as Alpha goes).
I understand that the website doesn't make this abundantly clear on the
homepage. FreeBSD 4.8 is the current production quality code. It will
Hi,
The following message appeared when I installed mysql server on Linux,,,
[2] 10804
[1] Exit 1 ./bin/mysqld -user-mysql
[EMAIL PROTECTED] mysql]$ Starting mysqld daemon with databases from
/var/lib/mysql
030701 19:59:18 mysqld ended
And also sometime the message can't fin
"Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> Version 3.23.56, for pc-linux on i686
>
> When I issue query as such...
>
> SELECT ID, Name, date, time
> FROM table
> WHERE Name NOT LIKE "zz%";
>
> I get a result that has as it's first record, a record where the Name
> field data IS LIKE "zz%" but th
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
> Hi Victoria,
>
> I enclose a sample.
>
> http://www.mysql.com/doc/en/Resetting_permissions.html
>
> ...
> 2. Restart mysqld with the --skip-grant-tables option.
> ...
>
> How would you understand this ?
>
> restarting mysqld or starting safe_mysqld
"Todd O'Bryan" <[EMAIL PROTECTED]> wrote:
> Something bad has happened. MySQL was up and running on my machine, but
> now it's not and I have a chicken and egg problem that I can't seem to
> solve...
>
> I uninstalled any old versions of MySQL and I'm using the package
> installer of version 4.
Idries Hamadi wrote:
Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface for a few
days now, a
1 will work.
2 will not work.
3 Use dbf2mysql. ( It should be in the downloads section on mysql.com )
fab wrote:
Hi all,
I'm quite new in mysql. Despite i've read a part of the doc, i can't
fix my prob. Here is my question:
I want to convert a DBASE IV file into mysql table:
1) Have i to convert
If you did not shutdown the server prior to the upgrade, you could have
left mysqld running, even after its socket was removed.
Use ps to see if mysqld is still running, and kill it if necessary.
Todd O'Bryan wrote:
Something bad has happened. MySQL was up and running on my machine,
but now it'
Does the client close the connection before exiting?
Joshua Shapiro wrote:
Hello,
I am running the binary mysql 4.0.13 pclinux i686 with a linux
2.4.19 kernel. I have the problem that every time a client
connects to the server and then exits, a defunct thread is
left behind. Eventually the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 25 Jun 2003, Luc Foisy wrote:
> Something interesting that may be my problem
> This is a known working install
> # mysql --version
> mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)
> # find /etc/rc.d -name *mysql
> /etc/rc.d/init.d/
Hi all,
I've just started using mysql and I'm sure that my all problems are
something todo with my oracle-ness, so please bear with me if I use
case-insensitive table names or somthing ;)
Ok. I've been using the mysql interactive command-line interface for a few
days now, and there's no problem t
Andrew Staples wrote:
I've setup my my.cnf file on the slave as:
[mysql.server]
user=mysql
basedir=/var/lib
socket=/var/lib/mysql/mysql.sock
server-id=2
master-host=206.xxx.xxx.xxx
master-user=replicateuser
master-password=replicatepassword
Master.info is:
tux-bin.001
3109
206.xxx.xxx.xxx
repli
Hi all,
I'm quite new in mysql. Despite i've read a part of the doc, i can't fix
my prob. Here is my question:
I want to convert a DBASE IV file into mysql table:
1) Have i to convert the dbf into flat file then use the LOAD DATA
INFILE cmd ?
or
2) Can i directly use the LOAD DATA INFILE cmd w
Something bad has happened. MySQL was up and running on my machine, but
now it's not and I have a chicken and egg problem that I can't seem to
solve...
I uninstalled any old versions of MySQL and I'm using the package
installer of version 4.0.13 on Mac OS 10.2.6.
When I "cd /usr/local/" and "s
Hi Victoria,
I enclose a sample.
http://www.mysql.com/doc/en/Resetting_permissions.html
...
2. Restart mysqld with the --skip-grant-tables option.
...
How would you understand this ?
restarting mysqld or starting safe_mysqld ??
Don't get me wrong the manual is not bad, but it leaves a lot o
Version 3.23.56, for pc-linux on i686
When I issue query as such...
SELECT ID, Name, date, time
FROM table
WHERE Name NOT LIKE "zz%";
I get a result that has as it's first record, a record where the Name
field data IS LIKE "zz%" but the actual output has that field blank as
in the example below.
Hi Karl-
I often use a unix timestamp value for my dates (an unsigned mediumint is
adequate) and index that. However, using date/time functions in the where
clause does have a significant impact on the execution times, even when the
index is used and the EXPLAIN output appears the same. See examp
Maciej Bobrowski <[EMAIL PROTECTED]> wrote:
>
> Let's say I have 1000 records in a 'table'. I want to select rows from 6
> to 11. How can I do this?
Use ORDER BY and LIMIT clauses:
http://www.mysql.com/doc/en/SELECT.html
--
For technical support contracts, goto https://order.mysql.com
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
>
> I agree this section could be made a bit clearer.
>
> Is this hint big enough for MySQL AB ;-) ??
>
What exactly is not clear enough for you?
--skip-grant-tables is option of mysqld, not safe_mysqld.
safe_mysqld is the script that runs mysqld.
>
"Gary Huntress" <[EMAIL PROTECTED]> wrote:
> I have some simple user quotas set to help balance my server load. I think
> I've implemented them properly because people do whine to me when they
> reach the query limit.
>
> I have max_connections set to 200, but right now I'm watching connections
Actually, this will *not* necessarily work. Without an ORDER BY
clause, the database is free to return records in any order; after
some deletions & insertions, your select below may return different
records, in a different order.
I would recommend adding an explicit record number to the table,
Nils,
InnoDB writes to ib_logfiles all tablespace modifying operations (=
mini-transactions), whether they belong to a successful or an unsuccessful
transaction. In crash recovery we redo everything, then roll back based on
undo logs inside the tablespace.
The best reference is Gray and Reuter: T
Maciej Bobrowski wrote:
Let's say I have 1000 records in a 'table'. I want to select rows from 6
to 11. How can I do this?
SELECT * FROM tablename where column>5 AND column<12;
No, no. I have no numerical fileds in the table. Your example is not good.
Even if I could add the 'id' column to the
O.K. I found the way:
select * from tablename limit 5,6;
it will select 6 records counting from 6.
>> Let's say I have 1000 records in a 'table'. I want to select rows from6
>> to 11. How can I do this?
> SELECT * FROM tablename where column>5 AND column<12;
Best regards,
Maciej Bobrowski
-
SELECT * FROM tablename LIMIT 5, 6
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "Nils Valentin" <[EMAIL PROTECTED]>
To: "Maciej Bobrowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, July 02, 2003 4:47 PM
Subject: Re: specific records
>> Let's say I have 1000 records in a 'table'. I want to select rows from 6
>> to 11. How can I do this?
> SELECT * FROM tablename where column>5 AND column<12;
No, no. I have no numerical fileds in the table. Your example is not good.
Even if I could add the 'id' column to the table, then when
SELECT * FROM tablename where column>5 AND column<12;
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 18:26、Maciej Bobrowski さんは書きました:
> Hi,
>
> Let's say I have 1000 records in a 'table'. I want to select rows from 6
> to 11. How can I do this?
>
>
> Regards,
> Maciej Bobrowski
--
--
Hi Egor,
Thanks for the straight and short answer.
Much appreciated.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 17:44、Egor Egorov さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > does anybody know how to initialize a new added Innodb file without
> > restarting the serve
Hi Harsh, Hi MySQL AB ;-)
I agree this section could be made a bit clearer.
Is this hint big enough for MySQL AB ;-) ??
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 2日 水曜日 18:08、harsh さんは書きました:
> Well its not your fault,its actually confusing
> the documentation says run the mysqld comman
1 - 100 of 116 matches
Mail list logo
