replication

All, I have a situation whereby I have two servers each running mysql in a Master slave replicated setup. Currently if the master server goes down we have to manually failover the database servers, taking a snaphost etc.. Is this still the optimal way to do this, or has the 'Change Master' command

Provider error '80040e37'

Hello, I am having trouble selecting text fields from my database. If I set the column type to varchar(255) it works fine. But when I change the column type to text or blob ( I need more space ) I get the error: Provider error '80040e37' Table does not exist. If I then change it back to var

Re: InnoDB & MySQL-4.0.11a using Linux Mandrake RPMs

Andy Jefferson wrote: > a simple question ... I have MySQL installed on my Mandrake Linux system, > via the RPM's > MySQL-4.0.11a-5.1mdk > MySQL-common-4.0.11a-5.1mdk > MySQL-client-4.0.11a-5.1mdk > > Can anyone tell me how > a) I check if InnoDB is available with this version ? (in the RPM releas

How to measure the number of descriptors mysql is using..

Greetings How do I measure the exact amount of descriptors mysql is currently using, is there some formula based on SHOW status? For example open_tables + open_files * threads or something? I have a sneaky suspicioun my mysql is running out of those descriptors since mysql starts rejecting co

Re: innodb

Gustavo, please send me the whole .err log. I have not seen the error in my own tests. There might be some rare bug in keeping or reading of log sequence numbers. Regards, Heikki .. Gustavo A. Baratto Date: September 23 2003 3:52 pm Subject: Re: innodb I haven't touched the

Re: Database quotas?

Yeah but when they make a nwe table, it will be owned by root.root wont it? > On Wed, Sep 24, 2003 at 01:38:43PM +1000, [EMAIL PROTECTED] wrote: >> Hey guys, >> >> is it possible to bind some databases to a userid so u can do disk >> quotas on them, or limit how big a db can be? > > chown the file

Re: Usage Monitoring

Your right - I created a temp database to test, and the innodb engine shows the same stats for that new database (with no tables, no rows) that it did for a database with tables and data. I guess InnoDB keeps one set of stats for all databases. I guess I'm too used to Oracle, that tracks statistic

RE: IP Address Operations in MySQL

you can also convert the ip to an ip number and store it that way. makes it easier so you don't have do deal with a octete'd number :) > -Original Message- > From: Hassan Schroeder [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2003 1:57 PM > To: MySQL Mailing List > Subject:

Re: Usage Monitoring

On Tue, Sep 23, 2003 at 09:12:46PM -0700, David Griffiths wrote: > If you're using InnoDB, then that's not exactly true. > > >From the msql client, you can type "show innodb status" and you'll get a > bunch of stats on the database, which include: > > -- > ROW OPERATIONS > ---

Re: Database quotas?

On Wed, Sep 24, 2003 at 01:38:43PM +1000, [EMAIL PROTECTED] wrote: > Hey guys, > > is it possible to bind some databases to a userid so u can do disk quotas > on them, or limit how big a db can be? chown the files. Just make sure they're group-wrtiable so that MySQL can write to 'em. -- Jeremy

Re: Usage Monitoring

If you're using InnoDB, then that's not exactly true. >From the msql client, you can type "show innodb status" and you'll get a bunch of stats on the database, which include: -- ROW OPERATIONS -- 0 queries inside InnoDB, 0 queries in queue Main thread process no. 5741, id

Re: case sensitive?

>From the MySQL manual A.5.1 Case-Sensitivity in Searches By default, MySQL searches are case-insensitive (although there are some character sets that are never case-insensitive, such as czech ). That means that if you search with col_name LIKE 'a%' , you will get all column values that sta

Database quotas?

Hey guys, is it possible to bind some databases to a userid so u can do disk quotas on them, or limit how big a db can be? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Usage Monitoring

On Tue, Sep 23, 2003 at 09:30:14PM -0400, John May wrote: > Is there any way to monitor which databases are being used the most > heavily on a MySQL server? Thanks for any info! No. MySQL doesn't keep per-database statistics. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!

Re: Usage Monitoring

Might try mytop (search google for it) .. jeremy z wrote it.. it works well for realtime monitoring.. On Tue, 23 Sep 2003, John May wrote: > Is there any way to monitor which databases are being used the most > heavily on a MySQL server? Thanks for any info! > > - John > > -- > > ---

case sensitive?

Hi, I have questions on string comparison: Table: user_att +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | user_id | int(11) | | PRI | 0

Re: Usage Monitoring

Mytop ? > Is there any way to monitor which databases are being used the most > heavily on a MySQL server? Thanks for any info! > > - John > > -- > > --- > John May : President > P

RE: Excel 2 CSV into phpMyAdmin

I save as CSV (MS-DOS). I then import into MySQL using SqlYog and the following parameters: Line terminator \r\n Delimiter , Strings Optionally surrounded by " That gives me a successful import every time. I have tried other variations and achieved same results as you - 'jumbled'

follow-up

I'm having this error and am not sure what's causing it. I'm using PHP/MySQL and Apache on Windows XP. I've looked at my server, user, password settings and they seem to be accurate, but the error seems to indicate this is the problem. Any help would be appreciated.

Re: Load Takes Too Long?

Randy Chrismon wrote: I just loaded about 125,000 records, each containing about 30 columns into an empty, newly created, mysql table. It took 56 minutes. Isn't that a little long? The table design was driven, in part, by an existing reporting application. The data to populate the table is being

Wildcards not allowed in GRANT commands for table names?

The docs explicitly say that wildcards are allowed when specifying database names in GRANT commands, but don't say anything about wildcards being allowed in table names. For example, in one large database I have table names that are grouped by function: security.ids_events secuirty.ids_correlatio

Re: FULL Text Limitation issue!

At 17:07 +0100 9/23/03, Imran Aziz wrote: Hello All, I have come to know that mySQL FULL TEXT search has the limitation of the search phrase to be more then 3 charators. In order to alter the default behavior one has to alter the variable ft_min_word_len. I am running MySQL 3.23.54 and t

Re: speeding up a search

well, I have a query with 6 or 7 tables and some of them have more than 130,000 records, plus 2 inner joins and 3 left joins and a variable condition, but still is fast!!! BUT I limit the output to about 30 records ( to fit in a screen ). make sure to have index on the link key. - Original M

Re: IP Address Operations in MySQL

Aaron Clausen wrote: I'm running 3.23.49 on a Win2k machine and wonder if anybody has > some advice on how to write queries dealing with IP addresses. > Specifically, I have a table with an ip address field. I want to > be able to do queries based on subnet. Has anybody got anyting > like this? Y

Re: innodb

Even with brand new log files, I got the messages again: 030923 13:37:10 InnoDB: Error: page 2621 log sequence number 0 758479545 InnoDB: is in the future! Current system log sequence number 0 330424282. InnoDB: Your database may be corrupt. 030923 13:37:10 InnoDB: Error: page 2622 log sequence

Re: speeding up a search

Make sure stamps.item_id and links.item_id are indexed, I had a similar problem, and when I indexed the columns, it went down to less than a half second. KL John Almberg wrote: > I am trying to find records (from the 'stamps' table) that are NOT > related to records in the 'links' table. To do

InnoDB & MySQL-4.0.11a using Linux Mandrake RPMs

Hi, a simple question ... I have MySQL installed on my Mandrake Linux system, via the RPM's MySQL-4.0.11a-5.1mdk MySQL-common-4.0.11a-5.1mdk MySQL-client-4.0.11a-5.1mdk Can anyone tell me how a) I check if InnoDB is available with this version ? (in the RPM release notes it seems InnoDB was inclu

Re: FULL Text Limitation issue!

On 23 Sep 2003 at 17:07, Imran Aziz wrote: > I have come to know that mySQL FULL TEXT search has the limitation > of the search phrase to be more then 3 charators. In order to > alter the default behavior one has to alter the variable > ft_min_word_len. I am running MySQL 3.23.54 a

Usage Monitoring

Is there any way to monitor which databases are being used the most heavily on a MySQL server? Thanks for any info! - John -- --- John May : President Point In Space Internet Solutio

Load Takes Too Long?

I just loaded about 125,000 records, each containing about 30 columns into an empty, newly created, mysql table. It took 56 minutes. Isn't that a little long? The table design was driven, in part, by an existing reporting application. The data to populate the table is being exported from Lotus Not

Does MySQL for windows support base 64 encoding ?

Does anyone know if MySQL for windows support base 64 encoding ? Or where this documented ? Jeff Stout CSG Systems, Inc. 303-200-3204 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.m

Re: speeding up a search

Run explain on the query and see if indexes are being used. John Almberg wrote: I am trying to find records (from the 'stamps' table) that are NOT related to records in the 'links' table. To do this, I'm using a left join. For example: select s.*, l.item_id as lid from stamps as s left join li

Re: speeding up a search

Wow! One of the fields was a primary key, but the other wasn't. When I indexed the second field the performance went up from 2 minutes to about 2 seconds. Thanks a bunch. -- John Kelley Lingerfelt wrote: Make sure stamps.item_id and links.item_id are indexed, I had a similar problem, and when

Re: Problems with MySQL on Linux (Linux Newbie)

Donald Tyler <[EMAIL PROTECTED]> wrote: > > I am just learning to use Linux and I am having some problems with > getting MySQL to load. > > > I have successfully installed & tested both Apache & PHP, so I am pretty > comfortable with the whole configure and make processes. > > > I followed the

Re: Using SQL variables

You have to initialize @var to something first, or it's just null. So try "set @var := 0;" before your query. Also, you don't say which version of MySQL you're using, but I'm using 4.0.14 and I can't say "... as number, * from ...", but have to say "... as number, tableName.* from ...". HTH, --

speeding up a search

I am trying to find records (from the 'stamps' table) that are NOT related to records in the 'links' table. To do this, I'm using a left join. For example: select s.*, l.item_id as lid from stamps as s left join links as l on (( s.item_id=l.item_id)) WHERE (s.sold is null); This worked great w

Re: Memory and C API...

Hi, I don't see anything wrong with that. If I was in your shoes I'd make sure I don't have any buffer overflows anywhere between the definitions and where you use the variable - these are notorious to only cause segmentation faults when there's no more memory to silently consume (e.g variable to

FULL Text Limitation issue!

Hello All, I have come to know that mySQL FULL TEXT search has the limitation of the search phrase to be more then 3 charators. In order to alter the default behavior one has to alter the variable ft_min_word_len. I am running MySQL 3.23.54 and the FULL Text search works fine , but I am

IP Address Operations in MySQL

I'm running 3.23.49 on a Win2k machine and wonder if anybody has some advice on how to write queries dealing with IP addresses. Specifically, I have a table with an ip address field. I want to be able to do queries based on subnet. Has anybody got anyting like this? -- Aaron Clausen [EMAIL

MySQL Control Center and InnoDB

Hi, I am very new to MySQL. Does anyone know if InnoDB works with the tool MySQL Control Center?? If works, what I have to do? If does not work, how I create the InnoDB tables in MySQL? regards

Re: SHOW SLAVE HOSTS returns nothing ?

On Mon, 22 Sep 2003 12:25:48 +0300 Victoria Reznichenko <[EMAIL PROTECTED]> wrote: > Ion-Mihai Tetcu <[EMAIL PROTECTED]> wrote: > > > > I had set up replication between 2 4.0.14 servers and everything > > seems to work OK. Except that SHOW SLAVE HOSTS on muster returns > > nothing. What am I miss

innodb: storage requirements

A simple question regarding storage allocated / reported by MySQL/InnoDB. If BIGINT takes 8 bytes, and a table has exactly four BIGINT columns, why is the reported avg. row length 148 bytes? mysql> show table status from pmsystem2 like 'editor_competence_product'\G *** 1. r

Table corruption w/ Optimize

I have a Mysql 4.0.14 standard database. A developer runs 'mysql optimize table_name' on a small database. After running it, the SQL gui reports that the 'MESSAGES.MYI' cannot be read. We have to use myisamchk -o on the table to get the table back but it is missing a lot of updates. Any idea wh

Re: nested select alternative??

Upgrade to MySQL 4.1 and your nested query will run with no problem. But remember to change TOP 50 into LIMIT 50 Thanks Emery - Original Message - From: "Wajih-ur-Rehman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 12:40 Subject: nested select alternative

Re: Using SQL variables

Can you run this query and tell me if it works on your machine? SELECT (@var := @var + 1) AS Number, * FROM any_table_with_records; As per the manual, this should give something like: +-- NumberFieldOne 1Value 2Value 3Valu

Innodb & disk geometry

Hi all, i've been trying to follow the Innodb upgrade that will allow setting up multiple separate blocks of disk for different databases, where the admin has the ability to put databases in specific tablespaces. There has been a bit of talk here, but whenever i go to the MySQL or Innodb web si

Problems with MySQL on Linux (Linux Newbie)

Hi, I am just learning to use Linux and I am having some problems with getting MySQL to load. I have successfully installed & tested both Apache & PHP, so I am pretty comfortable with the whole configure and make processes. I followed the MySQL installation docs to the letter, however w

Re: nested select alternative??

That query will work. The note is just dosn't matter, when building your SQL statment replace it with a varible. In PHP for instance you can do the following $IDValue = 100 ; $Query = "SELECT id FROM myTable WHERE infoId IN (3) AND id $IDValue ORDER BY id ASC LIMIT 49,1" ; Job done. No idea why

Re: nested select alternative??

"Wajih-ur-Rehman" <[EMAIL PROTECTED]> wrote: > I have this statement that works perfectly fine in Access and MSSQL: (In > words, i first get the top 50 id values according to the where clause and > then i get the maximum of those id values) > > "SELECT Max(id) FROM (select top 50 id from myTable

Re: utf8 collations with national symbol's grouping

Sorry :) i see that simbols i've written was converted into ASCII symbols. That is what i need, but in MySQL :). So is there any collation where: a = a-umlaut = a-with-any-other-"fix" ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://list

Re: Amount of memory: rule of thumb

Physical RAM = Database size is not a great rule of thumb. What if your database has 20 gigabytes of data? But say you have a 3 gigabyte database, and 3 gigabytes of RAM. You can't give all that RAM to the database. The operating system needs a bunch for itself and the processes running. If you t

RE: Memory and C API...

it could be that err is initialized as > 0 or not initialized at all -Original Message- From: Lars Wenderoth [mailto:[EMAIL PROTECTED] Sent: 23 September 2003 13:02 To: [EMAIL PROTECTED] Subject: Memory and C API... Hello there! I have a problem with a little C program i am writing.. It

Re: innodb

I haven't touched the log or the data files before or after I upgraded mysqld... Well, now I recreated the log files and so far that error didn't show up again. let's pray :) thank you very much Heikki Tuuri wrote: Harald, 030923 15:10:14 InnoDB: Error: page 53 log sequence number 6 19041

Custom/conditional grouping? (repost)

[Sorry for the accidental premature sending in the first post...] CREATE TABLE `payments` ( `date` date NOT NULL, `payee` varchar(255), `amount` double ) INSERT INTO payments VALUES ('2003-05-01','david',38); INSERT INTO payments VALUES ('2003-06-02','david',13.4); INSERT INTO payments VALUE

RE: Amount of memory: rule of thumb

Ah, of course. My apologize for being insufficient. OS will be Linux, Redhat 7.2. Please note, I'm only looking for a very general (and probably rough) estimate for the amount of internal memory. That's why a rule of thumb. There are a lot of circumstances that can make the world look completely d

Custom/conditional grouping?

Can I do this with in pure SQL (instead of having to create logic in programming language)? Thanks in advance, -- dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Amount of memory: rule of thumb

jihad! My opinion is memory concerns are bound to operating system. What is recommended for your OS? Best, Jerry Cornelius Hoeven, Maarten van der wrote: Hi all, Is there a rule of thumb how much internal memory you should install, when pursuing maximum performance? A rule of thumb like: "Int

Re: innodb

Harald, >030923 15:10:14 InnoDB: Error: page 53 log sequence number 6 190415140 >InnoDB: is in the future! Current system log sequence number 1 3864837242. >InnoDB: Your database may be corrupt. what do you think is the correct log sequence number? How much do you have data? The pag

Re: errors

"Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> wrote: > > I often get these errormessages. Why? If you often get table coruption, you can make a test case. Here you can find instruction how to do it: http://www.mysql.com/doc/en/Reproduceable_test_case.html > > * X clients is using o

Re: Memory and C API...

Hi, Could you post your definitions for 'dbase' and 'err'... Gerald. On Tue, 23 Sep 2003, Lars Wenderoth wrote: > Hello there! > > I have a problem with a little C program i am writing.. It uses > SSL-encrypted connections to a special server. This server needs > information from a MySQL databa

Re: innodb

Harald, if your server does not crash, then the database probably is not corrupt. But having wrong log sequence numbers can make it corrupt. What is the error message in your case? 4.0.15 contains the check, I think 4.0.14 did not. I am wondering if there could be some bug in InnoDB which lowers

RE: errors

Jonas, Can you check the mysql.err log and see if anything has been written their? -Original Message- From: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 7:36 AM To: [EMAIL PROTECTED] Subject: RE: errors Im pretty sure that the server has

RE: errors

Im pretty sure that the server has not been rebooted inproperly. Can there be any other reasons? The errors occur quite often. > -Ursprungligt meddelande- > Från: Victor Pendleton [mailto:[EMAIL PROTECTED] > Skickat: den 23 september 2003 14:26 > Till: Datatal AB - Gauffin, Jonas; [EMAI

Re: Does replication continue if master reboots?

S?ren Neigaard <[EMAIL PROTECTED]> wrote: > What happends if the master reboots, does the slave start replicating again > after the reboot? If master goes down, slave will try to reconnect every master-connect-retry seconds: http://www.mysql.com/doc/en/Replication_Options.html -- For te

RE: errors

Jonas, Are you getting these messages when you run a check tables? These errors can be caused when the database is not `cleanly` shutdown. -Original Message- From: Datatal AB - Gauffin, Jonas [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 7:22 AM To: [EMAIL PROTECTED] Subjec

VB: errors

No answers? No suggestions? Surely, someone must have got these errors. > -Ursprungligt meddelande- > Från: Datatal AB - Gauffin, Jonas > Skickat: den 22 september 2003 14:16 > Till: [EMAIL PROTECTED] > Ämne: errors > > > Hello > > I often get these errormessages. Why? > > * X

Memory and C API...

Hello there! I have a problem with a little C program i am writing.. It uses SSL-encrypted connections to a special server. This server needs information from a MySQL database. The SSL-encryption is running fine. The MySQL code runs fine, if the SSL code is not there.. Since i need both at the sam

Re: LOAD DATA INFILE failing on OS X Server

Bill Leonard <[EMAIL PROTECTED]> wrote: > Thank you for the response Victor! Victoria ;) > > On 9/22/03 4:02 AM, "Victoria Reznichenko" <[EMAIL PROTECTED]> > wrote: > >>> One of our users is trying to execute the LOAD DATA INFILE command (using >>> PHP to talk to MySQL). It is failing for some

Re: performance problem switching from Win2000 to WinXP clients!!

Angela Olmeijer escribió: Hi there! I encountered a performance problem when I switched from a Win2000 machine to a WinXP machine to access MySQL via a MS Access (XP) Front-end. Simple queries take 20 times more time to appear on screen. Here's a rundown of hard-/software. Windows 2000 Windows

Re: Access denied

Hi, You should do this: $connection=mysql_connect("host", "username", "password"); And then when querying: $result=mysql_db_query("database", "select * from table"); >From your error message it seems that your database is called simply 'database', and >that the username is empty. This doesn't

nested select alternative??

I have this statement that works perfectly fine in Access and MSSQL: (In words, i first get the top 50 id values according to the where clause and then i get the maximum of those id values) "SELECT Max(id) FROM (select top 50 id from myTable where infoId in ( 3 ) AND id > 100 order by id ASC) A

Re: MySQL user privileges

"H?kon Nilsen \(Exinet AS\)" <[EMAIL PROTECTED]> wrote: > > I *had* the anonymous user, but I deleted it since I couldn't find the use > for it. But I figured out what the problem was. I was > using --safe-show-database, but it didn't seem to work. > > My error was that I gave users privileges. I

performance problem switching from Win2000 to WinXP clients!!

Hi there! I encountered a performance problem when I switched from a Win2000 machine to a WinXP machine to access MySQL via a MS Access (XP) Front-end. Simple queries take 20 times more time to appear on screen. Here's a rundown of hard-/software. Windows 2000 Windows XP PIV processor PIV pr

Does replication continue if master reboots?

What happends if the master reboots, does the slave start replicating again after the reboot? Med venlig hilsen/Best regards Søren Neigaard System Architect Mobilethink A/S Arosgaarden Åboulevarden 23, 4.sal DK - 8000 Århus C Telefon: +45 86207800 Direct: +45 86207

Access denied

Hi list,   I am invoking mysql through php, so when i try to connect, it gives me this error message as i connecting mysql as localhost to 'database' database. While I dind't specify user/passwd for that.     Access denied for user: '@localhost' to database 'database'               Than

Re: trying to figure out error in PHP/MySQL

"Will Johnston" <[EMAIL PROTECTED]> wrote: > Hello, I'm new to the group and hoping someone can help me figure out a > problem which must be fairly common to new PHP/MySQL users. I have > PHP/MySQL/Apache installed on my Windows XP system. I'm using a supplied PHP > script for making calls from Act