Re: Large database with High Availability - how to do it?

Hi Daniel, Daniel Ek wrote: I really thought that MySQL tried to produce MySQL cluster for common hardware and with the design principle; more nodes with common hardware, insted of few nodes with extreme hardware. we do. I will probably never work for a company that can afford that kind of "supe

Re: Large database with High Availability - how to do it?

Hi Daniel, Daniel Ek wrote: Jonas Oreland wrote: Hi Daniel, Daniel Ek wrote: I really thought that MySQL tried to produce MySQL cluster for common hardware and with the design principle; more nodes with common hardware, insted of few nodes with extreme hardware. we do. I will probably never wor

Re: Large database with High Availability - how to do it?

Jochem van Dieten wrote: Daniel Ek wrote: Jonas Oreland wrote: Daniel Ek wrote: I today have a database using 20GB storage, which actually means that I should have at least 30GB (40GB recommended) ram using Mysql cluster. This could be 40 boxes with 1G ram each. But doesn't that increase the lo

MySQL Server - automatic shutdown

Hello: We are using MySQL database on a FreeBSD server. The problem we are facing is sometimes the MySQL server is automatically shutting down. There is no error logged on the server. The entry in the log file "mysite.com.err" shows: 040525 21:52:37 /usr/local/mysql-3.23.49/libexec/mysqld: Normal

DATETIME question

Given a column DATETIMEcolumn (-MM-DD HH:MM:SS), is there a SELECT statement that will: select all entries whose (TIME) of DATETIMEcolumn is BETWEEN 'HH:MM:SS' AND 'HH:MM:SS', but whose (DATE) is anything? Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.co

GROUP BY with MAX

Hi, I have a table that looks like: mysql> select * from test3; ++++ | sub_id | date | data | ++++ | 1 | 2004-05-01 | data 001 | | 1 | 2004-05-02 | data 002 | | 1 | 2004-05-03 | data 003 | | 2 | 2

RE: Is MySQL 4.1 ready?

I was told they found a bug that they wanted to fix. So "soon" is what I was told. Probably by the end of this week or the beginning of next week. Donny > -Original Message- > From: Marc Greenstock [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 25, 2004 11:40 PM > To: [EMAIL PROTECTED]

Re: Very Strange data corruption

Michael Stassen wrote: This comes up frequently. MySQL's behavior is explained in the manual . It begins: That's interesting, and I guess one just has to accept it as part of the mysql philosphy. I don't agree, as I don't like the data

Re: Is MySQL 4.1 ready?

"Wait until 4.1.2 is out in the next few days." - Do you know where I can find any indication of when 4.1.2 is expected to be released? Marc. ""Donny Simonton"" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Wait until 4.1.2 is out in the next few days. I've been using it since >

RE: Is MySQL 4.1 ready?

Wait until 4.1.2 is out in the next few days. I've been using it since 4.1.0, besides a few little bugs here and there, which almost every version has, it's very stable. I won't install any other version of any of my machines. Donny > -Original Message- > From: Marc Greenstock [mailto:[

Is MySQL 4.1 ready?

I would like to hear from people who have tested version 4.1 to determine if I should upgrade now or wait until it's in production release? Marc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FW: Re: FW: create database in specified character set

> -Original Message- > From: michael_wu[吳宏達] > Sent: Wednesday, May 26, 2004 9:12 AM > To: [EMAIL PROTECTED] > Subject: Re: FW: create database in specified character set > > Hi Hassan again, > Thanks for your kindly support. My program now works. I post > the so

Test errors with 4.0.20

Hello, I'm attempting to compile 4.0.20 and I'm receiving during testing (and sometimes compiling). My config is as follows: Dual Pentium III 1Ghz SCSI Raid 10 (~90G) Red Hat Linux release 7.3 (Valhalla) (not customized) When I configure with --prefix=/usr/local/mysql4 and then 'make'. The ma

Re: Adding to a record

Seems like you could do it either way: PHP or MySQL Depends if you want php or mysql to perform the calculation. Daniel Venturini wrote: Hello. Quick easy question I think? I display a INT value to a page (php) by querying mysql. I want to be able for someone to put a new number and add to that r

Re: Adding to a record

You might want to acctuly read through the documentation, or get a book on php/mysql. But you would send to the query: UPDATE 'table' SET number='' WHERE id= - Original Message - From: "Daniel Venturini" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 25, 2004 7:04 PM Sub

Adding to a record

Hello. Quick easy question I think? I display a INT value to a page (php) by querying mysql. I want to be able for someone to put a new number and add to that record. How would I go about doing this. Would this be a mysql command or a php thing? Thanks in advance.

196608 thread error

Hi, What is the cause of the error below? 040520 14:55:21 mysqld started 040520 14:55:21 Warning: Asked for 196608 thread stack, but got 126976 The server shutdown by itself, both RPM build and compiled from source doesn't run. The system is running in Fedora Core 2 in my laptop.

Problems with MySQL 4.0.20

We had some servers that were upgraded from 4.0.17/18 to 4.0.20 and had several problems thereafter: 1. Tables with FTS indices became corrupted, with queries on them causing segfaults on the servers. 2. BinLog files were getting created with ownership of root, not mysql. Then Mysql complains tha

Re: DB hanging

Brandon Metcalf wrote: We are running 3.23.58 on Solaris 8 and seeing the following problem. Periodically, mysqld gets into a state where we can't query just one table in all of our DBs--queries just hang. Restarting mysqld always fixes the problem, but a SIGKILL is required to stop it. Could this

Re: Posting Articles in Databases

--- Michael Kruckenberg <[EMAIL PROTECTED]> wrote: > David, > > MySQL is up to the task. Oodles of people doing > this. We do something > similar for course syllabi, thousands of documents > (currently 113,676), > both in XML and HTML, which can be as large as 100 > pages when printed. > I'm s

Re: Posting Articles in Databases

David, MySQL is up to the task. Oodles of people doing this. We do something similar for course syllabi, thousands of documents (currently 113,676), both in XML and HTML, which can be as large as 100 pages when printed. I'm sure there are examples out there with more impressive statistics. Mike

Re: Large database with High Availability - how to do it?

Daniel Ek wrote: Jonas Oreland wrote: Daniel Ek wrote: I today have a database using 20GB storage, which actually means that I should have at least 30GB (40GB recommended) ram using Mysql cluster. This could be 40 boxes with 1G ram each. But doesn't that increase the locking conflicts significantl

Re: Very Strange data corruption

This comes up frequently. MySQL's behavior is explained in the manual . It begins: | To be able to support easy handling of non-transactional tables, all | columns in MySQL have default values. | | If you insert an ``incorrect'' value i

Re: MySQL performance on FreeBSD compared to Linux

Hello Chris, I'm not familiar with super-smack, but it's compared to Apaches 'ab' which IMO is great for getting quick performance numbers but should in no way be trusted compared to a real world production environment. We run probably about 50+ dedicated mysql servers on various FreeBSD 4.X rele

Looking for a C API if it exisits

Hi all, I've been working with getting my on going C project merged with MySQL. So I can have an interactive Web Site incuded with it. I was wondering, when working with the rows... I'm having to call the values like: name = str_dup(row[0]); // returns me an memory allocated pointer Is there a

Posting Articles in Databases

I finally got my PHP add/edit form to work. While working on it, it occurred to me that I could use it to post and modify more than bits of data in tables. I could use it to make pages that people with no web design skills can add articles to. Most of my post focuses on PHP; my main question regar

Re: Large database with High Availability - how to do it?

Jonas Oreland wrote: Hi Daniel, Daniel Ek wrote: I really thought that MySQL tried to produce MySQL cluster for common hardware and with the design principle; more nodes with common hardware, insted of few nodes with extreme hardware. we do. I will probably never work for a company that can aff

RE: DB hanging

If you want to check a table while the database is being used I suggest using mysqlcheck instead of myisamchk. The table is `relatively small. I would suggest running an optimize table or an analyze table to reestablish the cardinality. -Original Message- From: Brandon Metcalf To: Victor

Re: Search for relationships that aren't present

a LEFT JOIN should do the trick something like this: SELECT users.user_id FROM users LEFT JOIN comps_users_link ON (users.user_id=comps_users_link.user_id) WHERE comps_users_link.computer_id IS NULL olinux --- Brad Tilley wrote: > Three tables: > > computers (Describes computers) > use

RE: Very Strange data corruption

From: Steve Meyers [mailto:[EMAIL PROTECTED] > David Griffiths wrote: > > I'm not sure what the sql standard says on the matter, but > Oracle, DB2 > > and Postgres would through an exception. In fact, there is > a page on > > MySQL "gotachs" to document MySQL behaviour when it differs > > sig

RE: DB hanging

V == [EMAIL PROTECTED] writes: V> How big is this table? It has 7325 rows. V> Do you run maintenance on this table? Not regularly. I just ran myisamchk against it and here's what I got. I'm not sure if this is useful since there are current connections: Checking MyISAM file: /home/cmvobad

RE: DB hanging

How big is this table? Do you run maintenance on this table? What does the show index for this table look like? -Original Message- From: Brandon Metcalf To: Victor Pendleton Cc: '[EMAIL PROTECTED] ' Sent: 5/25/04 2:56 PM Subject: RE: DB hanging V == [EMAIL PROTECTED] writes: V> What do

Re: Very Strange data corruption

David Griffiths wrote: But the reason modern databases have foreign keys, primary keys, not-nulls, check constraints and data-metadata (char(5), INT, BIGINT, etc) is to prevent bad data from going in.. If no exception is thrown because you are trying to put a BIGINT into an INT, then why throw o

a parameter in a sql script

I need to prepare some sql scripts which take parameters... how can I do? For example, suppose I want to have a sql script to create a new user granting to him some privileges and inserting its name in some application specific tables -- MySQL General Mailing List For list archives: http

Re: Very Strange data corruption

This complicates the database. This discussion has come up hundreds of times on this list. NULL/NOT-NULL is a basic check, and by saying NOTNULL, you're telling mysql to fail it. Same thing with Syntax checks, they're just that. The different INT fields are provided to make the database more e

Re: Very Strange data corruption

David Griffiths wrote: I'm not sure what the sql standard says on the matter, but Oracle, DB2 and Postgres would through an exception. In fact, there is a page on MySQL "gotachs" to document MySQL behaviour when it differs significnatly from other databases (like the first datetime field in a t

Re: DB hanging

m == [EMAIL PROTECTED] writes: m> Brandon Metcalf wrote: m> > We are running 3.23.58 on Solaris 8 and seeing the following problem. m> > Periodically, mysqld gets into a state where we can't query just one m> > table in all of our DBs--queries just hang. Restarting mysqld always m> > fixes

Re: Very Strange data corruption

The client software ought to be range-checking the data before sending it to the database. If the client isn't even doing that kind of minimal-effort check, how likely is it to be checking for exceptions? Not sure what you code in, but in Java, you *HAVE* to catch SQLExceptions (or throw them

Re: DB hanging

Brandon Metcalf wrote: We are running 3.23.58 on Solaris 8 and seeing the following problem. Periodically, mysqld gets into a state where we can't query just one table in all of our DBs--queries just hang. Restarting mysqld always fixes the problem, but a SIGKILL is required to stop it. Have you t

RE: DB hanging

V == [EMAIL PROTECTED] writes: V> What does show processlist return when this is happening? Is anything being V> logged to the error log? Nothing in the error log, but here's the output from show processlist: mysql> show processlist; +-+--++---

RE: Problem while insert binary

What error message are you getting or how are you verifying that the data is not loading correctly? -Original Message- From: giovanni cordeschi To: [EMAIL PROTECTED] Sent: 5/25/04 11:23 AM Subject: Problem while insert binary Using PHP i'm not able to insert a binary variable into a field

RE: Speeding up Inserts

At 09:32 AM 5/25/2004, [EMAIL PROTECTED] wrote: I should have mentioned, I get data in a text file, Pipe Seperated, Double Quotes Qualifiers, Eg. "col1"|"col2"|"col3" I tried Load Datafile, Didn't work for me, It skips an additional left most character from Col1, So I g

Re: Very Strange data corruption

David Brodbeck wrote: The client software ought to be range-checking the data before sending it to the database. If the client isn't even doing that kind of minimal-effort check, how likely is it to be checking for exceptions? That's not to say that an error or exception is a bad idea, but MySQL

Re: Very Strange data corruption

It's best practice to write unit tests for all your code, with calculated data to show what you expect. That data then gets compared to what is actually generated and if there is a discrepency, then you have a bug somewhere. But the reason modern databases have foreign keys, primary keys, not-

RE: DB hanging

What does show processlist return when this is happening? Is anything being logged to the error log? -Original Message- From: Brandon Metcalf To: [EMAIL PROTECTED] Sent: 5/25/04 2:33 PM Subject: DB hanging We are running 3.23.58 on Solaris 8 and seeing the following problem. Periodically,

Large database with High Availability - how to do it?

I really thought that MySQL tried to produce MySQL cluster for common hardware and with the design principle; more nodes with common hardware, insted of few nodes with extreme hardware. That to get higher availability (Much like the GFS (Google File System)). If the memory usage (RAM) as I have

(U) RE: Very Strange data corruption

CLASSIFICATION: UNCLASSIFIED who knows -Original Message- From: Mike Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 12:26 PM To: David Griffiths; [EMAIL PROTECTED] Subject: RE: Very Strange data corruption From: David Griffiths [mailto:[EMAIL PROTECTED] > MySQL really sh

Re: need help with a complicated join

You are beyond the realm of SQL. What you would need for something like this is a dynamically-generated case statement that would apply different multipliers based on the date of the quote you are trying to adjust. For those quote values that exist BEFORE multiple splits you must adjust by the PRO

Re: Very Strange data corruption

David Griffiths wrote: MySQL really should throw an exception/error rather than just quietly trim your data and accept it. When your data is critical, and your business depends on it, you can't have bad data quietly going into the database. David. Mike Johnson wrote: A value is not valid just

RE: Very Strange data corruption

> -Original Message- > From: David Griffiths [mailto:[EMAIL PROTECTED] > MySQL really should throw an exception/error rather than just quietly > trim your data and accept it. When your data is critical, and your > business depends on it, you can't have bad data quietly going > into th

DB hanging

We are running 3.23.58 on Solaris 8 and seeing the following problem. Periodically, mysqld gets into a state where we can't query just one table in all of our DBs--queries just hang. Restarting mysqld always fixes the problem, but a SIGKILL is required to stop it. Could this be something is corru

RE: Very Strange data corruption

From: David Griffiths [mailto:[EMAIL PROTECTED] > MySQL really should throw an exception/error rather than just quietly > trim your data and accept it. When your data is critical, and your > business depends on it, you can't have bad data quietly going > into the > database. Someone correct m

Re: Search for relationships that aren't present

Brad Tilley wrote: I should better describe the tables: computers has 'comp_id' as its primary, unique key. users has 'user_id' as its primary, unique key. comp-user-link has two (and only two fields) that are *never* null: 'comp_id' (which must be unique), and 'user_id' Every computer is linked t

Re: Search for relationships that aren't present

So you do have two ways to associate users with computers. One is directly on the computers table and the other is through the link table. That leaves me with two questions to answer: Question 1) Are there any users that do not have an ID in the user_id field on the computers table? Question 2)

Re: Search for relationships that aren't present

Ah yes, thank you Gerald. I didn't understand this until now. I guess I should say that 'by design' the linking table will never contain a null, but the left join changes that. Thank you for pointing that out. gerald_clark wrote: Brad Tilley wrote: I should better describe the tables: computers

RE: Understanding Explain in 4.1

It is going to do a full table scan of the Monday table trying to return all rows that are in the Friday table. You have restriction criteria outside of your join. -Original Message- From: Daniel Cummings To: 'Victor Pendleton'; [EMAIL PROTECTED] Sent: 5/25/04 2:05 PM Subject: RE: Underst

Re: Problem while insert binary

giovanni cordeschi wrote: Using PHP i'm not able to insert a binary variable into a field of type mediumblob of mysql. The command I've used is: $cfg_Query = "Insert into (operazioni, datacreazione) Values ('".$contents."', Now())"; $result = mysql_query($cfg_Query, $conn) It doesn't appear the

Re: Search for relationships that aren't present

Victor & Shawn, Thanks for the select info and the relationship info. Both of your examples worked. The reason we designed a separate linking table is that we wanted to always keep the computers separate from the users. A container of users and a container of computers with a linking table join

Re: Search for relationships that aren't present

Brad Tilley wrote: I should better describe the tables: computers has 'comp_id' as its primary, unique key. users has 'user_id' as its primary, unique key. comp-user-link has two (and only two fields) that are *never* null: Except within the context of a left join. Every user in a left join mat

Re: Very Strange data corruption

MySQL really should throw an exception/error rather than just quietly trim your data and accept it. When your data is critical, and your business depends on it, you can't have bad data quietly going into the database. David. Mike Johnson wrote: From: Jeff McKeon [mailto:[EMAIL PROTECTED] Que

need help with a complicated join

I am trying to come up with a query that takes two tables, one with non-split-adjusted historical stock prices, and one with information on splits, for instance: CREATE TABLE quotes ( symbol VARCHAR(127)NOT NULL, dateDATENOT NULL, quote FL

RE: Understanding Explain in 4.1

Victor- It's a little misleading. It looks like it's going to do a full table scan of the Monday table. Dan -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 6:18 AM To: 'Daniel Cummings '; '[EMAIL PROTECTED] ' Subject: RE: Understanding E

Re: Search for relationships that aren't present

I should better describe the tables: computers has 'comp_id' as its primary, unique key. users has 'user_id' as its primary, unique key. comp-user-link has two (and only two fields) that are *never* null: 'comp_id' (which must be unique), and 'user_id' Every computer is linked to a user... the pro

Re: Search for relationships that aren't present

Brad, This is also a design issue. Generally when designing tables to support a one-to-many relationship, you put a pointer field in the "many" table and load it with the ID value of the "one" that it relates to. In this case you would want a nullable field like "users_id" on your computers table

RE: Very Strange data corruption

Actually the Field type is fine. It was user input error. The person who created the ship ID added an extra digit, normally they are only 9 digits long. I didn't catch it until I looked at a list of all the ShipID's together and then it stuck out like a sore thumb. Thanks for all the explanatio

RE: Search for relationships that aren't present

If you are using a version that supports sub-selects you could perform a subquery. Otherwise,the solution depends on your primary keys. SELECT u.* FROM users u LEFT OUTER JOIN comp-user-link c ON u.userID = c.userID WHERE c.userID IS NULL -Original Message- From: Brad Tilley To: [EMAIL PRO

Re: Very Strange data corruption

Jeff, You are trying to exceed the limits of the INTEGER column. INTEGERs top out at 2GB-1 (or 2147483647). May I suggest you change your table to use a larger integer type like BIGINT. With BIGINT fields you can go all the way to 9223372036854775807. MySQL will give you the nearest possible num

RE: is there a PRODUCT() or MULTIPLY() aggregate function?

No there is not. Two options could be to either create an UDF or use a programming language. -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 5/25/04 1:25 PM Subject: is there a PRODUCT() or MULTIPLY() aggregate function? Is there an aggregate function that multiplie

RE: Very Strange data corruption

From: Jeff McKeon [mailto:[EMAIL PROTECTED] > Query: > > insert into > MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk > 2,pin1,pin > 2,TwoStage,Status,DateAssigned,DateDisabled,UserID) > VALUES('NULL', '6889927707', '1', '8988169214000421398', > '881621456175', > '', '', '88169

Search for relationships that aren't present

Three tables: computers (Describes computers) users (Describes users) comp-user-link (Links users to computers in a 1 user to many computers relationship) Could someone offer advice on how to construct a select statement to show which users aren't in the comp-user-link table? Sort of the reve

Re: Very Strange data corruption

Set the fieldtype to 'bigint' It's the limit on int "Jeff McKeon" <[EMAIL PROTECTED]> 05/25/2004 02:29 PM To: <[EMAIL PROTECTED]> cc: Subject:Very Strange data corruption Query: insert into MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,

Very Strange data corruption

Query: insert into MIS.simcard(ID,ShipID,Service_Provider,SN,v1,v2,f1,d1,puk1,puk2,pin1,pin 2,TwoStage,Status,DateAssigned,DateDisabled,UserID) VALUES('NULL', '6889927707', '1', '8988169214000421398', '881621456175', '', '', '881693156175', '62982149', '', '', '', '1307', '1', '1085508771',

is there a PRODUCT() or MULTIPLY() aggregate function?

Is there an aggregate function that multiplies column values just like SUM() adds them? For instance, if "SELECT value FROM data" returns three values 2, 3, and 4, then "SELECT PRODUCT(value) FROM data" would return 24, which is 2 * 3 * 4. Thanks! --- Fyodor Golos Stockworm, Inc.

Re: FULLTEXT and large database

Mysql is not sorting 200 rows, its sorting the entire found set and then returning the first 200 rows after it's sorted properly. So if your search found 2 million matches, it's going to sort the 2 million records, then return the first 200 records. Specifying a limit saves times on I/O sin

RE: Storing a subset of data in a slave database

Hi Victor, Thanks for your reply. Yes, I did mean to only replicate certain tables, so your answer fits to a tee. Thanks! On Wed, 2004-05-26 at 01:12, Victor Pendleton wrote: > What do you mean by storing a subset? Are you only wanting to replication a > portion of the tables? If so, you can conf

RE: Storing a subset of data in a slave database

What do you mean by storing a subset? Are you only wanting to replication a portion of the tables? If so, you can configure the master to ignore certain databases or you can configure the slave to apply updates for certain databases/tables or prohibit the master from replicating certain databases/t

Storing a subset of data in a slave database

Hi everyone, I am trying to set up database replication, and would like to know if I can store just a subset of data in the slave DB. Anyone has any insight? Thanks in advance, Callan signature.asc Description: This is a digitally signed message part

Re: Unable to Programatically Create DB Connection

Scott D. Spiegler said: > I am trying to programatically connect to my DB, but I > am not sure what the connection string should be. I am > using this statement: > > conn = > > DriverManager.getConnection("jdbc:mysql://localhost/test?user=scott&password=cuatro"); > > I am getting this exception me

RE: Unable to Programatically Create DB Connection

Hi Scott, You must register the driver first. Example : import com.mysql.jdbc.Driver; ... public Connection getConnection () throws SQLException { DriverManager.registerDriver (new Driver()); Connection conn = DriverManager.getConnection (

RE: Unable to Programatically Create DB Connection

-Original Message- From: Scott D. Spiegler [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 11:37 AM To: [EMAIL PROTECTED] Subject: Unable to Programatically Create DB Connection > I am trying to programatically connect to my DB, but I am not sure what > the connection string should

Strange return behaviour in UDF (bug?)

Hi there, I'm getting a strange behaviour when returning a value from my user defined function. When I print the return value inside of the function, I get one answer (the correct one), however mysql reports a different value all together. Is this my programming error or a mysql bug? Here's wha

R: Unable to Programatically Create DB Connection

try adding a Class.forName("com.mysql.jdbc.Driver").newInstance() before DriverManager.getConnection(... It should register the mysql jdbc driver. > -Messaggio originale- > Da: Scott D. Spiegler [mailto:[EMAIL PROTECTED] > Inviato: martedi 25 maggio 2004 18.37 > A: [EMAIL PROTECTED] >

Unable to Programatically Create DB Connection

I am trying to programatically connect to my DB, but I am not sure what the connection string should be. I am using this statement: conn = DriverManager.getConnection("jdbc:mysql://localhost/test?user=scott&password=cuatro"); I am getting this exception message: database_test.DBConnector S

RE: FULLTEXT and large database

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harald Fuchs Sent: Tuesday, May 25, 2004 11:18 AM To: James Drabb Subject: Re: FULLTEXT and large database > > I seem to get inconsistent results when using the FULLTEXT index > > speed-wise on 3 million+ rec

Problem while insert binary

Using PHP i'm not able to insert a binary variable into a field of type mediumblob of mysql. The command I've used is: $cfg_Query = "Insert into (operazioni, datacreazione) Values ('".$contents."', Now())"; $result = mysql_query($cfg_Query, $conn) where $contents is the binary variable. Can an

mysql_prepare is not built in 4.1.1a?

We downloaded 4.1.1a build, but all the new APIs for transaction and prepared statements are missing from the libmysql.dll. Is there a build for 4.1.x that we can use to test these APIs? Thanks. _ MSN Toolbar provides one-click ac

RE: FULLTEXT and large database

"James Drabb" <[EMAIL PROTECTED]> wrote on 25/05/2004 16:30:07: > The text 'May' is in the column, yet I get no rows returned? The admins > are looking > to be able to search for an arbitrary string in the MsgText field that > can be anywhere > in the field not just at the beginning. So

RE: FULLTEXT and large database

-Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 9:50 AM To: James Drabb Cc: Jigal van Hemert; [EMAIL PROTECTED] Subject: Re: FULLTEXT and large database > You may try increasing your sort_buffer_size and key_buffer_size, > see if that speeds up

RE: FULLTEXT and large database

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 8:52 AM To: [EMAIL PROTECTED] Cc: James Drabb; [EMAIL PROTECTED] Subject: Re: FULLTEXT and large database > One thing that ocurs to me is that, if you are using it for syslog type > data, the

Re: FULLTEXT and large database

You may try increasing your sort_buffer_size and key_buffer_size, see if that speeds up the searching and sorting. On May 25, 2004, at 9:54 AM, James Drabb wrote: When I run a FULLTEXT search and view the process list of MySQL in MySQL, I see in the state column that MySQL is "sorting results" wh

Re: FW: create database in specified character set

michael_wu[吳宏達] wrote: > Many thanks! I had downloaded V4.1.1 and created a database in utf8 > character set. > I successfully created a table and inserted rows of data with VARCHAR > columns into the table through the SQL pad. > With the Control Center GUI, I can see the result. It seems the da

RE: Speeding up Inserts

I should have mentioned, I get data in a text file, Pipe Seperated, Double Quotes Qualifiers, Eg. "col1"|"col2"|"col3" I tried Load Datafile, Didn't work for me, It skips an additional left most character from Col1, So I get 'ol1' instead of 'col1' ..so as of now, I

Re: Speeding up Inserts

[EMAIL PROTECTED] wrote: > Whats the fastest way to speed up inserts? > I have a table which I insert into once a week (about 20-30k Rows) > And select from all the time... > > Is the only way to speed up inserts to remove indexes? > And to speed up selectes, ...add the indexes again? > Take a l

RE: Query question

Select count(distinct("field")) from "table" where field >= 0 ? -Original Message- From: Laercio Xisto Braga Cavalcanti [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 11:18 PM To: 'John Nichel'; 'MySQL List' Subject: RE: Query question You can do: Select count(distinct("field"))

Re: Speeding up Inserts

At 08:55 AM 5/25/2004, you wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again? Regards,

RE: Speeding up Inserts

That fixed it, Thanks! -Original Message- From: Mirza [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:46 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: > Hi Al

Re: FULLTEXT and large database

From: "James Drabb" <[EMAIL PROTECTED]> > From: Jigal van Hemert [mailto:[EMAIL PROTECTED] > So is there any way to efficiently search a TEXT field of 5 million rows > for exact phrases? In this case the MsgText field contains a > descriptive > error message that the admins want to search for to h

Re: Speeding up Inserts

Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to re

Re: Speeding up Inserts

well, you could try mass insertion... instead of inserting each row one by one -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Speeding up Inserts

Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again? Regards, Amit -- MySQL General Mailing

  1   2   >