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:
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
>From the manual: "The default behavior for UNION is that duplicate rows are
>removed from the result."
On Sep 8, 2011, at 4:50 PM, Brandon Phelps wrote:
> Mihail,
>
> Thanks so much! I modified your example to include the proper ORDER BY and
> LIMIT clauses
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
Anybody can tell me about way which will force the mysqld write more
information into logs (.err file)?
My mysqld restarted every 20-30 minutes without reasonable info in log
file and I dont understand why it occurs.
I see only string "mysqld restarted" and nothing more! :(
Example of log:
I have problem at my replicated slaves. We have one master and 5 slaves. All of
its live in similar FreeBSD 7.0 systems. But by without understood for me
reasons 4 of 5 slaves are rebooted approximately one time at 30 minutes. There
are no signals and other reasons in logs. But one of slaves wi
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
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
r absolute compatibility for any engine and major migration.
The googled link: http://wikis.sun.com/display/WebStack/MySQL64bitARC
Any comments on this?
Mihail
On Apr 25, 2008, at 12:03 PM, Olaf Stein wrote:
Probably not
AFAIK it should work in theory if you have no floating point columns
but I
would
In the os x version I am able to insert columns anywhere I want.
Now I've noticed that there's no such option in windows' version. Strange.
Cheers,
Mihail
- Original Message -
From: Olaf Stein <[EMAIL PROTECTED]>
To: Jerry Schwartz <[EMAIL PROTECTED]>; MySql
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
just changed the table type and
began getting this error. We have lots of data to insert into this
table, therefore the optimal option is to use DELAYED and insert them in
blocks.
Not sure why they say that ARCHIVE storage engine is a new feature in 5.0?
Mihail
--
MySQL General Mailing Lis
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
.
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
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 tr
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
Did you try:
FLUSH PRIVILEGES;
Also, to see what user can do with his permissions you can try this:
SHOW GRANTS FOR username;
Mihail
Quoting Yat-Shing Tam <[EMAIL PROTECTED]>:
> Hi fellows,
>
> I have a MySQL privileges question and hope someone can provide som
:) Is this some sort of a joke?
I am grouping using event_id, which makes your query useless because it will
return just the first time row per each event_id.
Thanks anyway. I may have to use second query... :-(
Mihail
- Original Message -
From: "Bhavin Vyas" <[EMAIL P
count(DISTINCT time) AS Ranges
FROM
events
GROUP BY
event_id HAVING Ranges > 1
Please help me to find a single query that will return the time column as
well.
Mihail
-
Before posting, please check:
http://www.my
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?
--
48 matches
Mail list logo
