Re: cleaning up general_log table?

a shorter way ??? Rolando A. Edwards MySQL DBA (SCMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM& Skype : RolandoLogicWorx redwa...@logicworks.net http://www.linkedin.com/in/rolandoedwards -Original Message- From: Jacek

cleaning up general_log table?

Hello, Is there a way to purge parts of general log table without interrupting the server? Ideally, we would like to transfer older logs (say copy all entries from 2010 into a separate location, and then run: DELETE FROM mysql.general_log WHERE event_time<'2011-01-01' However this yields an err

background IO threads for MyISAM?

Hello, Does anyone know if MyISAM supports background IO threads, or it is available only for InnoDB? Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

converting non-materialized view to a table?

Hello, I need to convert a non-materialized MySQL view to a MySQL table. Are there any tools to do that? Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: dynamically splitting a table through one full table scan

Hi Kabel Yes, I did, it won't do the job for us. I didn't explain the whole usecase: we are dealing with a 50-billion row table which we want to split into 1-million-row tables, and then dynamically break each of these into smaller pieces in order to speed up n^2 near-neighbor joins. If we part

dynamically splitting a table through one full table scan

Hi, Is there a way to dynamically split a big table into n smaller tables by doing a single scan of the table that is being split? Here is more details: * Suppose I have a million row MyISAM table X, with relatively small number of columns. It has a column "chunkId" with values between 1

How to determine MyISAM sort order?

Hi, Is there a way to find which index was used to sort MyISAM table (suppose someone run "myisamchk --sort-index --sort-records=2" in the past, how to find that sorting was done based on index #2?) And a related question: how to determine which is the index "#2"? I guess if I look at the order

How to split output from SHOW SLAVE STATUS?

Hi, I'm trying to find how to split the output from SHOW SLAVE STATUS into individual fields. Specifically, I would like to be able to do in a stored function: 1) determine what the status of slave is, and if it is "Waiting for master to send event", do some action, like stop the slave 2) e

max_allowed_packet

Hi, I'm trying to see what speed I will get from a simple query like: select * from and I noticed the server-> client transfer is always 512 bytes. (iostat tells me I read 6348.80*1024 bytes/sec in a given time period, and 12697.60 reads/sec, which translates to exactly 512) I set the max_al

assigning variable without printing result?

Hi, Can someone tell me how to assign result to a variable inside SELECT without printing the result? Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

loading a subset of input file using mysqlimport?

Hi, Is there a way to load a section of an input file into mysql (MyISAM table) using mysqlimport or LOAD DATA INTO? The input data is in relatively large ascii files (10 million rows per file), and I'd like to break the load into smaller pieces rather than load whole file at once. Of course I co

Re: Foreign key support in MyISAM

Hi, I had asked similar question few days ago, and then checked with the developers as no one was able to answer on this mailing list. I was told it is very likely we'll get it in 5.2. Jacek Sujay Koduri wrote: does anyone have an idea when mysql guys are going to include foreign key support

timing queries?

Hi, Does anyone know how to execute SQL statements from a text file such that the summaries "X rows in set (X.YZ sec)" are printed for each query? Neither of these do it: mysql < batch-file mysql -e 'source batch-file' 'source batch-file' run inside mysql command-line does it, but then I n

foreign keys in MyISAM?

Hi, The documentation says "At a later stage, foreign key constraints will be implemented for MyISAM tables as well". Does anybody know what is the timescale? thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

avoiding conversion during insert?

Hi, Is there a way to insert binary data representing numbers directly into (preferably MyISAM) table. We are trying to avoid conversion from ASCII to float/double/int... Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

how to avoid precision problem w/o switching to double?

Hi, I'm having problems with floats while doing comparisons. create table fff (x float); create table ddd (x double); insert into fff (0.1); insert into ddd (0.1); "select * from ddd where x = 0.1" correctly returns one row, but "select * from fff where x = 0.1" does not return anything. I fou

Re: how to check if keys disabled?

le: t2 Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: x Collation: A Cardinality: 0 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: 1 row in set (0.00 sec) cheers, Jacek -Original Message- From: Jacek Becla [mailto:[EMAIL PRO

Re: how to check if keys disabled?

Jay Are you sure? DESCRIBE tells me the table has an index, but not whether the index is enabled or not: mysql> create table t1 (x int primary key); Query OK, 0 rows affected (0.01 sec) mysql> create table t2 (x int primary key); Query OK, 0 rows affected (0.01 sec) mysql> alter table t1 disable

how to check if keys disabled?

Hi, How can I find out if keys are enabled/disabled for a given table? Suppose I do: create table t1 (x int primary key); create table t2 (x int primary key); alter table t1 disable keys; How can I now find out that t1 has keys disabled, and t2 enabled? thanks, Jacek -- MySQL General Mailing List F

MyISAM and foreign key constraints?

Hi, MySQL docs claim at: http://dev.mysql.com/doc/mysql/en/ansi-diff-foreign-keys.html that "At a later stage, foreign key constraints will be implemented for MyISAM tables as well." Does anyone know what the timescale is? Thanks, Jacek -- MySQL General Mailing List For list archives: http://lis

Re: scalability of MySQL - future plans?

MySQL with large databases to consider doing the same. Thanks, Udi "Heikki Tuuri" <[EMAIL PROTECTED]> 11/12/2004 06:57 AM To: <[EMAIL PROTECTED]> cc: Subject:Re: scalability of MySQL - future plans? Jacek, - Original Message - From: "Jacek

scalability of MySQL - future plans?

handle petabyte-scale dataset in 8-10 years would be greatly appreciated. Best regards, Jacek Becla Stanford University -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]