RE: missing data after partitioning an existing table

May2015 VALUES LESS THAN > (TO_DAYS('2015-06-01')), PARTITION Jun2015 VALUES LESS THAN > (TO_DAYS('2015-07-01')), PARTITION Jul2015 VALUES LESS THAN > (TO_DAYS('2015-08-01')), PARTITION Aug2015 VALUES LESS THAN > (TO_DAYS('2015-09-01&#

RE: missing data after partitioning an existing table

SERT INTO p3_dna_new SELECT * FROM p3_dna_old; It finishes after a while, with absolutely no error nor warning. if i issue the following: select count(*) from p3_dna_new; it will be different than the result of select count(*) from p3_dna_old; If there's an issue, shouldn'

missing data after partitioning an existing table

I know a couple of things, but table partitioning isn't one of them. i have a 35 GB sized table which is causing performance issues, my research came across partitioning, which is what i tried and failed with today. i tried altering the table, that kept going for 2 hours with absolutely no chang

Database lock on mysql import - Information

Dear all, I realize this is a very newbie question so bear with me please. I know that when you import/export a DB its tables are locked to ensure consistency and no data corruption. but why would other DBs on the same server get locked if im importing/exporting one DB ? in other words: expo

killing mysqldump

Is it safe to kill a mysqldump while it's in process ? i mean aside loosing the dumped file, would it affect the running DB being dumped? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Best practice to minimize DB server performance effect (large query)

i agree it wouldn't cause trouble, though it might lock mysql as there's a number of other databases running on the same server. so performance is an issue even if it's just a CPU/RAM peak. On 5/31/12 11:23 AM, Reindl Harald wrote: Am 31.05.2012 09:13, schrieb Roland RoLa

Best practice to minimize DB server performance effect (large query)

Dear all,I have a task to anonymize data in 82000 record (for the time being)i've tested my script against about 30 of them, and it takes about 2.4 sec for each query to be executed. i'm seeking help with the following: - what's the best way to run such a script without affecting the DB server

Re: max() can't work

simpler and more efficient solution: select * from table_name order by movid desc limit 1. I hope this helps. Best regards Roland Kaber armando wrote: the field "movid" is type integer or varchar ? 2010/2/6 tech list select * from table_name where movid = max(movid); why the

Re: MySQL Date problem

l char(10) field. --rama Hi What about using the STR_TO_DATE function to transform the java Date as a MySQL Date: STR_TO_DATE('19/10/2008', '%m/%d/%Y')? To transform this back into the original format, you may use the DATE_FORMAT function: DATE_FORMAT('2008-

Re: Erro 1406 Data too long

In the INSERT, I used the CHAR function, rather than the ASCII, sorry for the mistake. Thanks again Roland Roland Kaber wrote: It looks like it is really a character set conflict. The copyright character © is ascii 169 and is part of latin-1. However, there is a similar character, (C) the

Re: Erro 1406 Data too long

x27;s character set to utf-8 2. keeping the latin 1 character set and changing the INSERT as follows: INSERT INTO text_t (t) VALUES (ASCII(169)) So, thank very much you for your excellent suggestion. Roland Jerry Schwartz wrote: It is a character set conflict between the source of the data an

Erro 1406 Data too long

my local server, MySQL version 5.0.37. * I run a MAC book pro. * I issued the same statements to a MySQL server on a Windows XP machine. The problem simply didn't occur even in traditional sql mode. Do you understand what is going on? Could it be a bug? Thank you in advance for any help you can offer. Roland K

Re: result set on prepared statements

lient side cursor. Because when using "classic functions" instead of prepared statements, I really must fetch *all* rows to avoid memory leak on database engine. With best regards, Roland. Visolve DB Team schrieb am 17.10.2006 07:57: > Hi, > > Hope this link will be useful: >

result set on prepared statements

want to use client side cursor). MySQL Version is 5.0.26 on Windows 32 Bit. Any Information is welcome. With best regards, Roland. | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL:2003 standard

Hello Peng, please have a look at http://www.wiscorp.com/SQLStandards.html There you can download all you need. With best regards, Roland. Peter Brawley wrote on 10.05.2006 16:51: > Peng Yi-fan wrote: >> Hi, >> >> It seems that ISO do not support SQL:2003 standard

MyISAM Key Buffer and Key Writes

n is: when exactly will blocks in key buffer be written to disk? -- mit freundlichen Grüßen - Roland Wilczek Moltkestraße 90 50859 Köln Tel.  : 02234 / 91 75 05 Fax   : 01212-5-382-69-201 E-Mail: [EMAIL PROTECTED] http://www.sales1x1.de - Vertrieb und Projektmanagement http://www.web-appz.de - Prog

move to 64 bit

Hi! What must I do to move our mysql-database from 32-bit binaries to 64-bit (mac os x). Is it as simple as just changing binaries for must I prepare the data-files somehow? Thanks in advance Roland Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Find the biggest blobs

Hi! I've need to find the largest blobs in a table but I seem not to be able to figure out what it is. Could anyone please help me with this? Regards Roland -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Backup for 24/5 system

to a backup that we can take down whenever we need to to make the backups (or other maintaince). So, is this a good way to solve the backups or do you think that I should consider any other solutions? Thanks in advance Roland -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Ini (cnf) file location

Thank you very much Roland Carlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: flush and flush delay

mysql have the path to the data directory on the RAM-disk as the datadir? Would there be any advice on how to set up the tables for maximum performance given the usage specifications as described in the earlier mail? Regards, Roland On Sunday 17 October 2004 17:50, Michael Stassen wrote

flush and flush delay

?) for maximum performance? Thanks for any help. Regards, Roland. -- -"I have not failed. I've just found 10,000 ways that won't work." -(Thomas Alva Edison 1847-1931) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

connecting via TCP/IP

27;@'%' as well as localhost. I can ping the server so the network connection is fine etc. Do I need some option to be able to supply the host as an IP address to the mysql call? Thanks again. Regards. Roland -- -"I have not failed. I've just found 10,000 ways that won&

connecting over TCP

x27;t connect to MySQL server on 'xxx.xxx.xxx.xxx' (10060). I have checked the firewall settings and port 3306 is open. What might I be doing wrong? Thanks in advance. Regards, Roland -- -"I have not failed. I've just found 10,000 ways that won't work." -(Thomas Alva E

reduced installation

the files that are strictly necessary. Eg without any documentation etc. Could someone tell me which files are absolutely necessary and which files and directories I can afford to ommit? Thanks in advance. Regards, Roland -- -"I have not failed. I've just found 10,000 ways that

mysql embedded with TCP support

and writing take place in volatile memory instead of accessing the HD every time? Regards and thanks in advance for all replies. Roland. -- -"I have not failed. I've just found 10,000 ways that won't work." -(Thomas Alva Edison 1847-1931) -- MySQL General Mailing Li

MySQL and dates before 1000-01-01

I will have used the above method of storing dates, can anyone see any potential "gotchas"/pitfalls? Alternatively, is there a better method which I could use? TIA for your time and help. Regards, Roland

three highest and lowest column values

Hello, from the following Product-table ProductId MarketId CustomerId Type Price ... i would like to get the three highest and lowest prices for each group of ProductId,MarketId & Type. How could i do that ??? Many thanks in advance roland

three highest and lowest column values

Hello, from the following Product-table ProductId MarketId CustomerId Type Price ... i would like to get the three highest and lowest prices for each group of ProductId,MarketId & Type. How could i do that ??? Many thanks in advance roland

Embedded MySQL?

run a standalone server in my program. Now I wonder how this works in practise? Ideally I want to call an API in a dll-file to create and maintain the database. /Roland --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.462 / Virus

Re: Large resultset

Thanks, that solved the problem. I thought that I could have my own fetch-size but I has now understood that Integer.MIN_VALUE is the only size that is accepted. Regards Roland Carlsson - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Roland Carlss

Re: Large resultset

n is reached it automatically gets the next portion. Thanks roland Carlsson - Original Message - From: "Rusch (ext) Reiner" <[EMAIL PROTECTED]> To: "'Roland Carlsson'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 12:59 PM Subj

Re: Large resultset

re is anything funny there. I have tried with a couple of fetchsizes ( 5, 50, 500 ) but it doesn't seem to do any difference. I also tested with TYPE_FORWARD_ONLY with no luck. Thanks in advance Roland Carlsson - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROT

Large resultset

tally missunderstood what setFetchSize does? I use J/Connector 3.0.6 Regards Roland Carlsson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Problem with Win XP / Powerbuilder

I have encountered a problem regarding MySQL / ODBC ! I have an application written in PB6.5 and running in Windows XP Home Edition. There is an error generated while updating to MySQL table: "Row Changed Between Retrieve and Update". I tried to move the application to Windows 98 and it worked pr

Re: Datentypen

Leider kann ich diese nicht in der Doku finden. how in the world did you manage to miss that one? http://www.mysql.com/doc/en/Column_types.html Regards Roland - Before posting, please check: http://www.mysql.com

Re: mysql_install_db script: can't find it

tables are > created automatically during installation. Hi, this script is in the folder /scripts in the source code. On Windows OS the Binary does automatically install the Privilege Tables. Best regards, Roland - Before

Store pictures in DB

Can I use MySQL to store pictures as part of a record? Should I just try to store the name of the picture? Thanks for any help Roland Perez [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php

Re: Mysql 3.23.51 on Solaris

> Connection Failed > 2003 - Cannot Connect to MySQL server on 10.1.1.95 (10061) Hi, it seems that the MySQL Server is not running. Try to start the server. Best regards, Roland -- [EMAIL PROTECTED] - Before p

Format of doubles in queries(feature request)

ard to implement? I don't think so. But it would save other programmers a lot of work. The way it is now, each application programmer has to program his own conversion, or use the single-quotes trick. Thanks for your attention, Roland --

Re: JDBC: Losing precision when mapping doubles from Java

re you can get it: http://www.thenetsquad.com/services/jdbcsupport.html Roland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: JDBC: Losing precision when mapping doubles from Java

> Hi, Roland > > Try my JDBC Driver. > >http://www.t3-jpn.com/jdbc/jdbcmysql.html >http://www.t3-jpn.com/jdbc/download/gweMysqlJDBC_extra3.zip > > Thanks. Hello, thanks for the quick answer. Your page has a link to: http://www.gwe.co.uk/ which is no

JDBC: Losing precision when mapping doubles from Java

Hello, I'm losing precision when I send a double to a mysql database from a Java program trough JDBC. Code: stmt.setDouble(i+3,((Double)value).doubleValue()); I use a prepared statement. Now, if I print out the double in java before sending it to the MySql database this is what it looks

JDBC: Losing precision when mapping doubles from Java

Hello, I'm losing precision when I send a double to a mysql database from a Java program trough JDBC. Code: stmt.setDouble(i+3,((Double)value).doubleValue()); I use a prepared statement. Now, if I print out the double in java before sending it to the MySql database this is what it looks like: 127

Can't connect to source

message. UNABLE TO CONNECT TO SOURCE “MYTEST” – “S1000” –“[TCX][MyODBC] Access Denied for user: ‘@MAILSERVER’ To database ‘roland’” – 0414 I then reset the link to the test database, and tried again, this worked fine. Do I need to setup something else on the server so I can access the database

lower_case_table_name has no effect on Linux

table fails. mysql> select * from GRU; ERROR 1146: Table 'rg.GRU' doesn't exist Does anybody know why? Roland Geist mailto:[EMAIL PROTECTED] Developer http://www.openshop.com - Befo

TIMESTAMP

Hi everybody, I am new to the list so if my question was answered recently I do apologize but I could not find the answer neither in the archive or the manual. Problem: I try to load data into a table using LOAD DATA LOCAL INFILE. Into a table containing a TIMESTAMP(14) field. The loading wor

[Error during auto start mysql.server]

After this the "pid file" is initialised in the directory "/usr/local/mysql/data/localhost.localdomain.pid" and we d'nt receave anny error message. may be this is correct too, I'm gratful if you reply me in french Sory for my english, I'm not