I'm trying to fix a problem with a users innodb database (mysql 5.0).When they try a
very simple insert they get "ERROR 1030 (HY000): Got error -1 from storage
engine" I have dumped and reloaded the tables but the problem persists. CHECK
TABLE does not indicate an error.
I stopped and r
pache user mailing
list on this one.
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Sat, 1 Apr 2006, Gary Huntress wrote:
To: [EMAIL PROTECTED]
From: Gary Huntress <[EMAIL PROTECTED]>
Subject: Re: Tuning a Server with >10,000 databases
GHz system.
The tuning articles I've read, and the sample my-*.cnf files that
ship with the tarball appear to apply to the more typical
installation of a single huge database rather than thousands of
individual dbs. Can anyone offer any suggestions?
Thanks,
Gary Huntress
Gary,
iles that ship
with the tarball appear to apply to the more typical installation of a
single huge database rather than thousands of individual dbs. Can
anyone offer any suggestions?
Thanks,
Gary Huntress
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
I have a new installation of MySQL 5.0 (I did not port an old ver). I am
running a Ruby on Rails application that uses this db. I have grants for
[EMAIL PROTECTED], root@"localhost" and root@'192.168.0.63'. The passwords for these 3
grants are old style 16 byte hashes. There was one single g
Hi,
I have db users from all over the world. I only understand english. This
is rarely a problem since I almost never need to look at users data, but
every once in a while I do need to, usually this is while reviewing
logfiles.
Here is an example. Selecting a text field from a table I g
I need to drop a database named ÃáãÃáà using the mysql client. I'm
getting "you have an error in your sql syntax" for the command
DROP database ÃáãÃáÃ;
I'm sure this is a character set issue. How can I drop this database?
Regards,
Gary H.
--
MySQL General Mailing List
For list a
nt field, and there are 2355008 total unique records,
yet even though the where clause is a test for equivalence I get three
result records. I think I reasonably expected to get 1 and only 1 record.
Puzzled,
Gary
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Gary Hun
As it happens, I found this post useful tonight for an almost identical
situation.
I have a table with exactly 200,000 rows, the first column is an
autoincrement ID field. I am confident that all IDs are consecutive and
there are no holes.
When I do:
Select ID from history where id = CAST(
Is there a way to determine the question count of an individual user?I
use the max_questions grant extensively in order to manage server resources
and this would help me out a lot.
Regards,
Gary Huntress
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Hi,
I rely on max_questions to balance the load on my servers. I'd like to
tune them more effectively than just a ballpark guess.
During the course of an hour (the question count resets each hour) is it
possible to retrieve the question count for a particular user? Obviously
it must b
I'm stumped by this query that I think will involve multiple self joins and
left joins.
My data looks like:
+--+--++
| id | Category | description |
+--+--++
|1 | color| red|
|2 | color| blue |
|3 | color| ye
I implement some simple per-user limits by setting max_questions to 800 (via
GRANT). This is ok for virtually all users, but a few routinely hit that
limit and are locked out for the hour.
The choice of 800 queries/hour was arbitrary on my part. I would prefer to
gather metrics on usage in order
user has
access to only their 1 database.
My version is 4.0.13-standard-log.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Original Message -----
Fro
DuBois" <[EMAIL PROTECTED]>
To: "Gary Huntress" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, June 28, 2003 5:45 PM
Subject: Re: max_connections being ignored/overridden?
> At 17:26 -0400 6/28/03, Gary Huntress wrote:
> >I have some simple user qu
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
for 1 user scroll by at an alarming rate. 7800 in le
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Gary Huntress" <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 4:33 PM
Subject: Re: Confused about network traffic on mysql port
> >I have noticed on many occasions some extensive
pers
Visit http://www.freesql.org
- Original Message -
From: "GERST, MICHAEL (SBCSI)" <[EMAIL PROTECTED]>
To: "'Gary Huntress'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 4:44 PM
Subject: RE: Confused about network t
I have noticed on many occasions some extensive traffic on my internal
network that I cannot explain. Below you will see two sets of tcpdump
traces. I have a mysql server running on my internal host named
"herzegbol" and a windows 98 host named shelbyville
This trace is when the MySQL server i
Greetings,
I've been running a public MySQL server for a couple of years that now
supports several thousand users. I used to run this on a lowly PII-350 and
it ran quite fine with CPU loads usually hanging well under 0.20. The only
hitch was the time necessary to connect seemed to jump up t
Hi,
I'd like to add to the "security flaw" thread with my own experience.
I have been hosting MySQL databases for over 2 years and on a few occasions
have had user databases disappear.
Last month one of my admin databases was dropped. The only user who has
access to that database is root
I have upgraded from 3.23 to 4.0 and I have read over
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Up
grading-from-3.23. I have not yet run mysql_fix_privilege_tables yet and I
really want to since I intend to implement query quotas.
Since this is a production ser
Doubly bad to reply twice to your own posts I have more info though.
my startup script has max_connections=1000, and I cannot log in as the
superuser as mentioned here
http://www.mysql.com/doc/en/Too_many_connections.html
- Original Message -
From: "Gary Huntress&quo
Bad form to reply to ones own postbut I should have emphasized my major
symptom:
I cannot stop the server, "mysqladmin -pxxx shutdown" never returns.
This is in addition to the "too many connections" and "forcing close of
threads" errors
- Orig
As I mentioned in a previous post, I have been using 3.23 for a very long
time with no problems whatsoever. About 1 month ago I began to have
stability problems, unable to connect, unable to shut downhundreds and
hundreds of myslq processes
At first I thought this was a particular user, so I
Hi,
I've been running 3.23.37 on a redhat box. with zero problems for a
very long time. For the past 4 days or so I've had a persistent problem.
I think I had a user with an out of control query which caused the system to
run out of VM. I tried shutting down with mysqladmin but it failed.
A few weeks ago I posted a question regarding bandwidth management for a
very busy mysql server that is swamping my cable modem upload bandwidth and
impacting the rest of my network. I was seeking a way to manage connections
by capping the data transferred and I wondered if this would impact MySQ
Accidentally sent a bit too early
>
> My question is this. Database server network usage is very asymmetric,
> incoming queries are small, outbound datasets are probably considerably
> larger.Given that I will now be further limiting outbound flow without
> really impacting the arrival rate
Feel free to put data on my server. (almost a year, and I'm still here!
:)))
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: "David
I've just checked my IDE parameters for one of my linux mysql servers.
Using hdparm -c -d I've discovered that I'm running at the default 16 bit
non DMA. I'm assuming that enabling both of these should increase
performance, possibly significantly.
However, I'm concerned about doing this 1) on
Far less complicated than that. I will assume that MyODBC is installed and
a data source has been created that points to the mysql data of interest.
Load MS Access. On the table tab, select "new/link table" (or import if
you prefer). In the "files of type" selection, choose ODBC, then pick
I have a table of user info containing mixed case text. One user has
created a database named "brain" and another has created a database "Brain".
I was surprised to see that:
select * from users where dbname= "Brain" returns both "brain" and "Brain".
I read section 6.3.2.2 and select binary db
Very sorry that I don't have an answer, only a followup question related to
character sets
I'm a sheltered American, unfamiliar with anything beyond the default
ISO-8859-1. However, I run FreeSQL.org and I'm absolutely amazed at the
international usage I receive. This has caused me a fair amou
I've read over the section in the manual that covers grant/revoke but I
still have a question. I want to make sure I'm not assuming anything before
I start messing with 12000 user accounts.
If I create a user by issuing:
GRANT select, insert, update, delete, index, alter, create, drop
ON someda
I'm up to over 1 databases in one data directory and that is becoming a
performance problem as users make their connections. I would like to begin
running multiple servers on the same box.I made my first attempt tonight
and was confused. Before I screw up a production box perhaps someon
Hi,
In my "real life" job, I'm a web/database/whatever developer for a DoD
lab. We made the jump from Access to client/server architecture quite a few
years ago. We evaluated many choices and settled at the time on Sybase. Of
course, MySQL did not exist then (or may have, just not in a use
Any books that you buy will probably be derived from:
http://www.mysql.com/documentation/mysql/bychapter/
http://www.php.net/manual/en/
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://
If you are trying to gather meaningful statistics from your weblog, you
might wish to consider the open source program Analog
(http://www.analog.cx).It works on windows, *nix, and took me less than
5 minutes to set up. There is also fine documentation about weblog
processing in general at ht
I'm currently hosting about 6700 MySQL databases.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: "program tester" <[EMAIL PROTECTED]
In the past few days 3 different people have asked me about "xml support" in
mysql. I was unsure what to tell them actually, beyond saying "you can
easily export recordsets to xml documents".Obviously you can store
entire XML documents in a TEXT field, but I'm not sure thats really the
functi
Hi,
I run a mysql host that currently has about 5500 seperate mysql
databases. Yesterday one of my users reported to me that he couldn't
connect. I suspected many of the usual culprits (grants, network, wrong
password etc) but I eventually came to find that the database is *gone*
without a
While I have not specifically done a linux vs NT shootout, I have worked
with many similar programs on both platforms. My closest experience was
with the commercial database Sybase (ASE 12.0)
With the same data, and the same database schema on the exact same
hardware, we found that linux (RH 6.
This is actually very easy. Change the content type of the document that
you send back and then just send all the data back in a .
Make the first line of your php and only send a table, no etc.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.
My opinion onlyif you are a dot com, and are having critical problems
with a production server that you rely on to make your $$$, then you should
suck it up and pay for support. We pay $40k/year for commercial support on
our "important" Sybase database, and its worth every penny.
Regards,
G
Hi,
My meager little mysql server is now hosting about 5000 databases.
They typically seem to be web based chat BBS's like phpNuke, phpBB and
vbulletin. Typical tables are small, and typical queries are simple
"select * from table where id=somevalue". The users seem to be happy, but
of co
First, lets make sure we're all talking about the same thing. A general
definition of data mining would be "the automated extraction of predictive
information from large databases". Automated implies some sort of agent,
and by its very nature the predictions are statistical (hence the large dat
I would imagine that they just don't want to...possilbly for security
reasons or for manpower/support reasons.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Orig
1) I left my ESP in my other pants, so I can't really debug your code.
2) Somebody will probably tell you that this isn't the appropriate group
for questions like this. You might try news://news.php.net or a site like
http://www.phpdeveloper.org or http://www.phpbuilder.com for tutorials.
R
Here is the text of an email that I googled (eeek! its a verb!)
The algorithm you need is called "single-source, shortest path", also
known as "Dijkstra's algorithm". Here's one way to implement it, in
pseudo-code.
Shortest route on graph of locations in Inform
I seem to have a connectivity problem that I'm having trouble diagnosing.
I have an internal network (192.168.0.*) with mysql running fine on machine
"A". The outside world can get to A fine, and ordinarily so can machine
Bhowever randomly and more often, I cannot log into A from B using
m
I'll have to pipe up and say that, empirically, mysql far outperforms
postgres on a non-state-of-the-art server. I have seen 10 simultaneous
connections to mysql and a system load of 0.1 versus 1 instance of postgres
(postmaster) and a load of over 2 (and with 3 instances of postmaster a load
of
I've used a rule of thumb that I was told ages ago when working on other
databases that inserting records into a non-indexed table is faster
generally than inserting records into an identical but indexed table.
I realize that this statement is probably an antiquated guideline.and
I'd like to
Hi,
I've started mysql with the parameter -O wait_timeout=1000 and verified
that it is set using show variables. Yet I routinely see lingering
processes with times over 1100 and higher. I have about 1000 active
database users at the moment, most are connecting via php pages and I had
been r
I wrote a really cheesy tutorial that demonstrates a simple way to export
the results of a query to XML. It's located at
http://www.phpdeveloper.org/tutout.php?num=20
Would it be useful to add an option to mysqldump to also write an xml
document? I've considered trying to tackle that too :)
R
No, MySQL is neither PVM nor MPI aware and thus not a Beowulf application.
Had you asked this on the Beowulf mailing list they would have said too
because *by definition* Beowulf is solely intended for computational
clusters, not high availability or parallel database clusters.
Regards,
Gary "Sup
the "FM" clearly allows the use of a FOREIGN KEY clause in the CREATE TABLE
syntax
(http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CR
EATE_TABLE). Personally, I don't think its a stretch to assume that
mysqldump would (might || should ) maintain this definition.
After
Coincidentally, I used perl DBI for the very first time last night, and this
worked for me fine:
#!/usr/bin/perl
use DBI;
my $dbh = DBI->connect('DBI:mysql:mysql','username','mypassword')
or die "couldn't connect to database: ".DBI->errstr;
$dbh->disconnect();
Regards,
Gary "SuperID"
I really like using ADO and I've had very good luck with it. I have used
it extensively to connect to access, sybase, oracle, and mysql databases as
well as other non relational data sources (using the correct provider). I
believe that the flexibility is the best part about ADO. Therefore if
MySQL does not have a built in report generator. I use the commercial
product Crystal Reports as my report generator. It is quite powerful,
buggy in early versions, but they seem to be getting better. Try here
http://www.crystaldecisions.com/products/crystalreports/
Regards,
Gary "SuperID" H
There is a php mail tutorial at http://www.phpdeveloper.org/tutorial.php
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
- Original Message -
From: "Prasad Mhatr
In the MySQL documentation section that covers upgrades, it discusses the
process of upgrading between major releases. If I am upgrading MySQL within
a major version, say from 3.23.30 to 3.23.36, is it as simple as just
replacing mysqld?
Regards,
Gary "SuperID" Huntress
Are you really sure that you want to create multiple databases? and not
just many tables in one database? A minor point, but it might make some
things simpler.
It sounds like you have two goals. 1) you want to make dynamic web pages
that query a mysql database. 2) you want to manage the data
You can do this by just issuing that statement as a regular SQL query. I
was able to connect via an ADO connection:
set myRecordset = conn.execute("describe thedatabase.thetable")
and I'm sure you could do this with php via mysql_query("describe
thetable")
In both cases you end up with
I've noticed, by doing "show processlist", that a few users end up with
dozens (sometimes 50) sleeping processessome are 4 hours old. What is
this typically caused by? I believe that most of my users connect using
php, and I believe that if they omit mysql_close() that the connection is
su
Open your datasource (via control panel/ ODBC datasource administrator) and
make sure the option "Change BIGINTcolumns to INT" is checked. This will
correct your problem with "show table status" and "show processlist"
Regards,
Gary "SuperID" Huntress
I have been offering free hosting of MySQL databases at freesql.org for the
last few weeks. As a result I now have several hundred databases (which I
think is great!), with a subset (perhaps 50) that are in active use. I
would like to implement a policy where I can cull dormant or otherwise
aban
Is there a particular reason that you are planning to shut it down? Lack
of interest in maintaining it? Hosting cost? Lack of traffic?
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http
Mysql has many command line options. Try mysql --help for a list, and you
will see that the -h option is used to specify the host.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.fr
I'm trying to write a simple windows client to monitor my MySQL server. I'm
using ADO and I can connect to the server fine from a remote host and issue
queries using the ADO connection object like:
set rs = conn.execute ("show databases")
conn.execute("use " & strDBName )
set rs = co
My firewall has denied and logged several of the following messages:
Packet log: input DENY eth0 PROTO=6 192.168.0.1:37656 66.31.176.185:3306
L=40 S=0x00 I=26581 F=0x T=39 (#2)
As you can see, it is a spoofed IP trying to connect to the mysql port.
I've looked around at basic security sites
I had a similar problem after I installed a driver set, I don't think it was
the MyODBC drivers, but the outcome was the same, a very generic windows
error that was not even associated with an attempted connection.
I had to reinstall the Microsoft MDAC components, available here
http://www.micros
- Original Message -
From: "Luis" <[EMAIL PROTECTED]>
To: "Steve Ruby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 04, 2001 9:59 PM
Subject: Help with ODBC
> Thank you for all the help on MyODBC but I can't connect to mysql server
> threw access.
>
> Here are the st
The MySQL manual is one of the best I've seen
1)
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html
#Commit-rollback
2)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOI
N
Regards,
Gary "SuperID" Huntress
===
you probably want something like:
select substring_index( mycolumn, ". ", 2) from mytable;
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://superid.dyndns.org:8080/freesql/index.
I have received several of the same messages, and I too believe that I'm
virus free (I just updated and ran NAV).
Since the message is signed with an ad for marshal software, which is sells
anti-virus services, I am viewing this as 100% spam.
Gary
- Original Message -
From: "Lindsay Ada
e error near '(now(), interval 5 day) and
> date_sub(now(), interval 2 day)
> order by datestamp d' at line 2
>
> :-((
>
> when I entered exactly what you suggested. What am I doing wrong?
>
> S.
>
>
> >From: "Gary Huntress" <[EMAIL PROTECTED]
Try this:
select * from visitor where
datestamp between
date_sub(now(), interval 5 day) and
date_sub(now(), interval 2 day)
order by datestamp desc;
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to develo
I don't mean to be argumentative, but what is everyones love affair with stored
procedures? I like putting my logic in the mid-tier and I'm constantly battling my
Sybase Admin at work who maligns me whenever they spot a query in my codeeven a
very simple select "oh, I can make that a store
I'd try:
Select distinct count(id) from myTable;
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://superid.dyndns.org:8080/freesql/index.php
"Currently 100% Slogan Free"
- Or
I am looking for MySQL users to beta test the following free database
hosting service:
http://superid.dyndns.org:8080/freesql/index.php
I've done a fair amount of testing myself, but I need a few more people to
work the rest of the bugs out. I'd be grateful if people would do the
following
80 matches
Mail list logo
