Try this:
LEFT('2014-09-17 12:22:16', 13)
Mihail Manolov
Senior Manager, Database
Liquidity Services, Inc.
1920 L Street NW
Washington DC 20036
202-467-6868 x3227 (Office)
202-256-9044 (Mobile)
mihail.mano...@liquidityservices.com
LiquidityServicesInc.com
> On Sep 18, 2014, at
: Singer Wang [mailto:w...@singerwang.com]
>> Sent: Thursday, February 14, 2013 2:59 PM
>> To: Mihail Manolov
>> Cc: Mike Franon; Akshay Suryavanshi;
>> Subject: Re: Upgrading form mysql 5.0.90 to 5.5 or 5.6
>>
>> There are queries that works with 5.1/5.0 that do not work wit
You could jump from 5.0 directly to 5.5 and skip 5.1. I have without any
issues. There are some configuration file change, which you may want to
consider checking. I definitely recommend upgrading your development servers
for an extensive testing. Some queries _may_ run slower or not work at all
Are you trying to promote a slave as a new master and replace current master or
create intermediate slave? If it is the latter all you need to do is to:
1. Stop the slave
2. Add "log_slave_updates = 1" in the slave's config file
3. Copy the slave files to the new slave(s)
4. Start your intermedia
Noel,
I am really sorry for those "high profile sites", which in your scenario
haven't tested their database in dev/test/stage before upgrading. Bugs happen.
Big organizations have slower communication.
Cheers,
Mihail
On Jun 30, 2012, at 0:16, "Noel Butler" wrote:
> I wonder if you would hav
AFAIK the tables will be locked one by one until checked/repaired.
On May 10, 2012, at 3:07 PM, Adrian Fita wrote:
> On 10/05/12 21:51, Mihail Manolov wrote:
>> You can enable check/recovery automatically by using
>> "myisam_recover". Look it up in the documentation.
You can enable check/recovery automatically by using "myisam_recover". Look it
up in the documentation.
There is no way to repair them "faster", though.
On May 10, 2012, at 2:40 PM, Adrian Fita wrote:
> Hi.
>
> I have several hundreds of databases with MyISAM tables in a server and
> after a p
Try this
SELECT `user_id`, `login_ip`,
COUNT(`id`) AS 'connections'
FROM `mysql_test`
WHERE `login_datetime` BETWEEN '2012-03-19 00:00:00' AND '2012-03-19
23:59:59'
GROUP BY `user_id`, `login_ip`
HAVING COUNT(`id`) > 2
ORDER BY COUNT(`id`) DESC
LIMIT 0, 15;
On Mar 19, 2012, at 12:06 PM, Steven S
ARY
> | PRIMARY | 2 | syslog.sc.dst_port |1 |
> |
> | NULL | UNION RESULT | | ALL| NULL
>| NULL | NULL| NULL | NULL | Using
> filesor
How about:
SELECT
sc.open_dt,
sc.close_dt,
sc.protocol,
INET_NTOA(sc.src_address) AS src_address,
sc.src_port,
INET_NTOA(sc.dst_address) AS dst_address,
sc.dst_port,
sc.sent,
sc.rcvd,
spm.desc AS src_port_desc,
If you're running version 5.1+ you may wanna take a look at table partitioning
options you may have.
On Sep 8, 2011, at 2:27 PM, Brandon Phelps wrote:
> Thanks for the reply Andy. Unfortunately the users will be selecting varying
> date ranges and new data is constantly coming in, so I am not
I concur. In addition to suggested index I would add a new column in articles
table called body_length, which is going to be updated every time the body
column is updated. Add that column to the composite index mentioned below.
This should speed up the query a lot.
Cheers,
Mihail
On Jan 18, 20
I would strongly suggest logging all your 4.0 queries for at least 24
hours and then running them on your new 5.x server to avoid any
surprises such as incompatible queries for example.
Good luck!
Mihail
On Mar 9, 2009, at 1:42 PM, Matthew Stuart wrote:
Hi all, I am on... wait for it... ve
ow if you have any questions.
Mihail
On Apr 25, 2008, at 12:48 PM, Mihail Manolov wrote:
I am in process of planning 32 to 64 migration as well. I googled the
following, but it could be only relevant to a specific application:
It should be noted that, when switching between 32bit and 64bit s
I am in process of planning 32 to 64 migration as well. I googled the
following, but it could be only relevant to a specific application:
It should be noted that, when switching between 32bit and 64bit server
using
the same data-files, all the current major storage engines
(with one exceptio
Flavio Gonçalves wrote:
I want to permit only MyISAM tables to be created in my server. How can I
disable all the other engines?
Put:
skip-innodb
skip-bdb
in your my.cnf file, [mysqld] section.
Mihail
--
Mihail Manolov
Government Liquidation, LLC
Special Projects Leader
202 558 6227
Jeff Smelser wrote:
I would highly suspect this is a bug.. I would submit one.. unless someone
else knows better..
Not real sure why you really need delayed, archive is suppose to be much
faster on inserts then even myisam.
Jeff
Thanks Jeff!
It's the way our code is written, and I just
Jeff Smelser wrote:
On Wednesday 19 October 2005 01:18 pm, Mihail Manolov wrote:
Apparently ARCHIVE tables do not support INSERT DELAYED. Why?
In documentation
(http://dev.mysql.com/doc/refman/4.1/en/archive-storage-engine.html) it
says that it should be possible.
Example of the error that I
7;user','549220','address_id','757812','5214');
ERROR 1031 (HY000): Table storage engine for 'audit_log' doesn't have
this option
Mihail
--
Mihail Manolov
Government Liquidation, LLC
Special Projects Leader
202 558 6227
--
MySQL General
Hi all,
It's not a big deal, but I can't seem to find how to sort or order my
connection entries in "Options->Connections" view tree in MySQL Query
Browser. (See attached screenshot.)
Any ideas?
Thanks!
Mihail
--
Mihail Manolov
Government Liquidation, LLC
Special
Will this work?
GROUP BY maxtime, user
ORDER BY maxtime DESC
comex wrote:
I have a table:
create table example(time datetime, username varchar(255));
timeusername
2005-06-21 15:58:02 user1
2005-06-21 14:58:02 user1
2005-06-21 11:57:51 user2
2005-06-21 10:57:51 user1
2005-0
Have you seen this before:
mysqldump: Got errno 5 on write
I have started getting this error recently in my email box - the message is
result of my daily backup cronjob.
Ideas?
rgrdz,
Mihail Manolov
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Check the size of your partition that contains /tmp directory.
Just in case symlink it to a bigger partition. Your temporary table may
be bigger than the available space in /tmp
Luck,
Mihail
Homam S.A. wrote:
Whenever I try to update an ISAM table (through a join
with nother small lookup table, a
.
Reading MySQL's manual only suggests that I have to add ALL tables that
I want the user to have access to into the tables_priv and exclude the
ones that the uses should not have accesss to.
Any better solutions than this one?
Thanks!
Mihail Manolov
--
MySQL General Mailing List
For
Hmm... I didn't have to upgrade our DBD drivers when we moved from
3.23.57 to 4.0.18. Strange you had to. Do you remember your old DBD
driver's version? Or was that only Win32 problem?
- Original Message -
From: "Mark" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>;
<[EMAIL P
Piece of cake :)
http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html
I've recently upgraded our servers from 3.23.57 to 4.0.18. No
problems at all.
Luck!
- Original Message -
From: "Joe Harkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 13, 2004 2:23 PM
Subj
There are different ways to do accomplish this.
You can use either:
SELECT id, datecol, text FROM table WHERE YEAR(datecol) = 2004 AND
MONTH(datecol) =$mySelectedMonth;
or:
SELECT id, datecol, text FROM table WHERE LEFT(datecol,7) =
'2004-$mySelectedMonth';
As of formated date... use the DATE_FO
Is this what you're looking for?
SELECT id, datecol, text FROM table WHERE MONTH(datecol)
=$mySelectedMonth;
- Original Message -
From: "H Bartel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 10, 2004 11:34 AM
Subject: Select month from Date
> Hi,
>
> I am trying to st
Hello,
Does anybody knows if User Conference' presentations were published
somewhere on the web? I was told that it will be done shortly after
the conference, and it is more than a week after the conference
end...
Thank you,
Mihail Manolov
___
Solutions Architect
Gover
Is there a reason for not using tables_priv table for this purpose?
Mihail
- Original Message -
From: "Dimitar Haralanov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 26, 2003 2:29 PM
Subject: Re: granting privileges using wildcards
On Wed, 26 Mar 2003 13:14:09 -0
Try:
SELECT fieldname FROM table ORDER 0+fieldname;
Hope it helps.
Mihail
- Original Message -
From: "John Almberg" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 8:04 PM
Subject: SQL question
> I'm trying to sort a table on a character-type
mysql < datadump.sql
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 4:44 PM
Subject: db dump question
> I need to copy a database and all its tables and contents to a backup
> server. The server
> they live on is on an ISP, the
Yes, both run 3.23.49a
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Mihail Manolov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 29, 2002 3:24 AM
Subject: Re: mysqlhotcopy problem - Segmentation fault
fancy in the my.cnf file - I have the default configuration
for mysqlhotcopy:
[mysqlhotcopy]
interactive-timeout
Any ideas? Does anyone has had such problem? It's not critical, but it's
strange.
Mihail Manolov
Government Liquidation, LLC
202 467 6868 x.227
[EMAIL PROTECTED]
www.govliqui
my.cnf file - I have the default configuration
for mysqlhotcopy:
[mysqlhotcopy]
interactive-timeout
Any ideas? Does anyone has had such problem? It's not critical, but it's
strange.
Mihail Manolov
Government Liquidation, LLC
202 467 6868 x.227
[EMAIL PROTECTED]
www.govliquidation.com
samchk -roq solved the problem.
My question is, what is the purpose of the error that I get and is it safe?
Mihail Manolov
Government Liquidation, LLC
202 467 6868 x.227
[EMAIL PROTECTED]
www.govliquidation.com
sql,query
-
Be
onnections? Cause they are usually permanent
connections.
"Threads_created" - Number of threads created to handle connections.
Thank you very much!
Mihail
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Mihail Manolov" <[EMAIL PROT
Could someone explain to me what is the difference between thread and
connection?
I guess one connection can have many threads? Am I right?
Thanks,
Mihail Manolov
sql,query
-
Before posting, please check:
http
ROTECTED]>
To: "Mihail Manolov" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 10:51 PM
Subject: Re: Help - query suggestion needed - interesting case
> How about:
>
> SELECT
> event_id, time,
> count(DISTINCT time) AS Ran
Greetings,
I am stuck with this problem:
I have the following table:
event_id time
1002000-10-23
1002000-10-23
1012000-10-24
1012000-10-25
I need to know all event_id's that have multiple times + time columns. Is it
possible to get that result in just one quer
from 833365852 limit 5' at line 1
Any help is appreciated!
Mihail Manolov
Government Liquidation, LLC
202 467 6868 x.227
[EMAIL PROTECTED]
www.govliquidation.com
-
Before posting, please check:
http://www.mysql.com/ma
Hey guys,
did you spot this problem?
mysql> select truncate(199.20,2);
++
| truncate(199.20,2) |
++
| 199.19 |
++
1 row in set (0.00 sec)
Bug?
Mihail Manolov
Government Liquidation, LLC
202 467 6868 x.227
[EM
Greetings,
We use MySQL 3.23.47 running on 4 Pentium III processors machine with 16GB
of RAM.
The site is hosted on 6 web servers using Alteon for load balancing.
If someone had such problem and knows how to fix it, or any ideas are
welcome regarding the following...
Here's what we know about
27 19:19 White.MYD
> -rwxrwxr-x1 root root 2079708160 Feb 27 22:11 White.MYI
> -rwxrwxr-x1 root root 9159 Feb 27 01:18 White.frm
[cut]
Does your system have support for files larger than 2GB?
--
44 matches
Mail list logo
