Innodb Error 1030

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

Re: Tuning a Server with 10,000 databases

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, Just a guess, but could

Re: Tuning a Server with 10,000 databases

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 David Logan wrote: mos

Tuning a Server with 10,000 databases

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 unsubscribe:http

16 vs 41 byte password hashes

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

Understanding Unicode

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

cannot drop database

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

Re: Efficiently finding a random record

, 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 Huntress [EMAIL PROTECTED] Cc

Re: Efficiently finding a random record

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 =

Users and Max_questions

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

Feature request Relating To max_questions

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

Multiple Self Joins and Left Joins ?

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|

Query Questions Per Hour Per User?

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

max_connections being ignored/overridden?

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

Re: max_connections being ignored/overridden?

] 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 quotas set to help balance my server load. I think I've implemented them

Re: max_connections being ignored/overridden?

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 - From: Paul DuBois [EMAIL PROTECTED] To: Gary Huntress [EMAIL

Confused about network traffic on mysql port

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 is

Re: Confused about network traffic on mysql port

://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 traffic on mysql port Somebody got control of mysql, or your rooted

Re: Confused about network traffic on mysql port

- 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 traffic on my internal network that I cannot

Linux Filesystem Type and Performance

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

MySQL Security Flaw - Dropped Databases

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

Reversing mysql_fix_privilege_tables ?

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

At Wits End With Unstable Unusable Server

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

Re: At Wits End With Unstable Unusable Server

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 - Original Message - From: Gary Huntress

Re: At Wits End With Unstable Unusable Server

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 [EMAIL PROTECTED

Mysqladmin can't shutdown server

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

Bandwidth Throttling - a followup

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

Re: Bandwidth Throttling?

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 of

Re: Are there any openly-accessible MySQL server [I can use for testing]?

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

linux and hdparm

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

Re: Avery Labels with MySQL

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

Re: Mysql and Japanese Characters - A Followup Question

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

Account Management Question

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

Re: Selling MySQL to Government

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

Trying to Start Two Servers

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

Re: SELECT Query in PHP

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

Re: Howmany databases??

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] To:

XML Support

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

Database Disappeared

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

Re: Performance

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

Re: database/php question

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 table. Make the first line of your php ?header(content-type: application/vnd.ms-excel) ? and only send a table, no html etc. Regards, Gary SuperID Huntress

Re: MySQL Spawns Many Processes and Uses 100% CPU! PART #2

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,

mysqld processes, system load, and performance

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

Re: beowulfen and mysql

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 data

Re: Errors on Mysql page

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.

Re: Shortest route between 2 cities

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

Troubleshooting connectivity

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

Re: Internals Of MySQL

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

Re: Speed of query - And Indexes

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

Server Config wait_timeout

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

Re: xml support?

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 :)

Re: Foreign Key in creating tables

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

Re: DBI:mysql

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

Re: API or ADO??

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

Re: reports

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

Re: mail all users in MySQL database

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 Mhatre

Upgrading from 3.23.30

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

Re: Metadata Retrieval

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

Re: Problem with MyODBC via VisualBasic6 ADO2.6 - Recordset

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

Too many sleepers?

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

Identifying unused databases

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

Re: Need feedback

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

Re: connecting to a remote machine

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

Logging connections and show processlist

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 =

Firewall logged probes on mysql port

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

Re: beggin, commit, and rollback

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

Re: Help with ODBC

- 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 steps on

Re: Help with ODBC

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

Re: limit text column

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

Re: Selecting 3 days worth of data with an offset of 5 days from now()

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

Re: Selecting 3 days worth of data with an offset of 5 days from now()

ub(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] To: "Stefen Lars" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Selecting 3 days worth of

Re: ---- Virus Detected ----

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

No Stored Procedures - Big Deal

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

Re: Counting distinct rows

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" -