Re: Correct way to use innodb_file_per_table?

Mike, - Original Message - From: "Mike Debnam" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Friday, March 04, 2005 6:15 AM Subject: Correct way to use innodb_file_per_table? I've added a second drive to my database machine and want to split my database tables between the

Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

Please don't respond directly to me if you have further questions, as you would probably be more likely to get better help from the list. It sounds like a typical database connection? What is your problem? What are the errors you are getting? All you have said so far is that you need help, a

Speed of Inserts into MyIsam tables from mysqlbinlog

I was running a table in InnoDB, and the table had about 6 indexes, none of which seemed to be affected when I ran mysqlbinlog against the tables in order to apply bin-logs from production against a test system. I was manage to process upwards of 2300 queries per second by throwing about 1.8 GB of

Correct way to use innodb_file_per_table?

I've added a second drive to my database machine and want to split my database tables between the two drives to balance the load and improve performance. I know I'll need to drop and restore the db to get MySQL to create the tables in their own files. What's the correct way to use innodb_file_per_t

Re: problem with fulltext search

"another" is a stop word. The default list of stopwords is in myisam/ft_static.c in a source distribution. See the manual for more . Michael Dawn O'Brien wrote: I'm trying to use the following query :: SELECT movie_id, title, genre,

Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Deniss Hennesy wrote: Hi, I have had to change mysql root passwd My procedure is just below shell> mysql -u root -p mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql> flush privileges; YOu may be need to execute command mysqladmin -u root password (yourpass

Re: # Seconds between two datetime fields

Brian Erickson wrote: We have a table that has two datetime fields (start_time and end_time). We'd like to be able to calculate the number of seconds between these two fields in a query. However, a simple "end_time - start_time" does not yield a correct result. SELECT start_time, end_time, end_time

Re: # Seconds between two datetime fields

The return you are getting is correct for the format you are using. A 90 second difference is in fact 1 minute, 30 seconds(130). To get the time difference in seconds convert the datetime or timestamp to a julian date or unixtime and then process. SELECT start_time, end_time, UNIX_TIMESTAMP(end_

# Seconds between two datetime fields

We have a table that has two datetime fields (start_time and end_time). We'd like to be able to calculate the number of seconds between these two fields in a query. However, a simple "end_time - start_time" does not yield a correct result. SELECT start_time, end_time, end_time - start_time FROM ma

need to know if mysql can handle this data

hi, i'm trying to choose a db, and looking at mysql. here's the problem. we're looking at storing large blob type objects - up to 30,000 char's per field, and possibly a table of 1000 records by 300 fields/record. can i put that all in one table? I have mac osx, so i'm not worried about the files

Re: access two like tables with one query

Rich Allen <[EMAIL PROTECTED]> wrote on 03/03/2005 04:28:07 PM: > iH > > i have a database that i only have READ access to (i am not the > creator). there are tables with stats data that are created each day; > ie "data3_1_2005" and 'data3_2_2005". each table has the same layout. > > create ta

access two like tables with one query

iH i have a database that i only have READ access to (i am not the creator). there are tables with stats data that are created each day; ie "data3_1_2005" and 'data3_2_2005". each table has the same layout. create table data3_1_2005 ( port char(8), tmval int, val int ) how can i create a single

Re: mysql 4.0.18 crashing on startup

Baba, an undo log seems to be corrupt. He should restart mysqld with: innodb_force_recovery=4 dump all tables, and recreate the whole InnoDB installation. Did the .err log contain any hint what could be behind the corruption? Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and ro

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

Hi, On Mar 3, 2005, at 3:13 PM, mos wrote: At 12:39 PM 3/3/2005, Harrison Fisk wrote: Hi, On Mar 3, 2005, at 11:32 AM, mos wrote: At 10:07 PM 3/2/2005, you wrote: Hello. You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process on the MyISAM table. That may work provided I can get th

Re: mysql crash - innodb not starting

Hi! Error 11 means that you already have a mysqld process running on the same files. Best regards, Heikki Tuuri Innobase Oy Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables http://www.innodb.com/order.p

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

At 12:39 PM 3/3/2005, Harrison Fisk wrote: Hi, On Mar 3, 2005, at 11:32 AM, mos wrote: At 10:07 PM 3/2/2005, you wrote: Hello. You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process on the MyISAM table. That may work provided I can get the keys rebuilt later using FileSort and not

RE: backup scripts

Kelly, You can find out what user mysqld is running as with the following: #ps axu | grep mysqld To change the permissions on the directory run the following as root: #chown mysql.mysql /usr/local/mysql/bakups #chmod 770 /usr/local/mysql/bakups If it is a different user, substitute it in for m

problem with fulltext search

I'm trying to use the following query :: SELECT movie_id, title, genre, description, TRIM( TRAILING ',' FROM actors ) , director, disclaimer, rating, year, ( MATCH ( title, description ) AGAINST ( 'another' ) ) AS score FROM movie_details WHERE ( MATCH ( title, description ) AGAINST ( 'another' ) )

Re: DB Export multiple tables to CSV

On 03/03/2005 2:18 PM <[EMAIL PROTECTED]> wrote: >Are you really asking this list to help you with moving data from >Excel to some unknown set of users? That's stretching it a bit, don't >you think? No, I was actually asking if there is a way or somebody had an helpful idea on how to export mul

Re: Simple explain

"Jonathan Mangin" <[EMAIL PROTECTED]> wrote on 03/03/2005 02:38:54 PM: > Hello, > > Does this mean a key is not being used? > > mysql> explain select vl_ts from view_log where vl_uid='bb'; > +--+--+---+--+-+--+-- > ++ > | table| ty

Simple explain

Hello, Does this mean a key is not being used? mysql> explain select vl_ts from view_log where vl_uid='bb'; +--+--+---+--+-+--+--++ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+

RE: DB Export multiple tables to CSV

SELECT * INTO OUTFILE "/dir/they/can/get/to" FROM TABLE WHERE DVP Dathan Vance Pattishall http://www.friendster.com > -Original Message- > From: H Ba [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 03, 2005 11:15 AM > To: mysql@lists.mysql.com > Subject: DB Export multiple

RE: backup scripts

On Thursday, March 03, 2005 13:12, [EMAIL PROTECTED] wrote: Hi Kelly, > Hello, > When I attempt to try and run the backup: > > shell> mysqldump --tab=/path/to/some/dir --opt db_name > I get the following errors: > ./mysqldump: Got error: 1: Can't create/write to file > '/usr/local/mysql/bakup

Re: DB Export multiple tables to CSV

H Ba <[EMAIL PROTECTED]> wrote on 03/03/2005 02:14:57 PM: > I have multiple tables set up and need to export these to csv in > order to import them into Excel. Since all tables are related to > each other and I can only export one at a time, is there a way to > somehow get a "readable" file aft

DB Export multiple tables to CSV

I have multiple tables set up and need to export these to csv in order to import them into Excel. Since all tables are related to each other and I can only export one at a time, is there a way to somehow get a "readable" file after importing into Excel, which non-programmers can edit and use for

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Hi, I have had to change mysql root passwd My procedure is just below shell> mysql -u root -p mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql> flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it di

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Hi, I have had to change mysql root passwd My procedure is just below shell> mysql -u root -p mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root'; mysql> flush privileges; and I checked this password another consol I saw MySQL wasn't accepted new passwd else, it didnt o

backup scripts

Hello, When I attempt to try and run the backup: shell> mysqldump --tab=/path/to/some/dir --opt db_name I get the following errors: ./mysqldump: Got error: 1: Can't create/write to file '/usr/local/mysql/bakups/config.txt' (Errcode: 13) when executing 'SELECT INTO OUTFILE' Or: shell> mysqlho

[ANN] New DBManager 3.0.3 Released Today

We are pleased to announce the new DBManager Professional 3.0.3. This is a major bug fix version with lots of improvements and a few new features. If you are a previous user of the DBManager 3.0 versions you may consider updating your system with the new version. Here is the list of changes: Fixe

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

Hi, On Mar 3, 2005, at 11:32 AM, mos wrote: At 10:07 PM 3/2/2005, you wrote: Hello. You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process on the MyISAM table. That may work provided I can get the keys rebuilt later using FileSort and not KeyCache. You see the problem isn't in l

innodb update issues

I have run into a fairly bizarre issue. Two tables were moved to innodb to take advantage of row level locking but they were moved back within a day. Both tables are fixed so updates should not cause table fragmentation and a required optimize. Also, there are no deletes to the tables in questio

Read / Write statistics

Hi, I am trying to obtain read/write statistics from our database (4.0.21). I started by using the Bytes_received and Bytes_sent from "show status"; however, today one of them (Bytes_sent) reset itself to 0... Which really messes up my calculations... I need this data... Is there any other wa

mysql_server_init crashes

Hi, this is 4.0.23 embedded. If the datadir defined in my.cnf does not exist: 050303 17:48:04 bdb: /home/vdr/mysql/log.01: No such file or directory 050303 17:48:04 bdb: PANIC: No such file or directory 050303 17:48:04 Can't init databases it should return an error condition instead o

Re: confirm subscribe to mysql@lists.mysql.com

On Donnerstag 03 März 2005 17:57, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > http://lists.mysql.com/s/mysql/422741fc45778425/wolfgang=rohdewald.de > > This confirmation serves

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

At 10:07 PM 3/2/2005, you wrote: Hello. You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process on the MyISAM table. That may work provided I can get the keys rebuilt later using FileSort and not KeyCache. You see the problem isn't in loading the data into the table which occurs

Re: import problem.

It works! Here is what I used: LOAD DATA INFILE 'Batch.txt' INTO TABLE Batch FIELDS TERMINATED BY '{' LINES TERMINATED BY '\r\n'; And the result: mysql> select * from batch where orderid=240414989; +---+---++--+ | QAID | OrderID |

Re: Switching to InnoDB turns out dissapointing

Brent Baisley wrote: calculations from your query, like replace datesub(now(), interval 12 month) with a constant. Which means figuring out the right date before hand. AFAIK, no column is involved in this particular function, so there's no point doing the computation beforehand, it's done by my

Re: ulimit effects on mysql user?

Hi Luke, all, Am Do, den 03.03.2005 schrieb Crouch, Luke H. um 15:44: > if I have changed my /etc/security/limits.conf file to include these lines: > > mysqlsoft nofile4096 > mysqlhard nofile63536 > > and then done: > > [EMAIL PROTECTED] root]# su mysql > [E

Re: import problem.

Does SQLyog log any errors for you? Are your lines terminated by \n or \r\n? Have you tried performing this import with the LOAD DATA INFILE command? There you could at least see if warnings or errors were encountered. Scott Hamm wrote: I got my csv delimited using "{" as follows: 87547{2404149

import problem.

I got my csv delimited using "{" as follows: 87547{240414986{0{ 87547{240414987{0{ 87547{240414988{0{ 87547{240414989{0{ 87547{240414990{1{GALLEGOS---MISKEYED MONTH IN BIRTHDATE I tried to import using SQLyog as following: Lines Terminated By: \n Fields set to Variable length, Fields Terminated b

replication with automatic master failover problems

Hello, we're working on a two node setup to achieve high availability using 4.1.8; we first setup both servers with --bin-log, and only the slave server (db1) with --log-slave-updates. (binary logfile name is "master" on both server) replication from db0 to db1 runs smoothly

Re: Reading oracle table

Do you know how the file was created/exported from Oracle? Are the files contents viewable? Marcos Sanches wrote: Hello all, I am a new user, in fact I've never used any software like Mysql, oracle or sqlserver. But I am very familiar with analysing data, I am a statistician. I've just received

Reading oracle table

Hello all, I am a new user, in fact I've never used any software like Mysql, oracle or sqlserver. But I am very familiar with analysing data, I am a statistician. I've just received an Oracle table, and need just to read it and export it to a new format, like delimited text. The file name has

ulimit effects on mysql user?

if I have changed my /etc/security/limits.conf file to include these lines: mysqlsoft nofile4096 mysqlhard nofile63536 and then done: [EMAIL PROTECTED] root]# su mysql [EMAIL PROTECTED] root]$ ulimit -n 8192 [EMAIL PROTECTED] root]$ ulimit -n 8192 does this n

mysql crash - innodb not starting

Hi, I just have a crash of my mysql 4.1.5 .(the machine where it was running just shutdown) Tried to restart it, and problem with innodb: 050303 11:58:46 [WARNING] Asked for 196608 thread stack, but got 126976 InnoDB: Unable to lock ./ibdata1, error: 11InnoDB: Error in opening ./ibdata1 050303

INNODB MONITOR OUTPUT

Hi Do you see any problems? = 050303 12:51:11 INNODB MONITOR OUTPUT = Per second averages calculated from the last 20 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 14266, signal count 14261 M

MySQL hangs

Hi, I've got webserver with php and mysql-4.0.22 There I've got large phpbb2. Sometimes, server's system load rapidly grows, and mysql are locked. Normally, there are 7-10 mysql processes, at this strange situation, there are 30-40. I don't know what can make such big system load in time of 1 mi

Please help - MySQL4.1.10 don't run properly after data restored from 5.0.1

Hi, I have removed all old data and restore the backup data to the directory /usr/local/mysql/data I also created root password with mysqladmin and flush its previliges... Execute the following perl+dbi script seems fine, it retrieves all data from the customer table in DB which I just restored:

Re: uninstall MySQL

Hello. It depends on the type of distribution you're using. [EMAIL PROTECTED] wrote: > Anyone knew how to uninstall old version of MySQL? Thanks > > __ > Switch to Netscape Internet Service. > As low as $9.95 a month --

Re: Problem with PHP + MySQL + InnoDB

Hello. > How to force to kill process which make lock of table ? since PHP make > many persistent connection to MySQL and i don't know > which one is locking the table :( You may get information about processes on your MySQL server using SHOW PROCESSLIST and kill the weird process with th

Re: Decimal Puzzle

Hello. > I designated a field Decimal 3,1. When I put a PHP > query on my page, it displayed 450 as 450, but it > rounded the fractions off, turning 24.8 into 25. I think - the problem is in number_format() function. From the PHP manual: "If only one parameter is given, number will be fo

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

Hello. You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process on the MyISAM table. mos <[EMAIL PROTECTED]> wrote: > I have a 50g CSV file that I am trying to import into an empty MyISAM > table. It appears to go fine except after 10 hours it hasn't completed. A > "Sho

Strange internal loop causing multiple updates on one record!?

Tested on MySQL version 4.0.23, 4.1.8 and 4.1.10 OS: RedHat Fedora Core 2 / RedHat 8 Table type: InnoDB or MyISAM Table structure: CREATE TABLE `param_str` ( `id` int(11) NOT NULL default '0', `name` varchar(32) NOT NULL default '', `value` varchar(255) default NULL, `match` varchar(255)

MySQL & CRON

Hi, I have a web based that allows users to upload XML files and insert them into the database, however some of these files are large and are causing the webserver to timeout. Is it possible to create a cron job that can insert the xml files say every hour, then the users of the site would only